I am working on the same thing. Since dynarange doesn't seem to cover it directly, I wanted to build them manually by placing dynaranges and then inserting the PALO-formulas without "guessing the argument". Hence, I expected Jedox to give me the full range of both dynaranges and automatically fill in the PALOs in the spreadsheet in between.

So far, the results are not satisfying. This could be a way, though. I'll get back to this when I find more time to do so.

Best regards!

Here is what you could do (probably not the best way, but at least a way):
If you have a e.g. vertical dynarange containing the dimension (lets say DIM1) elements, you can reserve a certain of columns for the following formula.
Select these cells (as column headers) and add the matrix-formula PALO.DIMENSION_LIST_ELEMENTS("Server/Database";"#_DIM1_") and confirm the formula by ctrl+shift+enter.

This should give you the list of attributes of the DIM1 as columns and the dynarange gives you the DIM1-elements in rows.
Last thing to do is adding a PALO.DATA into the cells covered by the dynarange showing the actual values from the attribute cube.

Regards.

Hi Hildebrandt,

Knowing that I have an attribut "EAN13" in my dimension "article", and localhost/BD_MArie is my database's name.
Your solution is it the same that : create a e.g vertical dynarange in cell a1 with DIM "Article"; in cell b1 use the formula PALO.DATAC("localhost/BD_Marie";"#_Article";"EAN13";$A$1) ?

Regards.
Belgarion.

Correct, when knowing the attribute (e.g. EAN13) you can simply get the values by using one dynarange and the palo.data-formula you described.

The original problem was different. fnsl wanted to have all attributes to a certain dimension.