dbTalk Databases Forums  

Calculated function not working in Excel..

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


Discuss Calculated function not working in Excel.. in the microsoft.public.sqlserver.olap forum.



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

Default Calculated function not working in Excel.. - 11-20-2003 , 09:45 PM






Hi
I created a .dll using vb and registered that in the
analysis server cubes calculated member.When i access
that calculated member from owc component on web its
works fine.When i connect the cube through excel that
function is not working and its showing the value like
this-#VALUE!.Anybody have any clue on that.Please tell me
how I can make that works both in excel and OWC,it'll be
greatful.Thanks in advance


Sanith



Reply With Quote
  #2  
Old   
Tom Chester
 
Posts: n/a

Default Re: Calculated function not working in Excel.. - 11-20-2003 , 10:12 PM






In thick client mode, custom functions must be deployed to client. (More
precisely, the functions must be installed on the server and wherever PTS is
installed.)

tom @ the domain below
www.tomchester.net


"sanith" <skumar (AT) 5by5networks (DOT) com> wrote

Quote:
Hi
I created a .dll using vb and registered that in the
analysis server cubes calculated member.When i access
that calculated member from owc component on web its
works fine.When i connect the cube through excel that
function is not working and its showing the value like
this-#VALUE!.Anybody have any clue on that.Please tell me
how I can make that works both in excel and OWC,it'll be
greatful.Thanks in advance


Sanith





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.