How to pass "MONDRIAN_CONNECTION" to subdataset?

[rajan_patil]

Hi,

 

I am trying to use crosstab with mdx (Using Mondrian-OLAP connection).

I am using subdataset in crosstab. But in JRXML I see the following -

$P{REPORT_CONNECTION}

Since I am using MDX query in subdataset, it seems I should have "MONDRIAN_CONNECTION" parameter in connectionExpression.

 

I have also gone through this link

http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=50644&page=1

 

But I didn't get how to pass MONDRIAN_CONNECTION Parameter to the subdataset.

Can anybody tell me how to deal with this?

 

Thanks in advance.

 

Rajan

[rajan_patil]

rajan_patil
Wrote:

Hi, I am trying to use crosstab with mdx (Using Mondrian-OLAP connection). I am using subdataset in crosstab. But in JRXML I see the following - Since I am using MDX query in subdataset, it seems I should have "MONDRIAN_CONNECTION" parameter in connectionExpression. I have also gone through this link http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=50644&page=1 But I didn't get how to pass MONDRIAN_CONNECTION Parameter to the subdataset. Can anybody tell me how to deal with this? Thanks in advance. Rajan

Code:

<crosstabDataset>	<dataset>	<datasetRun subDataset="dataset1">	<connectionExpression><![CDATA[$P{REPORT_CONNECTION}]]></connectionExpression>	</datasetRun>	</dataset></crosstabDataset>