We have an SSAS cube for our patient data. Instead of recreating the entire cube in powerpivot with all the measures and calculations, I am looking to use the cube itself and add onto it. I am just getting familiar with MDX, but is there an easy way to select ALL (select *) for a cube? I really don't want to filter out anything. I can build this with the design view in powerpivot, but as expected it takes forever to build as we have quite a few dimensions.
No comments:
Post a Comment