Building Universe over SSM tables (CPMS tables)

[Former Member]

Hi all,

I´m trying to build a BO universe over SAP strategy management tables (ex: CPMS_KPI, CPMS_OBJECTIVES, CPMS_CONTEXT..) since the ODBO provider supplied by SAP to connect BO and SSM does not include all the necessary Scorecard data.

So, i´ve created an ODBC connector to the SQL database server to get the SSM tables referred above (and a few more tables), the problem that i´m having relates with the fact that the webi report is getting wrong:

The result that im having is:

KPI A1, Objective O1, Perspective P1, Context C1

KPI A2, Objective O2, Perspective P1, Context C1

Expected result:

KPI A1, Objective O1, Perspective P1, Context C1

KPI A2, Objective O1, Perspective P1, Context C1

The KPI A2 only belongs to Objective O1 and not Objective O2.

The tables CPMS_KPI and CPMS_OBJECTIVE are linked by CPMS_KPI_ID.

If anyone with some experience creating universes with these SSM tables can give me some help I would appreciate it.

Thanks,

Pedro

[Former Member]

Hi Baris, thanks for your answer, I´ve managed to find a solution a few weeks ago!

we used a few more tables between CPMS_KPI and CPMS_OBJECTIVE, we connected CPMS_KPI to CPMS_OBJ_KPI and CPMS_KPI_OBJ, and then connected these two to CPMS_OBJECTIVE, and it worked.

Thanks for the help though,

Pedro

[Former Member]

Hi ,

Use CPMS_CONTEXT, CPMS_OBJECTIVE, CPMS_PERS_OBJ, CPMS_KPI .

Make the following joins,

CPMS_OBJECTIVE.CPMS_CONTEXT_ID(+)=CPMS_CONTEXT.ID

CPMS_PERS_OBJ.OBJECTIVE=CPMS_OBJECTIVE.NAME

CPMS_KPI.CPMS_KPI_ID=CPMS_OBJECTIVE.CPMS_KPI_ID

Let the designer finds the cardinality.

I hope this will help.

regards

Baris.