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!

getting null value in one of the two fact columns

user9255588Mar 11 2013 — edited Mar 12 2013
Hi
I have fact1,fact2,dim1 tables. Dim1 is the common table for both facts.
When I pulled columns from fact1,dim1,fact2 I am able to get result
When I added a new logical column in dim1 table, I am only getting data from fact1 .
When I use dim1 ,fact2 column getting null values. I checked the SQL, the bi server is making the fact null
Cast( null as double precision) as c3.i checked the content level everything is at detail level in both the facts.

Thanks for the help.

SR
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 9 2013
Added on Mar 11 2013
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
2 comments
500 views