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

Is there a better way to filter measures by attributes other than the 'FILTER' SQL function

Received Response
22
Views
1
Comments
LukePa
LukePa Rank 4 - Community Specialist
in Oracle Analytics Cloud and Server

I ahve found the FILTER function in DV to be very buggy, is there any other function I can use.

Example:

(Filter("VRM - Auction Sales"."Measures"."Sold Value (Net) % of CAP Black" using "VRM - Auction Sales"."Agreement - Current"."Termination Reason" = 'Mechanical Failure')

When the above measures isnt in the table the CAP column is this:

image.png

When i add the measure in it also affected the CAP column:

image.png

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Did you look at the LSQL and the physical query behind both visualization? For your numbers to change like that, it could be an interference between the filtering and maybe some inner join doing some unexpected filtering or something linked to your data source. But it isn't possible to say more based on 2 screenshots.

    The only element that matter is the query, the rest depends on that, so you should always start by looking at the queries. And then think at what data source you are using and how that could explain the difference in the queries etc.