how to define new calc to become part of the cube structure

Last post 09-25-2008 4:46 PM by light_wt. 0 replies.
Page 1 of 1 (1 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 09-25-2008 4:46 PM

    how to define new calc to become part of the cube structure

    hi,

    Normal 0 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;}

    I have a calculation which is best created after the cube is created and will stay forever as part of the structure and available to all users via all prespectives.

     

    I’ve tried:

    create member myCube.[MEASURES].[my New Calc]

    AS [Measures].[9]/[Measures].[10], VISIBLE=1;

     

    Excel user are not able to see this new calc with a new connection (session) to myCube.  users are able to see the other calc i created. To veriiy, I've scripted the cube after the create member, that member is not part of the create cube.  if I try to execute the create member, again, it will say, it already exists.

     

    What is the command to create a new calc so it will stay with the cube structure forever?

     

    Thanks.

Page 1 of 1 (1 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.