AS2K SP4

I have a cube with several Dimensions that provide data at the Account or
Company level. There are approx 3.5 million of these at a location specific
level
We recently had a requirement to provide a division of the organization a
drillthough by named territories. Specifically, Region-->State-->Account.

My problem is when this Dimension is added to the Cube and processed, my row
count diminishes by the number of named accounts within it
because AS only uses Inner Join when processing. Is there a way to process
using an Outer Join so that I get all the rows correctly?

I saw a post here from 10/21/2005. Subject: Dimension Question that seemed
to address this. But I am not sure this is the correct workaround
and I'm not totally clear on how to implement it.

Could anyone help me out with this, please?

Regards,

-Troy

Normally I would handle this type of situation, by adding a record to
the account dimension to connect to these unassigned/unknown/un-named
accounts. Then during the ETL process, insert the key for this member
into the appropriate fact records.

Another variation (shortcut) on this approach is to create a view on
your fact table and coalesce the null values to the value of the key for
the "unnamed" accounts. Then use this view in place of the actual fact
table.

If you follow either of these approaches the inner join that the cubes
use when they process will not be an issue.

AS2005 has some built-in facility for handling unknown members, but this
is one of the areas I have not had much chance to play with and there is
not much documentation on them in BOL that I could find.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#r8V4I3GGHA.608 (AT) TK2MSFTNGP14 (DOT) phx.gbl>, tjerkins (AT) alltel (DOT) net
says...