OBIEE 11g: How To Use Prompts in SmartView for OBIEE Union Queries (Doc ID 1673045.1)

Last updated on JANUARY 27, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.131017 and later
Business Intelligence Suite Enterprise Edition - Version 11.1.1.7.131017 and later
Information in this document applies to any platform.

Goal

You are using OBIEE 11.1.1.7.131017 with UNION queries.  How can you use these UNION queries with a prompt in SmartView?

In SmartView you there are two types of prompts:

  1. Page Prompts in Smart View are the equivalent of view prompts in BI Answers. View prompts are specified on individual views within an analysis. Smart View supports table prompts, graph prompts, and gauge prompts in BI Answers; these types of prompts are called page prompts in Smart View.
  2. Prompts in Smart View are the equivalent of prompts in BI Answers. Smart View only supports column prompts.

 

Solution

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms