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

suvechha_b — Wed, 25 Nov 2020 16:16:04 GMT

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,

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

sunny_talwar — Thu, 02 Aug 2018 18:11:40 GMT

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)

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