Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Recording SmartView report's "Last Retrieved" time

in Essbase 1 comment

Summary:

I have a SmartView report (Version 23.200). The report has about 50 data pull sheets and one control sheet where I define parameters (such as Product and Entity) for each data pull sheet. Say, I selected South America as my parameter, and cliked Refresh All. It went through all data pull sheets and refreshed them. Now all sheets have South America's data.

Then I changed the parameter from South America to North America and clicked Refresh All. The refresh failed somewhere. Now all my sheets say "North AMerica", but some of them still have South America's data.

I can check each worksheet's Sheet Info and check Last Retrieved data, but it's a lot of sheets to check. Is there any way to see which sheets were refreshed and which were not?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!