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:
bukhantsov.org 
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 …
LikeLike
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?
LikeLike