Bring 2 dimensions to a ListObject

[eliasmazur]

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

[zhadrakas]

Hello Elias,

you could build this field in script like

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

[ErikWetterberg]

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

[eliasmazur]

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