locked
Factless measure group - HOW? RRS feed

  • Question

  • I'm trying to implement many-to-many functionality using "Factless measure" approach. If I leaving measure group empty I'm  getting : " Error 1 Cube 'MyCube > Measure Group 'Matter' : No measures are defined."  error. The factless table consist of  3 keys (sting type) : row ID, refToDimentionTable1, refToDimentionTable2. Is it possible at all to create factless measure with Standard Edition not Enterprise?

     

    Any suggestions?

    Monday, April 14, 2008 6:22 PM

Answers

  • Usually you just create a Count measure that doesn't count a particular column but uses a "row binding" to count the number of rows.

     

    Monday, April 14, 2008 6:44 PM