Rules Performance: Help with Markers

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

    • Hi,
      I've tested your function for calculating currency, but it's very slow because of lots of calculated elements, and I have few experiences:

      1) use 2 dimensions in your cube for currency
      CURRENCY (CU1, CU2, CU3)
      CONVERSION (CUR, VAL)
      2) it is better to use hierarchies for sumations of currency
      CU1 [CZK]
      CU2 [EUR]
      CU3 [USD]
      CU1S [CZK SUMA]
      - CU2CU1 [EURtoCZK]
      - CU3CU1 [USDtoCZK]
      3) don't use currency cube, but use "CU2CU1" elements for setting rate
      5) you must explicitly specify all dimensions
      4) use this rule

      ['CU2CU1','VAL'] = N: PALO.MARKER("CFMCZV31-rules","CFMCURR",!'CENTRE',!'ALLOC',"CU2","CUR",!'VERSION',!'YEAR',!'PERIOD',!'IND') * PALO.MARKER("CFMCZV31-rules","CFMCURR","CC1X","TtotalX","CU2CU1","CUR",!'VERSION',!'YEAR',!'PERIOD',"CURR")

      where:
      PALO.MARKER("CFMCZV31-rules","CFMCURR",!'CENTRE',!'ALLOC',"CU2","CUR",!'VERSION',!'YEAR',!'PERIOD',!'IND')
      is value in currency

      PALO.MARKER("CFMCZV31-rules","CFMCURR","CC1X","TtotalX","CU2CU1","CUR",!'VERSION',!'YEAR',!'PERIOD',"CURR")
      is currency rate

      and

      ['CU3CU1','VAL'] = N: PALO.MARKER("CFMCZV31-rules","CFMCURR",!'CENTRE',!'ALLOC',"CU3","CUR",!'VERSION',!'YEAR',!'PERIOD',!'IND') * PALO.MARKER("CFMCZV31-rules","CFMCURR","CC1X","TtotalX","CU3CU1","CUR",!'VERSION',!'YEAR',!'PERIOD',"CURR")

      these rules are much faster :)
      Images
      • CUR.jpg

        69.93 kB, 722×431, viewed 790 times
      • VAL.jpg

        71.37 kB, 704×427, viewed 541 times
      • TREE.jpg

        34.91 kB, 660×470, viewed 535 times
      • CUBE.jpg

        6.01 kB, 192×171, viewed 485 times

      The post was edited 7 times, last by vesi ().