Cascade filters in dimensional report

[Rosanero4Ever]

Hi all,

I have to create a dimensional report (using an OLAP cube created with Transformer) related to the revenue about items bought for customers in the years.
BUT, I would like see items for customers that have bought a particular item.
In SQL I can resume what I want using the following statement:

Code Select Expand


SELECT customer, item, year, sum(revenue)
from Table1
where customer in (SELECT customer from Table 1 where item ='AAA')
group by customer, item, year

How can I create a slicer to obtain what I described?
May thanks in advance

[MFGF]

Hi all,

I have to create a dimensional report (using an OLAP cube created with Transformer) related to the revenue about items bought for customers in the years.
BUT, I would like see items for customers that have bought a particular item.
In SQL I can resume what I want using the following statement:

Code Select Expand


SELECT customer, item, year, sum(revenue)
from Table1
where customer in (SELECT customer from Table 1 where item ='AAA')
group by customer, item, year

How can I create a slicer to obtain what I described?
May thanks in advance

Hi,

A slicer filter does not appear to be what you require here. Slicer filters affect the measure values, but do not impact members displayed in rows or columns.

I suspect you need a dimensional expression in a calculation within your crosstab to do this

filter([Your Customer level or set of members], tuple([item AAA member],[Revenue measure]) > 0)

Use this instead of the Customer level in your report.

Cheers!

MF.

[Rosanero4Ever]

Many thanks!!!
It seems work very well!