Creating 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 Home button and buttons to export the report to pdf and Microsoft Excel. It has 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("BestPracticesOLAP","ANALYSIS","[CHANNEL].[All Channels]",
    "[MEASURE].[Gross Margin]","[POS].[All Pos]",C7,"[Period].[All Years]",D6,
    "[VALTYPE].[Variance].[Actual]")/GlobalVariables.bpt_Display_Scaling.Text

    To configure the Home button, right-click and select Format Button. Select Click to execute an action. Edit the action and specify a target report.