on 10-08-2008 11:17 AM
Please let me know how to create a Type Dimension in SSM which can be used to capture Benchmark/ Forecast
Hi Peeyush,
To leverage SSM's Type dimension functionality you do not need to create special "type" of dimension, you just need to create a dimension (using any name) that contains dimension members that you wish to use to measure your actual values against. For example you could create a dimension named "Comparison" that contained dimension members "Budget" and "Forecast". Then within the SSM Admin-->Set Scorecard Defaults in the "Use Measure Type Dimension" dropdown you would select your Comparison dimension. The following excerpt from the SSM Admin Help explains the rest....Hope this helps.
-
The Scorecard component shows actual and target details for KPIs. If your dimensional model contains a Type dimension that includes dimension members such as Forecast or Benchmark, you can incorporate the Type dimension into the Scorecard component and use that Type dimension member as an alternative to Target for the KPI. This feature allows users to be able to compare actual to forecast or actual to benchmark as well as actual to target.
Your Type dimension does not need to be named Type. It can have any name.
Integration
If you implement the Type dimension, the SAP Strategy Management user interface will be changed in the following ways:
A KPI's score and status, which by default represents the deviation between actual and target, will now represent the deviation between Actual and the selected Type dimension member.
Users can click Dimension filters in the Scorecard component and select which member of the Type dimension they want to review in the Scorecard component.
All instances of Target will be replaced by the currently selected Type dimension member. The score is recalculated based on the current selection and the status indicators are updated to reflect the current selection.
For example, if you are viewing the KPI Summary page or the Objective Detail page and you filter on Forecast for the Type dimension, the Target, Previous Target, and Target % Change columns will be replaced with Forecast, Previous Forecast, and Forecast % Change.
Prerequisites
Only the _TAR measures should be dimensioned by the Type dimension in the dimensional model.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks a lot. This will solve my problem of capturing Benchmark & Forecast
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
14 | |
4 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.