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

SpagoBI multi value parameter

I'm trying to create a multi-value parameter in SpagoBI. Here is my data set query whose last line appears to be causing an issue. select C."CUSTOMERNAME", C."CITY", D."YEAR", P."NAME" from "CUSTOMER" C, "DAY" D, "PRODUCT" P, "TRANSACTIONS"…
LucasPG
  • 423
  • 1
  • 6
  • 22
1
vote
0 answers

SpagoBI Studio after placing my dataset inside chart it's still default

I am trying to make chart with my data in SpagoBI Studio. When I am editing my chart I can see my data inside. But when I accept it it is still shown as default.
LucasPG
  • 423
  • 1
  • 6
  • 22
1
vote
0 answers

Smart filter saved in "my analysis"

I'm using SpagoBI and I would like to acces to smart filter I saved but i can't find it in the folder their show me "my analysis". I know this folder is present in user account, so i tried to save the smart filter into biuser (in fact i tried to…
Wazzouille
  • 43
  • 6
1
vote
0 answers

SpagoBI - multivalue parameter

I'm using SpagoBI for some week now, and I have some issues to configure parameter. I would like to have a multi-value parameter on a String column... I tried with: $P{par_columne (";,;")} like in the documentation. But that didn't work and I have…
1
vote
0 answers

How to allow Root Level search for LDAP in SpagoBI

I have connected ldap with my spagobi usiing ldap_authentication.xml It works fine. The point is that I need to provide "ou" name and it will search fr the user in the given ""ou' it self, even it does not performs Root Level Search. In My case,I…
Mr x
  • 828
  • 1
  • 8
  • 25
1
vote
1 answer

connecting spagobi to cosmos

I'm trying to connect SpagoBI to Cosmos via Hive JDBC driver. The connection works but I need to add jar (json-serde-1.3.1-SNAPSHOT-jar-with-dependencies.jar) to be able to execute map reduce when querying. The problem is that spago bi doesn't…
FrAG
  • 11
  • 2
1
vote
0 answers

SpagoBI charts: X axis values overlap when lot of values

I'm using SpagoBI to draw charts from values stored in a Database. If there are a few values, chart is showing properly, but if I have a lot of values the X axis legend overlaps. Example: Few values Lot of values I want to know if is possible to…
1
vote
1 answer

In SPAGOBI how can i print date parameters in actuall report

SELECT b1.voucher_no, b1.sl_name, b2.sub_ledger_name, b2.transaction_description, b2.gl_name FROM a_bank_receipt_voucher b1 inner join a_bank_receipt_account_details b2 on b1.bank_receipt_id = b2.bank_receipt_id …
1
vote
0 answers

Spagobi Birt report show all data using filter giving errors

I am using SpagoBI BIRT reports. I want to add multiple filters in my report and want to show all data by default. Why do I get errors like: Service Error: Cannot evaluate errors on parameter validation
1
vote
1 answer

Error adding widgets to a cockpit in SpagoBI 5.1.0

We have deployed a SpagoBI 5.1.0 using an pre-made vm image from FIWARE Cloud. We've added our PostgreSQL as a read-only data source. We've also added a few datasets and made some BIRT reports with Spago Studio. Those reports work fine, so I assume…
1
vote
1 answer

SpagoBI: Adding external hyperlink to report

I am building a report in SpagoBI using birt. I have build the report but I wanted to add a hyperlink that will point to an external site. I am unable to figure out how to do it. Any help is highly apprciated.
Jay Chakra
  • 1,481
  • 1
  • 13
  • 29
1
vote
1 answer

Drill down of DashBoards using BIRT

drilldown of charts can be done by considering the parent chart and child chart by relating them with some common parameter. But how can we drilldown the dashboard, as it consists of different charts in a single document?
ravi
  • 45
  • 4
1
vote
0 answers

Migrating Jasper Reports to SpagoBI Server

I have two servers running: The first one is a Jasper Server with multiple working reports. The second one is a freshly installed SpagoBI Server. Now the Jasper Server should not longer be used and the reports need to be migrated on the SpagoBI…
lumen
  • 219
  • 1
  • 2
  • 10
1
vote
0 answers

SemanticException [Error 10001]: Line 1:14 Table not found 'test1' through in hive

I am fetaching data from hive2 in SpagoBI 5.1 open source tool. When i am creating dashboard, it shows an error:- Impossible to load dataset [test_connection] due to the following service errors: Method not supported; And, in hive back ground,…
aman agrawal
  • 174
  • 8
1
vote
0 answers

Impossible to load dataset [dataset name] due to the following service errors: Method not supported in All-In-One SpagoBI 5.1

I am creating cockpit in SpagoBI 5.1. But, it through a error like:- "Impossible to load dataset [dataset name] due to the following service errors: Method not supported;" Why it is occurred? Please let me know the solution, if anybody…
aman agrawal
  • 174
  • 8
1 2
3
10 11