Filter a single year (with months) in Date DIM combobox

This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

  • Filter a single year (with months) in Date DIM combobox

    I have a combobox for users to choose a specific year or month.
    In Jedox 5.0 I used a fix TFILTER to display only the year 2014 and all the months of 2014.
    =PALO.SUBSET(Global_Server,"DateTime",1,"Name_EN",,PALO.TFILTER("2014$",TRUE),,,,PALO.SORT(1,0,,0,,0,1))
    But after the upgrade to 5.1 using this settings displays only the months, missing the whole year value (2014).
    Hierarchy tab is not set.

    How can I get the same functionality back to the way it was working before the upgrade?
    Images
    • 2014.png

      14.18 kB, 501×285, viewed 257 times
  • I inserted "2012.*|2013.*|2014.*" in TFILTER and found out, that the problem is only when selecting 1st alias...see attachments.
    So how can I set this up after the upgrade?
    Images
    • name_en.png

      20.1 kB, 901×349, viewed 232 times
    • no_alias.png

      21.76 kB, 894×370, viewed 233 times