cancel
Showing results for 
Search instead for 
Did you mean: 

BOBJ Universe Connection Pointing to SSM

Former Member
0 Kudos

Hi,

  I need to create BOBJ Universe for building WebI reports on top of SSM data.

In configuration guide its mentioned:  "

You can only select performance management models in the SSMCatalog

folder. Performance management models contain measures that are used as

the basis of KPIs.

If you want to view model information such as dimensions, attributes, and

measures in the Application Server model, select the model in the

PASCatalog folder."

Is there any guide/document which can suggest an approach for creating a data model in BO Universe using model information from SSMCatalog and PASCatalog?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

I have not done this but worked with a colleague who has set up a universe under 7.5. Which version are you building on?

What I say here is hearsay and may contain errors.

The universe is generated for you based on the SSM data model. You are not free to join tables in the way you would on a relational model. As a result the universe wil reflect whatever you've built in SSM and/or PAS. Once you get it connected you have not other work to do.

I believe your quoted section of the config guide refers to the two databases behind SSM;

  • the SSMCatalogue folder will be the relational data. Some PAS data is exposed through this layer.
  • the PASCatalogue folder will link directly through to the PAS database objects. This may contain objects not exposed in SSM.

PAS has a lot of power not used in SSM so the universe may be a good way to report on that data.

Another approach would be to build a convetional universe over the relational model, ie. the CPMS tables. SAP do not publish a data model for these but they are pretty self explanatory. A could of hours of invetigation should reveal most of the important tables.

Cliff

Former Member
0 Kudos

Hi Cliff,

  Thanks much for the update.

We will be using SSM10.0 and BO4.x.

As per an update from one of my friend we can only use Universe design tool (build universe with extention .unv and not .unx) while using BO4.x.

Reason:"SSM 10.0 does not support integration with BOE 3.1.   BOE 4.x requires XMLA support and at this time SSM 10.0 does not support XMLA)"

Do you have any documents which can give me details of PAS tables : Table structure details and description. It will be of great help if you can share that.Thansk.

Regards,

Ashish

Former Member
0 Kudos

I started to do this under version 7 but they changed many table names going into 10. The best thing s to study your SSM model and then look in the tables for objects matching the known values.

The tables are all prefixed with CPMS. From memory the next step is

  • CPMS.CB - used by cube builder
  • CPMS.SM - diagram manager
  • CPMS.EA - entry and approval

I have attached a document that is out of date and incomplete. Sadly it is probably the only such document in existence. If you update it to V10, please post the updated version.