Skip to Content
0
Former Member
Mar 03, 2009 at 02:18 PM

SSM 7.0 - Copy SAP BI data into PAS or Create Dim. Model viewing BI Data

26 Views

I am using SSM 7.0 with SAP BI. Is there some best practice / direction / comments on making a decision between:

#1 - Duplicate SAP BI data into PAS Dimensional Model

- Create an InfoCube in SAP BI

- Create the model connection required by BI Connection

- Copy the required SAP BW/BI InfoCube information into a PAS Model using the BI Connector

- Create KPIs based on this model connection

or

#2 - Make SAP BI data visible in PAS Dimensional Model (no data stored in PAS)

- Create an InfoCube in SAP BI

- Create a Dimensional Model based on this InfoCube using a Link ID and the SCHEMA commands

- Create a model connection to make data in InfoCube available in SSM

- Create KPIs based on this model connection

My thinking is that if the volume of data is low then not actually having to go to the trouble of duplicating the data in SSM would work well - with the benefit that the information is updated as soon as the SAP BI InfoCube is updated.

(At the moment I have tried #2 but so far not failed to create an KPIs - I am wondering if the Key Figures in the InfoCube need to use a particular naming standard)