Groups | Blog | Home
all groups > sql server data warehouse > april 2007 >

sql server data warehouse : Attribute relationship doestn't exisits between



Kalyan
4/5/2007 2:20:04 PM

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
MC
4/7/2007 12:00:00 AM
Well, did you check the atribute relationships in the dimension?


MC


[quoted text, click to view]

Kalyan
4/7/2007 11:32:02 AM
I gave relationship in data view, can you explain me how to check
atribute relationships in the dimension?

Thanks
Kalyan

[quoted text, click to view]
MC
4/7/2007 9:13:30 PM
You need to go to the dimension editor in BIDS and check on the atribute
relationships for the atributes involved.


MC


[quoted text, click to view]

AddThis Social Bookmark Button