Joining Fact Tables with Alias Tables

building semantic layer
1

I have a need to pull a column from a Fact Table which is linked to an Alias Table.
The join is correct as I can run a query using a SQL Generator(Sql Server) without issue.

But, if I try to pull in a field from the Fact table from the Alias table(where I am using most of the columns) I get an error message:

cannot run this report it contains objects that reference incompatible tables

:?: :?:

di652 (BOB member since 2005-02-24)

2

Ask the universe Designer to double-check any universe contexts.

Andreas :de: (BOB member since 2002-06-20)

3

Check if you still have some context defined in your universe. If at all there is a context defined in the universe, then each and every table in the universe should be part of any of the context. Otherwise we get the error of incompatible objects.
or
In where class try to use fact table for joins and not their aliases. And also try to have 1:1 join for your original fact tables and aliased tables in universe level.

vikingv009 (BOB member since 2016-10-13)

4

Thanks, looks like the tables are NOT joined. Maybe that is what prompted the error message I received.

Thanks again :slight_smile:

di652 (BOB member since 2005-02-24)