topic Re: QlikView not loading decimal place from SAP BW. in QlikView

QlikView not loading decimal place from SAP BW.

Mon, 26 Jan 2026 21:26:37 GMT

Hi All,

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.

Re: QlikView not loading decimal place from SAP BW.

Mon, 08 Feb 2016 19:08:45 GMT

Check your Number format in script. You can convert the field to text filed while loading for debug.

Re: QlikView not loading decimal place from SAP BW.

Tue, 09 Feb 2016 07:07:55 GMT

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.

Please help.

Re: QlikView not loading decimal place from SAP BW.

amit_saini — Tue, 09 Feb 2016 07:15:08 GMT

Hi,

Try like below:

Num(Your_Field,'##.##')

Thanks,

Re: QlikView not loading decimal place from SAP BW.

Tue, 09 Feb 2016 14:41:54 GMT

Hi ,

I am just running the pseudo mdx query. It looks something like this.

Select PseudoMDX(

Dimensions (

a(),

b(),

c()),

Measures(

l),

slices (

p,q,r),

Variables (

(I .[$(var1)]:.[$(var2)])),

From (z));

The source has decimals(ie float).

But the output of this query is giving integers.

Can i use some typecast on the mdx query?

Re: QlikView not loading decimal place from SAP BW.

Wed, 10 Feb 2016 02:46:53 GMT

I also noticed that in bw, that particular field is defined as a quantity key figure. Would this be a problem for qlikview to read its decimal values?

Re: QlikView not loading decimal place from SAP BW.

tobivogt — Fri, 12 Feb 2016 10:52:31 GMT

Hi,

will you get the same result in Transaction MDXTEST for your keyfigure, too?

Have you tried to do num format via Load-Piping like

TEST:

LOAD *,

Num(Your_Field,'##.##') as Your_Field_Format;

Select PseudoMDX(

Dimensions (

a(),

.....

Maybe there are some more suitable connections to use, too?

Maybe

Accessing BEx-Query via (new) BEx-Query Connector

Loading Cubes via Extractor connector

Loading DSOs via SQL-Connector

What kind of source do load?

Regards,

Tobias

Re: QlikView not loading decimal place from SAP BW.

dapostolopoylos — Thu, 17 Sep 2020 11:42:41 GMT

Did anybody found a solution about this?