How to avoid “Distinct” in OBI analysis

As you know, by default, OBI reports doesn’t display duplicated records in the analysis. The reason for such behavior it’s that OBI it’s the analytical tool, not a query tool. The main “Use Case” scenario for OBI, as well as any other Business Intelligence tools, it’s when a business user starts their data analysis from higher levels of data and drill down to the details. If for one fact, several fact values are related to the same dimension values (i.e. several amounts for one client), it will aggregate the values and show only one row.

Continue reading “How to avoid “Distinct” in OBI analysis”