Select the Pinned dimensions for static values, such as currency, and select targets.
To import the remaining and pinned dimensions:
Click Add. The Other Dimension List is displayed, identifying other external dimensions you can use.
Select the dimension to import. A row is added to the table.
From Dimension Depth, select the number of levels of data to import for the dimension. Zero (0) represents the root level.
Levels that you add in the future may require you to redefine the external data source to accommodate the levels. For example, if you select a highest depth of 3 for three levels, even if additional levels are added, only three levels are reported. However, the selection “No Restriction” returns values for all levels, and automatically adds any future extra levels.
Click Next. The Pinned Dimensions tab is displayed. Pinned dimensions contribute the same status members to all data queries to Essbase multidimensional databases.
For example, if the multidimensional database contains a “Scenario” dimension, and they only want to view the “Current” scenario within Performance Scorecard, pin the dimension “Scenario” to “Current.” These dimensions do not need to be imported into Performance Scorecard, but may be required to provide perspective to data queries. Using the Pinned Dimensions tab, you can specify the pinned members for non-attribute dimensions, such as Measures, Values or Time.
Select the name of the dimension in the external data source to update the “Pinned Member” label, then click Save.
The Pinned Member is the name of the member that is used in data queries to provide perspective for the database view, for example, a currency or versionCreate the target for the value in the external data source. See the Oracle Hyperion Performance Scorecard User Guide.
Click the Datasources tab and click Edit to select appropriate dimension member in the external datasource.