Skip to Content
author's profile photo Former Member
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.

Thanks for your comments!!.

César.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    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

    Add a comment
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    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.

    Add a comment
    10|10000 characters needed characters exceeded

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

    Hi Cesar,

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

    Regards

    Swapna Jain

    Add a comment
    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 18, 2015 at 06:07 AM

    Hi César.,

    Could you please describe more details about this formula? What is the basic key figure settings?

    How is it defined?

    Thanks,

    Giselle

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.