Posts Categorized: Web Intelligence

Weird issue in Webi

Posted by & filed under Web Intelligence.

A query is based on eFashion universe and returns two objects: measure [Promotion Cost USD] and dimension [Duration]. The variable [Cost] is defined as =If [Duration]>0 Then [Promotion Cost USD]/[Duration] The following formula in report’s cell returns #MULTIVALUE =Sum([Cost]) If I just replace the variable with the expression, it will return correct value =Sum(If [Duration]>0 […]

Calculation contexts issue with Sum, Where and If

Posted by & filed under Web Intelligence.

Make a report based on eFashion universe with [Year], [City], and [Sales revenue]. Now we will try to calculate total Sales revenue for Austin in 2004 but in two steps. Where and If Define variables as: [Sales Austin] =[Sales revenue] Where([City]="Austin") [Sales Austin 2004] =Sum(If [Year]="2004" Then [Sales Austin]) The expected value for [Sales Austin […]

How to edit merged dimensions in BO BI 4.x

Posted by & filed under Web Intelligence.

In BO XI 3.1, to edit a merged dimension, we could right click on a merged dimension, and select "Edit merged dimension" from pop up menu, this would open a dialog for editing merged dimensions. This has changed in BI 4.x, and it might be not obvious how to adjust merged dimensions. Add dimensions to a […]

Referencing to a document's block in OpenDocument link

Posted by & filed under Web Intelligence.

When we use a OpenDocument link to open a Webi document, the report is displayed with a number of controls. http://localhost:8080/OpenDocument/opendoc/openDocument.jsp?sType=wid&sIDType=CUID&iDocID=Aan15wubifNFikJjmlT.LVU   Sometimes we want to get rid of the controls and display only specific block (for instance, when it needs to be embedded into another application). This can be done with undocumented parameter sReportPart The link will […]

Weird merging issue in BO XI 3.1 SP5

Posted by & filed under Web Intelligence.

SP3 FP5.3 Create a report that contains 3 objects: Country, Year, Revenue Add table with expression =Sum(If([Year] Between ("FY2004";"FY2006"); [Revenue]; 0)) Add section by Country Everything looks nice Now add new query with only Year. Now the expression produces null result. But why??? To see the numbers again, you can either unmerge Year (which is […]

Difference between Where and If in Webi

Posted by & filed under Web Intelligence.

Two expressions =[Revenue] Where ([Country]="US") and =Sum(If [Country]="US" Then [Revenue]) might look similar. They produce the same result if Country is not used in the table: However with Country the result is slightly different The expression with Where removes Country from the context, i.e. something like =Sum(If [Country]="US" Then [Revenue]) ForAll([Country])

Alerters & Drilling in Webi

Posted by & filed under Web Intelligence.

It is not possible to use variables as drill object in Webi reports. Here is a clever trick how to overcome this limitation using alerters: http://deltekbpm.blogspot.dk/2013/03/be-alert-part-1-to-drill-or-not-to-drill.html The idea is to define a variable that calculates the drill level using the function DrillFilter() and then to use this variable in alerters to "overwrite" the value of […]

Join and Synchronization in Web Intelligence

Posted by & filed under Web Intelligence.

When objects are merged in a Webi document there are two possible types of the merge operation: join and synchronization. The type depends on the objects selected in a data block. To achieve expectable result, it is important to understand the difference between these operations. Let's consider examples of each operation. Join The document use […]

Hack of Webi prompts

Posted by & filed under Web Intelligence.

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 […]