Improvement in expression so that the pivot table report opens up quickly

[suvechha_b]

Hi All ,

How can I write the dimension and expression properly so that the pivot table chart opens up quickly. Now it is taking to long to open up.

Sample model attached.

Thanks,

[sunny_talwar]

A lot of your calculated dimension can either be done in the script or via set analysis... for example..

This can change from this

=if(DealFIName='System Administrator',Null(),DealFIName)

To

DealFIName

with this set analysis

{<DealFIName -= {'System Administrator'}>}

Next, you can do this in the script

Upper(customerFirstName & ' ' & customerSurname) as FullName

and then use FullName as your dimension...

so on and so forth