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

Tried to create a chart template and populate it on the server. When executing it, I receive the title, the axis and the legend + the error fromSDKTemplateToObjTemplate: Error while converting SDKTemplate into ObjTemplate.

The dataset gives back the data okay.

Is there a guide explaining how to create a chart type document from zero? I would like to be able to create a linkable document.

Thanks alot,

Zsolt
cmlo.spw wrote:Hi,

I have install the JDK version 1.7 with 64 bits. Set the System Variable as - JAVA_HOME = C:\Program Files\Java\jre7\bin.
After that, run the .bat file at bin folder - SpagoBIStartup (a slight flash).

But is not working as well.

Any other suggestion? Anthing that I missing?

Thanks in advanced.


Okay, I downloaded the all-in-one installer for Windows - InstallerSpagoBI-3.6.0_06112012. That installed all the engines (you can select), tomcat and the DB in few minutes. Then simply ran the Start_SpagoBI to launch the system.

On the other machine I did a custom installation - downloaded all the engines I thought I need, a MySQL version from Oracle and Tomcat 6. The wiki page about how to install is pretty good actually, it explains almost all. I had issues modifying the XML files of Tomcat at the beginning.

Let me know how it goes. might be able to help, though I am playing with since a week - have a demo to hack together by tomorrow.

Zsolt
Hi Community,

Trying to link two documents - a bar chart and a table - together within a composite document. What I would like to achieve is to allow the user to select a bar, pass the selected bar as an input to the table and display the details. When I try to specify the navigation in Spago Studio, the Destination Document combo box is empty.

Is there a comprehensive guide how to do such a thing?

Thanks alot for the help,

Zsolt
cmlo.spw wrote:Hi All,

I'm totally new to SpagoBI. Wanna to let SpagoBI, but having an issues to install the SpagoBI.

Follow the website - http://wiki.spagobi.org/xwiki/bin/view/spagobi_server/getting_started

As per the website, I just need to download the "All-in-one", Unzip and start the Tomcat server using startup.bat (double click and the screen just have a slight flash and then nothing happen).

Open the browser and type http://localhost:8080/SpagoBI - This is not working, I'm unable to access the URL.

Could anyone guide me, what are the thing that I missing? My OS is Window 7 64 bits (Hyper-V). Any prerequisites configuration/software installation that I need to done before install the "All-in-one".

FYI, I did not install the MySQL, JRE and etc. Did I need to install the MySQL, JRE first ?

As per the website, every thing since very simple just download the "All-in-one" and install it and it will auto configure all the necessary "thing".

Kindly guide me how to make the installation successfully.

Thanks in advanced.




Hi There,

Not an expert myself in SpagoBI, but using the all-in-one for testing and development. You need to have the JAVA installed and environment set before installing Spago. Make sure you take the right JAVA version (64 bit) and try the installation once more. The all-in-one is using its own TOMCAT and DB so no other installation is required. Once you managed to configure the tool, you will need to use the Start_SpagoBI/Stop_SpagoBI commands to start the system.

I also did a custom installation on another machine (Win 7, 64bit, MS SQL 2008 R2, Tomcat 6), that was a bit more complicated due to all the settings to do on Tomcat.

Good luck,

Zsolt
Dear All,

Iam trying to create a Datasource which connects to an MS SQL 2008 R2 database. There are several schemas in this DB. I created a user attribute to store the schema, then added this attribute to the SCHEMA ATTRIBUTE. When I try to execute the report using this data source, I receive an error message: Impossible to create engine instance for document [270]. The root cause of the error is: Impossible to retrive the value of attribute [schema] form user profile

Do I have to create a LOV and AD to get this value? and if yes, do I have to direct the result of this AD to this variable?

Thanks alot,

Zsolt
Hello Community,

I have to develop a series of KPI's based on dates. These dates are coming from a project management system and showing the performance of certain milestones.
Do you think it is possible? to do with the current Spago?

Thanks alot,

Zsolt
Found it!!
giachino wrote:Hi,
are you sure that the problem is only with the composite document??? Because if you have the same problem executing the document as stand-alone, I can suggest you a workaround in your Birt template.

You should add some rows of code in chart scripting (onRender event):



Set the right values for with and height..

Antonella


Hi Antonella,

You are right, I have the same issue with the standalone document. I dont know why I havent checked it before. I will try the code now.

Thanks alot for your help,

Zsolt
Dear All,

I try to build a composite document which has two elements: a bar chart and a table. I developed both components with BIRT. When I create a composite document, it displays the desired result, however the bar chart is very small and does not utilize the available estate. I tried to adjust the properties, etc, but no luck.

Have you ever seen such problem? How can I solve it?

Thanks alot,

Zsolt
annoul4.spw wrote:Maybe the data are cached and SpagoBI doesnot understand that the data has changed. I need to read more about caching.


Found a topic about it. It is cashed indeed, need to execute another document before to force data update. it works, but bizarre...

Hi Anna,

Thanks alot for your reply, I managed to do it thanks to the instructions. Now I am fighting other issue: the worksheet does not refresh the data when the dwh changes....only way I found is to restart the server..bit weird.

Zsolt
aghedin wrote:Hi Alessandro,

no now you can't do something like that (with out modify the source code).. We’ve decided to act in this way to help the performance, but you are right it’s a little bit uncomfortable.. A solution could be to add a button in the interface for refresh the temporary table..


Hi Alberto,

I have the same issue, using 3.6, right now I have only one single worksheet document, which does not picks up data from the dwh. The only way I found to refresh the chart is to restart the server! which is not really the good solution. Referring to your earlier post, have you done anything about the refresh button? I cant find it.

What is strange: when I develop the worksheet, the query is executed and the result is correct, but the chart displays the previous state.

Any ideas?

Zsolt
Hi Community,

I try to build some worksheets which are using simple filters. Used the Worksheet designer I selected a filed to be used as filter. When I try to execute the worksheet, Spago displays this: it.eng.spagobi.tools.dataset.co instead of the values from the filed. Does any of you ever seen this?

Cheers,

Zsolt Putnoky

Hi Community,

I have received the patch from Spago and tried. AND IT WORKS

The issue is being tracked on Jira and as soon as possible a final patch will be issued to all!

Cheers,

Zsolt Putnoky
Dear All,

I ran into the The error root cause is: Incorrect syntax near '`' error message yesterday. Checked with SpagoBi - excellent folks met during the OW2 Con 2012 - and they found an issue within the datamart.jar files. I received a patch and trying now. Will post the results.

My system is: Win 7 64 bit, MySQL for SpagoBI, MS SQL 2008 r2 for DWH and SpagoBI 3.6

Cheers,

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