Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Save $600 on Qlik Connect registration! Sign up by Dec. 6 to get an extra $100 off with code CYBERSAVE: REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QlikView not loading decimal place from SAP BW.

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.

7 Replies
Not applicable
Author

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

Not applicable
Author

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
Master III
Master III

Hi,

Try like below:

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

Thanks,

AS

Not applicable
Author

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?

Not applicable
Author

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
Partner - Contributor III
Partner - Contributor III

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
Creator III
Creator III

Did anybody found a solution about this?

Father/Husband/BI Developer