Version 1.4.5 supports full set of query-scoped calculated items

Since version 1.4.5 you can create Cell Calculations and Named Sets.

Named Set

Define Set expression.

Drag and drop created set to row or column area.

Cell Calculation

Define cell calculation set in SCOPE statement format. Define set expression.

Also you can set font and colors for cell calculations.

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.

How to execute MDX query in PivotGrid Designer

PivotGrid Designer allow execute MDX query and browse result in PivotGrid.

To execute your MDX query select MDX tab and push Clear button.

Type MDX query and push Execute button or press F5.

The PivotGrid tab will open and you will see query result in PivotGrid.

If errors occur the Response Errors tab will open and errors will be listed there. You can locate error position in MDX by clicking Location link or double click error row.

In case of error you can return to last successful result. Select PivotGrid tab and press Return To Last Successful Result button. Your query text and PivotGrid appearance will return to state when command execution was successful.