Skip to Content
0
Nov 08, 2012 at 09:40 PM

Rank() does not work proper in webi using 3 merge dimension

103 Views

I have a report built in Webi 3.1 SP3 FP 3.3, data source is Bex query. Three universes are brining the data in and common dimension is customer.

We have created a block to show the data and a rank formula as =Rank([Total Due]) Where ([L01 Customer Cust Class(F/L) (Key)] = "L") <=25

is applied at the block level. I don't see top 25 customers from this. when i change it to 49 i see the top 25 customers. What we have figure out is the same customer has different ranking in there respective data set.

We have about 30 variables created for this report. Whenever a customer is added or dropped the block shows one more or less customer. then i have to go change the formula to show the top 25 customers. and change the 30 variables to accommodate the block level results for sum.

Is there a easy way of doing this.

Thanks.

MAT.