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

BOBJ Universe Connection Pointing to SSM

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?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2012 at 04:20 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

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.