Excel SSAS 2005

  • Hello

    I have two projects, each containing an SSAS 2005 cube. Both have been deployed to the local server and using SSMS, I have connected to the AS server and can browse both cubes.

    Using my client machine and Excel (2003), I have attempted to browse both cubes through as a PivotTable. However, doing this, I am only able to view one of the cubes. Both AS databases are shown but only one of them shows the cube within.

    Given that, I can see that I have rights to connect to the server, the analysis services server, the analysis services database but can only see one cube. Neither cubes have roles assigned to them.

    Can anyone offer any suggestions as to a possible solution?

    Thanks.

    J

  • Does anyone have any ideas ? This is still an issue for me!

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply