Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
light_wt@hotmail.com
Starting Member
2 Posts |
 Posted - 2008-09-25 : 18:29:33
|
| 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;or create member CurrentCube.[MEASURES].[my New Calc]AS [Measures].[9]/[Measures].[10], VISIBLE=1;Excel user are not able to see [my New Calc] with a new connection (session) to myCube. To verifiy, 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. |
|
|
|
|
|
add cube object to cube structure.