[Logo] SpagoWorld Forums
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing  
[Groups] Back to home page  [Moderation Log] Moderation Log   [Register] Register /  [Login] Login 
Passing Field value as Parameter  XML
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Author Message
sadiqkhoja.spw

Newby

Joined: 11/03/2013 14:33:21
Messages: 29
Offline

I want to pass field value(which is Zone_Code) in Drill Parameter, here is my template:

<HIGHCHART width="100%" height="100%">
<CHART defaultSeriesType="column"/>
<TITLE text="Contribution Details"/>
<LEGEND/>
<SUBTITLE text="Year: $P{Year} Month: $P{Month}"/>
<X_AXIS alias="Zone">
<TITLE/>
</X_AXIS>
<Y_AXIS>
<TITLE/>
</Y_AXIS>
<PLOT_OPTIONS>
<COLUMN>
<DATA_LABELS/>
</COLUMN>
</PLOT_OPTIONS>
<DRILL document="CND_Regionwise">
<PARAM_LIST>
<PARAM name="Zone_Code" type="CATEGORY"/>
</PARAM_LIST>
</DRILL>
<SERIES_LIST>
<SERIES name="Contribution" alias="Zone_Code,Contribution" type="column"/>
</SERIES_LIST>
</HIGHCHART>

How to do that?

Thanks
gigavard

SpagoBI supporter
[Avatar]

Joined: 05/07/2010 13:30:10
Messages: 148
Location: Padova
Offline

Hi, has this field a role in chart construction?

As cross navigation you can pass, as shown below, the field value that represents categories (type CATEGORY),
the field value that represents series (SERIE),
an absolute value specified in the template (type ABSOLUTE), or the value present in one of the analytical drivers of the source document (type RELATVE)

hope this solves your need.


<DRILL document="Destination_document">
<PARAM_LIST>
<PARAM name="Par_to_pass" type="RELATIVE" value="My_Par_url_name"/>

<PARAM name="Absolute" type="ABSOLUTE" value="value_to_pass"/>

<PARAM name="Category" type="CATEGORY"/>

<PARAM name="Serie" type="SERIE"/>

</PARAM_LIST>
sadiqkhoja.spw

Newby

Joined: 11/03/2013 14:33:21
Messages: 29
Offline

actually 'Zone_Code' is the primary key of 'Zone' and in chart I want to show just 'Zone' (x-axis) but when user click on column then 'Zone_Code' should be passed to next document.

If I select 'CATEGORY' in drill then 'Zone' is passed
If I select 'SERIE' in drill then value of y-axis is passed


Here is the sample data:


gigavard

SpagoBI supporter
[Avatar]

Joined: 05/07/2010 13:30:10
Messages: 148
Location: Padova
Offline

I'm sorry but with the actual version of highchart engine it is not possible to add this logic.

You could easily realize it with a SpagoBI Birt report document, containing a chart and defining cross navigation
sadiqkhoja.spw

Newby

Joined: 11/03/2013 14:33:21
Messages: 29
Offline

thanks for responding.

Is there any guide for customizing SpagoBI or some architecture overview of it so that I can add this feature in it?
gigavard

SpagoBI supporter
[Avatar]

Joined: 05/07/2010 13:30:10
Messages: 148
Location: Padova
Offline

Hi,
as documentation for developing with SpagoBI we have SpagoBI Book on sale on SpagoBi website that is the most detailed documentation

or we have free wiki at: https://wiki.spagobi.org/xwiki/bin/view/Main/

greetings

 
Forum Index » Technical Help - SpagoBI Server - CHART & DASH
Go to:   
Powered by JForum 2.1.9 © JForum Team