tag:blogger.com,1999:blog-15319370.post2249253116835176322..comments2024-03-29T12:51:32.931+01:00Comments on Roland Bouman's blog: MDX: Grouping on non-unique levelsrpboumanhttp://www.blogger.com/profile/13365137747952711328noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-15319370.post-74772919321417133212017-09-02T18:17:22.630+02:002017-09-02T18:17:22.630+02:00Good article. Was looking for the same, but i just...Good article. Was looking for the same, but i just changed the mondriaan schema in the end :P<br /><br />In my case i needed the following hierachy to create a drill down table, but I also needed a pie chart with the sales per Client Partner. So I had 2 dimensions. 1 where client Partner is the second level and one where client partner is the first and only level in the hierarchy.<br /><br />Segment Head > Client Partner > Customers > Projects Stijnnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-73234960136490293122015-04-24T23:35:41.120+02:002015-04-24T23:35:41.120+02:00Hi Roland,
This is a very impressive article! Than...Hi Roland,<br />This is a very impressive article! Thanks for sharing these three solutions to my challenging question. I'd say we learnt a lot out of this. Certainly if we can change the Mondrian schema, we should be practical and create a dedicated hierarchy. We knew this - but we were also up for a good MDX challenge, which you passed with flying colors!<br />Best regards,<br />DiethardAnonymoushttps://www.blogger.com/profile/05683544764949933581noreply@blogger.com