Perspectives are reusable configurations that contain a subset of a consumption models attributes, measures and parameters.
Context
You can create multiple perspectives for your consumption model which allows for different variants to enable quick validation while modeling. Perspectives can be used to create stories in SAP Analytics Cloud.
You can create a perspective in the Perspectives tab of your consumption model or by choosing Data Preview and saving your preview as a perspective.
Define Perspectives From the Data Preview
Procedure
In your consumption model, choose Data Preview.
The context menu on a field has various options:
To remove fields from the output but keep it in the perspective: choose Remove from Output.
To remove or add fields: choose Remove from Perspective or Add to Perspecive.
To sort your fields: choose Sort.
To define a filter on the fields: choose Filter.
To move a field to a diffenrent position: choose Move.
The Association Context shows you where the field comes from.
You can also add or remove fields via drag&drop.
To define a filter you can also choose Add Filter the bar above the data preview. Here you can choose between the simple and the advanced editor.
You can also select more than one field by choosing Multi Select and then perform the action for multiple fields.
You can also remove a field from the output by chhoosing Remove from Output.
You can define settings for your perspective by choosing Settings:
Define your preferences for the
authorizations: this is only available if an authorization scenario has been assigned. You can only assign one authorization scenario per perspective. Assigning it to a perspective allows the authorization scenario to become effective. More information: Authorization Scenario
preview mode: you can choose between the Validate and the Explore mode.
refresh mode: the data can be refreshed automatically or manually.
row limit: you can specify the number of rows to be retrieved.
attribute display: you can choose it the text, the technical name or the ID is displayed.
Save your perspective by choosing Save New. Enter a title and save it.
When you make changes to your perspective, you can save the changes or you can save this changed perspective as a new perspective by choosing Save As. You can undo your changes by choosing Reset.
Switching to other perspectives: When you click on the title of your perspective, you can see the titles of the existing perspectives for this consumption model. From here, you can also open these perspectives.
In order to make your perspective consumable, you need to deploy it. Go back to your consumption model, choose the Perspectives tab and choose Deploy. A perspective needs to be deployed in order to be used in a story.
Define Perspectives on the Perspectives Tab
Procedure
Go to the Perspectives tab and choose (New Perspective) .
Enter a business purpose.
Enter an authorization scenario, if required.
Select your measures by choosing (New)
Select your attributes by choosing (New)
Select your hierarchies by choosing (New)
You can select Run in Analytical Mode. When you select this option, the USE_OLAP_PLAN hint is sent to the SQL optimizer.
This may improve view performance, particularly if a union is performed. It is only available if Expose for Consumption is enabled.
For more information, see HINT Details in the SAP HANA Cloud, SAP HANA Database SQL Reference Guide.
Save your perspective by choosing Save.
When you make changes to your perspective, you can save the changes or you can save this changed perspective as a new perspective by choosing Save As. You can undo your changes by choosing Reset.
In order to make your perspective consumable, you need to deploy it. Go back to the Perspectives tab and choose Deploy. A perspective needs to be deployed in order to be used in a story.
Results
The perspective can be found in the Repository Explorer. You can use your perspective in stories in SAP Analytics Cloud.