it4biz / saikuchartplus Goto Github PK

is it possible to change the text in the menu? For example: Pentaho MarketPlace -> Tienda MarketPlace

Estamos trabalhando com a ferramenta saiku-chart-plus e usamos GeoMaps, mas só aparece os países mas nao as ciudades. Como eu faz para mostrar as Cidades na Colombia?

Muito Obrigado.

I installed saiku chart plus package (saikuchartsplus-plugin-2.4-RC2.zip) on Pentaho 5.0.1 Community Edition but I get this error while load BA Server and saiku doesn’t work:

2014-01-15 10:04:39,392 ERROR [org.pentaho.platform.util.logging.Logger] Error: Pentaho
2014-01-15 10:04:39,393 ERROR [org.pentaho.platform.util.logging.Logger] misc-class org.pentaho.platform.plugin.services.pluginmgr.DefaultPluginManager: PluginManager.ERROR_0011 - Failed to register plugin saiku
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'pentahoDsManager' defined in file [/home/pentahoce501/pentaho/biserver-ce/pentaho-solutions/system/saiku/plugin.spring.xml]: Invocation of init method failed; nested exception is java.lang.NoSuchMethodError: org.pentaho.platform.util.xml.dom4j.XmlDom4JHelper.getDocFromFile(Ljava/lang/String;Lorg/xml/sax/EntityResolver;)Lorg/dom4j/Document;
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1338)

Hi, I create a Bar chart that has one Dimension in Row AXIS
and 2 dimensions in Column AXIS.
For example i have a Year dimension in the row axis
and a quarter dimension in column axis together with a sex dimension (male, female)
The thing is that the chart shows for every year bars with different colours that represent the Quarters
but can't figure out which quarter is for each sex.There is no description for the sex even if i highlight the bar with my cursor.

Do you have any ideas how can i achieve that?

Hi,
did you test chartplus with Saiku 2.5 (as a standalone app..) ??

What version of ChartPlus must install ?? ... because i have already test it with
vSaiku2.6-ChartPlusStable and vSaiku3-ChartPlusStable but nothing seems to work ....

I can't see the chartplus button ...

Thanks
Kostas

Dear all,

I could format the numbers for the different graphs using Highcharts.numberFormat function (this.y, 2, ',', '.') ... but I can't format the numbers for maps -the numbers which are showed in the tooltips- because I'm not sure about the right place in the code to make the changes

could you give me some indication?

Thanks in advance,

If I have a dataset with Multilevel-Dimension on rows and set-identifiers that can be converted to numbers ("6+", "6++"):

I get the following chart (with set-identifiers converted to numbers):

Changing Line 1237 in "plugin.js" (function "process_data") from:
parseFloat(args.data.cellset[row][col].value.replace(/[^a-zA-Z 0-9.]+/g,'')) && col>0)
to:
parseFloat(args.data.cellset[row][col].value.replace(/[^a-zA-Z 0-9.]+/g,'')) && col>lowest_level)
... things are working as expected

http://shop.highsoft.com/faq

Any commercial entity is supposed to buy a license and you are supposed to mention that if you bundle it with an opensource project.

Example with GeoChart:

http://jsfiddle.net/asgallant/rHqa2

Hi everyone,

I'm trying to run Saiku with a plugin, Saiku Chart Plus (http://it4biz.github.io/SaikuChartPlus/) without Pentaho BI. I've followed the instructions on the download page for the advanced installation, editing the saiku/ui/index.html file and adding the following code:

<!--search for this and put the files under this-->
<script type="text/javascript" src="js/saiku/plugins/Chart/plugin.js" defer></script>

<!--start js SaikuChartPlus-->
<script type="text/javascript" src="js/saiku/plugins/SaikuChartPlus/plugin.js" defer>    </script>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript"> 
     google.load('visualization', '1.0', {'packages':['geochart','geomap']});
</script>
<!--end js SaikuChartPlus-->

Then, I am supposed to download the project and extract the folder on saiku/ui/js/saiku/plugins/ . When I go to the file it indicates, there is already a file folder for Saiku Chart Plus, however, when I run saiku, it does not have the plugin functionality. What extra step am I missing?

Best,

Hello, I am working in maps of Ecuador Country and some states (province) no show. For example: ZAMORA CHINCHIPE, SANTO DOMINGO DE LOS TSÁCHILAS. In the map of saiku, the regions are shown but no show the data of this province. May be in saiku there is a diferents name for these provinces... How can I see the names of the provinces that saiku have ?

Thanky

Error in legend position.

On Saiku Chart Plus' Tools Bar, the icons not appear.. How can I resolve it?

Hi,

I'd like to see the results of my analysis on geographic maps. The data is only show at geochart world map, if I go into the detail of nations does not appear any more information. I need to show it until sub-district level. What could I do? Is it something wrong with my installation? And can/how I add sub-district to the map?

Thank you very much

Example:

https://google-developers.appspot.com/chart/interactive/docs/gallery/geochart_1b145d1d65eac5934fa85ac6fa7f62e5.frame?hl=pt-br

Cordial Saludo

Quisiera saber si en la parte de mapa del plugin existiria la posibilidad de tener zoom ya que se muestran muy pequeños los resultados, estuve viendo esto pero no se si se pueda incorporar http://jsfiddle.net/cmoreira/CCUpf/ aqui existe una forma de colocarlo, me gustaria saber si tiene esa posibilidad.

Gracias.

Att
Christiam Niño

I need to close the window when the SaikuChartPlus' user clicks on File -> Log Out
Can you help me please? I want to close the window and close the session at the same time..

2017/03/20 13:13:49 - Download Plugin - Connecting to URL: http://downloads.sourceforge.net/project/saikuchartplus/SaikuChartPlus3/saiku-chart-plus-vSaiku3-plugin-pentaho.zip
2017/03/20 13:13:49 - Download Plugin - Start reading reply from webserver.
2017/03/20 13:13:49 - Download Plugin - Resource type: text/html; charset=UTF-8, last modified on: Thu Jan 01 00:00:00 UTC 1970.
2017/03/20 13:13:49 - Download Plugin - Finished writing 425 bytes to result file [/home/olapadm/pentaho7/pentaho-server/pentaho-solutions/system/plugin-cache/downloads/saiku-chart-plus-2016.05.19_1490015629096.zip]
2017/03/20 13:13:49 - download_and_install_plugin - Starting entry [Unzip]
2017/03/20 13:13:49 - download_and_install_plugin - exec(2, 0, Unzip.0)
2017/03/20 13:13:49 - Unzip - Starting job entry
2017/03/20 13:13:49 - Unzip - Starting ...
2017/03/20 13:13:49 - Unzip - Processing row source File/folder source : [zip:${downloadDestination}] ... destination file/folder : [${stagingDestination}]... wildcard : [null]
2017/03/20 13:13:49 - Unzip - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Can not copy file/folder [zip:/home/olapadm/pentaho7/pentaho-server/pentaho-solutions/system/plugin-cache/downloads/saiku-chart-plus-2016.05.19_1490015629096.zip] to [/home/olapadm/pentaho7/pentaho-server/pentaho-solutions/system/plugin-cache/staging/]. Exception : [
2017/03/20 13:13:49 - Unzip -
2017/03/20 13:13:49 - Unzip - Unable to get VFS File object for filename 'zip:/home/olapadm/pentaho7/pentaho-server/pentaho-solutions/system/plugin-cache/downloads/saiku-chart-plus-2016.05.19_1490015629096.zip' : Could not open Zip file "/home/olapadm/pentaho7/pentaho-server/pentaho-solutions/system/plugin-cache/downloads/saiku-chart-plus-2016.05.19_1490015629096.zip".
2017/03/20 13:13:49 - Unzip -
2017/03/20 13:13:49 - Unzip - ]
2017/03/20 13:13:49 - Unzip - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : org.pentaho.di.core.exception.KettleFileException:
2017/03/20 13:13:49 - Unzip -
2017/03/20 13:13:49 - Unzip - Unable to get VFS File object for filename 'zip:/home/olapadm/pentaho7/pentaho-server/pentaho-solutions/system/plugin-cache/downloads/saiku-chart-plus-2016.05.19_1490015629096.zip' : Could not open Zip file "/home/olapadm/pentaho7/pentaho-server/pentaho-solutions/system/plugin-cache/downloads/saiku-chart-plus-2016.05.19_1490015629096.zip".
2017/03/20 13:13:49 - Unzip -
2017/03/20 13:13:49 - Unzip -
2017/03/20 13:13:49 - Unzip - at org.pentaho.di.core.vfs.KettleVFS.getFileObject(KettleVFS.java:159)
2017/03/20 13:13:49 - Unzip - at org.pentaho.di.core.vfs.KettleVFS.getFileObject(KettleVFS.java:106)
2017/03/20 13:13:49 - Unzip - at org.pentaho.di.job.entries.copyfiles.JobEntryCopyFiles.ProcessFileFolder(JobEntryCopyFiles.java:427)
2017/03/20 13:13:49 - Unzip - at org.pentaho.di.job.entries.copyfiles.JobEntryCopyFiles.execute(JobEntryCopyFiles.java:382)
2017/03/20 13:13:49 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:724)
2017/03/20 13:13:49 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:865)
2017/03/20 13:13:49 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:865)
2017/03/20 13:13:49 - Unzip - at org.pentaho.di.job.Job.execute(Job.java:546)
2017/03/20 13:13:49 - Unzip - at org.pentaho.di.job.Job.run(Job.java:436)
2017/03/20 13:13:49 - download_and_install_plugin - Starting entry [Unzipped Plugin Exists]
2017/03/20 13:13:49 - download_and_install_plugin - exec(3, 0, Unzipped Plugin Exists.0)
2017/03/20 13:13:49 - Unzipped Plugin Exists - Starting job entry
2017/03/20 13:13:49 - Unzipped Plugin Exists - File [/home/olapadm/pentaho7/pentaho-server/pentaho-solutions/system/plugin-cache/staging/saiku-chart-plus] does not exist!
2017/03/20 13:13:49 - download_and_install_plugin - Starting entry [Cleanup Staging]
2017/03/20 13:13:49 - download_and_install_plugin - exec(4, 0, Cleanup Staging.0)
2017/03/20 13:13:49 - Cleanup Staging - Starting job entry
2017/03/20 13:13:49 - Cleanup Staging - Processing folder [/home/olapadm/pentaho7/pentaho-server/pentaho-solutions/system/plugin-cache/staging/]
2017/03/20 13:13:49 - Cleanup Staging - Folder /home/olapadm/pentaho7/pentaho-server/pentaho-solutions/system/plugin-cache/staging/ was deleted. Total deleted files = 1
2017/03/20 13:13:49 - Cleanup Staging - =======================================
2017/03/20 13:13:49 - Cleanup Staging - Number of errors : 0
2017/03/20 13:13:49 - Cleanup Staging - Number of deleted folders : 1
2017/03/20 13:13:49 - Cleanup Staging - =======================================
2017/03/20 13:13:49 - download_and_install_plugin - Starting entry [Abort job]
2017/03/20 13:13:49 - download_and_install_plugin - exec(5, 0, Abort job.0)
2017/03/20 13:13:49 - Abort job - Starting job entry
2017/03/20 13:13:49 - Abort job - ERROR (version 7.0.0.0-25, build 1 from 2016-11-05 15.35.36 by buildguy) : Plugin did not contain ID
2017/03/20 13:13:49 - download_and_install_plugin - Finished job entry [Abort job] (result=[false])
2017/03/20 13:13:49 - download_and_install_plugin - Finished job entry [Cleanup Staging] (result=[false])
2017/03/20 13:13:49 - download_and_install_plugin - Finished job entry [Unzipped Plugin Exists] (result=[false])
2017/03/20 13:13:49 - download_and_install_plugin - Finished job entry [Unzip] (result=[false])
2017/03/20 13:13:49 - download_and_install_plugin - Finished job entry [Download Plugin] (result=[false])
2017/03/20 13:13:49 - download_and_install_plugin - Job execution finished

Primeiramente parabéns pelo plugin e pela iniciativa recorrente de promover o uso do Pentaho como uma suite madura de BI.
A minha dúvida é com relação a opção de mapa, só funciona com o mapa mundi?
Eu não conseguiria aplicar um mapa só do Brasil? Só de SP, RJ, etc...
Com certeza meus usuários iriam se beneficiar muito com esse recurso, mas não apenas os meus usuários e sim milhares que já utilizam Saiku.

Obrigado!

Hi: It is possible to include municipalities division for a map? I need it for El Salvador. Thanks in advance

Add Interactive Heatmaps with Google Maps API v3.

Please I need to insert sub district of the state/province to the map of Cuba!!!
If the cost of doing that es high,,Im more interested in divide in subdistrict Santiago de Cuba province, I attached the image for this propose.
I hope someone can help me!!

Hello,

I would like to thank you for the great job perform !!

Is it possible to install your plugin without pentaho by follow the recommendation hereafter ?

Thanks in advance for your feedback.

BEst Regards

Mehdi

For developer or advanced instalation

1. Edit the file saiku/ui/index.html, insert the code below:

Hi
I have data statistics classified by sex in day. Now I want to compare male and female trends on 8.11 and 8.12, but I can't distinguish the data between these lines.

but saiku's built-in lines can display like this, I think we should display all columns except first one.

The tool could be otimizated to be able export the graphics for excell as well pdf

Hoje estive tentando instalar o SaikuChartPlus através deste post (http://www.it4biz.com.br/novosite/saiku-chart-plus/), só que nenhuma das duas maneiras a sua execução acontece. Utilizo o Pentaho 4.8.

Vocês teriam alguma sugestão?

Hi,
It looks like it's easy to convert a table to char in saiku worksapce but how about a external URL visits?
How can I let ChartPlus work when I try to access a saved saiku report file CallUrlPlugin.saiku
http://localhost:9080?mode=table&plugin=true#query/open/Beta/CallUrlPlugin.saiku

Error load scripts in SSL environment.

Hi，
I have data statistics which is saved in half an hour，but sometimes the save will fail which result the data is not complete。Then I have this problem as the following image：

I have installed Saiku ChartPlus using Pentaho 5.2 marketplace, but the chart selection isn't working.
I'm using a Dell i3 notebook loaded with Windows 8.1 and JDK 1.7u72
I just can see the horizontal bar chart and I'm unable to choose another char such as pie chart or vertical bars chart.

When you install the pluging Saiku Chart Plus within the platform pentaho, me this error message appears. I'm using version 6 of Pentaho Comminity.
I am attaching the log file.
Thank you very much.
Angel

logs.docx

Hi i'm reda from morocco,
I can't display correctly points using lat/long attributes on the map,
also i can't see my points on the map when i chouse a county
Thnaks

Some kind of characters such á, é, í, ó, ú, ü, ñ show error.

I am unable to install Saiku Chart Plus from the pentaho CE 6.1 marketplace.

I am getting the 'no id' error as described here on StackOverflow
http://stackoverflow.com/questions/36789651/pentaho-marketplace-install-saiku-chart-plus-plugin-failed

Thanks

Fernando, We need that Geo Maps shows "San Andrés, Providencia y Santa Catalina". As you can see the Geo map shows the information of every state except "San Andrés, Providencia y Santa Catalina"

Thank you,

Hi, does the plugin support Dashboard functionality or is this an issue?
Because when i insert a saved report to widget in dashbaord it doesn't load it.