SAP SSM Transactional Data Loading

[Former Member]

Hi guys

I have configured 0FIGL_C10_Q0001 query which shows FI GL balance

its a standard query

I opened BICA and I have imported a schema for the mentioned query

then I used Import Tab to import the data in the query to PAS

I need to know what is the next step so that i could create  report using SSM based on the mentioned query

one more thing is there any master data that should be created on the SSM layar or they just are created automatically when I import schema ?

[Former Member · Accepted solution]

Hello Colin

What do you mean by metrics

is it member of dimension ?

[Former Member · Accepted solution]

Hi,

A dimension is the hierarchy of data which describes how the data consolidates up to the top level (the result level). If you look at the pwsample demo you will see a Customer dimension with a hierarchy of types of Customer, a Store dimension organising the different stores into regions and a Product dimension organising the types of products.

The members are the individual data points within the dimension so each store is a member of the Store dimension.

A metric is the thing you are measuring - so Revenue is a metric and may also be a KPI but is not necessarily a KPI. In pwsample the KPI Store Units Sold is a KPI which is also a metric that tells you how many items were sold in which store to each type of customer. So the KPI Store Units sold is dimensioned by Store, Customer and Product.

To be a KPI it is has to have an Actual and a Target from which you calculate the Score, have a threshold for performance so you can determine the status by matching the Score to those thresholds and be associated with an Objective.

The KPI 'Units per customer' is calculated by  a calculation of the metrics 'Number of units sold' and 'Number of customers'

Regards

Colin

[Former Member]

Elhoussiny,

If you have now imported some data into PAS you now need to create a structure so that this will display in the front end. Did you import Target as well as Actual values?

a) populate the Library with Perspectives and Objectives so you will have something to build a  structure with.

b) create at least one KPI and map the KPI you created in PAS to the KPI you create in the Library

c) create a Context and then populate that context with Perspectives, Objectives and the KPI(s) from the Library

d) don't forget to assign the relevant Roles to the Context

e) good idea to run the job in the scheduler 'Calculate all scorecard objects' to push the status indicators through.

Regards

Colin

[Former Member]

Hello Colin

I did all below steps

1-Import Schema

2-Import Data

3- Model Connection

4-created a score card with 1 KPI

the thing is i need to know how to link the KPI by a GL in the query

for example the KPI revenue is the balance of the GL revenue in the query

and how to make sure that the step Import data is successful

[Former Member]

Hi,

When you created your KPI in the Library you will see a drop down selector for PAS Model. When you select the PAS model you are going to connect.

Then click the Actual drop down selector and it will automatically list all the metrics in the PAS model you selected which have _Actual. You choose which one is associated with the KPI you are creating. When you choose the Actual you want it will automatically associate the 4 other metrics in the set to the rest of the set that is in your PAS model.

Regards

Colin