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

Oracle DVD - "Filter Using " - Is this function working properly ?

Received Response
51
Views
3
Comments
Kavi Skr Raj
Kavi Skr Raj Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Summary

Oracle DVD - "Filter Using " - Is this function working properly ?

Content

Hi,

 

I am trying to use "FILTER(Measure USING Attribute condition) in Oracle DVD. But its not showing me filtered value. Instead it shows me total measure value only.

 

May I request you to kindly help or advise me on this please.

 

Thanks,

Kaviraj.

Answers

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    Can you post a screenshot of what you are trying to achieve, I am not seeing the same issue.

    Regards,

    Gabby

    Screen Shot 2018-03-05 at 10.23.43 PM.png

  • Gabby Rubin-Oracle
    Gabby Rubin-Oracle Admin

    Are you doing it in the Prep screen or as 'My Calculation'? An expression that you define in Prepare is performed at the leaf level of the data set while 'My Calculation' expressions are performed at the query level, which might be post the measure aggregation.

    Regards,

    Gabby

  • Kavi Skr Raj
    Kavi Skr Raj Rank 3 - Community Apprentice

    Hi Gabby,

    I am doing it at the "My Calculation' level. The measure value not getting filtered( based on Dimension Filter). Instead the measure value gives Aggregated value only( without any filtration)

    Please advise me.

    Thanks,

    Kaviraj.