Data BI Visuals

By default, "Object from this query" option will be disabled when drag and drop the object in query filter.     How to enable "Object from this query" option?   It is easy to enable this. As you can see in the filter, by default "In list" option will be there, by changing the value from list to other values , "Object from this query" option will be enabled. 

In this post, we are going to learn how to create a nested filter in web intelligence rich client. Drag and drop the objects into the query filter like below, You can change the condition to OR by clicking on "AND". Now drag the filter over the filter you wish to nest with. Now am dragging the "Kunnr" filter into "Land1", you will get screen like below, We got the nested filter. It is nothing but the filter over filter. As per the requirement, you can change the condition "And" & "Or". We can check the Query script viewer to confirm the result.

In BO, we need to setup a user selection screen for most of the reports where user feed their input and based on the input value report will display the results. We can get the Prompt option in 2 ways either in IDT or WEBI. Prompt option in IDT, We can create prompt (Dynamic filter) by creating filter in Business layer. If you don’t know where to create filter, check it below. Double click on the filter and go to WHERE area, their you can use @prompt function to achieve the prompt. @Prompt Function Syntax: @Prompt (1, 2, 3, 4, 5) 1=”Prompt Message” (This will show while prompting) 2= Prompt Type (A = Character ; N=Number; D=Date; U=Unit) 3=Class Name/Object Name 4=Multi or Mono (Multi = Multiple (2001,2002, 2003); Mono=single (2001)) 5=Free / Constrain (Free – Select Value from LOV; Constrain – Select Value) Example Value : ."VLCVEHICLE"."MATNR" IN @Prompt('Enter Value','A',{'value1','value2','value...