Question:
hi gurus,
I have a question regarding how bex retrieves time dependent navigational attributes.
My scenario is with HR EMP Master data where I have the following records :
EMP "John" belongs to DEPT "IT" during the valid from date of "01 Jan 2002" to valid date "31 Dec 2002"
and
EMP "John" belongs to DEPT "HR" during the valid from date of "01 Jan 2003" to valid date "31 Dec 9999"
So if my cube contains emp, dept (Navigational Attribute) and 0calday for example. Which dept will it retrieve when I list out John with a 0calday record value of "01 Nov 2002"?
I notice on rsrt BEX query uses the current system date and that sounds weird to me. How do I retrieve historical data if that was the case?
Would really appreciate if someone can advice.
Thank you in advance.
Answer:
The key date is used to retrieve time-dependent data. Check the query properties in Query Designer. Depending if you need current, old or both versions of truth you can use different designs. I have a document on time-dependency (the Multi-dimensional modeling accelerator document) that most certainly will explain everything you need to know about time-dependencies. If you PM me your e-mail address I will send it to you. And guys, please just ask for the document if you have current use for it.
Regards
--Andreas
Answer:
Hi Andreas,
Firstly, thanks for the reply.
What can I do if I want to look at the whole week data meaning from 30 Aug 2004 to 3 Sept 2004 since the key date value can only be of single entry. Why I ask is because what if the value changes between 30 Sept 2004 and 3 Sept 2004 which value would it use?
Thank you in advance for your reply.
Answer:
Key date is key date, not key week.
It is often an issue.
One way to overcome the issue is to integrate the said attribute at cube level.
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.