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.