Skip to Content
0
Former Member
May 30, 2007 at 11:10 AM

ROLLUPTIME

94 Views

Hi,

I'm facing a problem that has already been posted onto these forums but I believe that no one could solve it.

On 0ADHOC web template (BW 3.X) there is a text element named 'Actuality' which is supposed to show the "freshness of data" of the InfoProvider. The problem on this field is that for a MultiProvider, the actuality of data is calculated as the oldest date for each of its connected InfoProviders.

This is usually a bad calculation, cause when you have an InfoProvider refreshed daily and another InfoProvider refreshed monthly (i.e. plan data), you never get the correct "freshness of data" (which in this case would be the newest date of the connected InfoProviders.

In order to change this behaviour, I read on the forums some options:

- Link the Actuality text element to a query connected to the daily refreshed InfoProvider --> But this is not a generic solution for all queries, I wouldn't be able to set this up on a generic web template for all queries on the system.

- Note 594735 --> I believe this note doesn't face this issue.

On my testing I noticed that when I activate the SHOW_COMMON_ELEMENTS flag on the text item and leave the ITEM_LIST field empty, the date I'm trying to get is shown as the last one on the list of all common elements. So, I can believe that if I find the correct item name on the item list, I would be able to show the date I need. But the item list on SAP help doesn't mention this field (it mentions ROLLUPTIME, and I also tried ROLLUPTIME_MAX, but the first one is not the date I need and the second one is not working). Please, check:

http://help.sap.com/saphelp_nw04/helpdata/en/9f/4e9d39d44cd45ee10000000a11402f/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/47/96784226d1d242e10000000a1550b0/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/54/5d22111b654e8e946bbf988b6a8fde/frameset.htm

Any suggestions? Does anybody know which is the name for the field in the ITEM_LIST that shows the correct date for a MultiProvider? Is there a way to show an item on the SHOW_COMMONT_ELEMENTS list other than by using its name?

Any other suggestions on how to show the newest date for connected InfoProviders to a MultiProvider?

Thanks and best regards,

David.

Message was edited by:

David Sirvent