Hi all,
I'm not an expert in multidimensional reporting and need some help.
I have a dimension with 2 levels: "Vendor" and "Invoice".
I have measures "Invoice Total" and "Invoice Count".
I also have a parameter "prmThreshold".
I'd like to display a table, showing the percentage of invoices per Vendor, that their total exceeds the specified threshold.
I have a
In a relational report, I'd simply create a data item with an expression:
IF
([business_view].[Invoice Data].[Invoice Total] > ?prmThreshold?)
THEN
(1)
ELSE
(0)
and set the aggregation to Total, but in a dimensional report this simply doesn't work - the condition is applied to the total of "Invoice Total" for each "Vendor" and you just get 1.
I tried to have the "Invoice" level in the query and then aggregate the values with a query reference, but it just runs forever.
Any suggestions?
I have a feeling, that a dimensional function can solve it, but none of my attempts worked so far.
Thanks,
David