We are using the SAP delivered virtual cube for G/L financial statements reporting. We are running these queries on Portal (BI 7.0) we are using the 0ANALYSIS_PATTERN template. Now since we are not actually loading data in this cube the template show "Last Data updated" as long time back, I am guessing when the cube was last activated or transported.
The template and time stamp is working perfect for queries on all other cubes or Multiproviders.
The business users are asking can we have the actual time stamp there (when actually the data was last loaded),
Does anyone have any idea how we can do it without actually rewriting the queries on standard cube.
Thanks in advance,