Let user choice the dimension in datacube

Rin

Hello,<br />
<br />
When using data cube with cross tab in BIRT for some aggregation reporting, I define the dimension for the cube using expression like <em class='bbc'>dimension["Group Name"]["Column Name"]</em>. Is there a way to let user to choice the dimension that the aggregate working on please?<br />
<br />
I tried to use a parameter in the expression, like <em class='bbc'>dimension["Group Name"][params["the_column_that_user_want_to_do_aggregate_on"].value]</em>, but it didn't work.<br />
<br />
For example ,I have a table with 4 tuples.<br />
<br />
Area id price sell<br />
NY a 1123 421<br />
NY a 5212 100<br />
NY b 4092 200<br />
NJ b 1245 401<br />
<br />
where area, id, price,sell is the columns name<br />
<br />
I firstly create a data set Set1 with:<br />
<em class='bbc'>select * from table<br />
where sell > 150</em> <br />
<br />
Then I create a data cube on Set1, which called cube1, then create some aggregation in Summary Fields. Finally I create a cross tab to display the results.<br />
<br />
But since the dimension expression is fixed in the cross tab, users can not decided the dimension they want to do the aggregation on.

mwilliams

Can you explain more about your question? What is the user choosing? The dimensions in the crosstab or something else? If they're choosing the dimension, what are their choices? Are they dynamic or limited? Let me know.