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!

how to base a calculated column in another dimension

MaahjoorOct 27 2015 — edited Oct 29 2015

Dear all,

i am using OBIEE 11.9 on oracle 12c.

i have the following two dimensions in Bussiness Model,

pastedImage_0.png

i want to create TOTAL FEMALE logical column in F1 Student Graduation dimension which is based on the Gender column in the D1 Student dimension. The gender column has two possible values 'F', 'M'. the TOTAL FEMALE column should count the gender for F.

how could i do that?

thank you.

Regards.
This post has been answered by Thomas Dodds on Oct 27 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 26 2015
Added on Oct 27 2015
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
9 comments
471 views