Skip to Content
author's profile photo Former Member
Former Member

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

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)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 12, 2012 at 01:58 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.