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

 Return to Index  

Maybe...

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


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.

HTH

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

  1. Maybe - Fay on Dec 22, 12:39 PM
  2.  
 Copyright © 1999-2014 Network54. All rights reserved.   Terms of Use   Privacy Statement  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.