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. 

How to customize the table look. We can able to get alternate colour for table like in excel. If you choose pre-defined format, we will get two colours. We can achieve the same in Webi report also. Objective: We are going to see, how to get the table like below As you can see, it used two colour alternatively. We are going to learn, how to get that. Step 1:  Right click on the table and look for “Format table” Step 2:  Go to Appearance section and find alternate colour at the bottom. This is the place we have to select colour and row frequency. Thanks. Please let me know, any more tips or queries on Web Intelligence.

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.

By using query properties, we can restrict the records to display in a report. Please check the options in query properties Max rows retrieved - Maximum number of rows of data that are displayed when a query is run. This is related with Sample Result set. For example, if you give 1000 rows in "Max rows retrieved" then 500 rows in "Sample Result Set" then you will get 500 rows only. Also it can be restricted based on the administrator security profile. Sample Result Set - It determine the Maximum number of queries returns. This restriction is applied in database level. Fixed - At each data refresh, query returns the same rows when Fixed option is marked. If not then on each data refresh, query returns different set of sampled rows Retrieve duplicate rows - In some cases, in database, the same data may be repeated over many rows. You can restrict those data using this option.

One of the tab in WebI report is, Report Element Tables Cell Section chart others Tools, Position & Linking Tables  - We can create variety of tables Vertical Table Horizontal Table Cross Table Form   Cell  - We can add 2 types of cell in report Blank Cell Pre-Defined Cell Section  - Insert section based on the table values Chart  - Different type of charts Others  - Apart from normal default, we have plenty of other charts also available Tools, Position & Linking  - The other tools under report element will be in disable state till we add any of the figure in reporting area. Other elements will be discussed, keep visit here. Thanks

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...

We always not prefer to see the duplicate records in report. in some cases the output of the universe may have duplicates. We can remove the duplicates in WEBI layer. Follow the below steps to remove duplicates. Go to Query Panel in Webi, Click the properties and uncheck the “retrieve the duplicate rows”. By default, it is checked   Thanks. Please let me know for any issues.