Attribute dimensions slowing retrieval process times
SummaryAttribute dimensions slowing retrieval process times
We recently migrated from Hyperion Essbase 126.96.36.199 + Windows 2008 + Smartiview 188.8.131.52 to Hyperion Essbase 184.108.40.206.500 + Windows 2012 R2 + Smartview 220.127.116.11.620.
All our processes are working in good speed.
But we have a retrieval with attribute dimensions + 2 dense dynamic calc dimensions (Accounts and Period) and 5 sparse dimensions.
The retrieval with the old setup was in seconds, but in the new setup it takes between 1 to 7 minutes to retrieve or sometimes fails connection and Excel gets hung.
I checked online for solutions, it showed dynamic calculations might be a reason. But i cannot find dynamic calculations on any values except for the Accounts and Period dimensions.