search

jazzido / mondrian-rest

A REST interface for Mondrian ROLAP server
MIT License
32 stars 8 forks source link

[Feature] Except cuts #14

Open jspeis opened 7 years ago

jspeis commented 7 years ago

what about something along the lines of [Year].[Year].~&[2014] to say any year that's not 2014

jazzido commented 7 years ago

Thanks for the suggestion, but I think it'll be confusing to introduce a syntax similar to an MDX literal, but that it's not actually valid MDX.

I'm more inclined to generalize the cut[] parameter so it accepts any valid MDX expression that returns an entity that can express a cut (i.e.: sets, members and ranges). For expressing an "Except" clause, it can be the following: cut[]=Except([Year].[Year].Members, { [Year].[Year].&[2014] })

What do you think?

jspeis commented 7 years ago

That sounds like a great idea