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.

OBIEE RPD Question

2934998Nov 29 2016 — edited Nov 29 2016

Hi,

I need to join a new table to an existing fact table and a dimension join with the following scenario:

Dim A
1
2
3

Fact
1
2
3

Dim B
1
3

Fact -> Dim A

Fact -> Dim B

In my report i want to show all the records from dim A but wherever it matches with Dim B have a *, how can we implement this in RPD? So the output in Publisher i am looking for is:

Output
1* 2 3*

Output

Any help is appreciated

Thanks,

Nimesh

This post has been answered by Gianni Ceresa on Nov 29 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 27 2016

Added on Nov 29 2016

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #publisher

7 comments

521 views