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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

the used tables should not disappear in the list.
first time I hear this.
how do you try to create the new measure? do you use the wizard?

The only place where the used tables are not listed is in the partition editor, when you try to add a new partition.
Allready used tables are hidden by default.
but this is not a new MG.


"Paul van Oordt" <info@xxxxxxxxxxx> wrote in message news:4ec18cb5-244b-48f7-98b1-c2e2d97f4714@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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

  • Help with queries
    ... This is the first time after school that I am trying to use ms access at ... work and i need ur help in creating a query. ... seperate table. ...
    (microsoft.public.access.queries)
  • Re: Bad language in Pinball FX Extreme?
    ... I believe he says 'Bring it'...the first time he says it, ... sound a bit like the n word..he does say 'boy' alot..offensive south ... of the Mason-Dixon line... ... I heard that part but the part that concerns me is seperate from that. ...
    (alt.games.video.xbox)