time dependent master data text (SAP BW)

[TomBond77]

Hello friends

I need to load the right time dependent text data of a dimension or infoobject (SAP BW) into QlikSense.

Example: 0COSTCENTER

1000000000 01.01.1000 - 31.12.2017 

1000000000 01.01.2018 - 31.12.9999  Auto Garage New Delhi

As you can see the first line has no text information.

In my BW Query I tried a SAP standard key date variable 0DAT (calculates the actual day) without success. Furthermore the key date value 31.12.9999 didn't work.

Date format in QlikSense is given as: DateFormat='DD.MM.YYYY';

How do we get the most recent text data record?

Thank you!

Tom

[TomBond77]

additional information: this dimension 0COSTCENTER comes along with transactional/fact data.

[TomBond77]

Hi Friends

any ideas?

Thanks

Tom