Cannot see the cube using Crystal Analysis 9

Hi,

I'm currently using SQL 2000 Analysis Manager to create a cube, and Crystal Analysis 9 to try to view the cube.

When I grant the role of the cube to "Everyone", there is no problem, CA is able to view the cube.

However, when the role is granted to a specific "domain account", the cube is NOT showing up in CA...

My settings are: SQL 2000 on one PC, and CA on another PC. Both are under the same domain, and both are logged in using the same domain account. Also, this domain account is already granted the "Administrator" rights in SQL 2000 PC.

Any idea why this is happening?

Anyone ran into this problem too?

Thanks very much in advance.

sendmehere.

Try to narrow problem a little bit.

Try and use another application to browse your AS2000 cubes. You can try Excel PivotTables for that. See if you can connect and see the cubes.

If Excel works for you, the problem is then with CA.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward, I'll try that on Monday!!!

Will let you know the result afterwards.

|||

bad news...

When I use EXCEL pivot table, it is able to connect to the cube with or without a proper domain account / password...

so I cannot proof that it is CA problem...

Or it may be the Analysis Manager's problem?

Anymore ideas?

Thanks!!!

|||

If Excel is able to connect, the problem is likely in the CA.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.