dbTalk Databases Forums  

Dynamic Formula in OWC/OLAP

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


Discuss Dynamic Formula in OWC/OLAP in the microsoft.public.sqlserver.olap forum.



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

Default Dynamic Formula in OWC/OLAP - 02-14-2006 , 02:07 PM






Hi All,

I have to calculate a formula dynamically on the fly based on passed
input
Parameters in my time cube.

FTE = time / (number workings hours per day) * (working days in
selected interval)

Where...

Number workings hours per day = input parameter
Working days in selected interval = calculated from start and end dates
input parameters.
Time = total time measure from time cube

I want to know how to pass input parameters from OWC and then apply
this formula dynamically on the fly on cube data

Any help appreciated

Thanks in advance
Narinder


Reply With Quote
  #2  
Old   
dbahooker@hotmail.com
 
Posts: n/a

Default Re: Dynamic Formula in OWC/OLAP - 02-15-2006 , 03:42 PM






you can't do it on the server side? sure seems easier on the server
side..

i can do it in the frontend.. programmatically; im sure it's totally
doable

i would reccomend microsoft 'step by step office web components' book

-aaron


Reply With Quote
  #3  
Old   
Narinder
 
Posts: n/a

Default Re: Dynamic Formula in OWC/OLAP - 02-16-2006 , 09:38 AM



hi aaron,

thanks for the reply.

can you give me some more clues as i don't have much time to complete
it.

i'll start looking at the book in mean time.

Narinder


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.