How can I set dimension consolidation of measure into "Enter" in PAS(IDQL)

[Former Member]

SSM Version 10.0 sp4

In Cube Builder, we can set the measure with "Enter" in dimension consolidation. But when we maintain measure in PAS(IDQL), we just use FIRST, LAST, AVERAGE, SUM, WEIGHTED, MIN, MAX(such as create monthly measure1 'measure1' by product SUM  ). How can I set dimension consolidation of measure into "Enter" in PAS(IDQL)

[Former Member · Accepted solution]

Hi Wenxiang,

The options that you have available when creating a measure in PAS are just related to the Time Aggregation. These options (FIRST, LAST, AVERAGE, SUM, WEIGHTED, MIN, MAX) define how data aggregates from days to weeks to months to quarters to years.

The dimension consolidation for a metric isn't defined by the measure properties, though. It is defined by the CONSOLINFO document in the respective PAS model. This document should contain a list of the metrics you are using for E&A, together with the respective Dimension Consolidation method and the levels at which you can enter data in E&A. Please find an example of how you can apply this logic in the following thread:

http://scn.sap.com/thread/1278248

The Dimension Consolidation "Enter" corresponds to the "ALL" value in the 3rd parameter, as in the example below:

EXAMPLE_MEASURE_TAR,NONE,ALL

Best regards!

Ricardo Vieira

[Former Member · Accepted solution]

Thinks for your reply.

And I have another question:

http://scn.sap.com/thread/3269054

   How can I enter data in Time Dimension instead of the default consolidation (FIRST,LAST,AVE,SUM, etc.). For example, our clients need to input target data directly in quarterly, yearly for some monthly measures. In Cube Builder, we just consolidation from monthly to quarterly( to yearly) via FIRST, LAST, AVERAGE, SUM, WEIGHTED, MIN, MAX. We need "Enter" in Time Dimension. Do you know how to realize? Thanks in advanced.