"Mike Austin" <anonymous@discussions.microsoft.com> wrote in message
news:0a6301c39e56$a68cd790$a001280a@phx.gbl...
> I am creating a number of data marts that will be using
> conformed dimensions (I hope). I have a slowly-changing
> account dimension that will have 100 million+ rows in it.
> However, some of my data marts have only 65,000 rows. When
> I run the storage wizard, I receive an error that the
> 64,000 row limit on "orphaned" dimension rows has been
> exceeded. In other words, my account dimension has tens of
> millions of rows in it that do not match up with a fact. I
> was hoping that these rows would be ignored...
>
> I would rather not have a separate account dimension for
> each fact table and apparently it is not possible to use a
> view as a dimension.
>
> Any suggestions welcome.
>
> TIA,
>
> Mike

>-----Original Message-----
>You can use a view as a dimension. That's the approach
that I would take.
>If you have 100 million members, you're going to have to
use ROLAP storage
>or you will need to have a 64-bit box with A LOT of
memory.
>
>Sean
>
>Sean Boon
>SQL BI Product Unit
>
>--
>This posting is provided "AS IS" with no warranties, and
confers no rights.
>Use of included script samples are subject to the terms
specified at
>http://www.microsoft.com/info/cpyright.htm.
>
>"Mike Austin" <anonymous@discussions.microsoft.com> wrote
in message
>news:0a6301c39e56$a68cd790$a001280a@phx.gbl...
>> I am creating a number of data marts that will be using
>> conformed dimensions (I hope). I have a slowly-changing
>> account dimension that will have 100 million+ rows in
it.
>> However, some of my data marts have only 65,000 rows.
When
>> I run the storage wizard, I receive an error that the
>> 64,000 row limit on "orphaned" dimension rows has been
>> exceeded. In other words, my account dimension has tens
of
>> millions of rows in it that do not match up with a
fact. I
>> was hoping that these rows would be ignored...
>>
>> I would rather not have a separate account dimension for
>> each fact table and apparently it is not possible to
use a
>> view as a dimension.
>>
>> Any suggestions welcome.
>>
>> TIA,
>>
>> Mike
>
>
>.