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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Prompt

user10441472Mar 4 2010 — edited Mar 4 2010
I have created one prompt using two dimension tables (no fact)
Organization and employee. Up to last week it was working fine (the join became between two dimensions and first fact table). In last week I had created one more fact table and join with these two dimensions (for other requirement). Then my prompt is not working. I gone through SQL query, I came to know it is joins with new fact.
My questions are how I can restrict those two dimensions stick with first fact only. If I keep any columns from first fact in prompt how I can hide that one.?
Should I create new folder in presentation layer for this prompt?

I would appreciate for your help.

Comments

daan bakboord
Hi,

Define a 'Implicit Fact Column', via the properties of your Presentation Catalog. You will find this setting on the General Tab.

Good Luck,

Daan Bakboord
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 1 2010
Added on Mar 4 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #prompt
1 comment
503 views