Forum Discussion
Data modeling- multiple subcategories in a dimension
I have a matrix visual which has under rows a Sector and then a Subcategory, both in the same dimension table. DimSector looks like this: Sector SubSector Sector Key Cash 1 Government...
I was able to fix the problem without modifying the measures - I made a mistake in merging the dimension keys with the fact tables. Thank you for the reponses!
I was able to fix the problem without modifying the measures - I made a mistake in merging the dimension keys with the fact tables. Thank you for the reponses!