Count multilplies by 3

Question

Hi I am using OBIEE 12 c and I have a following isssue.

I have one formula columnn that says  Count(my_column) and in the analysis it gives me the values that are multiplied by 3. If the real count is 9 i have 27 and so on...

Does anyone know what could be the problem??

Best regards, Matija

Robert Angel · Answer

That is funny, I nearly came back to the board with an additional - or the data in your underlying tables is wrong....

Thanks for your thanks, sometimes you try heard and do not get repaid with courtesy, it is appreciated.

mmajdana1 · Answer

I had multiple same values in one of Dimension tables, that caused my issue.

Than you very much for the effort.

Gianni Ceresa · Answer

What Robert said, if your values are multiplied by 3 it means one (or many) of your joins is multiplying the returned rows.

So look at the generated physical query and you will spot which join is wrong and multiplying the rows.