Skip to Content
avatar image
Former Member

Bex Query element issue

Jul 25, 2017 at 08:54 AM | 76 Views

Help your help for sure.

Kindly see the screenshot below,

I have no clue to identify the problem exactly.

t8yef.png (1.8 kB)
4wjrb.png (4.2 kB)
tj50i.png (8.8 kB)
hxzoy.png (3.2 kB)
BW Business Explorer (SAP BEx)
BW SAP BEx Analyzer | BW (SAP Business Warehouse)
Add comment
10|10000 characters needed characters exceeded

  • William Ayd
    Aug 30, 2017 at 02:16 AM

    How are RM_Qty and OTH_QTY defined? The error suggests they aren't using the same dimension - are they both using the same UOM or alternately do they both have NODIM consistently applied (assuming they are calculated key figures themselves)?

  • Get RSS Feed

3 Answers

  • avatar image
    Tammy Powlas
    Jul 25, 2017 at 09:25 AM

    I'm guessing here, based on this reply https://archive.sap.com/discussions/thread/3306390

    I would try using NODIM( AMOUNT IN LOCAL CURRENCY * 70/100) - change the parentheses placement

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 26, 2017 at 03:17 AM

    Hi,

    Thanks for your reply,

    Actually i am getting error in BO web intelligence report firstly,

    So after that i have checked in particular bex query

    i have used NODIM,then too i am getting the above error

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Cornelia Lezoch
    Sep 05, 2017 at 11:43 AM

    hi RGI - would be nice if you told us your name when you ask questions ...

    the formatting for the "Amount..." looks strange - it should be not in black.

    just delete this part from the formula and insert it correctly again.

    regards

    Cornelia

    Add comment
    10|10000 characters needed characters exceeded