SQL Server 2005 april CTP
Hi, I have an snowflake dimension with 2 levels which I used in a cube. But I need to link it to the top level.
In AS 2000, the only thing I used to do is to disable the next level from the linked level. Now i'm trying to do this with no success.
How can I do that?
For example:
Dimension: Warehouse
Level 1: Warehouse
Level 2: Rack
I have linked my cube to the level Warehouse and I want to disable level Rack but AS raises this error: Errors in the metadata manager. The attribute for the 'Rack' source attribute, of the 'Rack' source cube level, is disabled.
I need to disable this level because it isn't linked to the cube.
Any ideas?
Thanks in advance.It was my error. I have mystake definning the key of the dimension. I fixed the key. Then in dimension usage you only have to define the correct granularity of the dimension and that's all.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment