Currently trying to build a report in SSRS using SSAS cube. Load the cube into excel fine and can see all the measures. However when I load it into Query Designer in VS I get "More measures exist than can be shown".
Anyone seen this before and can suggest a way around this? I have tried looking at it with MDX and DAX selected and its the same for both.