PBCS Adhoc with Smartview: When using option filter #no data / Missing performance is very slow on Z
While running some tests on an Planning ADHOCK, we find that Smartview is very slow to Zoom In Bottom Level of a Dense member ( Column or Row) if the SV option #Zero Data / Missing is selected.
Any other option does not make the data retrieval slow, but only the above option on a Dense member.
1. Is this an expected behaviour? What is taking up the time during this process?
2. How can we ensure that we do not see this performance deterioration while zoomin in Bottom Level?
3. If there another setting we can select to counter this performance?