New Cube Reference Syntax as dynamic as PALO.DATA() ?

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

    • New Cube Reference Syntax as dynamic as PALO.DATA() ?

      The new syntax for PALO.DATA() allows to specify only the dimensions that are different. All other dimension, being part of both cubes, are mapped automatically.

      Using the PALO.DATA() function I am able to use strings (pulled from an other element or as an atrribute) for the database and element names. Making the cube reference dynamic.

      To take advantage of the automatic mapping of dimensions, I would like to do the same with the syntax '<cube>'['<Dim1>':'<Element1>',...].
      But I am not able to let the rule parser take a string for <cube> or <Dim>. For <Element> it works.

      Is there any way to make the rule parser take a string as '<cube>' and '<Dim>' definition?
    • new cell reference works just fine
      example cube: Sales, dimensions: Time, Product, Measure

      when referenced from other cube X with the same dimensions: Time, Product, Measure

      you can write rule for cube X:

      [] = 'Sales'[]
      is the same as
      [] = PALO.DATA("","Sales",!'Time', !'Product', !'Measure')

      other examples:
      [] = 'Sales'['Time':!'Time']
      is the same as
      [] = PALO.DATA("","Sales",!'Time', !'Product', !'Measure')

      [] = 'Sales'['Time':'2020']
      is the same as
      [] = PALO.DATA("","Sales","2020", !'Product', !'Measure')

      [] = 'Sales'['Time':"2020"]
      is the same as
      [] = PALO.DATA("","Sales","2020", !'Product', !'Measure')

      when referencing Sales from the same cube, wou can just keep cube name empty
      ['Time':'2021'] = ''['Time':'2020']
      is the same as
      ['Time':'2021'] = 'Sales'['Time':'2020']

      single quotes can be used only in square brackets and after exclamation mark - only for for cube, dimension and elements
      Names in single quotes should be translated in rules automatically if you rename the dimension or element
      PALO.DATA and other functions require strings - in double quotes