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.

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