Showing posts with label ctp. Show all posts
Showing posts with label ctp. Show all posts

Friday, March 23, 2012

I can't dissable a dimension level

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.

I can't deploy a solution

I installed April CTP 2005 in a new computer and I can't deploy an existing solution which works in the old computer.
When I deploy it give me Error -1056899072 with no messages.
If I make a new solution then it works fine.
I'm sure the problem is with the datasource. Because when I try to deploy with june CTP give an error: "no se ha efectuado ninguna asignacion entre los nombres de cuenta y los identificadores de seguridad" and in English is like No mapping between account names and security IDs.
Any ideas?
I don't want to fix all by hand
Thanks in advance.I have defined roles for cubes. Then you must validate each member of the role with the user accounts.
Hopefully I can deploy the project.