hi all,
I am somewhat new to MSAS and olap and exploring MSAS functions.
Presently I am working on cube writeback options and would like to use this
feature in a particular way, but couldn't visualize it.

My idea is, I'll have a budgeted sales measure and actual sales measure.
There should be something like Targeted sales.
E.g. Budgete sales for the year 2006 would be say 1 mil., and as a product
manager I want to allocate this to quarterly targets say 2.5 lacs per quarter
for all products. I shud be able to distribute this 2.5 to all products based
on their previous year sale figures (weighted) so I'd have target values for
all my brands.
I'll be able to compare and adjust those target values with my actual sales
figures.

Do u people think this is realistic ? : )

Now, there are several problems,
1. How to have measures with dif ganularity in one cube (I'd like 2 have
budgeted values yearly and targets quartely or monthly, and actuals will be
based on invoices)

2. The targeted sales is end user defined , so how should I consider it in
design?

.........

can neone give me some idea to start with ???

thanks ...