My Oracle Support Banner

How To Add Prompt Filter To OTBI Analysis To Filter On Creation Date Within Last 90 Days etc (Doc ID 2790169.1)

Last updated on JULY 07, 2021

Applies to:

Oracle Fusion CX Sales Cloud Service - Version 11.13.21.01.0 and later
Information in this document applies to any platform.

Goal

On : 11.13.20.01.0 version, Analytics

How do we create a Prompt filter to OTBI Analysis to filter on creation date?

Customer has created a column prompt that lets an user filter by creation date with choice list of Last 7 days, last 90 days, last year, etc.

SQL for Choice List values


SELECT 'Last 90 Days', '1' FROM "sales - crm sales activity" UNION SELECT 'Last 30 Days', '2' FROM "sales - crm sales activity" UNION SELECT 'Next 7 Days, including Today',
 '3' FROM "sales - crm sales activity" UNION SELECT 'Next 30 Days, including Today', '4' FROM "sales - crm sales activity" UNION SELECT 'Next 90 Days, including Today',
'5' FROM "sales - crm sales activity" ORDER BY 2
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.