missing a "Left outer join" in MS AS

[nsoerensen]

Hi

As a fairly new user, I am running in to trouble about joins in Analysis Manager.

I have a shared dimension build as a snowflake schema.
Now, I don't get all of my records from my facttable.
I have discovered that that columns in my facttable can be empty, so I got nothing for level 2 and 3 in my dimension. Therefor it is filtered out. Is it possible to use af left outer join in Analysis Manager og what other "workaround" is there?

 

[pabloj]

AFAIK fact table can't contain null values, so no outer joins.
You can try building logical fact and dimensions by using views and then build the cube on those views.
The best solution would be to understand why there are nulls and take appropriate actions

Stick to your guns