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
Any help would be appreciated. Thanks in advance.
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.
I am just running the pseudo mdx query. It looks something like this.
The source has decimals(ie float).
But the output of this query is giving integers.
Can i use some typecast on the mdx query?
will you get the same result in Transaction MDXTEST for your keyfigure, too?
Have you tried to do num format via Load-Piping like
Num(Your_Field,'##.##') as Your_Field_Format;
Maybe there are some more suitable connections to use, too?
Accessing BEx-Query via (new) BEx-Query Connector
Loading Cubes via Extractor connector
Loading DSOs via SQL-Connector
What kind of source do load?