Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
additional information: this dimension 0COSTCENTER comes along with transactional/fact data.
Hi Friends
any ideas?
Thanks
Tom