Computing Expressions on Script Level

[Anonymous]

Hello All,

I have almso 20-25 expressions calculated on UI level across various Charts and Graphs for 20 Domensions (almost). The Application is getting affected because of the loading or refreshing time of charts.

I want to calculate all or may be few expressions in UI level. Please guide me accordingly.

Following are a few expressions used in UI level--

1. Annual Loss Amount - (Sum({<Year_Quarter = {"$(=Max(Year_Quarter))"}>}Disitnct Annual_Loss)

2. Loss Amount Ratio - (Sum(Disitnct Annual_Loss) + Sum(Disitnct Risk_Loss) + Sum(Disitnct Settlement_Cost)) / Sum(Disitnct Premium_Amount)

3. Insurance Premium - Sum({<Year_Quarter = {"$(=Max(Year_Quarter))"}>}Disitnct Policy_Premium)

4. Premium Ratio - Sum({<Year_Quarter = {"$(=Max(Year_Quarter))"}>}Disitnct Policy_Premium) / Sum({<Year_Quarter = {"$(=Max(Year_Quarter))"}>}Disitnct Premium_Amount)

Likewise a few more. I am thinking to write above calculations with Group By all the Dimensions.

Please suggest correct way.

Thanks in Advance.

[Anonymous]

yes