This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  


December 22 2011 at 3:24 AM
No score for this post
Alan Hutchins 
from IP address

Response to Tracking spreadsheet retrievals

First off I have never used ASO, so my apologies if this does not help you.

If it were BSO, then I would write 2 macros :

Macro 1 - set all settings to standard, but set Navigate without data to on.
Macro 2 - revert all settings to standard

2 retrieve sheets:

Retrieve 1
Retrieve 2 - just top level dimensions only.

Ask users to run Macro 1, and then do one of their normal retrieves in sheet Retrieve 1, and disconnect. Then ask them to run Macro 2 and retrieve sheet "Retrieve2", and disconnect. Then send the workbook to you for evaluation.

That way you can see what they are looking at without the confidential data and Retrieve 2 should be just meaningless numbers.

I would also send out a note stating that you are asking for their assistance in determining whar gets used, as you want to review the performance of the system.

You never know, they might co-operate.


Scoring disabled. You must be logged in to score posts.Respond to this message   

  1. Maybe - Fay on Dec 22, 2011, 12:39 PM

RSS feed for this forum - Please email hypess (at), if you have any questions/feedback/issues.