Creating a report based on a style sheet

To create a report based on a style sheet:

  1. Right-click a folder in the Report Catalog and select New > Report.
  2. Specify the name of the report and select the style sheet from the Style Sheet list.
  3. Click OK.
    In reports based on the standard style, a title bar contains a link to the Cockpit report, buttons to export the report to pdf and Microsoft Excel, and options to change the scaling of report values. You can edit the title bar by opening the standard style sheet in design mode.
    To link the scaling options to the values in your reports, include this string at the end of each formula that returns a value: /GlobalVariables.bpt_Display_Scaling.Text. For example:
    =ROC("Best Practices OLAP","ANALYSIS","[CHANNEL].[All Channels]",
    "[MEASURE].[Gross Margin]","[POS].[All Pos]",C7,"[Period].[All Years]",D6,
    "[VALTYPE].[Variance].[Actual]")/GlobalVariables.bpt_Display_Scaling.Text
Related topics