Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Using hierarchy in a runtime filter — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Using hierarchy in a runtime filter

Accepted answer
19
Views
5
Comments
edited Sep 27, 2019 12:21PM in Reporting & Analytics for B2C Service 5 comments

Summary

Creating an if(expr & expr,1,0) filter using prod_hierarchy.id

Content

Hi all

Just wondering if anyone knows the answer to this one
I tried a few things but I'm unable to succeed.

If we take the following working example

if(incidents.c$incident_type.id = 151 & incidents.prod_id.id = 186, 1,0)

And if we want to have this in a filter as to exclude certain incidents where both the custom field and product id have a certain value we would have to use the hierarchy as prod_id is not available in filters.

So basically this (non working example)

if(incidents.c$incident_type.id = 151 & incidents.prod_hierarchy = 186, 1,0)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!