Creating a New Measure Under Existing Measure Group?

Hello,

When working with SSAS cubes, is there a way to add a new Measure to to the existing Measure Group without creating a new Measure Group? For instance, I have a Measure Group called Account with one measure in it but when I try to add a new measure to Account but it gets added to a new Measure Group called Account 1.

Thanks

You are probably trying to add new measure based on a column that is coming from another table in relational database.

Analysis Services tools dont consider this situation a good practice and suggest you create a new measure group for data coming from another table.

If you want the measure to appear in the same measure group, you can replace your original table with named query in DSV where you join 2 tables together. And then you should be able to add new measure to you measure group.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Thanks Edward.

I am new to Analysis Services and I have been struggling with the following issue for the last two days. Here is the deal: I have two dimensions such as Gender and Semester and one measure called # Of Students. What I would like to have differences between # Of Students for 06FS and 05FS semesters. I used a [Calculated Member] measure but without much success:

CREATE MEMBER CURRENTCUBE.[MEASURES].[Calculated Member]

AS [Measures].[Distinct # Of Students]-[Measures].[Distinct # Of Students],

VISIBLE = 1 ;

The desired column is in blue

Semester

05FS

06FS

Gender

# Of Students

Difference

Females

6000

6200

200

Males

6800

690

100

Could you give me a hand with this?

Thanks for your help!

|||

Hi I have the same problem despite my measures are coming from the same table. I have created a Measure with the Sum aggregation on one column and another one with the DistinctCount Aggregation on a second colum of the same table and SSAS creates a different Measure Group for the second measure. I don't understand why. I have exactly the same structure for another table and two measures are stored under the same Measure Group.

Any idea why I can't have my two measures in the same Measure Group ?

|||

This is Stupid, when I create a new Measure with an aggregation on a column from the same table than another measure it automatically creates a new measure group for this measure. But If I create a new Measure Group it automatically creates different measures depending of the types of the column from the selected table. I have just replaced the properties I needed from the different measures within the measure group. That's the only way I've found to have multiple measures in an existing measure group.