Oracle Analytics Cloud and Server

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

Aggregate rule in rpd not working

Received Response
11
Views
1
Comments
ForSly
ForSly Rank 5 - Community Champion

I have created an rpd with an aggregate rule set to sum howver when I upload the  rpd to BICS, the aggregate rule doesn't seem to work and instead of getting a sum I am getting a count. anyone ran across this issue before?

Answers

  • SonPat99
    SonPat99 Rank 6 - Analytics Lead

    Dear User,

    Can you check the physical query generated and see if SUM is used or COUNT?