Calculated Members are not displayed in SQL Server 2005 Management Studio

Hi, all here,

I am having a question about the visibility of calculated members. Why we can not see the calculated members from SQL Server 2005 Management Studio? But when we browse cubes, we can see the calculated members. But why Management studio dose not display the calculated members?

Thank you very much for any helpful guidance and advices for that.

With best regards,

Yours sincerely,

Yes Calculated members are only visible i BI-Developer Studio and in Management Studio if you start a MDX-query. The idea is to make all changes to the solution in BI-Developer Studio because you actually make scripts of all parts of a cube there. In management studio all your changes are not scripted but directly implemented. You can add users/roles i management studio but I recommend to use BI-Dev Studio for this. If you change parts of the cube in management studio your BI-Dev Studio version will not be correct and not include your changes in Management Studio.

You script/the solution can be easily transfered and kept in a repository that can detec changes.

If your cubes disappears due to a disk failure you can easily recreate them with your script in BI-Dev Studio.

Regards

Thomas Ivarsson

|||

Hi, Thomas,

Thank you very much for your guidances.

With best regards,

Yours sincerely,