I have a table in the dsv that contains
Key
ParentKey
AccountNumber

It is a parent child table.

I have created that relationship in the dsv

When I go into the dimension wizard to create the dimension, It appears to
recognize that this is a parent child dimension, I get a message "Invalid
Object Name dbo.AccountsPC". dbo.AccountsPC is the name of the table.
It won't display the data in the "Preview Attribute values:" section of the
wizard.
If I ignore this error and continue, the dimension wizard will finish, but
it won't create any hierarchy's.

Can someone tell me what I am doing wrong. I am on SP1 of SSAS 2005.


Thanks

can you create it without the wizard?>

"Chris" <cexley (AT) enableconsulting (DOT) com> wrote