AS2005 SP1.


I have a cube were I have a dimension with a hierarchy with 4 levels.

region
land
+-region (rigid, many)
mandants
+-land (rigid, many)
salesman
+- mandants (rigid, many)


When I browse the cube I get correct data on the leaf members (salesman) but
on all other levels there is no data. I've build another cube wich contains
only this dimension and I've got the same problem. There is data for only 2
salesmans wich is corectlly agregated on all levels.

The fact data is correct, the dimenion table is correct, the dimension
definition is also correct!.

region1 200
+-land1 (empty)
+-mand1 (empty)
+- salesman1 100
+- salesman2 100
+-land2 200
+-mand3 200
+-salesman3 100
+-salesman4 100
+-salesman5 50
+- mand4 (empty)
+- salesman6 100
+-salesman7 100

I can't find the error or why is acting like this. I have in the same
database also other cubes/dimensions wich are working flawless.

Anyone has an ideea why is not working?.
I can't delete the dimension and recreate it because I have rolles (250)
assigned to it and I will loose all the permisions.
When I browsed I was logged in as administrator, and there is no explicit
role assigned to this user.


Thanks,
Radu

I copied the database to a development server and create the script for the
dimension.
Then I delete the dimension and recreate -it (running the script) and bind
it in the cube.

The data is right now!

I don't want to delete it (if it is possible) in the live system because by
deleting it I will loose all cube permissions(approx 250) related to this
dimmesnion.

Is there a way to fix this dimension somehow without deleting it and
re-creating it?
Anyone has an ideea?

Thanks,
Radu



"Radu Colceriu" <radu_colceriu (AT) hotmail (DOT) com> wrote