Incompatible data between analysis and database

Daniel Gerçossimo

Good morning community, how do we?!

I have an analysis in which I show spending on employees in a given month as salaries, security, ticket and transportation vouchers.

Making a comparison between the HR database and DW, the data are correct, which found that the ETL is working.

The repository I just do a sum () as aggregation rule in the fields of values and when I play the analysis is giving a very big difference that I could not identify where the error or why BI is not pulling the values correctly.

If possible ask you to assist me.

I thank the collaboration of all.

Regards,
Daniel.

OBIEE 12.2.1.0.0 (Build-BIPS 20,151,008,013,645 64-bit)

Andrew Fomin.

That is a pretty typical question with a typical answer:

1. Enable query logging (if it is not yet).

2. Find the query for your report.

3. Analyse this query and identify the cause.

4. Correct your model.

OBIEE has no magical _SHOW_CORRECT_VALUES=true|false option and we don't know your model.

Daniel Gerçossimo

How am newbie has certain things that still can not understand, I'll see if I can turn the log and post it here.

Grateful!
Daniel

Andrew Fomin.

OK.

1.How to enable logs: Diagnosing and Resolving Issues in Oracle Business Intelligence - 11g Release 1 (11.1.1)

2. How to find your query log: Trace SQL Query OBIEE 12c

3 and 4 are more tricky so you may need to come back later with more information.

Daniel Gerçossimo

Andrew grateful!

I found the problem. In fact it was the ETL that was missing the load of a table!

Gradually I come to evolve and maybe one day be able to help people like you in the community.

Big hug.

Daniel.

[Deleted User]

Don't worry @Andrew Fomin. was just playing the "bad cop" while I was away. He can go back to being the "good cop" again now

Andrew Fomin.

WAT?!

I gave:

1. Step by step guide;

2. Easy to follow;

3. Reference links;

4. Everything numbered.

And you call me a "bad cop"?

@Daniel Gerçossimo you are welcome

Thomas Dodds

"_SHOW_CORRECT_VALUES=true|false option" is @Gianni Ceresa and/or @Christian Berg

Now that you've used it ...

[Deleted User]

Deepest apologies  Andrew, my bad, I had only seen the magical flag and though you were being snarky.

Andrew Fomin.

Oh, that one.

Well, I'm simply trying to be honest and useful. Isn't it better to tell the truth at the beginning of the journey, not when someone comes with something starting with "I have a requirement..."?

[Deleted User]

Much much much better