Tags » BusinessObjects

ForceMerge function

ForceMerge function might be very helpful in some merged dimensions scenarios. Here is a short description how it works.

We have 2 data providers with few objects based of eFashion universe where Category dimensions are merged. 102 more words

Webi

SAP BI Running Embedded Into SalesForce

I come across a lot of situations where customers run SalesForce and ask me whether they can combine their SalesForce data with other corporate data. A most recent request was to combine SAP BW Copa data (profitability analysis) with SalesForce data on clients with payment risks. 100 more words

BusinessObjects

Highlight top 40%

In this scenario we have Lines, Categories and Revenue objects from the eFashion database and we want to highlight top 40% (based on revenue) of Categories. 62 more words

Webi

Input and Output calculation contexts Part 2

In Part 1 of this post I explained what Input and Output calculation contexts are. Now let’s focused on some advanced solutions. How about a combination of a calculation context and a filter with a rank function? 234 more words

Webi

Input and Output calculation contexts - Part 1

I think that calculation contexts are probably one of the most useful and the least understood features in Webi. There are many very helpful posts on the internet explaining the concept but I will strive to provide one more explanation. 584 more words

Webi

RelativeValue() and its limitation

Think about the scenario where you want to calculate the difference e.g. in Sales between current and previous months, in other words calculate a Revenue gain from month to month. 330 more words

Webi

Hide a column

In BO3.1 in Webi there is no default option to hide a column but fortunately there are some workarounds. Usually you want to hide a column which serves only to enforce a sort on a table. 133 more words

Webi