Skip to Content
0
Former Member
Jul 22, 2008 at 05:24 PM

Defining key figures

29 Views

I have the following scenario.

1. We are reporting off a multi provider.

2. We have built a report which the majority of the Key figures are defined based on values from a specific part provider

3. The part provider is loaded with data from a SAP and non SAP system as two seperate loads

4. We have defined a flag field which identifies the source of the data i.e. SAP, Non SAP system

5. In the query we have a set of Restricted key figures which are defined for example as follows:

RKF1

Object1 - restrict Not assigned values

Key Figure

The problem is with all the data from the non SAP system Object1 is always not assigned.

What would be the best way for us to define additional RKF so that we can have the not assigned restriction for SAP data and not have the restriction for Non SAP data? Should I define new RKF or can it be done in one and what would also be best for performance? Thanks