Level based Metrix - Content Level in OBIEE vs Fixed in Tableau

This is a continuation of my earlier post Level based Metrix - Content Level in OBIEE vs Exclude in Tableau , and I am going to focus on Fixed in Tableau.

To start with, I am creating a new calculation 'Company wise Revenue', which is the Sum of Revenue at the Company level of the Office hierarchy in the RPD BMM.

I add this column in an analysis in OBIEE. 

I am keeping all the 3 columns 

1. Revenue - Details level

2. Revenue (Sum for All Office) - Total level

3. Company wise Revenue - Company level

(For the hierachy refer to Level based Metrix - Content Level in OBIEE vs Exclude in Tableau )

We can compare these 3 columns side by side and can onserve how the 'Company wise Revenue' is summing up at Company level.

Next I calculate the same in Tableau using 'Fixed' expression, at Company level of the Office hierarchy in Tableau (for the hierachy refer to Level based Metrix - Content Level in OBIEE vs Exclude in Tableau ). 

And I test that column along with 'Revenue' and 'Revenue Exclude'.

The output is same as we have seen in OBIEE.

Level based Metrix - Content Level in OBIEE vs Exclude in Tableau

In this post, my objective is to showcase Level based Metrix in using Content Level OBIEE vs Exclude in Tableau. However, I am not going to get into which one is better or worse. This more of exploring options in OBIEE and Tableau to reach to get the same result.

Level Based Matrix - We create a hierarchy of dimensions in reporting solutions and built Calculations / Metrics associated with a specific level. Examples of such calculations are Monthly Sales, Quarterly expense, Country wise revenue etc.

I am using 1 fact and 1 dimension. First, let me do it in OBIEE. I have created the joins in the physical layer.

I have brought those 2 tables in the BMM.

And created logical dimension/hierarchy for Dim - Office.

In the Fact - Revenue, I have kept the content level for Dim - Office at the details level like usual. 

I have 2 Revenue columns, 'Revenue', and 'Revenue (Sum for All Offices)'. Revenue is a straightforward logical column with aggregation as SUM, and Level not defined separately.

However, Revenue (Sum for All Offices) has level defined at the total level of Office. 

I test both the columns and the result is as desired.

Now it is time to replicate the same in Tableau. I have added those 2 tables and joined them.

Next, I have created Office hierarchy, and duplicated 'Revenue' as 'Revenue Exclude'. 

And I have used 'Exclude' expression, and have excluded all the levels of Office hierarchy.  

I test it 'Revenue', and 'Revenue Exclude' in a report. The output is same as we have seen in OBIEE.

There are 2 more expressions 'Include' and 'Fixed' in Tableau, which are also used for the same purpose. I will try to explore them on the next blog.