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

SSM - more than 12 dimensions , cannot import variables into PAS database

Hi,

I am trying to configure a pilot implimentation of SSM 7.0. This is really a case of learning while moving forward. Based on the success of the pilot management will decide whether we buy SSM.

I have import all the Dimensions (characteristics) of an Infocube into a database in PAS.

Now I am trying to import Variables (key figures)

Unfortunately I am unable to progress as it keep telling me:

Schema> IMP VAR * FORCE

VAR224:

Variables May Only Have 12 Dimensions

Any advice on how to progress? We cannot change the Infocubes. How can we get pass this limitation? Hopefully this issue is not a deal buster...

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 13, 2009 at 03:49 PM

    Hi Adriaan,

    Normally when you are accessing an InfoCube to load data using the BI Connector in PAS, what you would reference would be a Query, not the InfoCube directly. Because of restrictions of the PAS engine, each measure (key figure) can be associated with at most 12 dimensions (characteristics or hierarchies). As InfoCube typically contain significant numbers of characteristics and key figures, the only of restricting this is to create a Query and use that as the source for the data in PAS.

    There is a Best Practice published which discusses some suggestions of doing this [which you can see here|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/701b8da0-3135-2b10-929d-936e43164b06]. I will also look and see if there is other published documentation or recommendations on this.

    Hope this helps,

    Robert

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 14, 2009 at 06:02 AM

    thanks for the advice

    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.