Report Studio Tip – Creating a simple member calculation

Creating a simple member calculation

Version 8.4 allows you to create simple calculations in dimensional data sources using the calculation icon just like you do in Analysis or Query Studio.

1. Create a crosstab report off of a dimensional data source like this one created off the Sales and Marketing cube.

2. Select the Revenue and Planned Revenue column title headers (crosstab node member)

3. Click on the calculation icon.

4. In the drop down list select: Revenue – Planned Revenue

Note: The order you select the columns determines the math order of operations.

The report with the calculation added:

Run the report to see the results: