Using SQL2K,CE&CA9..
I have created a OLAP cube using SQL Analysis Service, and then created a cube in Crystal Analysis. I can view the cube fine in CE (I am an administrator), but when a member of Joe Public tries, they get a message stating that the Cube no longer exists and gives them the option to select another. I am not sure how rights on Cubes should be set up, could anyone point me in the right direction. I had thought that it would be the same as "regular" reports - I have given the account that CE runs under (cdrepadmin) all rights to the cube, but to no avail.
I have created a OLAP cube using SQL Analysis Service, and then created a cube in Crystal Analysis. I can view the cube fine in CE (I am an administrator), but when a member of Joe Public tries, they get a message stating that the Cube no longer exists and gives them the option to select another. I am not sure how rights on Cubes should be set up, could anyone point me in the right direction. I had thought that it would be the same as "regular" reports - I have given the account that CE runs under (cdrepadmin) all rights to the cube, but to no avail.