bar chart

goodmorning to all,
i'm trying to build some char, for example a bar chart,
i prepare a dataset query like:

and i've a correct result by clicking the test button:
id_comp x value1
38 Amedee Geothermal Venture 10.0
39 Bali Energy Ltd 18.0
41 Bay of Plenty Energy 50.0
... .... ....

but it doesn't work with my chart, that is my template:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<BARCHART type='simplebar' name="Title">
  	<DIMENSION width='465' height='300'/>
      <STYLE_LABELS_DEFAULT font='Arial' size='10' color='#000000' orientation='horizontal'/>
      <STYLE_X_AXIS_LABELS font='Arial' size='10' color='#000000' orientation='horizontal'/>
      <STYLE_Y_AXIS_LABELS font='Arial' size='10' color='#000000' orientation='horizontal'/>
      <STYLE_TITLE font='Arial' size='13' color='#0C2D83'/>  
      <STYLE_SUBTITLE font='Arial' size='12' color='#6699FF' name='Subtitle'/>  
      <COLORS background='#FFFFFF'/>
      <STYLE_VALUE_LABELS font='Arial' size='7' color='#000000' orientation='horizontal' />  
   <CONF>
      <PARAMETER name='category_label' value='x'/>
      <PARAMETER name='value_label' value='value1'/>
      <SERIES_COLORS   SER1='#009999'  SER2='#8AA5CB' SER3='#CCCCFF' />
      <PARAMETER name='add_labels' value='false'/>
      <PARAMETER name='n_visualization' value='60'/>
      <PARAMETER name='view_filter' value='false'/>
      <PARAMETER name='view_slider' value='false'/>
      <PARAMETER name='filter_cat_groups' value='true'/>
      <PARAMETER name='legend_position' value='right'/>
      <PARAMETER name='legend' value='true'/>
      <PARAMETER name='orientation' value='vertical'/>
   </CONF>
</BARCHART>

and if test the chart i get:
Could not retrieve value; check the dataset

On wiki documentation i read the explanation of the dataset format, it seem to be like
a query concatenation by union, isn't it? that is the only way?

Thanks

Eugenio

Hi
on wiki you can find some example, you can use any type of query to read data.
Did you find any errors in log files ?

regards
Angelo

This message was edited 1 time. Last update was at 11/01/2011 13:23:57

Hi,
my problem is closely to the template file, i'm thinking,
because i have the right result from the query in dataset,
both using pgadmin3 on db and the dataset test button.
But if i try the chart document i recive:

Could not retrieve value; check the dataset

Maybe i made a mistake uploading the template file and,
connecting it to the chart document, anyway i don't understand why..

looking into the catilina log file i see:

[http-8080-6] 11 gen 2011 13:07:56,066 ERROR it.eng.spagobi.engines.chart.SpagoBIChartInternalEngine.execute:293 - Error in retrieving the value
it.eng.spago.base.SourceBeanException: Impossibile elaborare lo stream XML
	at it.eng.spago.base.SourceBean.fromXMLStream(SourceBean.java:1263)
	at it.eng.spago.base.SourceBean.fromXMLString(SourceBean.java:1345)
	at it.eng.spago.base.SourceBean.fromXMLString(SourceBean.java:1362)
	at it.eng.spagobi.engines.chart.bo.charttypes.barcharts.BarCharts.calculateValue(BarCharts.java:164)
	at it.eng.spagobi.engines.chart.SpagoBIChartInternalEngine.execute(SpagoBIChartInternalEngine.java:290)
	at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.execute(ExecuteBIObjectModule.java:1079)
	at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.initNewExecutionHandler(ExecuteBIObjectModule.java:418)
	at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.service(ExecuteBIObjectModule.java:154)
	at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
	at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
	at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
	at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
	at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:636)

Could you give me any suggests?
Regards

Eugenio

Hi Eugenio,
try to delete from your template this line:

<PARAMETER name='category_label' value='x'/>

Let us know!

Regards,
Fabio

Hi Eugenio,
could you please try avoiding empty spaces in category definition,
i am afraid this gives problem with Spao Source Bean,
try to substitute them with a _ ('Amedee_Geothermal_Venture')

please let me know if worked,

Greetings

Giulio

Hi to all,
i tested the last two hints from gigavard and dovidio, but
i have no chart yet...
that's the spagobi log:

[http-8080-2] 18 gen 2011 11:30:32,333 ERROR it.eng.spagobi.engines.chart.SpagoBIChartInternalEngine.execute:293 - Error in retrieving the value
it.eng.spago.base.SourceBeanException: Impossibile elaborare lo stream XML
	at it.eng.spago.base.SourceBean.fromXMLStream(SourceBean.java:1263)
	at it.eng.spago.base.SourceBean.fromXMLString(SourceBean.java:1345)
	at it.eng.spago.base.SourceBean.fromXMLString(SourceBean.java:1362)
	at it.eng.spagobi.engines.chart.bo.charttypes.barcharts.BarCharts.calculateValue(BarCharts.java:164)
	at it.eng.spagobi.engines.chart.SpagoBIChartInternalEngine.execute(SpagoBIChartInternalEngine.java:290)
	at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.execute(ExecuteBIObjectModule.java:1079)
	at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.initNewExecutionHandler(ExecuteBIObjectModule.java:418)
	at it.eng.spagobi.analiticalmodel.document.service.ExecuteBIObjectModule.service(ExecuteBIObjectModule.java:154)
	at it.eng.spago.dispatching.module.DefaultPage.invokeServiceBusiness(DefaultPage.java:352)
	at it.eng.spago.dispatching.module.DefaultPage.nextStep(DefaultPage.java:302)
	at it.eng.spago.dispatching.module.DefaultPage.service(DefaultPage.java:202)
	at it.eng.spago.dispatching.module.ModuleCoordinator.service(ModuleCoordinator.java:102)
	at it.eng.spago.dispatching.httpchannel.AdapterHTTP.service(AdapterHTTP.java:433)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at it.eng.spagobi.commons.filters.ProfileFilter.doFilter(ProfileFilter.java:117)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
	at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
	at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
	at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
	at java.lang.Thread.run(Thread.java:636)

and this is the new template after dovidio hint:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<BARCHART type='simplebar' name="Title">
  	<DIMENSION width='465' height='300'/>
      <STYLE_LABELS_DEFAULT font='Arial' size='10' color='#000000' orientation='horizontal'/>
      <STYLE_X_AXIS_LABELS font='Arial' size='10' color='#000000' orientation='horizontal'/>
      <STYLE_Y_AXIS_LABELS font='Arial' size='10' color='#000000' orientation='horizontal'/>
      <STYLE_TITLE font='Arial' size='13' color='#0C2D83'/>  
      <STYLE_SUBTITLE font='Arial' size='12' color='#6699FF' name='Subtitle'/>  
      <COLORS background='#FFFFFF'/>
      <STYLE_VALUE_LABELS font='Arial' size='7' color='#000000' orientation='horizontal' />  
   <CONF>
      <SERIES_COLORS   serie1='#009999'  />
      <PARAMETER name='add_labels' value='false'/>
      <PARAMETER name='n_visualization' value='60'/>
      <PARAMETER name='view_filter' value='false'/>
      <PARAMETER name='view_slider' value='false'/>
      <PARAMETER name='filter_cat_groups' value='true'/>
      <PARAMETER name='legend_position' value='right'/>
      <PARAMETER name='legend' value='true'/>
      <PARAMETER name='orientation' value='vertical'/>
   </CONF>
</BARCHART>

I also try to change x in X in the dataset definition,
and i changed the field company name removing
the space in the company name, as gigavard suggested me...

What con i do to have my chart?????
I'm in trouble...

Thanks for any other suggestions...

Eugenio

hi to all,
finally i think i solved the problem,
there was some company name with a bad character
like '/' or '&' that are wrong...i removed that and now it seems working!!!

Thanks for all!

Eugenio

Goodmorning,
today i'm going to prepare the bar chart, so i'm going to prepare
with more attention the template file.
I read the wiki pages, there is something that i don't understand yet.
I'm wondering if there is a complete xml guide to build and personalize
the chart, to better learn the parameters and options usable.
for example in my case on the x axis i have about 70 features,
so it's hard to read the label in the chart, so i put:

but if i use the slider in the document don't change the
elements in the x axis.

Regards

Eugenio

Hi Eugenio,
there s not a complete guide actually,
but by downloading the SpagoBI studio you would get some help in configuring the chart
(because it gives a graphic editor to create the template).

Anyway,
with the parameters you put you should also put

<PARAMETER name="filter_categories" value="true" />

this should fit your case.

greetings

Giulio

Hi,
i just add the line that you suggest me in my template code,
but the slider doesn't work yet.
I've also another problem, i not able to see the axis titles,
and i've the parameters connected:

and

mmm...maybe there something that i don't undestand yet in building template...

I try spagostudio on window host, but it use more parameters..i will try again...

Eugenio

Let me know if with SpagoBI Studio you can solve your problems,
otherwise please write me your template so I can directly compare it
with my working ones.

Write me also which SpagoBi version you are using.

Greetings

Giulio

Hi gigavard,
my spagostudio linux version is quite different from the windows one,
because i haven't the list of option to build the chart but only the text editor.

Anyway i put here my template:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<BARCHART type='overlaid_barline' name="Geothermal company">
  	<DIMENSION width='1000' height='500'/>
      <STYLE_LABELS_DEFAULT font='Arial' size='8' color='#000000' orientation='horizontal'/>
      <STYLE_X_AXIS_LABELS font='Arial' size='12' color='#000000' orientation='vertical'/>
      <STYLE_Y_AXIS_LABELS font='Arial' size='10' color='#000000' orientation='vertical'/>
      <STYLE_TITLE font='Arial' size='13' color='#0C2D83'/>  
      <STYLE_SUBTITLE font='Arial' size='12' color='#6699FF' name='Installed Capacity [MW] and Produced Energy [GWh/y]'/>  
      <COLORS background='#FFFFFF'/>
      <STYLE_VALUE_LABELS font='Arial' size='10' color='#000000' orientation='horizontal' /> 
      <STYLE_FILTER font='Arial' size='12' color='#003366'/> 
      <STYLE_SLIDER_AREA font='Arial' size='10' color='#1C2834'/>
   <CONF>
  <PARAMETER name='category_level' value='Company'/>
      <PARAMETER name='value_level' value='installed'/>
      <SERIES_COLORS   installed='#009999' produced='#8AA5CB'/>
      <SERIES_DRAW installed='bar' produced='line'/> 
      <SERIES_LABELS installed='Installed Capacity [MW]' produced='Produced Energy [GWh/y]'/>
      <SERIES_SCALES installed='1' produced='2'  />
  <PARAMETER name='add_labels' value='true'/>
      <PARAMETER name="show_value_labels" value="true" />
      <PARAMETER name='n_visualization' value='15'/>
      <PARAMETER name='view_filter' value='true'/>
      <PARAMETER name='view_slider' value='true'/>
      <PARAMETER name="filter_categories" value="true" /> 

      <PARAMETER name='legend_position' value='bottom'/>
      <PARAMETER name='legend' value='true'/>
      <PARAMETER name='orientation' value='vertical'/>

      <PARAMETER name='second_axis_label' value='GWh/y'/>
	  <PARAMETER name='dynamic_n_visualization' value='true'/> 


<PARAMETER name="n_cat_visualization" value="15" />







<PARAMETER name="position_slider" value="bottom" />




   </CONF>
</BARCHART>

some of these parameters coming from the template build by spagostudio on windows
but for some of these i don't know the meaning...

SpagoBI vs 2.4

Regards
Eugenio

Hi,
I tested your example,
on current SpagoBi version it works but in 2.4 it does not, it's probably due to a bug we solved later.

Is that you need to have both bars and lines in your chart?
If you need only bars you could try simpleBar subtype, i made a test on 2.4 and slider is ok.

FOr what concern the axis labels, they are not shown because in template you put
<PARAMETER name='category_level' value='Company'/>
<PARAMETER name='value_level' value='installed'/>

but correct sintax is

<PARAMETER name='category_label' value='Company'/>
<PARAMETER name='value_label' value='installed'/>

so "label" instead of "level".

Greetings

Giulio

Hi gigavard,
i just solved the problem connected to the axis label,
then i use your suggest to test the slide bar with simplebar subtype,
but it doesn't work, i don't know why...
There is a reason becouse i used the overlaid_barline, the reason is that i need
two kind o scale on Y axies, and i undestand that the simplebar doesn't
provide this feature.

Maybe there something wrong in my query? or in my category and series coming from
the query?

Thanks for now

Eugenio

Hi gigavard,
as i told you i solved the problem of the axis label,
now i'm working with the spagobi 2.4 version yet,
but i observe something strange in the behavior of the
slide bar for the category and the select choice for the
series:
i load the char document, so i tried the sliding bar, without any results,
then i leave the page of the chart open, and i work with another internet
page...after some minutes i come back to the spagobi chart chart document
and i retried to move the sliding bar, it works just for one time, if i reuse the bar
it didn't work...if i come back after other minutes the bar works...

Why?
What is the problem, is the bug that you told me?

Here my template:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<BARCHART type="overlaid_barline" name="Geothermal company">
<DIMENSION width='1000' height='500' />
<COLORS background='#ffffff' />
<STYLE_Y_AXIS_LABELS font="Arial" size="10" color="#000000" orientation="HORIZONTAL" />
<STYLE_TITLE font="Arial" size="13" color="#0c2d83" orientation="HORIZONTAL" />
<STYLE_VALUE_LABELS font="Arial" size="10" color="#000000" orientation="VERTICAL" />
<STYLE_SUBTITLE font="Arial" size="12" color="#6699ff" orientation="" name="Installed Capacity [MW] and Produced Energy [GWh/y]" />
<STYLE_LABELS_DEFAULT font="Arial" size="8" color="#000000" orientation="horizontal" />
<STYLE_X_AXIS_LABELS font="Arial" size="12" color="#000000" orientation="HORIZONTAL" />
<CONF>
<PARAMETER name="range_axis_location" value=" TOP_OR_LEFT" />
<PARAMETER name="category_label" value="Company" />
<PARAMETER name="legend_position" value="bottom" />
<PARAMETER name="value_label" value="MW" />
<PARAMETER name="enable_tooltips" value="true" />
<PARAMETER name="n_ser_visualization" value="2" /> 
<PARAMETER name="n_cat_visualization" value="15" />
<PARAMETER name="filter_cat_groups" value="true" />
<PARAMETER name="show_value_labels" value="true" />
<PARAMETER name="filter_series_buttons" value="false" />
<PARAMETER name="filter_categories" value="false" />
<PARAMETER name="legend" value="true" />
<PARAMETER name="filter_series" value="true" />
<PARAMETER name="range_integer_values" value="true" />
<PARAMETER name="slider_start_from_end" value="false" />
<PARAMETER name="dynamic_n_visualization" value="false" />
<PARAMETER name="view_slider" value="true" />
<PARAMETER name="position_slider" value="bottom" />
<PARAMETER name="maximum_bar_width" value="5.01" />
<PARAMETER name="add_labels" value="true" />
<PARAMETER name="value_labels_position" value="outside" />
<PARAMETER name="stacked_bar_renderer_1" value="true" />
<PARAMETER name="stacked_bar_renderer_2" value="true" />
<PARAMETER name="second_axis_label" value="GWh/y" />
</CONF>
<SERIES_COLORS  installed="#ff0000"  produced="#0080ff"  />
<SERIES_DRAW  installed="bar"  produced="line"  />
<SERIES_LABELS  installed="Installed Capacity [MW]"  produced="Produced Energy [GWh/y]"  />
<SERIES_SCALES installed="1"  produced="2"  />
</BARCHART>

Regards

Eugenio