I have an app which connects to sap bw using an olap connector. in the edit script i also see a pseudo mdx query which is capturing some data from sap. My concern here is that i noticed 2 fields being loaded without the decimal places. SAP BW has these decimal places but when it is loaded to qlikview it seems as if the values are getting trimmed.
For eg: When the value is 96.65 the value shown in qlikview is 96
Re: QlikView not loading decimal place from SAP BW.
What i understand as of now is that the values are being extracted using the pseudo mdx query and the output of this query itself returns a number which does not have a decimal part. I could have used the num function over the script to enforce a format but since this is a mdx query , i am not sure how to give a typecast or a formatting function over it.