measures visibility

Hi!

I have declared a measure as follows:

create [Measures].[Immobilien Anzahl];

([Measures].[Immobilien Anzahl], [Zeit].[Tag].MEMBERS) = ([Measures].[Immobilien je Tag Anzahl Original]);

([Measures].[Immobilien Anzahl], [Zeit].[Monat].MEMBERS) = ([Measures].[Immobilien je Monat Anzahl Original]);

([Measures].[Immobilien Anzahl], [Zeit].[Jahr].MEMBERS) = ([Measures].[Immobilien je Jahr Anzahl Original]);

Format_string([Measures].[Immobilien Anzahl])="#";

it works fine, but I dont want it to be visible. that's why I want to use the following codeline:

VISIBLE(([Measures].[Immobilien Anzahl])=0;

But I receive always this error message:

Error 1 Query (2724, 1) Parser: The syntax for 'VISIBLE' is incorrect. [Line:2724; Column:1] 0 0

I know that I can use the perspectives, but I would like to make it invisible hier.

How can I solve this problem?

Thank you for your help,

cvlasceanu

Try:

create MEMBER CurrentCube.[Measures].[Immobilien Anzahl] AS NULL

, VISIBLE = 1

, FORMAT_STRING = '#';

([Measures].[Immobilien Anzahl], [Zeit].[Tag].MEMBERS) = ([Measures].[Immobilien je Tag Anzahl Original]);

([Measures].[Immobilien Anzahl], [Zeit].[Monat].MEMBERS) = ([Measures].[Immobilien je Monat Anzahl Original]);

([Measures].[Immobilien Anzahl], [Zeit].[Jahr].MEMBERS) = ([Measures].[Immobilien je Jahr Anzahl Original]);

|||

I think he said he *did not* want it visible. So either use Vidas' suggestion but say VISIBLE=0 or you can use your original syntax and say:

create hidden [Measures].[Immobilien Anzahl];

|||

Furmangg,

my mistake, thanks for point this out. Of course I meant Visible=0.

Vidas Matelis

|||

It works, of course.

Thank you very much for your answers.

Best regards,

cvlasceanu

sql