locked
measures visibility RRS feed

  • Question

  •  

    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

     

     


     

    Friday, March 30, 2007 9:36 AM

Answers

  • 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];

    Friday, March 30, 2007 2:26 PM

All replies

  • 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]);

     

    Friday, March 30, 2007 1:23 PM
  • 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];

    Friday, March 30, 2007 2:26 PM
  • Furmangg,

     

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

     

    Vidas Matelis

    Friday, March 30, 2007 2:33 PM
  • It works, of course.

    Thank you very much for your answers.

     

    Best regards,

    cvlasceanu

    Saturday, March 31, 2007 12:54 PM