none
Distinct count of role-played dimension attribute

    Question

  • Needed distinct count of AccountGroup attribute of AccountB dimension which is a role played dimension of Account.

    Added measure distinct count of the dimension attribute (AccountGroup). In dimension usage added the main fact table as intermediate for other dimensions with many2many relationships.

    The two role played Account dimensions must be related to the new AccountFact table with fact relationship.

    But then how will I be able to count distinct attribute of certain Account dimension (out of the two role played dimensions)???


    Namnami

    Thursday, June 26, 2014 10:20 AM

Answers

  • Thanks for the links, they are useful. But still they do not explain how to manage a distinct count of certain role played dimension attribute. 

    I gave up on this and added that dimension attribute to the fact table so now I do a regular distinct count on a cube fact measure. 

    Thanks


    Namnami


    • Edited by namnami Sunday, July 06, 2014 6:16 AM correction
    • Marked as answer by namnami Sunday, July 06, 2014 6:17 AM
    Sunday, July 06, 2014 6:16 AM

All replies

  • http://blog.sqltechie.com/2009/09/distinctcount-analysis-service.html
    http://svangasql.wordpress.com/2012/03/14/distinct-count-in-analysis-services/
    Friday, July 04, 2014 9:39 AM
  • Thanks for the links, they are useful. But still they do not explain how to manage a distinct count of certain role played dimension attribute. 

    I gave up on this and added that dimension attribute to the fact table so now I do a regular distinct count on a cube fact measure. 

    Thanks


    Namnami


    • Edited by namnami Sunday, July 06, 2014 6:16 AM correction
    • Marked as answer by namnami Sunday, July 06, 2014 6:17 AM
    Sunday, July 06, 2014 6:16 AM