How to add and use Calculated Members

PivotGrid allow create and use query-scoped calculated members.

To add new calculated member push the button “Add Calculated Member” on the query designer.

Set calculated member name and expression. When you write expression you can drag and drop olap items from the cube browser and from the PivotGrid.

You can set font, back color and fore color for calculated member.

“Color” button replaces a color expression with value that you choose in the Color dialog. “Add color” adds color value to expression in place of the cursor or replace selected text with color value. “Template” button replaces expression with mdx template that sets different color for negative, positive, zero and null data values. “Font” buttons sets font name, font size and font flags expessions.

After you have created the calculated member you can drag it to the query designer panes or to the PivotGrid areas. Also you can select the calculated member in the hierarchy filter.

Calculated member properties that you can define:

• Name
• Expression
• Parent hierarchy
• Parent member
• Fore color
• Back Color
• Font name
• Font size
• Font flags
• Non-empty behavior
• Solve order

Using calculated member that has parent hierarchy other than Measures

Set parent member for calculated member that has parent hierarchy other than Measures. In other case you will not be able to drilldown top level member.

You will see your calculated member in hierarchy tree only if you work with Microsoft SQL Server 2008 R2 Analysis Services. If you have Microsoft SQL Server 2005 Analysis Services or Microsoft SQL Server 2008 Analysis Services you can use your calculated member only in hierarchy filter.