Skip to Content
0
Former Member
Apr 28, 2014 at 04:53 PM

Filtering measures

30 Views

Hi,

Is it possible to create a procedure for calculation of a virtual measure in a way to filter dimension elements in the original measure?

Example:

Measure - Net sales by products

Product A 150

Produst B 100

Product C 50

Total 300

we have a KPI Net sales that should calculate net sales for all products (Net sales = 300), but we also have the KPI Net sales for strategic brands - that KPI should calculate net sales for product A + product B (Net sales =250).

We have one BW query that loads the data in PAS model and a measure Net sales (by products). We would like to create another measure that would be filtered on product dimension (just product A and Product B).

Any ideas how to do that?

Regards,

Sladjana