MENU
    Report Sets
    • 4 Minutes to read
    • Dark
    • PDF

    Report Sets

    • Dark
    • PDF

    Article summary

    Overview

    Report sets are like prebuilt snippets that you can use to build dynamic reports. Once created, you can use a report set across multiple reports if needed. Using report sets promotes consistency across the reports that use the same report set. You can use a report set on the row or column of the report and is interchangeable.

    A report set primarily contains different line types that you can link to a specific dimension member in a hierarchy based on your requirements. While working on the Reference Account line types in a report set, make sure that you link the line to the correct dimension(s) and that they match the naming convention you give for the Reference Account. You can refer to multiple dimensions within the report set lines based on your needs.

    You can use Report Sets as rows or column axis members in a Dynamic Report. Report Sets are individually designed on a specific dimension. Once created they can be referenced in multiple reports. Report Sets on the row of a Dynamic Report are referred to as Row Sets. Report Sets on the column axis of a Dynamic Report are called Column Sets.

    A few examples of Report Sets are; Income Statements, Balance Sheets, and Cash Flow statements on an Account dimension or yearly, quarterly, and monthly on a Time dimension.

    Note:
    The existing user can contact Planful Support to enable the Dynamic Reports Headers functionality in your Production environment. This functionality will be enabled by default, for the new users

    Report Set Types

    There are two types of report sets in the Planful application:

    Static Report Set - You can create a Static Report by defining each Report Set line item individually and are classified into the following:

    • Classic
    • Modern

    Default formatting and column precedence are applied after enabling Modern Features on a Classic Report Set for absolute rows. All details can be modified and saved. The audit log is updated upon editing and saving.

    Note:
    You must manually adjust Dynamic Reports with Report Sets when Modern Features are enabled on a Classic Report Set which has any of the following formatting features applied: Borders, Apply On, and Precedence.

    Dynamic Report Set - Dynamic Report Sets are created using Rules, which fetch members directly from the dimensional hierarchies.

    When a Static or Dynamic Report Set is used on the row axis of a Dynamic Report, the primary dimension used in the Report Set is reflected as the column header in the report. This is also applicable to the Dynamic Report Set used in combination with other Report Sets and dimensions.

    Static vs Dynamic Report Sets

    Static Report Sets offer better features, formatting, and functionality compared to Dynamic Report Sets. The key difference is the types of rule expressions that Static Report Sets support. These include:

    • Member Value Expressions — Parent, lead, lag, first child, last child, current member, previous member, next member, ancestor, first sibling, last sibling, etc.

    • Numeric Functions —Aggregate, sum, average, count, etc

    • Time Series Functions — Parallel period, opening period, closing period, periods to date, etc.

    • String Manipulations — MEMBERTOSTR, STRTOMEMBER

    • Tuples — Mutli-dimensional rule.

    Note:
    The rule generates a single element or member as the output for the above-listed Static Report Set expressions.

    One limitation with Static Report Sets is that they don't support Set Value Expressions where the rule results in a set of elements or members. This is where you can use Dynamic Report Sets, using Set Value Expressions such as Hierarchies, Descendants/Ancestors/Children of a member, Filter, TopCount, Order, Except, and so on.

    The key differences between the Modern and Classic Report Sets are displayed in the table below.

    Fields

    Modern Report Set


    Classic Report Set


    Font Name

    Available under Format > Line > Style

    Not available

    Font Size

    Available under Format > Line

    Not available

    Color

    Available under Format > Line > Border

    Not available

    Outside Borders

    Left Border

    Right Border

    Double Bottom Border

    Available under Format > Line > Border

    Not available

    Apply On drop-down list

    Available under Format > Line > Miscellaneous

    Not available

    Absolute check box

    Not available

    Available under Format > Data > Display As

    Currency Alignment

    Available under Format > Data

    Not available

    Negative Number drop-down list

    Available under Format > Data > Number Format

    Not available

    Absolute for Number Scale check box

    Not available

    Available under Format > Number Format

    Display Thousand Separator check box

    Available under Format > Data > Number Format

    Not available

    Precedence

    Available under Format > Data > Number Format

    Not available

    Add a Report Set

    Perform the following steps to create a report set:

    1. From the New list box, select Report Set. The Add Report Set window is displayed.
    2. From the Type drop-down list, select one of the following:
      • Static
      • Dynamic
    3. Enter a unique code for Report Set in the Code field.
    4. Enter a unique code for Report Set in the Code field.
    5. Enter a unique Report Set name in the Name field.
    6. Select one of the following from the Reporting Area drop-down list:
      • Financial
      • Workforce
    7. Select the required dimension from the Dimension drop-down list.
    8. Select the required location where you want to save the Report Set.
    9. Click Save to add the new Report Set to the selected location.

    Report Sets and Measure

    You cannot use more than one measure in a Report Set. For example, if you want to create a Report Set with a Workforce Attribute and the value of each compensation item, you will not be able to save the Report Set. This is because Workforce Attributes are created as measures in the Workforce Planning Cube.


    Was this article helpful?