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

Reconsolidating Dimensions Members and Hierarchies

Good day Experts,

I built a (PAS) model (in SSM 10.0) with its associatted levels, members, measures etc, created a model connection and entered data via entry and approval. Later on I had to go back to the model (in cube builder) and delete dimension members and change hierarchies (in the initial model I created) however I am experiencing issues when I try to build the PAS model again. Is there a specific function I can utilise in SSM to reconsilidate dimension members and hierachies? I have attempted a couple of workarounds (and still trying) without much results... (references to documents, links etc that can assist in getting a resolution are welcome.) Thank you.

Kind Regards

Babalo

Model Recon..PNG (28.3 kB)
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 May 29, 2013 at 09:53 PM

    Inside PAS you can write a procedure to consolidate the data. I don't have access to a working system so I am doing this from memory and there may be errors in my code. It will need to be something like this.

    Select Dim Dimension1

    Select Dim Dimension2

    ... and so on for each dimension your variables are dimensioned by

    Set period Jan 2012 - Dec 2012 ... or whatever date range you can data for

    Consolidate KPI1_Act

    Consolidate KPI1_Tar

    Consolidate KPI2_Act

    Consolidate KPI2_Tar

    ... and so on for each KPI.

    Run the procedure and it will reconsolidate the data.

    Add a comment
    10|10000 characters needed characters exceeded

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.