Hi,

I have a scenario where i need to show Actual # of passengers per City along
with Estimated # of passengers per City for Tri rail.
I have the detail data in a table while i have another table having only
Summary per City Total # of passengers.......

what is the best practice to show this kind of data in one cube like I want
to show Estimated Vs Actual..........

One would be to create another table having summary of actual from detail
table and then show the two tables measures in one cubes
but is there a way i can skip this extra creation of table...........

any best practice on this

Regards,

BizWorld

using AS2000 you have to create 2 cubes, 1 for the actual value the second
for the estimated measures.
then create a virtual cube which include the 2 first.
now you have the estimated values with the real values.

using AS2005, you have to create 1 cube and 2 measure group (1 for each
table)

you can now create a calculated measure like (which works with AS2000 and
AS2005):
Real / estimated to get the ratio.

"BizWorld" <moonis.tahir (AT) gmail (DOT) com> wrote

I am now working with Analysis service 2005. can you please explain a little
bit more how do i create two measure Groups under one Cube???



"Jéjé" <willgart (AT) BBBhotmailAAA (DOT) com> wrote

simple,
use the cube creation wizard or create a new measure group by clicking the
"new measure group" in the "cube" menu. (open the cube, go to the cube menu,
or click the icon number 4 in the toolbar)

each measure group is related to a specific fact table.


"BizWorld" <moonis.tahir (AT) gmail (DOT) com> wrote