Former Member

Problems with decimals in query bex (BW 7.4 SP 10)

Hi Guys;

We have a problem with number of decimals in formula on query bex, in the properties of the formula is set for example 0,00 (2 decimals), but the report shows 14,32987263 (many decimals).

Does anyone has happened this? we are on BW 7.4 SP 10.

César.

10|10000 characters needed characters exceeded

Related questions

Posted on May 18, 2015 at 09:24 AM

Hi Cesar,

Is there any characteristics structure available? If it is so then go to Properties->Display tab->Check No of decimal places.

you set the formula properties and no of decimal places (0,00) and in characteristics structure, no of decimal places (0,00000) then output will be decided by no of decimals in characteristics structure properties.

So output would be For Ex: 2,00000.

Hope you understood.

Thanks,

Swapna Jain

10|10000 characters needed characters exceeded
• Posted on May 19, 2015 at 12:55 AM

Yes, if you define two structures in the query. Both setting of decimal in column and row will play a role, and the one define last win. So you could try to set the formula decimal to another value, save, change it back to 0.00, save and see whether now formula get 2 decimal

10|10000 characters needed characters exceeded
• Former Member
Posted on May 15, 2015 at 04:42 PM

Hi César!

Try with keyfigure properties, or you can create one formule with decimals 2 and your keyfigure inside.

Regards.

10|10000 characters needed characters exceeded
• Former Member Former Member

Hi César!

Try hide this formule, and create another with decimals 2 and inside add your original (hide) formule .

Regards.

• Posted on May 17, 2015 at 04:11 AM

Hi Cesar,

Try by creating ckf( Calculated key figure) rather than formula.

Regards

Swapna Jain

10|10000 characters needed characters exceeded
• Posted on May 18, 2015 at 05:23 AM

Hi Cesar,

Can you try to change Infoobject level in BEX explore tab,

There you can maintian decimals lentgh.

and try create formula in BEX level.

Decimal Places Setting in Bex Query Designer

Thanks,

Ram'S

10|10000 characters needed characters exceeded
• Posted on May 18, 2015 at 06:07 AM

Hi César.,

How is it defined?

Thanks,

Giselle