Stack Overflow
Stack Overflow

Questions tagged [spagobi]

SpagoBI is an Open Source Business Intelligence suite covering analytical areas of Business Intelligence projects, like reporting, multidimensional analysis (OLAP), interactive cockpits, data mining, network analysis,...

SpagoBI is an Open Source Business Intelligence suite covering analytical areas of Business Intelligence projects, like reporting, multidimensional analysis (OLAP), interactive cockpits, data mining, network analysis,...

http://www.spagobi.org/

151 questions
1
vote
2 answers

Is it possible to get data from REST APIs in SpagoBI?

I try to use Tuleap REST API with SpagoBI and it can't find any information. So, is it possible to get data from REST APIs in SpagoBI? Thanks for your answer, Sandra
Sandrae
  • 21
  • 2
1
vote
2 answers

How to create a Stacked Bar Chart with my data set created?

I have just now deployed a SpagoBI server and after setting up my data source: MS SQL Server. I am able to successfully create a data set. Now using my data set I want to create a stacked bar chart. So I select Charts->Stacked but to my surprise…
Programmer
  • 8,303
  • 23
  • 78
  • 162
1
vote
1 answer

How to create Cubes in SpagoBI?

I am new to SpagoBI. I am using SpagoBI studio to connect with MYSQL server. I can able to upload my Business models into SpagoBI server. I want to create a cube i.e., fact table using the database tables (MySQL) which I have connected in my studio.…
Sivam
  • 1,099
  • 3
  • 12
  • 25
1
vote
2 answers

SpagoBI URL directly

I'm using this URL to go directly to my document in SpagoBI but it does not work: http://localhost:8080/SpagoBI/servlet/AdapterHTTP? PAGE=LoginPage&NEW_SESSION=TRUE&OBJECT_LABEL=DocumentName It gives me the message that I should log in but i'm…
naruto
  • 19
  • 4
1
vote
3 answers

How to pass parameter top LOV query in SpagoBI

How I can pass a parameter to a LOV query in SPagoBI? I am creating a LOV using query ... something like this: select id, name from table1 where parent_id = ${parent_id} When I click on "Test before save" to evaluate query appears window with title…
gandra404
  • 5,727
  • 10
  • 52
  • 76
1
vote
2 answers

How I can choose conditionally parameter from multiple dependent combo boxes in SpagoBI

How I can choose conditionally parameter from multiple dependent combo boxes with subqueries and send it to a report? I have a BIRT report which use a stored procedure which expect parameter @category_id The input should come from one of three…
gandra404
  • 5,727
  • 10
  • 52
  • 76
1
vote
0 answers

SpagoBI SDK how to get the entire datasets & extract info from them through webservices?

Is it possible to get a dataset through WS against SpagoBI SDK? All that I got were just some documents but I was wondering if I could do that with Datasets as well. From the website I can see "The services available through web service are: Data…
ackuser
  • 5,681
  • 5
  • 40
  • 48
1
vote
0 answers

In memory Cockpits in SpagoBI 5 for different users

We met a problem when we build an in-memory cockpits document for different users. The problem is, user 'A' built a cockpit, and user 'B' (end-user) wanted to edit it as a template in his personal folder, but he doesn't allowed to do it. Some of…
Tom
  • 11
  • 1
0
votes
0 answers

How to embedded Knowage to html

I a new user to Knowage BI. I want to know on how to embed Knowage cockpit into html. So far I login as demo_admin and try to embed one of the cockpit to html using but when I did the embed and go to the embedded html and it will ask to login…
merry
  • 17
  • 7
0
votes
1 answer

Knowage stops responding [on Apache Tomcat]

I'm using Knowage and have setup a data source, many parameterized datasets, and a cockpit. I have a detailed report that requires many datasets. The cockpit started freezing and I have to restart the Knowage server to get it to respond. I split the…
Jeremy
  • 2,970
  • 1
  • 26
  • 50
0
votes
1 answer

How to concatenate text from multiple rows based on another common field in BI?

I need to concat the data in column B into a single line grouped by column A. I am using a Spago BI UI that limits me to distinct clause, group by, calculated values, where and having clauses. Wondering if anyone has any ideas. a b 1 Text 1…
user2865268
  • 5
  • 3
0
votes
3 answers

how to order by month name chronologically instead of alphabetically?

I would like to get the month names to be in chronological order instead of alphabetically ordered. Here is my Sql code. select SUM(montant_ht)as Achat ,monthname(dim_date.date) as mois from operation_odoo join dim_date on…
Dhouha
  • 661
  • 1
  • 8
  • 27
0
votes
1 answer

after installation, not able to login in knowage (http://localhost:8080/knowage)

I am done with knowage CE6.2 installation just now. And when I am trying to login using user - demo_admin(user name and password are same) demo_user (user name and password are same) I am unable to log in . Please see the attachment , That shows…
neeraj
  • 21
  • 3
0
votes
1 answer

Export Report format PDF in SpagoBI

When i export report in SpagoBI with format PDF,the page is cut in the right. Report in SpagoBI Report after export PDF How to resolve this problem? Thanks
Mokhless Hachicha
  • 1
  • 4
0
votes
1 answer

A BIRT exception occurred

I am running a report in local server. The query I have added works fine in mysql and is fetching data however when I use the same for running the birt report I get an error: Table User Registration: A BIRT exception occurred. See next exception…
user9370936
  • 13
  • 4
1 2 3
…
10 11