August 19, 2015 at 8:26 am
Hi All,
I hope you can guide me on this one...
I added a New dimension and measure to my existing cube but I am getting random duplicate results.
In the fact table the rows only appear once.
When I query the dimension, it is correct; however, the measure is doubling only on certain records (rows)
Any ideas on what is causing the issue is greatly appreciated!! 🙂
August 19, 2015 at 9:39 am
We'll need a bit more information to help you. Could you please post the results you are getting, as well as the Dimension Usage tab in your cube.
August 19, 2015 at 1:55 pm
Hi John,
When you added the dimension to your cube, did you establish the correct join between the dimension and fact tables? The fact and dimension may seperately be displaying the correct rows, but if the join you established between these tables isn't correct, you may end up with duplicate records.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply