Set up indicator in Bex

[Former Member]

Hi,

I have requirement where I need to show an indicator in BW report.

Current situation:

Acc/Dep Oper Expense

800320 $10000

I need to put an indicator ' V ' for all the accounts which start with 800320

Required:

Indicator Acc/Dep Oper Expense

V 800320 $10000

Is there a way we can achieve this in Bex without changing anything in the backend. Looking forward to all your reponses.

Thanks,

Kal

[Former Member · Accepted solution]

Kal,

Try using a text variable. Check the options if it will work with a exit for a text variable. This is just an idea. Just try out.

[Former Member]

Try this:

Create a structure with the name "Indicator". Create a selection with the title ' V '. In the restrictions, restrict to a range of Accounts 800320000-8003209999 (i'm not sure how many digits you hae in your account #s).

Create a second selection with the title ' '. In the restrictions, select the opposite of the above node.

I'm not sure if this will give you exactly what you're looking for, but it's the closest you're going to get in BEx. Otherwise you will have to create a new info object on the backend and populate in the update rules. (not that difficult, but you have to reload your data provider to update existing records).