Workbook aspects

You can permit user customization of a report. This could be used to set ‌defaults or provide fast switching between different combinations of slicer selections, or allow customization of the report structure itself.

Workbook aspects enable different "Aspects" or views of a report to be created. There's also an option that allows users to create their own aspects and pick which to use when a report is first loaded in Anaplan XL Web.

They work by storing the values to use for the Web Parameters setup on the workbook.

The feature can be accessed in Excel under: Anaplan XL > Web > Parameters > Manage Aspects.

To store different combinations of reports, set the slicers you want to control to have an Output range:

Create a web parameter for that range:

You can then include that in the aspect:

The end-user can then select a pre-defined aspect or create their own aspect (if that option was enabled):

You could use aspects combined with XL3ColumnVisible, XL3RowVisible or XL3SetProperty to set the default report structure. You can enable users to store the current setup as a new aspect.

‌Set up a Web Parameter. Use that cell in the logic as to which parts of the reports to display or use. Use XL3Link to enable users to update that value interactively. With the Aspects enabled, they can then "store" those settings as an aspect.