Attribute dimensions slowing retrieval process times
Summary
Attribute dimensions slowing retrieval process timesContent
Hi
We recently migrated from Hyperion Essbase 11.1.2.1 + Windows 2008 + Smartiview 11.1.2.1 to Hyperion Essbase 11.1.2.3.500 + Windows 2012 R2 + Smartview 11.1.2.5.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.
0