SQL Server Performance

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

Discussion in 'SQL Server 2005 Analysis Services' started by light_wt, Sep 25, 2008.

  1. light_wt New Member

    hi,
    I have a calculation which is bestcreated after the cube is created and will stay forever as part of thestructure and available to all users via all prespectives.
    I’ve tried:
    create membermyCube.[MEASURES].[my New Calc]
    AS [Measures].[9]/[Measures].[10], VISIBLE=1;
    Excel user are not able to see this new calcwith a new connection (session) to myCube. users are able to see the other calc i created. To veriiy, I've scripted thecube 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 newcalc so it will stay with the cube structure forever?
    Thanks.

Share This Page