[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 
Messages posted by: rider21.spw
Forum Index » Profile for rider21.spw » Messages posted by rider21.spw
Author Message
Hi everyone,

I wonder if there is a way to show the name of the columns in the X-Axis instead of the default type (linear).

It would be ok too if I could show the values per id, like 1, 2, 3, 4... for example.

I tried to do this with the ''categorized option'', but it doesn't seem to work.

I'd need to do this without modifying the dataset, because in my case it'd be too tricky.

If anyone could help me I'd appreciate it.

Thanks in advance
Hello everyone,

I've recently started to migrate my application from Spago BI 3.0 to the last version.

I've deal with some issues so far, but there is one that I'm not able to solve it:

When creating a new Data Set and selecting a Java class type, I'm not able to enter any java class name in the box. I've also tried by selecting a custom data set type instead of a java class one, because in this case it allows me to enter a java class name, but when trying to execute the dash I got a data set error.

If anyone could help it'd be great.

Thanks in advance.
I also have the same problem when trying to log in, so I anyone could help us it'd be great :)

Thanks in advance.
And here you have a sample of my data:

Image and video hosting by TinyPic
Hello Antonella,

This the template I'm using:

I've already set the max values for the first y axis and second y axis for this chart, in fact, If i don't set the max value for the second Y axis, the last two series won't appear on the chart.

The result given by the query is almost the same as the java class, the java class one has more restrictions, but i don't think it'll affect to the chart.

Thanks again,


Thanks for replying.

Yes I already read the documentation before and tried many changes. The thing is that when using a query type data set i don't have that problem, but now I'm using a javaclass data set (because it allows me to add restrictions much more easy than sql), and I get higher values in the y axis. In my case, the max value for the y axis is 4, and when generating the chart the y axis goes up to 70, so if i don't restrict the values by myself, the chart doesn't look good at all.

I don't know if it's a bug or problem with the java class data set, or if I'm doing something wrong, but I'm using the exact xml template to generate the charts.

I'm using HighChart library.
Hello everyone,

Does anyone know how to adjust the max. value of the Y axis without putting the option max='xx' ??

In my case, I've got a chart with a max. value of 5 for the Y axis, but if i don't put the option max='7' for example, the max value goes up to 70, which is too much for my set of values, and the chart doesn't look very nice then.

Thanks in advance,

Hi all,

I finally managed to create a chart using a java class data set. But now i got the next problem:

I want to show 4 series in my chart, 2 of them are columns and the other 2 are lines. In the dataset result, almost all 4 set of values have different values for each month. With the column series I don't have any problem, it shows me all the values properly, but in the line series, it doesn't show me the series. Then I realized that if I put too many different values it doesn't show me the series, but if I put the same couple of values for all the months it shows me the 2 line series.

Any idea about what the problem could be??

Thanks in advance.
This is the interface I have to implement and its methods:

public interface IJavaClassDataSet {

* Gets the values formatted into an xml structure.
* @param profile a user profile used to fill attributes required by the query
* @return the xml string of the values
public String getValues(Map profile, Map parameters);

* Gets the list of profile attribute names required by the class.
* @return the list of profile attribute names
public List getNamesOfProfileAttributeRequired();


Now the next step is to find out how to the result of the query data set looks in java. If someone could help me I'd appreciate that

Thanks and regards
Hello again,

Since I didn't receive any suggestion, I tried to search for a solution by myself, and yesterday i made some progress. Here I explain how i did it:

First I installed the Spago BI studio to check if maybe there could be an example of how to implement a java class data set, but aften struggling a lite bit managing to run the suite properly I realized that there wasn't any example.

Then I remember that if I run the platform locally from your own server, you have a log file where you can check all the errors and exceptions. What I wanted to do is to find out which class I had to implement in order to do the java class dataset. So did the next:

1. I installed the all-in-one-package and run the Apache Tomcat.
2. Created an empty java class and copied the folder containing the java class to the next route: ....\apache-tomcat-6.0.18\webapps\SpagoBI\WEB-INF\classes\
3. Created a new data set and choosed the type dataset and in the Java Class Name field I specified the the folder and the name of the class (in my case test.queryclass)
4. Then I tried to created a new chart with that dataset and obviously I got a dataset error.
5. I took a look at the SpagoBI.log file and... voilĂ ! this is what i got:

[http-8080-8] 24 Oct 2011 17:17:00,374 ERROR it.eng.spagobi.tools.dataset.service.ManageDatasets.getDatasetTestResultList:824 - Error while executing dataset for test purpose
it.eng.spagobi.utilities.exceptions.SpagoBIRuntimeException: Impossible to load dataset
at it.eng.spagobi.tools.dataset.common.dataproxy.JavaClassDataProxy.load(JavaClassDataProxy.java:89)
at it.eng.spagobi.tools.dataset.bo.ConfigurableDataSet.loadData(ConfigurableDataSet.java:91)
at it.eng.spagobi.tools.dataset.service.ManageDatasets.getDatasetTestResultList(ManageDatasets.java:817)
at it.eng.spagobi.tools.dataset.service.ManageDatasets.datasetTest(ManageDatasets.java:582)
at it.eng.spagobi.tools.dataset.service.ManageDatasets.datatsetTest(ManageDatasets.java:196)
at it.eng.spagobi.tools.dataset.service.ManageDatasets.doService(ManageDatasets.java:10
at it.eng.spagobi.commons.services.AbstractSpagoBIAction.service(AbstractSpagoBIAction.java:85)
at it.eng.spago.dispatching.action.ActionCoordinator.invokeServiceBusiness(ActionCoordinator.java:209)
at it.eng.spago.dispatching.action.ActionCoordinator.service(ActionCoordinator.java:15
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 it.eng.spagobi.commons.filters.SpagoBICoreCheckSessionFilter.doFilter(SpagoBICoreCheckSessionFilter.java:107)
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:12
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:722)
Caused by: java.lang.ClassCastException: test.Queryclass cannot be cast to it.eng.spagobi.tools.dataset.bo.IJavaClassDataSet
at it.eng.spagobi.tools.dataset.common.dataproxy.JavaClassDataProxy.load(JavaClassDataProxy.java:66).

It would have been much easier and faster to write in the documentation something like:

"To define a Java Class Data Set you need to implement the interface IJavaClassDataSet located in the package 'it.eng.spagobi.tools.dataset.bo', where you can find it in the source code on the download page..."

Hello Everyone,

Could someone tell me how to create a java class dataset?? The information in the documentation is not very helpful i guess hehe, and i've been googling for a while but i couldn't find anything.

The thing is I want to make some charts in highcharts, and I already made a query datatype for them, but it's always much easier and flexible to make changes in your data set if you got it in Java rather than sql.

So if someone could help me it would be great!

Thanks in avance,

Forum Index » Profile for rider21.spw » Messages posted by rider21.spw
Go to:   
Powered by JForum 2.1.9 © JForum Team