Count multilplies by 3 — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Count multilplies by 3

Received Response
1
Views
4
Comments
mmajdana1
mmajdana1 Rank 6 - Analytics Lead
edited Aug 13, 2024 5:50PM in Oracle Analytics Cloud and Server

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

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Sure, your model is wrong!

    Seriously, double check that all of your joins are valid and complete.

    Double check that the fact to dimension Logical Table Source contents are set at the correct level of detail.

    Double check your keys.

    The answer will be in one of those factors.

  • Gianni Ceresa
    Gianni Ceresa Mod

    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.

  • mmajdana1
    mmajdana1 Rank 6 - Analytics Lead

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

    Than you very much for the effort.

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    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.