time dependent master data text (SAP BW)

TomBond77 — Fri, 22 Nov 2019 06:28:08 GMT

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

Re: time dependent master data text (SAP BW)

TomBond77 — Fri, 22 Nov 2019 06:38:18 GMT

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

Re: time dependent master data text (SAP BW)

TomBond77 — Mon, 25 Nov 2019 11:41:51 GMT

Hi Friends

any ideas?

Thanks

Tom

topic Re: time dependent master data text (SAP BW) in App Development

time dependent master data text (SAP BW)

Re: time dependent master data text (SAP BW)

Re: time dependent master data text (SAP BW)