[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 
What are the pitfalls of SpagoBI  XML
Forum Index » Technical Help - SpagoBI Server - FREE INQUIRY
Author Message
sraavsarma.spw

Newby

Joined: 31/01/2013 10:25:32
Messages: 46
Offline

Dear Experts,


We are looking for Open Source Business Intelligence Technology, where we came across SPAGO BI.
Now we should take a decision at our work place whether we should go with Spago BI or any other technology.

Could you plz tell us the PITFALLS/DRAWBACKS of SpagoBI. Based on the we will move ahead.
(We are using Oracle 11g database)

[Email]
sadiqkhoja.spw

Newby

Joined: 11/03/2013 14:33:21
Messages: 29
Offline

1) No Drilldown on Charts (Cross Navigation is just like drill through)
2) No Graphical Analysis on OLAP Cube (JPivot and JPalo are pivot tables with limited graphical options)
3) Documentation is very limited
4) Key-Value dimension can't be used as category in Charts (for details: http://www.spagoworld.org/jforum/posts/list/2264.page)
5) Prompts are not AJAX-Based, user has to press 'Execute' button after selecting prompt values

For more user experience, play with demo site : http://spagobi.eng.it/SpagoBI


but remember SpagoBI is absolutely FREE


Regards,
Sadiq Khoja
sraavsarma.spw

Newby

Joined: 31/01/2013 10:25:32
Messages: 46
Offline

Hi Sadiq,

Thank you so much for you quick reply...
[Email]
sraavsarma.spw

Newby

Joined: 31/01/2013 10:25:32
Messages: 46
Offline

is it possible to export records more than 10000 in spagobi??Either in XLS or PDF.
[Email]
huvernes.spw

Newby

Joined: 30/08/2010 11:47:01
Messages: 21
Offline

Hi,

Yes, you can, with Qbe engine, you have to modify the following line :

<QBE-SQL-RESULT-LIMIT value="10000" isBlocking="true">

in file SpagoBIQbeEngine/WEB-INF/conf/qbe.xml

Regard's
Hugo
sraavsarma.spw

Newby

Joined: 31/01/2013 10:25:32
Messages: 46
Offline

Ya I have changed that to maximum value,after changing I can be able to save upto 20-22 thousands only.My task is to save approximately 5 lakhs records in PDF/XLS


Anyway thanks for reply.
[Email]
aghedin

SpagoBI hero
[Avatar]

Joined: 14/07/2010 09:25:00
Messages: 465
Offline

sadiqkhoja.spw wrote:
1) No Drilldown on Charts (Cross Navigation is just like drill through)

You can do that with cross navigation (you should implement the logic in the query)
sadiqkhoja.spw wrote:
2) No Graphical Analysis on OLAP Cube (JPivot and JPalo are pivot tables with limited graphical options)

Actually JPivot has charts. It's true that they are limited
sadiqkhoja.spw wrote:
3) Documentation is very limited

There is the wiki http://wiki.spagobi.org/xwiki/bin/view/Main/ and SpagoBi book http://www.spagoworld.org/xwiki/bin/view/SpagoBI/Book

For more user experience, play with demo site : http://spagobi.eng.it/SpagoBI

sadiqkhoja.spw wrote:
but remember SpagoBI is absolutely FREE


And no "vendor lock in"

SpagoBI is The only 100% open source, complete and flexible BI suite
- a complete, robust, secure, scalable, industry-grade OS BI suite
- 16 analytical areas, more than 30 analytical engines
- unique solutions, not only usual reporting and charting tools: Geo, QbE, Dossier, KPIs, Interactive Dashboards, Real-time BI.

Alberto Ghedin

~~~ sis felix ~~~
omehacker.spw

Newby

Joined: 12/10/2017 13:46:24
Messages: 11
Offline

Thank you so much to the last suggestion.Now am easily able to play spades card game with the help of this amazing website free online spades games for free and online.I like to play at this kind of platform and invite my friends too.
 
Forum Index » Technical Help - SpagoBI Server - FREE INQUIRY
Go to:   
Powered by JForum 2.1.9 © JForum Team