Thanks you guys. All the solutions work. I'm sorry for not following rules and posting the DDL statements. I'll keep this in mind when I post next time.

Sorry if...

The question is the last part . The fact table needs to updated with the news ids.

Please see the last table. That is the result form I need it...

Hi Guys,

Any more inputs required or do you'll think this would still work ?

Uploaded the data zip file at

http://wikisend.com/download/240868/Data .zip

This contains the insert statement for about 75000 rows, which will really test the performance.

1. Sorry guys for my oversight.Totally my mistake, it was just a condition that really didn't make much of a difference, but here's the new DDL script (Please see below)....

Hi Lynn did you get a change to look into this. I need to figure out if we can't do this.

Found this online . You might want to try this :

I discovered that the Reporting Services Configuration Manager was incorrectly showing green check-marks indicating my Report Server and Report Manager...

Any suggestions ?

So the calculation goes like this :

Modeled Cost = (Driver1/Driver2)*UnitA*UnitB+FixedCost

For eg :

Old Modeled Cost (6330/5918)*70791.61*1.025+0 = 77612.98

So If I was to update Driver1 from 6330 to 7000

New Modeled...

Here's the DDL statement:

CREATE TABLE dbo.TBF_BUDGETExpenses

(

BudgetID int not null,

Scenario varchar(50) not null,

DriverValue1 float null,

DriverValue2 float null,

UnitA float null,

UnitB float null,

FixedCost float null,

ModeledCost decimal(18,2)null,

Oct decimal(18,2) null,

Nov decimal(18,2) null,

Dec decimal(18,2) null,

Jan decimal(18,2)...

Thanks guys. I'll try out your sugesstions and reply back.. Thanks!!!

Any thoughts people ?