Author: Kepion Product Team
You can simplify your data analysis by using the Perspectives feature. Perspectives allow you to create a more user friendly interface for 3rd party analysis tools, such as Excel PivotTables, when connecting to your Model’s data.
To use Perspectives, select a Model in Modeler and click on the PERSPECTIVE tab.
Click the Add button and the Perspective dialog window will appear. Select the items that you would like to show for your Perspective. Once you click OK, be sure to save your application and deploy.
Now when connecting via an Excel PivotTable, you can see the Perspective.
And it will only show you the fields that you would like the users to see.