[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: chayden.spw
Forum Index » Profile for chayden.spw » Messages posted by chayden.spw
Author Message
Hi,
Can some tell me the version of Birt that will be included in SpagoBI 4.
Thanks.
Could you tell me what version of BIRT is included in SpagoBI 4.0
Hi,
Is it possible to have the target updated from a database(i.e. a moving target)?
Hi All,
Below is my environment information;
SpagoBI version: 3.6
Spago Database: HSQL
OS: Windows 7 32 bit


My problem is I have created my KPI(document and template) as specified in the how to. My KPI document runs but the value and the chart does not display. The value is being retrieved from a SQL Server 2005 database. The SpagoBI.log files shows the following;

[http-8080-1] 11 Dec 2012 08:04:05,960 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - Not in aggregate function or group by clause: org.hsqldb.Expression@af468f in statement [select top ? max(sbikpivalu0_.id_kpi_instance_value) as col_0_0_, sbikpivalu0_.VALUE as col_1_0_, sbikpivalu0_.BEGIN_DT as col_2_0_ from SBI_KPI_VALUE sbikpivalu0_ where sbikpivalu0_.id_kpi_instance=? and sbikpivalu0_.BEGIN_DT<=? group by sbikpivalu0_.BEGIN_DT order by sbikpivalu0_.BEGIN_DT desc]
[http-8080-1] 11 Dec 2012 08:04:05,960 ERROR org.hibernate.util.JDBCExceptionReporter.logExceptions:234 - Not in aggregate function or group by clause: org.hsqldb.Expression@af468f in statement [select top ? max(sbikpivalu0_.id_kpi_instance_value) as col_0_0_, sbikpivalu0_.VALUE as col_1_0_, sbikpivalu0_.BEGIN_DT as col_2_0_ from SBI_KPI_VALUE sbikpivalu0_ where sbikpivalu0_.id_kpi_instance=? and sbikpivalu0_.BEGIN_DT<=? group by sbikpivalu0_.BEGIN_DT order by sbikpivalu0_.BEGIN_DT desc]
[http-8080-1] 11 Dec 2012 08:04:05,960 ERROR it.eng.spagobi.kpi.config.dao.KpiDAOImpl.getKpiTrend:663 - org.hibernate.exception.SQLGrammarException: could not execute query
[http-8080-1] 11 Dec 2012 08:04:05,990 ERROR it.eng.spagobi.engines.kpi.utils.KpiGUIUtil.recursiveGetJsonObject:121 - Error getting execution instances
[http-8080-1] 11 Dec 2012 08:04:05,990 ERROR it.eng.spagobi.engines.kpi.utils.KpiGUIUtil.recursiveGetJsonObject:121 - Error getting execution instances
[http-8080-1] 11 Dec 2012 08:04:06,000 ERROR it.eng.spagobi.engines.kpi.utils.KpiGUIUtil.recursiveGetJsonObject:121 - Error getting execution instances
Hi All,
Can someone give me the steps to upgrade from version 3.4 to 3.6 with losing any of my documents and setup.
Thanks
Ok,
I downloaded the source code for version 3.4 and made the necessary changes in the required file and compile it. I think it works as not I am getting a OutOfMemory error when I am exporting.
Hi All,
I have being doing a little digging around and found the problem. Please take a look at the following link that has source code for a ExportResultAction.java file which handles result export.
http://websvn.ow2.org/log.php?repname=spagobi&path=%2FV_3.x%2FServer%2Ftags%2FSpagoBI-3.4%2820120416%29%2FSpagoBIQbeEngine%2Fsrc%2Fit%2Feng%2Fspagobi%2Fengines%2Fqbe%2Fservices%2Fcore%2FExportResultAction.java&rev=18028&peg=18028

Revision 16874 to 17077 has the corrected code to export to XLSX but from revision 17273 onward the correction was reverted back to the xls export.

Can someone make the necessary change
FROM
QbeXLSExporter exp = new QbeXLSExporter(dataStore, locale);

TO
QbeXLSXExporter exp = new QbeXLSXExporter(dataStore);

in the exportIntoXLSX function.


Thanks.
Have you got a solution or work around for this. I am facing the same problem.
Hi,
I am using SPAGOBI v3.4 on a Windows 2003 server. When exporting I am limited to excel 2003 with a 65536 rows. How can get this changed to export to Excel 2007 with 1,000,000 row limit. My objective is to go over the 65536 limit. I tried exporting to csv but csv does not include the column header in its export.
Thanks for the initial direction but is there any more info/details you can give. I will update as I go along.
Hi All,
Is there any way to create/define a new dialect that can be select when setting up a new datasource. If not, is it possible to modify an existing one.
Hi again,
I tried creating the subquery as tated but when I tried to save the query(not the subquery) with the subquery in the right operand I get the following error "An unpredicted error occurred while executing VALIDATE_CATALOGUE_ACTION service. The root cause of the error is: Input parameter 'query' cannot be null"
Thanks for the suggestion. With the large amount data and conparison I want to do, would you advise I put consumption for each month in a separate column and include columns having the total for each year. Eg a record will have column JAN2011, FEB2011 ...,DEC2011, 2011TOTAL, 2011AVG

I was thinking of this layout for the warehouse/datamart. By this I don't have 12 records(for one year of data) in table for each customer but one record. With the layout above I would then be able to (quickly) compare any month. What are your thoughts.

Also on a slightly different note I was trying to get an open source column store(eg monetdb, luciddb) database to work without success. The query response time are amazing.
Thank for the response. Is there anyway I would be able to get it include or there any plans to have it included in the next release. I am very impress with Luciddb speed and would love have it work. If not, is there any other open source column store database that will work with SpagoBI.
Hi,
Thanks for the response. I am aware of that. What i was looking for is a way to have the user specify the filter. Eg. Say filter this month sales < YTD average or this month sales < any specified year's average.
While it may not seem to be the best design I am looking to have each month sales in a different column and a column with each year average. With this doing I can compare any month's sale with the average for any year. I looking to have maximum 10 years of data for each customer.
 
Forum Index » Profile for chayden.spw » Messages posted by chayden.spw
Go to:   
Powered by JForum 2.1.9 © JForum Team