All,

I am just starting to work with cubes. I have a fact table
on which my measures are count and count DISCITNCT.

I have 4 dimensions. One of the dimensions does not exist
for all values in the Fact table as a result of the inner
join between the fact and the dimension table my result
set is very limited.

How can I set the fact table to overlook or do an outer
join when the dimension does not have any corresponding
members of the fact table ?

Thank you all,
Chandra.

Depending on your case, some people create an "Unknown" entry in the dim
table to default to when an entry in the fact does not join, you can set
your fact table to this in your staging area. Again, if your case allows
this, if not, you'll have to do some more scrubbing

HTH

--
Ray Higdon MCSE, MCDBA, CCNA
---
"Chandra" <anonymous (AT) discussions (DOT) microsoft.com> wrote

Thanks, Ray.

I am not sure how I would create the unknown entry. Could
you please point this out.

Thanks,
Chandra.

For any null values in your fact table that you are wanting to see
counts on, you could update them to "unknown" then have an entry in the
dim table called "unknown".

Using distinct count in a cube that has other measures can be
problematic, you might create one cube with the distinct count, another
with your other measures then create a virtual cube to tie them
together.

HTH

Ray Higdon MCSE, MCDBA, CCNA

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!