+ Reply to Thread
Results 1 to 2 of 2

Macro to refresh Essbase data sets, display refresh date?

  1. #1
    Registered User
    Join Date
    11-06-2014
    Location
    Austin, TX
    MS-Off Ver
    360
    Posts
    35

    Macro to refresh Essbase data sets, display refresh date?

    Hey everyone, I am working on a file with 10 tabs that each have an essbase data set in them. Right now I have a macro that goes through and refreshes all of the essbase data sets but I am trying to find a way to incorporate a refresh date into it (whether it's displaying it in the essbase pull or pasting the date stamp in a different cell, I'm not sure). I know that I can just put a date stamp into a cell for each set while the macro is running but that doesn't actually validate that the Essbase pull was "Actually Refreshed". Maybe Excel and Essbase don't cooperate in this way but does anyone know of a way to pull the refresh date/time for a data set from Essbase? Any help will be greatly appreciated. Thanks!

  2. #2
    Registered User
    Join Date
    11-06-2014
    Location
    Austin, TX
    MS-Off Ver
    360
    Posts
    35

    Re: Macro to refresh Essbase data sets, display refresh date?

    I guess there isn't a solution for this....

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 09-29-2013, 06:15 AM
  2. Replies: 1
    Last Post: 09-28-2013, 07:11 PM
  3. Pivot - display source data filename after refresh
    By FerdieB in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-05-2012, 03:19 AM
  4. Enable Auto Refresh - Wait for refresh to sinish before running a macro
    By tomlancaster in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2011, 11:52 AM
  5. Refresh filter after data refresh?
    By ravensjeff in forum Excel General
    Replies: 0
    Last Post: 12-08-2007, 11:14 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1