O'Reilly logo

Microsoft® SQL Server® 2008 MDX Step by Step by C Ryan Clay Bryan C Smith and Hitachi Consulting

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 10 Quick Reference

To

Do this

Define a cube-scoped calculated member

Edit the cube’s script using the Calculations tab in the Business Intelligence Development Studio’s Cube Designer interface. Click the New Member button to add the member to the script and modify the member’s name, expression, and other properties using the form view before deploying the updated script to Analysis Services.

Hide a cube-scoped calculated member

Set the calculated member’s VISIBLE property to False. In the Calculations tab form view, this property is set through the Visible drop-down list.

Format a cube-scoped calculated member

Set the calculated member’s FORMAT_STRING property to an appropriate standard or custom format string value. In the Calculations tab form ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required