Frequently Asked Questions (FAQs) for Report Sets

The ParallelPeriod function is commonly used to retrieve values from a prior period based on a specified time interval. It helps in comparative analysis by fetching data for the same period in previous years, months, or quarters.

This function uses the following syntax:

ParallelPeriod(Level, Lag, Member)

• Level: Defines the time hierarchy level (e.g., Year, Quarter, Month).

• Lag: Specifies the number of periods to shift backward.

• Member: Represents the current time member.

Example Use Cases

• Retrieve prior year data

  • ParallelPeriod(Year, 1, Time.CurrentMember)

  • This retrieves data from the same period in the previous year.

• Retrieve prior month data

  • ParallelPeriod(Month, 1, Time.CurrentMember)

  • This retrieves data from the previous month.

• Retrieve data for the same quarter last year

  • ParallelPeriod(Quarter, 1, Time.CurrentMember)

  • This helps compare the same quarter from the prior year.

You can use the Reverse Sign option under Format > Data in the Report Set configuration. This setting forces all values to display as negative, regardless of their original sign. It also ensures that historically positive values appear as negative in the final output. To learn more about Reverse Sign, click here.

How do I exit a report set view?

To exit a report set view, click the Close (X) icon on the report tab.

You can add a variable to a Static Report Set in the Add/Edit Rule window.

To access the Add/Edit Rule window, do the following:

1. In the report set, navigate to the Rule column and click Add/Edit.

2. In the dimension member selection pane, select the required variable checkbox from the available list.

The tilde (~) operator is only supported when used with report sets on the column axis of a dynamic report. It is not supported for row sets.