Hi,
I am working on multiple facts cube(with measure groups) and looking for
some online resources related to this feature in SSAS 2005.

pls point to some resources.

Thanks
Bhaskar

there is nothing special to know.

consider each measure group like an AS2000 cube and the AS2005 cube like an
AS2000 virtual cube which encapsulate these cubes.
1 measure group can contain measures from only 1 fact table like in AS2000
where 1 cube is related to 1 fact table only.
each measure group can be partitionned (each measure group and each
partition can be stored into different drives and folders)
a measure group can be a linked measure group coming from another cube in
the same database or from another (remote) database

after this, you can create calculated members etc like in AS2000 but with
more power and options.

if you want a side by side comparison with AS2000, there is too many
options.
but the most interesting are:
a "Real" distinct count measure which works fine under any type of
calculation (I mean this measure now support the aggregate function and
support multiple selections and filters while in AS2000 this is not
possible)
the many-many feature which allow you to link a dimension to a measure group
through another measure group.
proactive caching which provide real time or near real time cubes without
the usage of ROLAP partitions
and more...

I think you can found a lot of webcasts on the net and start to llok at the
adventure works sample database.
http://msdn.microsoft.com/sql/bi/analysis/default.aspx
http://www.microsoft.com/sql/technol...s/default.mspx

I hope this will help you.


"Bhaskar" <Bhaskar (AT) discussions (DOT) microsoft.com> wrote

Thanks Jeje for your help.

Bhaskar

"Jeje" wrote: