in

Prologika Forums

Business Intelligence to the Masses
Forums » Books » Applied Microsoft Analysis Services 2005 » Best way to get a distinct count of dimension rows related to a fact table?
Latest post 06-03-2008 8:08 PM by tlachev. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 06-03-2008 7:24 PM

    Best way to get a distinct count of dimension rows related to a fact table?

    Reply Contact

    Hi Teo,

    I have DimUsers and DimQuestions related to FactAnswers ... and I want to get a distinct count of Users for each Question.  What is the best way to do so?

    Thanks - Wayde 

  • 06-03-2008 8:08 PM In reply to

    Re: Best way to get a distinct count of dimension rows related to a fact table?

    Reply Contact

    I'd consider building a DistinctCount measure on the UserID column in FactAnswers. This will be the best approach from a performance standpoint and it will work across any dimension.
Page 1 of 1 (2 items)
Copyright © 2005 Prologika, LLC
Powered by Community Server (Commercial Edition), by Telligent Systems