Hi,
I was teaching MSBI to my trainees and I noticed that the in the cube browser the Grand total value is repeating for all its measure values as shown in the below picture.
To resolve this error check your dimension structure under "Cube Structure" tab. Check if the dimension you are dragging and droping is diretly related to your fact table. If not then establish the relationship by clicking on "Dimension Usage" tab. I added the referenced relationship and bingo, it worked
I was teaching MSBI to my trainees and I noticed that the in the cube browser the Grand total value is repeating for all its measure values as shown in the below picture.
To resolve this error check your dimension structure under "Cube Structure" tab. Check if the dimension you are dragging and droping is diretly related to your fact table. If not then establish the relationship by clicking on "Dimension Usage" tab. I added the referenced relationship and bingo, it worked
No comments:
Post a Comment