I am using SSAS 2005 (64bit)
i have client table

Dimension is

ClientShortCode (First letter of clientcode)
ClientCode
ClientName




In Dataview

Related clientcode to clientcode in fact table.


Before SP2 installation works fine, when i browse the dimension it looks like


A
ACC
Axxxx (name of client)
ABI
Abi.....

.....

.....
.....


L
LUJACK
LUMBERJACKS




After installing SP2, it give warning message

Attribute relationship doestn't exisits between one or more levels in this
hierachy


Is there any thing we need to do after installing SP2

any soultions or idea


Thanks in advance
kk

Well, did you check the atribute relationships in the dimension?


MC


"Kalyan" <Kalyan@discussions.microsoft.com> wrote in message
news:43D2E6FA-B462-4132-9336-944AA350F07A@microsoft.com...
>
> I am using SSAS 2005 (64bit)
> i have client table
>
> Dimension is
>
> ClientShortCode (First letter of clientcode)
> ClientCode
> ClientName
>
>
>
>
> In Dataview
>
> Related clientcode to clientcode in fact table.
>
>
> Before SP2 installation works fine, when i browse the dimension it looks
> like
>
>
> A
> ACC
> Axxxx (name of client)
> ABI
> Abi.....
>
> .....
>
> .....
> .....
>
>
> L
> LUJACK
> LUMBERJACKS
>
>
>
>
> After installing SP2, it give warning message
>
> Attribute relationship doestn't exisits between one or more levels in this
> hierachy
>
>
> Is there any thing we need to do after installing SP2
>
> any soultions or idea
>
>
> Thanks in advance
> kk

I gave relationship in data view, can you explain me how to check
atribute relationships in the dimension?

Thanks
Kalyan

"MC" wrote:

> Well, did you check the atribute relationships in the dimension?
>
>
> MC
>
>
> "Kalyan" <Kalyan@discussions.microsoft.com> wrote in message
> news:43D2E6FA-B462-4132-9336-944AA350F07A@microsoft.com...
> >
> > I am using SSAS 2005 (64bit)
> > i have client table
> >
> > Dimension is
> >
> > ClientShortCode (First letter of clientcode)
> > ClientCode
> > ClientName
> >
> >
> >
> >
> > In Dataview
> >
> > Related clientcode to clientcode in fact table.
> >
> >
> > Before SP2 installation works fine, when i browse the dimension it looks
> > like
> >
> >
> > A
> > ACC
> > Axxxx (name of client)
> > ABI
> > Abi.....
> >
> > .....
> >
> > .....
> > .....
> >
> >
> > L
> > LUJACK
> > LUMBERJACKS
> >
> >
> >
> >
> > After installing SP2, it give warning message
> >
> > Attribute relationship doestn't exisits between one or more levels in this
> > hierachy
> >
> >
> > Is there any thing we need to do after installing SP2
> >
> > any soultions or idea
> >
> >
> > Thanks in advance
> > kk
>
>
>

You need to go to the dimension editor in BIDS and check on the atribute
relationships for the atributes involved.


MC


"Kalyan" <Kalyan@discussions.microsoft.com> wrote in message
news993701D-45E5-454A-A28D-84D33EE515B0@microsoft.com...
> I gave relationship in data view, can you explain me how to check
> atribute relationships in the dimension?
>
> Thanks
> Kalyan
>
> "MC" wrote:
>
>> Well, did you check the atribute relationships in the dimension?
>>
>>
>> MC
>>
>>
>> "Kalyan" <Kalyan@discussions.microsoft.com> wrote in message
>> news:43D2E6FA-B462-4132-9336-944AA350F07A@microsoft.com...
>> >
>> > I am using SSAS 2005 (64bit)
>> > i have client table
>> >
>> > Dimension is
>> >
>> > ClientShortCode (First letter of clientcode)
>> > ClientCode
>> > ClientName
>> >
>> >
>> >
>> >
>> > In Dataview
>> >
>> > Related clientcode to clientcode in fact table.
>> >
>> >
>> > Before SP2 installation works fine, when i browse the dimension it
>> > looks
>> > like
>> >
>> >
>> > A
>> > ACC
>> > Axxxx (name of client)
>> > ABI
>> > Abi.....
>> >
>> > .....
>> >
>> > .....
>> > .....
>> >
>> >
>> > L
>> > LUJACK
>> > LUMBERJACKS
>> >
>> >
>> >
>> >
>> > After installing SP2, it give warning message
>> >
>> > Attribute relationship doestn't exisits between one or more levels in
>> > this
>> > hierachy
>> >
>> >
>> > Is there any thing we need to do after installing SP2
>> >
>> > any soultions or idea
>> >
>> >
>> > Thanks in advance
>> > kk
>>
>>
>>