Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Navigational Attributes Time-dependant

Hello

I created a new navigational attribute, with time-dependant master data. However, when I display the values at my queries, only display the value, for the last period of master data (I'm working with non-cumulative cubes: 0RE_C01 Surfaces real estate)

Example:

Rental Unit Date to Date from Usage Type

1 31.01.2006 01.01.2006 empty

2 28.02.2005 01.02.2006 own use

3 31.12.9999 01.03.2006 #

Queries always display the usage type #, for all the time selection.

Thanks

Roberto

Former Member
replied

Hi Roberto,

With time-dependent master data, the 0CALDAY or MONTH/YEAR values in the cube/query does not have an effect on, which master data record is used.

Instead, it's the key date of the query. If you do not define a key date for the query in the query properites in the query designer, then current date will be the key date. So regardless of the 0CALDAY, the time-dependent master data is picked up based on the current date.

What can you do?

1) You can set up a fixed date for the key date

2) You can set up a variable that is asked from the user before the execution of the query

3) Or if you are asking a user to enter a 0CALDAY in the selection screen, you can then use user exit to fill that 0CALDAY value as the key date.

Regards,

Lauri

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question