Oracle Analytics and AI

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

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.

Find more posts tagged with

Accepted answers

All comments

Gabby Rubin-Oracle

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

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

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.