|
Home > Archive > MS SQL Server OLAP > December 2005 > Viewing Cube data in a client web browser
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Viewing Cube data in a client web browser
|
|
|
| good day, everybody. This question may seem simple to most of you, but i've
not found a solution to it yet. If you know what's ailing me, please do help
me out.
I've a asp.net web application hosted on Windows 2003 server SP1. I want to
view a report generated with OLAP cube. The cubes are set up on the web
server's analysis server database (version= MS SQL Server 2000 Analysis
Services SP 3a)
The report renders nicely in the web browser launched on the web server.
However, there is an error rendering the report when i launch the web
browser on another machine.
The error message is not very helpful. It says:
The query could not be processed. The data provider didn't supply any
further information.
On this client machine, the internet explorer settings has been changed to
allow access of data source across domain, and both web server and client are
in the same workgroup.
This is my question. Thank you for your time.
| |
| Erdal Akbulut 2005-12-20, 7:23 am |
| Minas,
How do you access to data source from web page, be sure you have setup the
security on the Analysis Services.
Did you try to access to the cube form excel ?
"Minas" <Minas@discussions.microsoft.com> wrote in message
news:44D0BEA9-C11B-4F52-ABDC- 2CEC6CFF5E18@microso
ft.com...
> good day, everybody. This question may seem simple to most of you, but
i've
> not found a solution to it yet. If you know what's ailing me, please do
help
> me out.
>
> I've a asp.net web application hosted on Windows 2003 server SP1. I want
to
> view a report generated with OLAP cube. The cubes are set up on the web
> server's analysis server database (version= MS SQL Server 2000 Analysis
> Services SP 3a)
>
> The report renders nicely in the web browser launched on the web server.
>
> However, there is an error rendering the report when i launch the web
> browser on another machine.
>
> The error message is not very helpful. It says:
>
> The query could not be processed. The data provider didn't supply any
> further information.
>
> On this client machine, the internet explorer settings has been changed to
> allow access of data source across domain, and both web server and client
are
> in the same workgroup.
>
> This is my question. Thank you for your time.
>
| |
|
| Erdal,
thank you.
i've not defined any database role in Analysis Manager for accessing the
cube. Is that what you mean by setting up the security on Analysis service?
Please elaborate.
No, i'm not accessing the cube from Excel. i'm trying to access the cube
from a web browser page.
The analysis service is installed on the web server, and the web server has
an ODBC DSN set up, to access the database server.
"Erdal Akbulut" wrote:
> Minas,
>
> How do you access to data source from web page, be sure you have setup the
> security on the Analysis Services.
>
> Did you try to access to the cube form excel ?
>
> "Minas" <Minas@discussions.microsoft.com> wrote in message
> news:44D0BEA9-C11B-4F52-ABDC- 2CEC6CFF5E18@microso
ft.com...
> i've
> help
> to
> are
>
>
>
| |
| Erdal Akbulut 2005-12-22, 3:24 am |
| Minas,
Logon a client machine with the user name and password you are using to log
on Server.
If you cannot browse the cube from the client but the server. probably there
is a security issue.
Try connecting to the cube from a client machine using same user that you
use in the server.
"Minas" <Minas@discussions.microsoft.com> wrote in message
news:4F68AE21-7C3D-48A2-8AF0- 2BFABDABC573@microso
ft.com...
> Erdal,
>
> thank you.
>
> i've not defined any database role in Analysis Manager for accessing the
> cube. Is that what you mean by setting up the security on Analysis
service?
> Please elaborate.
>
> No, i'm not accessing the cube from Excel. i'm trying to access the cube
> from a web browser page.
>
> The analysis service is installed on the web server, and the web server
has[color=darkred]
> an ODBC DSN set up, to access the database server.
>
>
> "Erdal Akbulut" wrote:
>
the[color=darkred]
do[color=darkred]
want[color=darkred]
web[color=darkred]
Analysis[color=darkr
ed]
server.[color=darkred]
changed to[color=darkred]
client[color=darkred
]
|
|
|
|
|