M
Markus Stehle
Hi all!
I have an asp.net web application which contains some statistic pages that
contain OWC10 pivot tables and charts (displaying sales values and so on).
The pivot tables are connected to an OLAP cube hosted on a database server.
These pages are accessed via the local intranet by a special group of
people. The application itself is only accessible via the local intranet.
Now the statistic pages should be made available to a very small group of
external people. The members of the group should be able to access the pages
via the internet. All the members will have the required MS Office products
installed on their local machines so that can use the fully interactive mode
of OWC10.
This leads me to two problems that I currently do not know how to solve:
1) Connection issue
The OWC10 components within my pages run on client side. The connection
string somewhere within the HTML code looks like this:
provider=MSOlap.2;data source=myServer;initial catalog=myDatabase.
The be accessible via the internet, the connection string should like
datasource=http://myIP/myServer or whatveer, but that does not work.
Currently my only solution was a VPN connection making the external people
part of the intranet - but that is not really suitable solution.
2) Security issue
As the external peolpe should not have access to all the data contained in
the cube, I must e.g. exclude some cube dimension members and so on. But as
this will be done via JS code on client side, it was also possible that one
of the guys modifies the code and removes the limitations on his own
(assuming he has some programming knowledge).
I'm sure there is a solution for the first problem, but I'm not sure if the
second problem can be solved that easily. Can anybody provide me some help
with these?
Thanks
Markus
I have an asp.net web application which contains some statistic pages that
contain OWC10 pivot tables and charts (displaying sales values and so on).
The pivot tables are connected to an OLAP cube hosted on a database server.
These pages are accessed via the local intranet by a special group of
people. The application itself is only accessible via the local intranet.
Now the statistic pages should be made available to a very small group of
external people. The members of the group should be able to access the pages
via the internet. All the members will have the required MS Office products
installed on their local machines so that can use the fully interactive mode
of OWC10.
This leads me to two problems that I currently do not know how to solve:
1) Connection issue
The OWC10 components within my pages run on client side. The connection
string somewhere within the HTML code looks like this:
provider=MSOlap.2;data source=myServer;initial catalog=myDatabase.
The be accessible via the internet, the connection string should like
datasource=http://myIP/myServer or whatveer, but that does not work.
Currently my only solution was a VPN connection making the external people
part of the intranet - but that is not really suitable solution.
2) Security issue
As the external peolpe should not have access to all the data contained in
the cube, I must e.g. exclude some cube dimension members and so on. But as
this will be done via JS code on client side, it was also possible that one
of the guys modifies the code and removes the limitations on his own
(assuming he has some programming knowledge).
I'm sure there is a solution for the first problem, but I'm not sure if the
second problem can be solved that easily. Can anybody provide me some help
with these?
Thanks
Markus