QlikView not loading decimal place from SAP BW.

[#1]

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.

[#2]

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

[#3]

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.

[amit_saini]

Hi,

Try like below:

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

Thanks,

AS

[#5]

Hi ,

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

Select PseudoMDX(

Dimensions (

a(),

b(),

c()),

Measures(

j,

k,

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?

[#6]

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?

[tobivogt]

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

[dapostolopoylos]

Did anybody found a solution about this?