CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Prompt using SQL statement

edited Mar 1, 2013 5:16AM in CRM On Demand - Reports and Dashboards (MOSC) 12 commentsAnswered

I am trying to limit what shows on the prompt for a report.

We are using two books of business and only want to show the Product Categories for one book of business on the prompt.

SELECT "Product Category"."Parent Product"

FROM "Product Code Detail Lists"

WHERE "Product Category"."Parent Product 8" = "Graham - Batavia"

Below is the ananlytics area that is being used to create the report.

Active Subject Area:
Product Code Detail History

Columns

Account

Account Territory

Campaign

Date

Owned By User

Principal Partner Account

Product

Product Category

Category Name

Created By

Created Date

.Description

Last Modified By

Modified

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center