Multiple Fact table issue

I have a subject area with 7 confirmed dimensions and two fact tables in that one table is fact less fact table, here I am trying to create a report using 3 columns out of which 2 columns are coming from two fact tables and one column is coming from dimension table.

When I created such report all I see only two columns that are related to dimension table and factless fact table, but I cannot  see the third column data which comes from another fact table.
No ERRORS but at the same time no result in the column
on checking the log I observe that it is looking at only one fact table (which is factless fact table)
In the RPD I have created hierarchies to all the dimension tables and set the aggression content to the detail level in the fact table.

SO not sure what is going wrong with that third column.

Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PortletPaulEE Topic AdvisorCommented:
I regret to say I just don't understand and so I cannot help.

Can you please provide:
  some sample data?
  your existing query?
  your expected result?

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
shragiAuthor Commented:
I fixed the issue it's my DB that is setup wrong.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.