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

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

Received Response
11
Views
2
Comments
User_IPFAK
User_IPFAK Rank 1 - Community Starter
in Oracle Analytics Cloud and Server

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

Answers

  • Federico Venturin - Oracle
    Federico Venturin - Oracle Mod

    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?

  • User_IPFAK
    User_IPFAK Rank 1 - Community Starter

    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