How can I pass parameters from a dataset to a nested Data Cube ?

rveeraraghav

<p>Hi,</p>
<p>   This is the scenario I have. I am trying to create a report grouping on an element and a cross tab per each group value. In other words something like this</p>
<p> </p>
<p>A</p>
<p>               1  2  3 4</p>
<p>  a</p>
<p>  b</p>
<p>  c</p>
<p> </p>
<p>B</p>
<p>              1 2 3 4</p>
<p>  a</p>
<p>  b</p>
<p>  c</p>
<p> </p>
<p>etc.</p>
<p>So, what I created was a dataset which will return values A, B, C..</p>
<p> And a nested datacube which should return results based on the values A, B ..</p>
<p> </p>
<p>But, I am unable to modify or set the parameters used by the datacube to be dynamic. I even tried using reportContext, but still I get the same values are passed in to the datacube query.</p>
<p> </p>
<p>Any suggestions or solutions?</p>
<p> </p>
<p>I am willing to use any other data object if it will fix my problem.</p>
<p>Thanks in advance,</p>
<p> Ravi</p>

mwilliams

I'm pretty certain you'll need to bring everything into the cube data set the first time and just use filters to limit the values shown per group.