Multiple output indexes in Pentaho CDA

Until today, if you wanted to reuse a query in a .cda file with a different output spec, you needed to duplicate it as many times as you needed different outputs, today i committed a code change that allows all you guys to specify it directly in the same DataAccess xml node:


<CDADescriptor>
...
<DataAccess id="1" connection="1" type="sql" access="public" cache="true" cacheDuration="3600">
...
<Output indexes="1,0,2,3"/>
<Output id="2" indexes="1,0,2"/>
<Output id="3" indexes="0,2,3"/>
</DataAccess>
</CDADescriptor>

To use a different output you just need to specify the outputIndexId parameter in the call to the doQuery servlet! 🙂

All this code was developed internally at Xpand IT, I just wrapped it up, cleaned the code and committed it back 🙂

Cheers,
ITXpander

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s