Hello, everybody!
I want to show annual report for time-dependent navigation attribute. Main character changed its nav attributes values during year.
How to do this? I have date in each record, so BW can see to date to determine timedependent atribute value correctly. But it doesn't.
DW MUST show such data correctly (SCD - slowly changing dimensions). Else it is not DW.
AFAIK, BW OLAP server can map date character to row key date. But how??? And another problem is that very often we have only fiscper in data, and we need to map fiscal period to date. Is there any engine to do this in BW.
GURU, HELP US!