The measure group has zero dimensional with all other measure group. consider moving to separate cube

Question

getting warning The measure group has zero dimensional with all other measure group. consider moving to separate cube

for reporting purpose, i can n't have two separate cube,  because of warning,    one measure group total not sliced with dimension, total amount is displayed to all dimension.

thanks

v

Answer 1

for reporting purpose, i can n't have two separate cube,  

That's why this is just a warning, not an error.  If you have some strange situation where it makes sense for you that's ok, this warning is just saying that for most uses this does not make any sense.

---

http://darren.gosbell.com - please mark correct answers

Answer 2

when i browse the cube,

Total Count

102232

but when drag city on row

Chicago     102232

London      102232

New York   102232

102232 is total and it is correct.  but  102232  should be spitted/spread across all the city,  even i tried with country on row

USA      102232

UK        102232

Thanks

V

Answer 3

This will happen if there is no relationship between the dimension with city/country and the measure group with [Total Count] - this is why this warning exists, because it usually indicates that there is an error like this in your cube.

---

http://darren.gosbell.com - please mark correct answers