Does anyone know if it is possible to hide / show Dimensions, Measure groups, or Attributes via MDX? I am using personalization extensions (which is awesome) to create "things" on the fly keeping them separate for each client who uses our cubes.
But now we are entering the realm of "we don't want to see that, as it doesn't apply to us" [they came into the picture after so much was already built]. It would be great if I could use some MDX to hide entire things at a pop, and it is already built
Does anyone know if this is possible? Or would I have to use XMLA to accomplish this? Or would it be better to use the .Net classes (as they provide a safety layer between my code and future changes)?
Thank you in advance,
View Complete Post