Re: OWC and Analysis Services (cross-post)

what is the XMLA virtual directory security?
do you allow anynomous access?
if yes, then create a role in your SSAS database with a member which is the account used behind the anonymous access of the virtual directory.

if you don't allow anonymous access then add the end user account in the membership list of the role.

"craig_amtdatatechnologies@xxxxxxxxxxxxxx" <craigamtdatatechnologiesdiscussionsmi@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:611353EB-A5FE-4005-91B0-160489D9E645@xxxxxxxxxxxxxxxx
Hi,

We've been asked to enable an external client to access a cube via OWC.

The idea is that if they play about with the cube through the PivotTable
control, this will enable them to define their requirements for a reporting
system to sit on top of the cube.

I've read and implemented the contents of the following document:-

- http://www.microsoft.com/technet/prodtechnol/sql/2005/httpasws.mspx


I've installed OWC and the SQL data access components on a test machine, and
have been trying to access the cube through a web-page hosting the pivot
table control.

Data access across domains is enabled in IE

The error returned is "The query could not be processed: The HTTP server
returned the following error: Forbidden."

Obviosuly some security setting somewhere needs to be tweaked ... but which
one :/

Access to the web-page hosting the OWC control will be locked down by IP
address.

Bearing all the above, what is the most straightforward means of enabling
access via the OWC PivotTble control?


Thank you for help.


.

Relevant Pages

  • Re: How to control owc
    ... if you know the language you can control exactly what ... data is pulled back from the cube which affects what shows up on the client ... > Can I somehow control the way owc present dimensions. ... > Can I do MDX to do the trick or events handling? ...
    (microsoft.public.office.developer.web.components)
  • Re: Critical Performance Issue - OLAP + OWC11
    ... I made a performance comparison to the Foodmart Warehouse and Sales cube, ... amount of data downloaded to the client. ... Execution Location=3;Default Isolation Mode=1 ... The client still downloads about 6mb for each OWC in a view, ...
    (microsoft.public.sqlserver.olap)
  • Re: License issues with OWC11
    ... and problem for intranet OWC developers. ... Before when the control had the license checking code, ... the clients who would use the OWC, because if the clients didn't have ...
    (microsoft.public.office.developer.web.components)
  • Re: How to extend OWC
    ... OWC support actions when you add so code behind the OWC. ... I have tried to create the same control, but I have some errors with the ... Microsoft is providing this information as a convenience to you. ...
    (microsoft.public.sqlserver.olap)
  • 401:Unauthorized Connection Puzzler
    ... This is the 5th time i have installed XML SDK as well as the Grape City ... getting an "unauthorized" connection error ... When i use the BI control to try and connect i get the same error - 401 ... connect Excel to the cube, so i don't think it's rights or role restrictions ...
    (microsoft.public.data.xmlanalysis)
Loading