I am facing issue with measure aggregation.
The dimension I am using has 4 levels.
Business Unit, Product Line, Product and Application.
I am trying to calculate the number of production defects for each level.
The problem is that the issue ticket numbers are not unique and can be used by different application.
Application 1: issue numbers PM1, PM2, PM3
Application 2: issue numbers PM1, PM4, PM5,PM6
Now when I perform count at the application level counts should be
Application 1: Prod Issue = 3
Application 2: Prod Issue = 4
But when we roll up to higher level like Product which has both the application in it the count should be 6 instead of 7
Product 1( having Application 1 and Application 2 ) Prod Issue = 6 as it should be a distinct count.
I did try using Distinct Count Aggregation in Summarization settings but not able to understand how to use this.
WebFOCUS 7.7.3 PMF 5.2.3, Windows, AHTML,PDF,Excel