|
Home > Archive > MS SQL Server OLAP > November 2005 > problems with cube from tutorial
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
problems with cube from tutorial
|
|
| mkazmierski@gmail.com 2005-11-26, 8:39 pm |
| Hello,
I just wanted to build a cube according to 'Microsoft SQL Server 2000
Analysis Services' tutorial (point 2. Basic Functions(60 minutes)).
When I try to build a cube I get hunderds of errors like these:
A member with key '1' was found in the fact table but was not found in
the set of leaf members of dimension 'Employee'
The maximum number of dimension key processing errors has been
exceeded.
A member with key '2' was found in the fact table but was not found in
the set of leaf members of dimension 'Employee'.
The maximum number of dimension key processing errors has been
exceeded.
etc.
What's wrong??
Regards, Mark
| |
|
|
mkazmierski@gmail.com wrote:
> Hello,
>
> I just wanted to build a cube according to 'Microsoft SQL Server 2000
> Analysis Services' tutorial (point 2. Basic Functions(60 minutes)).
>
> When I try to build a cube I get hunderds of errors like these:
>
> A member with key '1' was found in the fact table but was not found in
> the set of leaf members of dimension 'Employee'
> The maximum number of dimension key processing errors has been
> exceeded.
>
> A member with key '2' was found in the fact table but was not found in
> the set of leaf members of dimension 'Employee'.
> The maximum number of dimension key processing errors has been
> exceeded.
>
> etc.
>
> What's wrong??
>
> Regards, Mark
| |
|
| Your fact table contains a dimension (foreign) key which references a
non-leaf dimension member, meaning the dimension member referenced by
the key in the fact table has a child or children members. Practically
speaking, your fact table can only reference dimension members which
have NO children. That's the definition of a leaf member.
Either change the key in the fact table, or eliminate child dimension
members in the offending dimension table. Then reprocess.
DAP
mkazmierski@gmail.com wrote:
> Hello,
>
> I just wanted to build a cube according to 'Microsoft SQL Server 2000
> Analysis Services' tutorial (point 2. Basic Functions(60 minutes)).
>
> When I try to build a cube I get hunderds of errors like these:
>
> A member with key '1' was found in the fact table but was not found in
> the set of leaf members of dimension 'Employee'
> The maximum number of dimension key processing errors has been
> exceeded.
>
> A member with key '2' was found in the fact table but was not found in
> the set of leaf members of dimension 'Employee'.
> The maximum number of dimension key processing errors has been
> exceeded.
>
> etc.
>
> What's wrong??
>
> Regards, Mark
| |
|
| Your fact table contains a dimension (foreign) key which references a
non-leaf dimension member, meaning the dimension member referenced by
the key in the fact table has a child or children members. Practically
speaking, your fact table can only reference dimension members which
have NO children. That's the definition of a leaf member.
Either change the key in the fact table, or eliminate child dimension
members in the offending dimension table. Then reprocess.
DAP
mkazmierski@gmail.com wrote:
> Hello,
>
> I just wanted to build a cube according to 'Microsoft SQL Server 2000
> Analysis Services' tutorial (point 2. Basic Functions(60 minutes)).
>
> When I try to build a cube I get hunderds of errors like these:
>
> A member with key '1' was found in the fact table but was not found in
> the set of leaf members of dimension 'Employee'
> The maximum number of dimension key processing errors has been
> exceeded.
>
> A member with key '2' was found in the fact table but was not found in
> the set of leaf members of dimension 'Employee'.
> The maximum number of dimension key processing errors has been
> exceeded.
>
> etc.
>
> What's wrong??
>
> Regards, Mark
|
|
|
|
|