ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 XML for Analysis Security
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

n/a

30 Posts

Posted - 04/30/2006 :  22:52:28  Show Profile  Reply with Quote
RP Version 2.1
OS = Win 2003
Asp.Net = v2
SQL Server = 2000

I have enabled XML for Analysis but have not been able to connect to the desired OLAP cubes.

The SQL Server, Analysis Server, IIS and Domain Server are all on the machine.

Even when the Domain Administrator is given access to the cubes via the database roles in Analysis Services (AS) and then logs onto report portal with his NT username and password set up in the REport Portal User account the cubes are not visible.

If the 'Everyone' user is added to the AS database role the cubes are visible.

Strangely when the Synchronise Users feature of Report Portal is used the required domain displays but does not return users however an old domain set up on another server with NT 4 shows both the domain and users?

Help!

Thanks
Ryan

Cheers
Ryan

admin

1644 Posts

Posted - 05/01/2006 :  11:02:40  Show Profile  Reply with Quote
What results do you get when connecting with Excel or OWC?

Did you try the “Test Role” button? (Cube > Manage Roles)
Go to Top of Page

n/a

30 Posts

Posted - 05/01/2006 :  17:49:51  Show Profile  Reply with Quote
I have used the Test Role button and it worked fine.

I have NOT tested with Excel. I will do so and report back.


Cheers
Ryan
Go to Top of Page

admin

1644 Posts

Posted - 05/05/2006 :  10:09:25  Show Profile  Reply with Quote
If you don’t have Excel you can do the same with MDX Sample Application (mdxsampl.exe). Shift-Right click on the executable and select “Run As…”
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page