on 06-11-2012 10:48 AM
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?
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;
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
User | Count |
---|---|
5 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.