Column selectors built in DV using parameters giving incorrect results for Last(Sum()) aggregation f

Question

Hi Team,

We have created a DV Report having Column Selector Using Parameters. The report does not give results as expected when measure having Last(Sum()) aggregation function but it is working as expected for only sum() aggregate function.  I have raised a product support ticket(4-0000253120), They have mentioned that this is limitation Product. So could you please implement this last(sum()) aggregation function with column selector using parameter in OAC DV?

Thanks,

Satish

User_IPFAK · Answer

Hi Federico,

Yes, this Last(sum()) aggregation measure is work fine in normal reports which is directly coming from the SA but if we use same aggregation measures in column selector/parameter its causing issue.

Last(sum()) aggregation function will work like below:

I am supporting Oracle HRMS data, so Headcount values remain same in all months of Fiscal Year. If any user is running for one Fiscal Year then we need to see only one month data but entire headcount so in this case Sum() aggregation will not work but in this case we can use Last(Sum()) aggregation based on month. This will give correct data as per requirement.

Note: Everything is working fine in Classic BI but same functionality is not working in OAC DV

Please let me know if anything required from our end.

Thanks,

Satish

Federico Venturin - Oracle · Answer

Hi @User_IPFAK ,

Does Last(Sum()) work as expected without any column selector/parameter?

Can you please be more specific and share some sample data, the current result and what you would like to achieve?