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

[Former Member]

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...

[former_member84747 · Accepted solution]

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

[Former Member]

thanks for the advice