Dimension Attribute Was Not Found

[levodestro]

Hi,

I have a dimension with 3 levels: Departament, Sector and Product Code.

In this dimension I added some "attribute relatioships" (Product Name, Sale Price, etc).

I can process this dimension and the cube with no problems, but when I try to browse the data I get a "#Value!" error message (The Product Name dimension attribute was not found) in Departament and Sector levels. In Product Code level all the data are shown correctly.

I've tried everything but nothing seems to work.

Thanks,

LevoDestro.

 

[johnherman]

The attributes you added appear to be at the Product level, thus would have multiple values or be meaningless at the parent levels of Sector and Department.

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[levodestro]

johnherman,

the attributes are indeed related to the Product level.

this cube was originally developed in SQL Server 2000 and it works fine. it shows no data in Departament and Sector levels, only in Product level.

i checked at Microsoft and i found that this problem was solved with Service Pack 1.

the server i'm working with has this service pack applied, but i'm still having this problem.

thanks,

levodestro.

 

[levodestro]

I found the solution. I'm now checking in wich level of the dimension I'm in to show or not the data.