how to add a new MG on a fact table that is already used

A recommendation from MSFT is

Do put each distinct count measure into a separate measure group
(http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/
olapdbpssas2005.mspx)

However if in BIDS I want to make a seperate MG on the fact table I
have to select a table from a list. Tables already used are excluded.
How can I make a seperate MG for the distinct count measure?

Do I have to edit the xml?

Hopefully somebody has another idea!

Thanks, Paul
.

Relevant Pages

  • Re: Two companies one SBS
    ... > The reason I suggested two OUs was to keep the company names seperate ... If I didn't what would I call my root domain name, ... I'm not sure what you mean by "keeping the company names separate". ...
    (microsoft.public.windows.server.sbs)
  • Re: Should Xen be a sub-arch or a build option?
    ... This is what I'd prefer - i386/amd64 as separate dir under sys/xen. ... how well it would mesh with the existing build tools as there are a ... I wouldn't go for a build option; I'd prefer to make it seperate, ... fear making it a seperate build option would introduce needless clutter ...
    (freebsd-arch)
  • Re: need help w/ macro prompting with info and pasting the info based on user input
    ... seperate the data into different years...if is there a separate table ... do you sum them under the DAACT for that month?? ... The P is for the "Previous Year" row in SHEET1. ...
    (microsoft.public.excel.programming)
  • RE: Creating a template
    ... to separate sections, use a section break ... "Kieran Kincaid" wrote: ... sections seperate so when I type in one section the heading on the next page ...
    (microsoft.public.word.docmanagement)