i have tried to investigate this part @Gianni Ceresa Because for a given "P Number" there are many "Line Number" and those seem to join many times to "Quantity" and "Id", you should investigate the "Line Number" mostly I would say: why are you seeing many instead of just the 2 you expected? And if it's correct to see many,…

I had checked the join and all seems to be joined as correctly , i agree with both of you about granularity just not very sure how to troubleshoot it once i verify the join in the physical layer as well as levels. what do you mean by this part(If the quantity and id is connected correctly to the 2 line numbers) and how can…

sorry just curious what is IDCS and how do i synchronize the new user account with rpd application roles?

I have checked the session log and , my filters are not being applied

Quick question though, when you say to create a test user and a custom application, can you walk me through how to do that if you dont mind and also how to synchronize the new user / role with the rpd?

Hi, i am testing with myself and i still see the results. I have also tried to deny access to the subject area to myself and still getting access

I am having a similar issue but using Oracle analytics cloud , just curious how did you resolve this issue, i cant find an Aggregate By function, can you please share you solution