Hack of Webi prompts

Prompts can be used to select a value from the list of values. What about selecting a field from a list of fields? Say you have FIELD1 and FIELD2 in SOMETABLE. You want to display FIELD1 or FIELD2 depending on the user answer. You can write a long select using CASE WHEN, but that is not interesting. Here is a dirty hack 🙂

Create an object with select:

@Prompt('Select Dimension ', 'N', {'FIELD1', 'FIELD2'}, mono, constrained, persistent,)

Select SOMETABLE in the property Tables.

‘N’ is used as prompt type. This means that the values in the LoV are supposed to be numeric, so BO will unquote the selected value generating SQL.

Let’s try this in a report. Pick the object, and check the generated SQL:

When you run report, you will get a prompt:

You will see ‘foo’ in the report (which is the value of the field FIELD1)

The generated SQL:

2 thoughts on “Hack of Webi prompts

  1. LAMER_CZ

    FYI:
    Heh, we are using this ‘hack’ for years …. but in R4.0/1 it’s fixed. Now it returns 0 (zero) on values it cannot convert to number, which makes all our reports unusable. According to SAP, they just fixed issue of previous versions ….. they introduced new ‘K’ type which do exactly the same, but it works only in new UNX type of universe:) Great!
    We are using something like this BT_DMD_TIME_SE_TB.@Prompt(‘Report Type:’,’N’,{‘Month’,’Week’,’Day’},mono,constrained,not_persistent,,)
    Anyway, this hack don’t work since R4.0 …

    Like

    Reply
  2. neve_rmind

    Hi,
    Do you have a hack for –
    Web Intelligence Query Panel – not possible to use “OR” operator when creating Query Filters on BICS BEX source ?
    There is a SAP note 1687933 released in this regard with a workaround. However, the client is not interested in the proposed workaround.

    We are basically looking at having a “OR” condition in the Query Filters in webi (BO 4.0)
    Can you help us with it?

    Like

    Reply

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s