Hi rajinish,
we have complex calculations in webi report. now i would like to move all the calculations at universe level. for that i created one calculated key figure and moved in web i report i didn't get any error but if i am trying to add one more calcuted key then i am getting error..
webi calculation

=Count([L01 Maintenance Order Key] Where([L01 Maintenance Order Order type (Key)]="PM10"))
now i calculated above formula in universe like below
SELECT BOX

<EXPRESSION>
@Select(Maintenance Order\L01 Maintenance Order Key)
</EXPRESSION>
WHERE BOX

L01 Maintenance Order Order type (Key)="PM10"
PLEASE GUIDE ME IF I AM MISSING ANYTHING..
Add a comment