PENTAHO: DRILL DOWN CHART

-Create one parameterized report in report designer and publish it as xaction.

-Open design studio, create one new java project. Then create one new action sequence and

  Input with parameter name.

-In process Action, select get data from in that select relational. Give the required data base

  connection details, and query same as given in report designer.

-In process Action, click on add, in that report and select pentaho report.

  In report specification, browse and select the xml of the report, in report data select query result. 

  Give the output report name.

-In the process output select the name of output report name and select response. Save the

  xaction and run it.

- now we need to create the main xaction with chart. Create one new xaction,  Process input add

  Input with the same parameter name, select request and give the default value. In the process

  action select get data from, in that relation. Give the required database connection details, and

  write down the query.

-in process action, click on add, select chart in that select chart of your choice. Give chart data as 

 Query_result. Click on toggle tab, in that under configuration add the below tag, i.e. details of link xaction    path

            <urltemplate><![CDATA[/ViewAction?solution=GIVE SOLUTION NAME&path=&action=XACTION

          NAME&PARAMETER NAME={FIELD NAME}]]></url-template> 

          <paramName>GIVE THE NAME(I.E. NAME OF THE PARAMETER FIELD)</paramName> 

           <series-name>GIVE THE SERIES NAME</series-name>

- Save and run the xaction.