OBIEE 12c analysis wont show a particular record - may be outer join issue in BMM Layer ?

Joe_obieeoas

Hi Gurus,

Our user ran an analysis and identified he is missing a record, this analysis has 4 dimension tables. Strangely if he remove a particular dimension table from the analysis, that missing record shows up. Wonder if its because of improperly joining this dimension table in BMM Layer.

Please share insights on this.

Thanks in advance.

Shantaram-Oracle

Hello,

a) Is this issue specific to a user or for all users from an application role?

b) What are the data filters applied on the repository?

c) Can the user query data from the table that was removed from the query?

d) What is the query that is getting generated both before and after removing the dimension table?

Thanks

Shantaram

Joe_obieeoas

Hi Shantaram,

a. For all users

b. None

c. yes

d. Can't share

Thank you.

Shantaram-Oracle

Hi Joe,

Do you see a difference in the queries that can give you an insight as to what data is being pulled so you can take a look at the data model in the repository for the tables joins in BMW layer? You may also want to run the queries directly against your DB to check if the data level security restriction is not at the DB level.

Best Regards

Joe_obieeoas

Hi Shantaram,

By including that dimension table, 2 additional filter conditions are being added into the query, and no matching record with that key ID column exists, seems that might be causing the issue.

Thank you.

Gianni Ceresa

Queries, queries and queries again. OBIEE doesn't do any magic, it only generates queries based on what is modeled.

Missing a record? Look at the query and identify if you have a model or data quality issue and fix it.

Too many records/duplicates? Look at the query and identify if you have a model or data quality issue and fix it.

In the end the answer is always to look at the query and fix the cause is. OBIEE isn't going to hide or fix any data quality issue or join issue in your data.