dbTalk Databases Forums  

PIVOT TABLE CONNECTVITY PROBLEM

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


Discuss PIVOT TABLE CONNECTVITY PROBLEM in the microsoft.public.sqlserver.olap forum.



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

Default PIVOT TABLE CONNECTVITY PROBLEM - 10-21-2003 , 09:44 AM







i am getting the connectivity problem to the web-page at server.

At server i have saved he Pivot Tables in EXCEL as web-pages.

All these HTML files are store in a folder c:\alm-reports.

This is given the sharing privilege.

I have 6 web pages.

Asset, Liability, Cash, Deposits etc.....


In the OS level i have created the following users

ALM
ALM4
RM

All these users are members of the OLAP Administrators Group in OS.

All the above user systems and the Server are in the ALM Work Group.

----------------

In the OLAP manager in the Database roles the following are created:

Role: ALM
Memberships: ALM,ALM4,RM (all the above NT Users)
CUBES: all the CUBES are selected for the access
Dimensions: Default ( all the accessible)

----------------

Server OS: Windows 2000
server bame: ALMSERVER
workgroup: ALM
Clients: Win-98
---------------

whenever i try to access the web-pages i get following error:

"PIVOT TABLE cound not connect to the datasouce Asset.
for information about the datasouce consult the cretor of the file"

ofx800004005 can not connect to the server "ALMSERVER"

----------------


Once you suggested open in the EXCEL at the client machine
and to publish there itself.

I tried to do the same.

when i try to get the <GET DATA>

when i try access the ALMSERVER for OLAP-server the error is as follows:

"access can not be authenticated. security reasons"

-----------------

When the OS users are members of the OLAP administrators, all the
macines are in the same work group and all these are inturn defined as
the
members of the ALM Role of the OLAP database role,

why does the above error occur...

HOW TO RECTIFY THE ABOVE error

-----------------

2.

for top 10 branhes and for ranking i have used the MDX query.
i have written mdx query but how to deploy it on WEB with ASP.


i wrote a small English fquery also. How to deploy it on WEB with ASP.

I seek an appointment with you. I know you are busy, still i request you
to
help me. We will shortly be getting a high end server for the analysis.

i need you help, guidance for web deployment of mdx, EQ and the web
pages
client access.


at what time i can call you in the night please tell me. i need to
expalin
you.


excuse me for the inconvenience i cause to you.

awaiting your reply.


radha_y2k (AT) yahoo (DOT) com



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

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.