topic Re: Bring 2 dimensions to a ListObject in Integration, Extension & APIs

Bring 2 dimensions to a ListObject

eliasmazur — Wed, 02 Aug 2017 21:19:13 GMT

I am developing a filter that needs to list the main dimension and an associated one. For example, l want to list the products but I want to put the product type next to the list, like:

Smart Phone (E)

MS Word (S)

Unix (O)

where E=electronic, S=software and O=op sys.

Both the prod name and type reside in the same table. I would like to use a listobject instead of a hypercube. Any ideas on how to get the second dimension (prod type) into the extension with the prod name?

Thanks.

Elias

Re: Bring 2 dimensions to a ListObject

zhadrakas — Thu, 03 Aug 2017 05:26:56 GMT

Hello Elias,

you could build this field in script like

Load Product & '(' upper(left(ProductType,1)) & ')' as FilterField

Re: Bring 2 dimensions to a ListObject

ErikWetterberg — Thu, 03 Aug 2017 14:33:38 GMT

Hi Elias,

Another option is to use the qExpressions array in the ListObject.

You might need to wrap the expression in a function (Only ??) to make this work.

Hope this helps

Erik Wetterberg

Re: Bring 2 dimensions to a ListObject

eliasmazur — Thu, 03 Aug 2017 18:56:26 GMT

Hi Erik.

Thanks for the reply. I'm trying to figure out how would an expression work here. I'm using the eachDataRow backend call to render the data on the screen. How would I get the expression to return the associated prod type for each prod I get in the call ?

Do you think a cyclic group would work here?

Thanks again.

Elias