Measure Groups in AS2000

Hi,

I have a lot of CurrencyMeasures, > 80, and a would like to create something like a 'measuregroup' in AS2000. I e Euro, Dollar should be measuregroups that contain measures, i.e Group_Euro_InvoiceAmount, Group_Euro_TaxAmount.

Do anyone have some ideas about this?

Hi,

From my understanding, measure groups are related to a fact table. Therefore if all of your measures are coming from the same fact table, I doubt you will be able to send them to different measure group.

If all of your measures are coming from the same fact table maybe you should look into the display folder property to separate them in a logical way.

Another soution could be to split your fact table into multiple named query (one named query per currency) and use those named query in your cube. This would allow you to have one measure group per currency

HTH,

Eric

|||

Larra,

If you are in AS2000 and not planning on moving to 2005, you can achieve the same result by creating multiple cubes, one per desired group, and then creating a virtual cube to pull them together.

If the source fact table is the same for all your measures, this will not be very efficient unless you add filters to your cube source to limit the rows read for each cube.

Depending on the client tool being used, you may not achieve the segmentation of measures that you are looking for though, as all measures in a virtual cube appear lumped together just as they would if you built a single cube.

|||

Thanks Clayton,

The client is using Cognos PowerPlay as the client tool to view AS2000 cubes. Do anyone know how PowerPlay is treating the measuregroups from the different cubes in the virtual cube?

_

Larra