Saturday, February 25, 2012

Attribute relationship doestn't exisits between

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...
>
>
|||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
news:D993701D-45E5-454A-A28D-84D33EE515B0@.microsoft.com...[vbcol=seagreen]
> I gave relationship in data view, can you explain me how to check
> atribute relationships in the dimension?
> Thanks
> Kalyan
> "MC" wrote:

No comments:

Post a Comment