Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cube refresh Date
Hi
I have a requirement to display the cube refresh date in my Excel report. I know that if you click on Data tab in the ribbon and choose Properties tou can see this data. But I will have to make it as a part of the template in the report. -- Thanks in advance for you support and suggestions. Sincerely Lakshmi |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cube refresh Date
On May 11, 7:14*am, Lakshmi wrote:
Hi I have a requirement to display the cube refresh date in my Excel report. I know that if you click on Data tab in the ribbon and choose Properties tou can see this data. But I will have to make it as a part of the template in the report. -- Thanks in advance for you support and suggestions. Sincerely Lakshmi Add a dim in your cube that is the cube refresh/update date and display the max of this field. This also allows you track when records are added to a cube if incrementally build rather than full rebuilds. The question becomes, do they want the cube refresh or data refresh date which may be different. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I refresh 2 pivot tables from same OLAP cube | Excel Discussion (Misc queries) | |||
OLAP Cube Refresh Excel 2003 | Excel Discussion (Misc queries) | |||
Date of last refresh? | Excel Worksheet Functions | |||
suppress warning and locate cube in a pivot table from olap cube | Excel Discussion (Misc queries) | |||
Refreshing OLAP cube by date using VBA | Excel Worksheet Functions |