M
m.delbuffa
Hi,
is there a way to clear the DEFAULT_MEMBER once I have set it?
I did this
ALTER CUBE [Production] UPDATE DIMENSION [Dim Time].[Date],
DEFAULT_MEMBER = '[Dim Time].[Date].[20/12/2006]'
and when I SELECT something everything is OK (right numbers). But when
I try to get back doing this
ALTER CUBE [Production] UPDATE DIMENSION [Dim Time].[Date],
DEFAULT_MEMBER = '[Dim Time].[Date].[All]'
(All is the All Member Value) the numbers are wrong. Is this the right
way to reset or clear the DEFAULT_MEMBER? I tried also with these
ALTER CUBE [Production] UPDATE DIMENSION [Dim Time].[Date],
DEFAULT_MEMBER = ''
ALTER CUBE [Production] UPDATE DIMENSION [Dim Time].[Date],
DEFAULT_MEMBER = 'NULL'
ALTER CUBE [Production] UPDATE DIMENSION [Dim Time].[Date],
DEFAULT_MEMBER = NULL
but all these commands seam to be wrong.
Thank you.
Mau
is there a way to clear the DEFAULT_MEMBER once I have set it?
I did this
ALTER CUBE [Production] UPDATE DIMENSION [Dim Time].[Date],
DEFAULT_MEMBER = '[Dim Time].[Date].[20/12/2006]'
and when I SELECT something everything is OK (right numbers). But when
I try to get back doing this
ALTER CUBE [Production] UPDATE DIMENSION [Dim Time].[Date],
DEFAULT_MEMBER = '[Dim Time].[Date].[All]'
(All is the All Member Value) the numbers are wrong. Is this the right
way to reset or clear the DEFAULT_MEMBER? I tried also with these
ALTER CUBE [Production] UPDATE DIMENSION [Dim Time].[Date],
DEFAULT_MEMBER = ''
ALTER CUBE [Production] UPDATE DIMENSION [Dim Time].[Date],
DEFAULT_MEMBER = 'NULL'
ALTER CUBE [Production] UPDATE DIMENSION [Dim Time].[Date],
DEFAULT_MEMBER = NULL
but all these commands seam to be wrong.
Thank you.
Mau