Clear DEFAULT_MEMBER

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
 
J

jam96-BuffaloJoe

You must not have the Excel interop files on the server.

Check your dev environment for references to other .dll's or components.

Make sure all of those components are registered on the server.

You might need to install licensed components on the server.

Visual Studio has setup and distribution projects which might help you, as
they have come a long way in sensing what they need to live when moved to
another environment.

Any way, this is a setup and deployment issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top