Want to create a MDX report but not sure of the query.
This may sound rather obvious but it took some working out on my part. I wanted a report to be emailed out but the query was MDX, and the report designer doesn’t directly support MDX generation, ie: unlike sql you can’t see what your doing.
So publish an analysis cube with the JPivot stuff, load it up and work out how you want your table displayed and setup. It may be an idea to clean up the code a bit but once that’s done copy it out, and paste it into the report wizard/designer and it should all work, just make sure you use the same cube 