Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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.

6 Replies
Not applicable

Re: QlikView not loading decimal place from SAP BW.

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

Not applicable

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.

Please help.

amit_saini
Honored Contributor III

Re: QlikView not loading decimal place from SAP BW.

Hi,

Try like below:

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

Thanks,

AS

Not applicable

Re: QlikView not loading decimal place from SAP BW.

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

Re: QlikView not loading decimal place from SAP BW.

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

Re: QlikView not loading decimal place from SAP BW.

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

Community Browser