Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Presentation Variable in Column Formula

user 1208988Jun 19 2017 — edited Jun 19 2017

Hi All.

I have this requirement to show multiple values of presentation variable in separate rows in a table or pivot.

For example, if I select three department names from dashboard prompt, the table/pivot will populate three rows representing a department.

The column I am trying to populate is not modeled, it's SELECT_PHYSICAL query (to create the prompt).

And then presentation variable in column formula of analysis.

Result at the moment looks like Dept1,Dept2,Dept3 all in one row.

My need is to show

Dept1

Dept2

Dept3

Thanks

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 17 2017
Added on Jun 19 2017
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
3 comments
204 views