Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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