Hi, I'm having a problem with a simple subject area that causes issues with measures from two fact tables.
- I have two fact tables (Signon_A and Signon_B) and two dimension tables (Calendar and Employee)
- Signon_A and Signon_B are both joined to Employee through Employee_Key
- Signon_A and Signon_B are both joined to Calendar through Date_Key
- Both fact tables have non-aggregated and aggregated facts (specific start and stop dates as well as an aggregated duration)
When I create an analysis using Signon_A.start_date, signon_A.stop_date and signon_A.duration as well as Employee.Name and Calendar.Date the analysis runs fine. If I add Signon_B.duration it also runs fine but when I add Signon_B.start_date the analysis breaks with the 'no fact table exists' error.
There are some hieararchies created (Employee and Calendar) but I didn't think that i had to worry about this because I'm using common dimensions between the two tables. Any thoughts on how to resolve this?
Since both fact tables are at same granular level I would suggest to map each other (Signon_A maping Signon_B) in BMM layer logical fact @source.
Considering them as Fact and with fact extension.
BTW: Did you try by setting implicit fact at subject area properties?
Edited by: Srini VEERAVALLI on Feb 1, 2013 9:04 AM
in BMM local fact for Signon_A
expand source folder you might see 'Signon_A' ->properties >General tab ->Click on + icon
Pull required columns from Signon_B from physical layer to logical fact table
Edited by: Srini VEERAVALLI on Feb 1, 2013 2:21 PM