In Reporting Studio, create a report and insert a grid for a Financial Management application.

In this example, you use the Comma sample application, add the Entity dimension to the rows, the Period dimension to the columns, and the Scenario and Account dimensions to the page area.

For the Scenario dimension in the Pages list, select Actual and Budget.
For the Account dimension in the Pages list, select Children of OperatingExpenses (Inclusive).

For the Period dimension in column A, select the Children of Quarter1.

Column A is an expanded data segment that expands to display the January, February, and March periods.

For the Entity dimension in row 1, select the Children of Geographical.UnitedStates and the Children of Geographical.Europe.

Row 1 is an expanded data segment that displays four entities in this order: EastRegion, WestRegion, Italy, and UK.

In the Financial Management application, the entities are assigned these currencies:

Select row 1 and select Insert > Row > Data to add a data row. For the Entity dimension in row 2, select the Children Of Geographical.Europe and the Children of Geographical.UnitedStates.

Row 2 is an expanded data segment that displays four entities in this order: Italy, UK, EastRegion, and WestRegion.

Select row 2 and select Insert > Row > Text to add a text row above row 2.

Select column A, and select Insert > Column > Text to add a text column before column A.

Select cell [1,A], which is in row 1, column A. On the Cell Properties sheet, enter or select the HFMCurrency function to display the currency for Grid1, row 1, column B, and page 1.

When you run the report, the text function displays the currencies for the expanded entities from row 1.

Select cell [3,A]. On the Cell Properties sheet, enter or select the HFMCurrency function to display the currency for Grid1, row 3, column B, and page 1.

When you run the report, the text function displays the currencies for the expanded entities from row 3.

Set the user POV to these selections, and select File > Print Preview to preview the report.

The report displays incorrect currencies for the expanded entities from rows 1 and 3. When you hard code the row number in a text function for an expanded row, the text function retrieves the information for the top row. For expanded row 1, the HFMCurrency function displays USD for all entities from row 1 because USD is the currency ID for the top row member, EastRegion. For expanded row 3, the HFMCurrency function displays EUR for all entities from row 3 because EUR is the currency ID for the top row member, Italy.

Delete row 3. In cell [1,A], change the text function to <<HFMCurrency(cur, cur, cur, cur)>> to display the currency for the current grid, row, column, and page.

You can use any form of the Current keyword: current or cur. Current keywords are not case-sensitive.

When you use the Current keyword in a row that expands, the results are relative to the expanded row. As row 1 expands, the HFMCurrency function retrieves the correct currency for each expanded segment of row 1.

Preview the report.

When you use the Current keyword instead of the row number, the report displays the correct currencies for each entity.

In Reporting Studio, continue to work with the same report.

Increase the height of row 2.

From the Pages drop-down list, select Actual, Budget to display the Page Properties sheet. From the Page Printing Positioning area of the Page Properties sheet, select Same Page.

Preview the report.

This figure displays a portion of the report.

The page headings display the scenario and account member names.

Modify the page heading to display the scenario member name and the account member description.

From the Pages drop-down list, select Actual, Budget to display the Page Properties sheet. For the Scenario heading on the Page Properties sheet, select Custom Heading. Insert the following functions to display the scenario member name and the account member description.

In these text functions, you reference Grid1, page 1, and the dimension names.

From the Page Properties sheet, select Account and select Custom Heading. Leave the custom heading text box blank. Format the page headings with a larger font and color.

Preview the report.

When you hard code page 1 in the text functions, the page headings for all pages display the scenario and account members from page 1, Actual and Direct Costs.

In the page headings, replace the reference to page 1 with the Current keyword.

Preview the report.

When you use the Current keyword for the page parameter in text functions, the functions display the correct scenario and account members for each page.