Skip to Content
avatar image
Former Member

Bex query designer the blank space

Bex query designer the blank space fill # is mandatory one, but i don't fill #.in the report i need blank field only

Message was edited by: Jason Lax > Moved to right space, updated title

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jan 04, 2015 at 08:17 AM

    Hi Bala,

    The hash sign (#) represents an initial (blank) value in BW and BEx Query Designer. That is how it is designed.

    Best regards,

    Sander

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04, 2015 at 08:55 AM

    Hi,

    # means it is the blank vlaue.

    check the MP/CUBE in the LISTCUBE (TXCODE)

    if you want blank values in report level you will get # values

    if don't want the # values  you can restrict the at the designer level.

    open the query designer -> open the qeury -> select the object -> right click -> select the restrict with exclude function.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 04, 2015 at 10:26 PM

    Hi,

    Did you think about VBA code changing it.

    http://scn.sap.com/thread/1040239

    http://scn.sap.com/thread/451819

    Hope this helps.

    Leszek

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 07, 2015 at 12:00 AM

    I have a similar question i want to create a formula with handling "#".

    how can i acheive this in bex , as we dont have if and else statements i am using Boolean functions to achieve this  , but i cant enter "#' or cant use a blank ""

    ( Formula variable ==1001) *KF1+( Formula variable== 5002) * KF2+  (Formula variable =="#")*KF3

    Note : Formula variable is by processing type - replacement path with Char info object.

    Add comment
    10|10000 characters needed characters exceeded