Hi,

I am very new to Analysis Services. I know how to create cubes, dimemsions.
When I create cube and dimemsions, the measures in the dimensions is
calculated. My question is, after the cubes are created, how do I
recalculate the measures? I don't think recreating cubes is good idea.

TIA

You need to have an ETL (Extraction, Transformation, Loading) that pulls out
data from one or more systems and
fills up you fact and dimension tables in SQL. After this is done you need
to process the dimensions and cubes to
get it to recalculate aggregations.

This process can be automated and can be advanced in complex cases and not
so advanced in not so complex cases.

--Michael V.


"Danny Ni" <dndn (AT) yahoo (DOT) com> skrev i en meddelelse
news:eC$HGRxeEHA.3476 (AT) tk2msftngp13 (DOT) phx.gbl...