SSAS FAQ 
Design FAQ How do you create distinct count measure in the separate measure group from the same fact table
Design FAQ How do you create distinct count measure in the separate measure group from the same fact table
| How do you create distinct count measure in the separate measure group from the same fact table |
| Written by Vidas Matelis | |||
| Friday, 04 May 2007 19:44 | |||
|
Q: How do you create distinct count measure in the separate measure group from the same fact table? A: It is recommended to have measure with aggregation type "Distinct count" in the separate measure group. But in the cube designer if fact table already has measure group associated with it, by default new measures based on that fact table with be added to the same measure group. To create new measure group you should use "New Measure..." wizard (button on the toolbar). In this wizard if you select usage "Distinct count", new measure will be added to its own measure group. Thanks Jeje for this tip.
|
Tags: design, distinct count, faq
Comments (1)
Most read
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- MDX-How can I get Last (Previous) Year to Date (YTD) values?
- MDX-How do you format or round KPI expression value?
- Analysis Services 2005 error: Errors in the metadata manager. The attribute with ID of ., Name of . refer
- MDX-How do you calculate monthly average of one year, optionally including empty months?
Top Rated
- How to install Adventure Works SQL DW and Analysis Services 2005/2008 sample database and project
- Analysis Services 2005 XMLA script to add/drop existing partition aggregate
- Why In Reporting Services MDX query disappears after leaving "Data" tab.
- When accessing calculation tab in BIDS I am getting error Unexpected error occurred
- MDX-How can I setup default dimension member in cube calculation script?
- How to calculate YTD monthly average and compare it over several years for the same selected month
- In an MDX query how can I get the top 3 sales years based on the order quantity?
- How in SSAS 2005 do you create what is used to be "Member Properties" in Analysis Services 2000
I strongly recommand, as Microsoft and ssas-info did, to isolate any distinct count measures from other measures.
I've just solved a huge performance and disk usage problem by isolating my distinct count measure.