cancel
Showing results for 
Search instead for 
Did you mean: 

include non existent values in selection

Former Member
0 Kudos

Dear BW Experts,

the following data is in an Info cube:

customer__________business

4711______________MFH

4711______________MFU

4711______________HA

4711______________EL

4811______________MFK

...

Now we need the following result lists(examples):

Case____________________________result

Customers without MFK______________4711

Customers with MFU and MFH_________4711

Customers with EL but not MFK________4711

Any ideas?

Regards

Harry

Edited by: Harry Mangold on Jan 30, 2008 9:52 AM

Edited by: Harry Mangold on Jan 30, 2008 11:33 AM

Edited by: Harry Mangold on Jan 31, 2008 6:45 AM

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

HI Harry

I am assuming that result column is the customers and that there will be potentially more than one per grouping, ie.

Case____________________________Result

Customers without MFK______________4711

-


1234

-


4567

Customers with MFU and MFH_________4711

-


7890

Customers with EL but not MFK________4711

-


4567

If this is the case, in the query designer create a structure in the rows then create 3 Restricted Key Figures

Rows

Structure

-Customers without MFK (Restict Buisness to exclude MFK)

-Customers with MFU and MFH(Restrict to include MFU and MFH)

-Customers with EL but not MFK(Restrict to include EL and exclude MFK)

Customers(Drag this characteristic so it is below the structure)

You will have to include a key figure if you werent going to, to get around this jsut include 0amount or something similar and change the display setting to always hide.

Hope this helps

Josh