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

ROW COUNT ISSUE WHEN USING CASE STATEMENT IN A COLUMN

Received Response
76
Views
2
Comments
3601907
3601907 Rank 5 - Community Champion
edited August 13 in Oracle Analytics Cloud and Server

Hi,

I have a report which has a case statement in one of the columns. When I use a formula to get row count I am getting an incorrect row count. When I remove this column the report renders showing the correct count. I am using MAX(RCOUNT(1)) and also tried MAX(COUNT(DISTINCT(RCOUNT(1)))). Both of these give the same result. Any ideas anybody? I am on 12c Platform.

Answers

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    What are you trying to achieve (COUNT)?

    Are you taking simple counts or Running Counts (RCOUNT)?

    Both are very different. Please check

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Your issue is probably one of the order of aggregation, due to whether your objects are physical or logical, on the case of case statements and aggregation you nearly always need it to be based on physical measures.

    My advice would be to create your logic in the rpd if possible, reproduce your case statement based on the physical, then your results will not be spurious.