CODEWITHSUNDEEP
ssas
thotwielder
thotwielder

Reputation: 1707

SSAS 2005 put measures in the same folder in excel

I created a SSAS 2005 cube and connect to it from Excel 2007. I have a measure group sales. The key of the table is receipt no, line no. Now I create a new measure transactions, which is count distinct of receipt no. SSAS 2005 automatically assign the new measure in a separate measure group. The problem is in Excel, sales related measures are now in two measure groups (the sales and newly created one for the transactions). I find it a bit of awkward to go to these two folders to drag these measures since they are requested together a lot.

Is there a way to put these measures in same folder? I know there is a folder property for each measure in BIDS, but that will just create a new folder under existing folder for the measure group. Thanks.

Upvotes: 0

Views: 506

Answers (1)

FrankPl
FrankPl

Reputation: 13315

One workaround would be to make your distinct count measure invisible, and to define a calculated measure in the calculation script that is just replicating this invisible measure, and setting its ASSOCIATED_MEASURE_GROUP to the name of the main measure group. The ASSOCIATED_MEASURE_GROUP property of a calculated measure is just use for display purposes, as far as I am aware.

Upvotes: 1

Related Questions