Forum Discussion
Get key instead of text from SAP BW Cube
Hi All. I'm using PBI to get data from SAP BW InfoCubes. In my cubes, most characteristics have both a key value and a text value. When I bring the data into PBI, only the text value is importe...
I need the KEY value too; otherwise, the SAP BW connector will be useless to me. Currently I am using ODATA link as workaround since ODATA link can show the key and/or TEXT value. However, if SAP BW connector works, that will be nice since it will save a few steps and I don't need to create service, odatalink and transport the changes in BW anymore.