dbTalk Databases Forums  

re:easiest way to publish a cube on web

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


Discuss re:easiest way to publish a cube on web in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
dr_7ef
 
Posts: n/a

Default re:easiest way to publish a cube on web - 08-28-2005 , 07:05 AM






DEAR Jéjé

infrastructure
windows 2003 and IIS and IE 6 and SQL(db + OLAP Analysis Manager
entrprise eda. msolap and (creat
pivot table and conect it by OLAP Analysis Manager and chang
connection string to http: connection like tha
Provider=msolap.2;Initial Catalog=FoodMart 2000; Dat
Source=http://PORTALS;initialcatalog; Client Cache Size=0;Auto Sync
Period=100000;Execution Location=3;Large Level Threshold=100; Connec
Timeout=120;

1) enable anonymous access and windows integration

if you have 2 user in your same pc ( admin , usr
if you login by admin it run when you login usr not run and provide
can't see Analysis Manage


Reply With Quote
  #2  
Old   
Jéjé
 
Posts: n/a

Default Re: re:easiest way to publish a cube on web - 08-28-2005 , 08:57 AM






does your database has a role defined?
without roles the user can't access the cube, you must explicitly autorize
the user to access the cubes in your database.

the admin user has access to all cubes by default.


"dr_7ef" <dr_7ef (AT) hotmail-dot-com (DOT) no-spam.invalid> wrote

Quote:
DEAR Jéjé;

infrastructure :
windows 2003 and IIS and IE 6 and SQL(db + OLAP Analysis Manager )
entrprise eda. msolap and (create
pivot table and conect it by OLAP Analysis Manager and change
connection string to http: connection like that
Provider=msolap.2;Initial Catalog=FoodMart 2000; Data
Source=http://PORTALS;initialcatalog; Client Cache Size=0;Auto Synch
Period=100000;Execution Location=3;Large Level Threshold=100; Connect
Timeout=120

1) enable anonymous access and windows integration .

if you have 2 user in your same pc ( admin , usr )
if you login by admin it run when you login usr not run and provider
can't see Analysis Manager



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.