Re: SSAS and SSRS

#1

have you created some security roles in your cubes?
if no, create one and see if this helps you.

"Scott Mescall" <ScottMescall (AT) discussions (DOT) microsoft.com> wrote

Quote:

All,

I'm having A LOT of trouble connecting a RS report to an SSAS cube. The
error I'm getting is "no cubes can be found". It's strange because all
other
SQL components can see and interact with this cube. SSAS is 64 bit and
I'm
running 32 bit client tools with x86 SP1 on the client machine. Not sure
if
this is a 64 bit issue or what. I've also un-installed and re-installed
the
client tools and SP1. Nothing seems to help. I've never had this much
trouble connecting to SSAS before!?!

Any help anyone has would be awesome!

Thanks,
Scott

#2

I'm using the same setup like yours and I have no issue.

Can you access your cubes from reporting services but on the server himself?

"Scott Mescall" <ScottMescall (AT) discussions (DOT) microsoft.com> wrote

Quote:

I had roles at 1st and it was not working, I have since taken the roles
off.

"JÃ©jÃ©" wrote:

have you created some security roles in your cubes?
if no, create one and see if this helps you.

"Scott Mescall" <ScottMescall (AT) discussions (DOT) microsoft.com> wrote in message
news:B394BAEB-B94D-4933-8E2A-223D26D94623 (AT) microsoft (DOT) com...
All,

I'm having A LOT of trouble connecting a RS report to an SSAS cube.
The
error I'm getting is "no cubes can be found". It's strange because all
other
SQL components can see and interact with this cube. SSAS is 64 bit and
I'm
running 32 bit client tools with x86 SP1 on the client machine. Not
sure
if
this is a 64 bit issue or what. I've also un-installed and
re-installed
the
client tools and SP1. Nothing seems to help. I've never had this much
trouble connecting to SSAS before!?!

Any help anyone has would be awesome!

Thanks,
Scott

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SSAS and SSRS

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Re: SSAS and SSRS - 12-12-2006 , 07:43 AM

Re: SSAS and SSRS - 12-12-2006 , 08:42 AM