I have created a new dimension by copying the existing dimension but am running into an issue.
So when am dragging some dimension and and measure fields, the data that is populating onto the grid is same for all the column.
Please check attached .zip file.
I think its common behavior for the new dimension. So am sot sure what to do to sync this new dimension with the cube so it populate the accurate data.
Could you please provide some help how to sync it?
Do I need to change any property or any other change required?
I would like to mention that this new dimension is exact copy of existing one except name change.
I'll be waiting for your response.