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.

AdminTool unable to create dimension

choracy69Jun 24 2016 — edited Jun 27 2016

Hi,

I have problem with my structure in RPD when I want to create Logical Dimension.

My structure:

Physical Layer:

I have to Fact Table: Fact_Hours_REQ (1) i Fact_Hours_MES (2). Both table have columns: SEQ_NUM, but in (1) is double and in (2) is varchar.

Logical Layer:

I want to create dimension from this two tables with one column: SEQ_NUM.

My dimension called: Dim_OPERATION_SEQ_NUM

And it joins to this two fact tables: Fact_Hours_REQ (1) i Fact_Hours_MES (2)

pastedImage_1.png

pastedImage_0.png

And when I want to create logical dimension I have error:

pastedImage_3.png

Any suggestions?
This post has been answered by choracy69 on Jun 27 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 25 2016
Added on Jun 24 2016
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
10 comments
1,543 views