Cube via Stored Procedure - incorrect summing

[Guest_imported]

Hi
I have built a cube off a stored procedure which brings data in from many sources. The data is at daily granularity - however two measure that I bring in (Revenue and Costs) are at monthly levels.

When inserting into the cube, I naturally get the month figure adding up for every day (ie. month total = 24,000,000 x 30 days - instead of just 24,000,000 )

What is the best way to overcome this?

I cannot bring the data in at a daily level - it has to stay at monthly - and I cannot change the cube to monthly granularity - the customer wants it at daily.

Help please!?

Thanx

 

[Guest_imported]

I would create a separate cube with those measures at the month level. Then reference those measures in the "day" cube using the cubelookup function.

dshroyer@obs3.com
OLAP Business Solutions