<div>
I fixed the issue it's my DB that is setup wrong.
</div>


I fixed the issue it's my DB that is setup wrong.

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
When I created such report all I see only two columns that are related to dimension table and factless fact table, but I cannot &nbsp;see the third column data which comes from another fact table.<br />
No ERRORS but at the same time no result in the column<br />
on checking the log I observe that it is looking at only one fact table (which is factless fact table) <br />
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.<br />
<br />
SO not sure what is going wrong with that third column.<br />
<br />
Thanks,
</div>
</div>


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.

Thanks,

Multiple Fact table issue

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.

Oracle Database

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.

DB Reporting Tools

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.