Hi !

I have successfully created cubes for sales data with quite some measures
and dimensions, but now I must take it one step further and create what I
would like to call a "Stock cube".

The cube will have dimensions like:
Itemnumber, Itemgroup, Stocklocation, Blocked, Customs classification
number, etc... around 5 other dimension for classifications of the
itemnumbers, and then a date dimension.

Those dimensions are no problem, but I am having problems with the measures,
which are not the simple sums of things for the diemsions and date you
select, but rather the current stock status.

The measures I am thinking about include:
Costprice, Kilograms, Quantity etc....

To further explain the problem, then all those measures are supposed o be
"status" or "stock" measures, stating the current status of the stock, based
on the dimensions you have selected. Thus selecting a particular itemnumber
and a stocklocation, should give you the current Quantity, CostPrice and
Kilograms for the selected item, in the selected stocklocation.

I need some ideas to create a cube like that, if it is at all possible.....

I could of course have two measures for each of Costprice, Kilograms and
Quantity, stating what is bought and what is sold for each, and then the sum
of bought+sold from the beginning of the fact table would be the status for
each item. But then I have problems with the date dimension. If I select
some specific date, I would like the cube to display the status of each of
the measures at the end of that date.

To further complicate things, after I accomplish all that, I would then like
to add some features to the cube, like calculating the mean stocklevel for
each given time period etc.....

OK, I am a relative newbie on the OLAP grounds, allthough I have
successfully created some "sale like" cubes in the past.

Please could anyone give me some directions and ideas on how to build my
"stock cube"...

Regards,
Pallli