Hans-

Thanks for the persistence and I'm really starting to like the fully dynamic calculation idea. Going to run some tests now...

- B

On a related side note - here's what I'm doing to calculate cumulative performance - Month to Date, Quarter to date etc...

http://www.sqlservercentral.com/forum/topic.asp?TOPIC_ID=11056&FORUM_ID=8&CAT_ID=1&Topic_Title=Calculating+Financial+Performance+question&Forum_Title=T%2DSQL

It uses LOG and EXP with SUM...

Actually - spoke with a Finance guy and he has a slightly different way which is additive and uses LOG and EXP - but the result is exactly the same....

Most excellent David - thanks.

My performance data ends up looking like this:

ENTITY DATE PERFORMANCE

S&P 500 5/1/2002 ...

Thanks Steve -

I have both "ToolKit" books - have read the older one and am halfway through the newer.

Unfortunately, I can be a conceptual blockhead at times and am still...

Thanks -

So are you saying I do not necessarily need a data warehouse, data marts, or some kind of temporary scrubbing tables? I can "Load My Cube" every day...

Thanks again S -

"Out of curiosity, why try to go with a trigger to start with?"

1) I'm primarily a middle-tier / front-end developer. As such, I've read much of...

Well, thanks and here's why.

If I wanted to change this group from

Group1 Bob 50

Group1 Joe 50

To This:

Group1 Bob 60

Group1 Joe 40

It would probably be accomplished in 2 Update statements.

Update Groups...

Thanks Scorpion...Thanks.

I "Assume" such things are happening - but - I also assume the worst. Meaning - it's warning me for a real reason. Perhaps I'm doing something...

When I save the Computed Formula - I get this message:

Warnings were encountered during the pre-save validation process, and may result in a failure during save. Do you want...

Hey funny guy...

1) Read my posts - I obviously have a "working" solution.

2) If you actually took the time to test my sample and have ever written a program before...

Again....

Please look at the source code.

*Important*

There are no non-deterministic functions in my example function and it compiles fine.

*Important*

The function compiles and runs fine.

Problems arise only when calling the...

Heh Don...

Read my first post carefully - in fact - try it on your machine. My problem is that I AM passing in a datetime param.

All I want to...

Ya thanks -

I have that working - but it seems that any time I try to embed functions as parameters I get problems. I'd like to use T-SQL...

Thanks again Mike.

Ya - I've been reading myself and "Surrogate Keys" are mentioned many times. However - What if I wish to link from my Cube back to the source...