Best Practices / Tips and Tricks

• To override page level parameters on the dynamic report, you must provide the dimension name and dimension code.

Example - {[Scenario].[Actual]} ,{ [Time].[2015], [Time].[2016]}, {[Company].[US Company1]}

• APIs extract the data from the OLAP cube. Information and settings like excel formulas, headers and footers, report level comments, insert formulas, formula exceptions, hide/show rows, text formatting, suppress empty rows/columns/headers that are present in a report in the application are excluded in the API response.

• APIs are supported only for Financial and Workforce (a.k.a cubes).