How to view data in PAS

[Former Member]

Hi guys

I have configured pw sample data base for demo purpose

now i need to view the data in the pas

i need to know how do i link between pas and bw to extract data from ERP

[Former Member · Accepted solution]

So from your words i start with importing a schema which defines a connection between PAS and BW

then i use Import Data to import the data from BW to PAS which is automatically displayed in SSM

for example there is business case which i will import data from financial cube

i will import revenue for the year ( General ledger is 123456 = 5000$ )

the steps would be to de import schema first to linkage between PAS and BW

then i import the data from the cube to PAS using BICA ( Import Data )

and this will automatically load the Master Data which is GL number and The key figure which is 5000$ to PAS

right ?

[Former Member · Accepted solution]

Elhoussiny

Yes - the first thing is creating a container (a PAS model) in which the data will be held. Doing this with BICA establishes the connection between BW and that PAS model.

Then you need to create the structure for the data within that model - the dimensions via the schema which is based on the hierarchies within BW also via BICA.

Then you need to create the metrics within the model so that there are placeholders on which to sit the data - via BICA.

You now have a container with the right structure and the right placeholders to hang the numbers on that you import from BW via BICA.

Regards

Colin

[Former Member]

Thanks Guys for answers

what i need to know is do i have to do any modeling in the PAS or i just handle data in the BW side then move them to SSM using BICA

if i did so what is the role of the PAS is it used as data base where data are moved automatically using BICA from BW to SSM

[Former Member]

best practice to Create PAS database & load from BW into PAS database using BICA and then the same data will be displayed in score card

SriG

[Former Member]

Elhoussiny

It is theoretically possible for you to pass querys through PAS to BW but it is not recommended as this will have poor performance. Each time you move from KPI to KPI you will be running a query on BW slowing down the delivery of data and causing far more load on BW. I don't think anyone ever does this.

Far, far better is to use BICA to draw the elements of data that you need from BW and load them into PAS - then the response in SSM is as good as instantaneous. To do that you need to have the dimensions, metrics and KPIs set up in PAS. You can use BICA to:

1. generate the PAS model linked to BW
2. create the dimensions in PAS
3. create the metrics and KPIs in PAS
4. populate those metrics and KPIs with data from BW

It is unlikely that every piece of data you need will be in BW so SSM allows you to load the PAS cube/model with data from multiple sources either via automated loads from other other systems or via the manual data collection Entry and Approval system within SSM.

Regards

Colin

[Former Member]

Elhiussiny

You can see the data in PAS using the DataView tab within PAS. You select the data you want to see using the Viewer.

Alternatively if you have set up the pwsample demo you can see the data beyond what appears in the scorecard by going into the Reports tab and all the metrics in the PAS model are available to you to create reports with!

Regards

Colin

[Former Member]

Hi

You Can Connect thru BICA. Pl. follow configuration file for the same.

Rgds

Sri G