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:
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
Quote from: Rosanero4Ever on 14 Jan 2016 02:21:42 AM
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:
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.
Many thanks!!!
It seems work very well!