tag:blogger.com,1999:blog-2399137000203798153.post5026937005436583912..comments2022-05-08T14:25:25.678-05:00Comments on B for Binary: MDX Filter Connection FormulaAnonymoushttp://www.blogger.com/profile/10596094854199549331noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-2399137000203798153.post-35554989011215192082011-10-20T20:45:40.627-05:002011-10-20T20:45:40.627-05:00Hi, Giorgio!
I am not in front of a computer on w...Hi, Giorgio!<br /><br />I am not in front of a computer on which I can test it right now so I can't tell you with absolute certainty, but I will try nevertheless. You seem to be pretty familiar with connecting the filter to the chart. When you make the connection to a chart, you should see an option to "Specify Connection Formula" (or something very similar). <br /><br />Here you can specify, through MDX, the values that you want to pass to the chart as filter values, based on what the user selects. The code that you specify in the connection formula should be written in MDX, using "<>" as the value that the user specifies.<br /><br />For example, let's say that we want to select the twelve months of a year when a user selects a certain year, and let's say that, as you said, your hierarchy has a "year" level and beneath that the "month" level. In that case you would write something like the following when specifying the formula:<br /><br /><>.Children<br /><br />which will send all the children of the selected year to the chart.<br /><br />As far as I understand, your users are going to select a month and you want the chart to show all the dates before and up to that month, maintaining your hierarchies.<br /><br />If you do not need to keep the hierarchies, the MDX PeriodsToDate function should work perfectly for you.<br /><br />http://msdn.microsoft.com/en-us/library/ms144925.aspx<br /><br />I am assuming that you want to keep your hierarchies. If you have not found your answer by the time you read this, please let me know and I will dig into some code for you. There should be more than one way to accomplish this. Hope this points you at least in the right direction. Sorry I can't help you anymore right now, but feel free to get back to me.<br /><br />HermannAnonymoushttps://www.blogger.com/profile/11436515683518865670noreply@blogger.comtag:blogger.com,1999:blog-2399137000203798153.post-10097552124645761622011-10-20T09:25:04.894-05:002011-10-20T09:25:04.894-05:00Hi!
I have a grid with year,month hierarchy on col...Hi!<br />I have a grid with year,month hierarchy on column, hooked to a Post Formula Filter. How can I filter the calendar hierarchy in the grid from the first date to the month selected in the post formula filter?<br />ThanksGiorgiohttps://www.blogger.com/profile/01668186341104260658noreply@blogger.com