Importing Measures definitions in PAS

[Former Member]

Hi,

Is there any Best Practice for importing Measure definitions directly into PAS?

Working in PAS, we have been able to import Dimentional data from a CSV file (for an Organizational dimension), and to set up a few Measures manually.

We have manually created the connections in SSM to Date Entry + Scorecard, but we would like to import the Measure definitions (not the actual/target values!).

Any help appreciated

Lars

[Former Member]

My technque is as follows. In Excel I have a spreadsheet that I use to record information about the KPIs. Each KPI has a row of its own, with columns for such properties as periodicity, scoring method, dimensionality and so forth.

A second sheet contains repeating groups of five rows. Each group corresponds to a single KPI row on the first sheet. When I build my list of KPIs I repeat the groups on the seond page to provide one group for each KPI.

Each of these groups on the seond page have one line for each of the five measures behind the KPIs (Act, Tar,TarDev, Trd,and TrdDev) . Each row has formula that reference the KPI sheet and build a PAS statement to create a measure. These are simple Excel formula and do not require VBA code.

When I change a KPI the generated code on the second sheet automatcally updates.

In PAS I have a CreateVars procedure. I cut the generated code from Excel into this procedure, compile it and run it. This gives me the ability to manage automated build of KPIs without using Cube Builder. Because I control the spreadsheet I have freedom to define KPIs in ways tat I can't using CubeBuilder.

[Bob_McGlynn]

Lars,

You could import measures using the IMPORT SCHEMA command. This command will import variables and dimensions defined in a schema into an existing PAS model. The schema would need to conform to PAS's Hybrid OLAP specifications. You should be able to find more information in the HELP section of PAS.

This import schema approach is what is used to connect with SAP BW using the BICA connector and built in there. The BICA connector only is designed for use with SAP BW.

Regards,

Bob