Pentaho Double Counting Values

Question

I do not understand why this is happening. I've probably spent like 12 hours messing with this.

When I use Pentaho to build an analyzer report, all years have the same values with the same data.

For example, 2014, 2015, 2016, for the month of May, will all say 1000. When you drill down and click on 2014, it will have 2015 and 2016 included as well. Same for drilling down on 2015 and 2016.

Why in the world is this happening? :)

Answer 1

I found a solution. Here is what I discovered:

1. There was nothing wrong with my data in the table. Querying the table directly gave me exactly what I expected it to.
2. It was the Mondrian Cube that was the problem.
3. I set it so that "Quarter" and "Month" had unique members. I should not not done this.

Once I removed unique members from "Quarter" and "Month," everything worked perfectly. Thanks guys!