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)
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 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 ?