Open Business Intelligence

La red del Business Intelligence

Hola buenas tardes comunidad de Pentaho, me dirijo a ustedes ya que en este foro he encontrado información muy util y con la cual he aprendido a manejar las diferentes herramientas que ofrece Pentaho, motivo por el cual quiero aprender a realizar Dashboard. he visto varios tutoriales y son de mucha ayuda pero actualmente estoy presentando problemas al crear un grafico de barras que estoy siguiendo de un tutorial.

El problema es el siguiente: En la pestaña del Data Sources (DS) cuando quiero crear un nuevo DS usando el MDX Queries especificamente el mdx over mondrianJndi al momento de querer seleccionar un Mondrian Schema en este campo no se carga ninguno, no se a que se deba. espero me puedan ayudar!!

Nota: El problema solo existe en el MDX Queries, ya que en los demas tipos de DS si me carga los esquemas.

Visitas: 1231

Respuestas a esta discusión

Estimado, comienza a escribir parte del nombre y aparecerán los DS JNDI y los Esquemas mondrian, los campos no son listas desplegables, son textos que se autocompletan.

La url que utiliza CDE es:

http://localhost:8080/pentaho/content/pentaho-cdf-dd/OlapUtils?operation=GetOlapCubes

La respuesta debe ser un JSON con algo similar a esto:

{ "status": "true", "result": {"catalogs": [ { "name": "SampleData", "schema": "solution:steel-wheels/analysis/SampleData.mondrian.xml", "jndi": "SampleData", "cubes": [ { "id": "Quadrant Analysis", "name": "Quadrant Analysis" }] }, { "name": "SteelWheels", "schema": "solution:steel-wheels/analysis/steelwheels.mondrian.xml", "jndi": "SampleData", "cubes": [ { "id": "SteelWheelsSales", "name": "SteelWheelsSales" }] } ]} }

De lo contrario hay algún otro problema.

Qué versión de Pentaho y CDE estás usando?

Qué browser usas?

Saludos

Mariano

Gracias Mariano por tu respuesta, estoy usando la versión de Pentaho biserver-ce-4.5 y el CDE-bundle-1.0-RC3 y como browser es Mozilla Firefox 15.0

De verdad que no se si es por una mala instalacion del CDE o algo parecido.

Te recomiendo que utilices la última versión de CDF/CDE, puedes instalarlos utilizando ctools-installer.sh o bien la versión para windows, a esta última no la he utilizado nunca, pero se que existe y funciona. yo utilizo la versión para linux y la corro cada semana, en cuestión de minutos tengo las CTools & Saiku actualizadas.

Saludos

Mariano

Yo estoy usando debian y me baje el ctools-installer.sh pero cuando lo ejecuto no sucede nada! dice que los instalo correctamente pero no tengo visible la opcion para crear CDE por eso descargue el CDE-bundle aparte

Bien, entonces es fácil solo ejecuta ctools-installer así (asumiendo que te encuentras en la carpeta padre de biserver-ce):

sh ctools-installer.sh -s biserver-ce/pentaho-solutions -w biserver-ce/tomcat/webapps/pentaho -b dev

Responde a todo Y

Debes detener el bi-server antes de ejecutar

Saludos

Mariano

root@info-analista2:/opt/biserver-ce-4.5.0-stable# sh ctools-installer.sh -s biserver-ce/pentaho-solutions/ -w biserver-ce/tomcat/webapps/pentaho -b dev

CTOOLS

ctools-installer version 1.37

Author: Pedro Alves (webdetails)
Thanks to Analytical Labs for jenkins builds
Copyright Webdetails 2011


Changelog:

v1.37 - plugin-samples/cdv was not deleted. Fixed
v1.36 - CDV now installs samples too
v1.35 - Support for stable CDV, CDC and CDB installation
v1.34 - Support for CDV installation using -b dev switch
v1.33 - Added support for Saiku ad hoc stable (release) installations.
v1.32 - Added windows cr tolerance for this script's auto update
v1.31 - Support for CDB installation using -b dev switch
v1.30 - Support for CDC installation using -b dev switch
v1.29 - Changed saiku download path to 2.3
v1.28 - Support for CGG in 4.5, where webapp path is no longer required
v1.27 - Added support for CGG stable ( release ) installations.
v1.26 - -y flag now also works for ctools-installer update. ctools-installer update is now automated - Thanks to Mark Reid.
v1.25 - Removed overwrite, explicitly deleting marketplace definition
v1.24 - Added force overwrite to unzip to phase out overwrite confirmation
v1.23 - CDF trunk installation change due to js publish
v1.22 - Changed saiku download path to 2.2
v1.21 - Added support for CDE stable (release) installations.
v1.20 - CDF new samples location updated to stable installation.
v1.19 - Corrected installCDF and installCDE to remove samples dir before installing
v1.18 - CDA samples installation to plugin-samples also in stable mode.
v1.17 - Change to CDA and CDE samples installation. Now installs to folder plugin-samples instead of bi-developers (for trunk snapshot only).
v1.16 - Added support for CDC and Saiku-adhoc installation - for now only available in dev/trunk mode.
v1.15 - Change to CDF samples installation. Now installs to folder plugin-samples instead of bi-developers (for trunk snapshot only).
v1.14 - Added support for CDF stable (release) installations.
v1.13 - Fixed issue in CGG download
v1.12 - Fixed typo in -Y option
v1.11 - Added support for -y option (assume yes) - Thanks to Christian G. Warden
v1.10 - Added support for Saiku trunk snapshots installations.
v1.9 - Added support for CDA stable (release) installations.
v1.8 - Added CGG; Script refactor
v1.7 - Changed url locations to new path of analytical labs
v1.6 - Changed saiku download path to 2.1
v1.5 - Changed default indicator values in prompts
v1.4 - Added Saiku for the list of installs
v1.3 - Added support for automatic updates
v1.2 - Silent mode for downloading
v1.1 - Minor bugfixes
v1.0 - First release


Disclaimer: we can't be responsible for any damage done to your system, which hopefully will not happen
Note: ctools-installer.sh will upgrade the plugins under system directory.
      Any changes you have made there (eg: cdf templates) will have to be backed up and manually copied after running the script
     CGG will need to change the server WEB-INF/lib too. Backup your server

ctools-installer.sh: 129: [[: not found
ctools-installer.sh: 135: [[: not found
ctools-installer.sh: 146: [[: not found
ctools-installer.sh: 155: [[: not found
ctools-installer.sh: 155: [[: not found

Install CDF? This will delete everything in biserver-ce/pentaho-solutions//system/pentaho-cdf. you sure? (y/N) read: 452: Illegal option -e

Install CDA? This will delete everything in biserver-ce/pentaho-solutions//system/cda. you sure? (y/N) read: 465: Illegal option -e

Install CDE? This will delete everything in biserver-ce/pentaho-solutions//system/pentaho-cdf-dd. you sure? (y/N) read: 478: Illegal option -e

Install CGG? This will delete everything in biserver-ce/pentaho-solutions//system/cgg. you sure? (y/N) read: 490: Illegal option -e
ctools-installer.sh: 510: [[: not found

No webapp path provided, will not install CDC

Install CDB? This will delete everything in biserver-ce/pentaho-solutions//system/cdb. you sure? (y/N) read: 524: Illegal option -e

Install CDV? This will delete everything in biserver-ce/pentaho-solutions//system/cdv. you sure? (y/N) read: 538: Illegal option -e

Install Saiku? This will delete everything in biserver-ce/pentaho-solutions//system/saiku. you sure? (y/N) read: 554: Illegal option -e

Install Saiku Adhoc? This will delete everything in biserver-ce/pentaho-solutions//system/saiku-adhoc. you sure? (y/N) read: 567: Illegal option -e
Nothing to do. Exiting

Eso fue lo que arrojo!!

Que macana, no se que puede ser, tendrías que instalar CTools/Saiku a mano, pero es un tema medio largo, si quieres ir viendo, entra en http://ci.analytical-labs.com/, abre una cuenta en las pestañas Saiku y Webdetails están los paquetenes que necesitas, hace tiempo que no lo hago a mano, no me animo a decirte cual era mi procedimiento, ya que pueden haber cambiado la forma, igualmente en el script ctools-installer.sh puedes ver paso a paso lo que debes hacer.

Saludos

Mariano

Buenas, fijate de cambiar los parámetros que le envias al script.
El log te dice que esta ruta no existe:

biserver-ce/pentaho-solutions//system/saiku-adhoc

Tiene una doble barra ( // ) luego de pentaho-solutions. Intenta entonces al ejecutar el script pasarle el path de pentaho-solutions sin la barra final. Es decir:

$ sh ctools-installer.sh -s biserver-ce/pentaho-solutions

Saludos

Buenas, gracias Bernabeu por responder y fijarte de ese detalle lo ejecute sin la barra y esto fue lo que arrojo:

root@info-analista2:/opt/biserver-ce-4.5.0-stable# sh ctools-installer.sh -s biserver-ce/pentaho-solutions -w biserver-ce/tomcat/webapps/pentaho -b dev

CTOOLS

ctools-installer version 1.37

Author: Pedro Alves (webdetails)
Thanks to Analytical Labs for jenkins builds
Copyright Webdetails 2011


Changelog:

v1.37 - plugin-samples/cdv was not deleted. Fixed
v1.36 - CDV now installs samples too
v1.35 - Support for stable CDV, CDC and CDB installation
v1.34 - Support for CDV installation using -b dev switch
v1.33 - Added support for Saiku ad hoc stable (release) installations.
v1.32 - Added windows cr tolerance for this script's auto update
v1.31 - Support for CDB installation using -b dev switch
v1.30 - Support for CDC installation using -b dev switch
v1.29 - Changed saiku download path to 2.3
v1.28 - Support for CGG in 4.5, where webapp path is no longer required
v1.27 - Added support for CGG stable ( release ) installations.
v1.26 - -y flag now also works for ctools-installer update. ctools-installer update is now automated - Thanks to Mark Reid.
v1.25 - Removed overwrite, explicitly deleting marketplace definition
v1.24 - Added force overwrite to unzip to phase out overwrite confirmation
v1.23 - CDF trunk installation change due to js publish
v1.22 - Changed saiku download path to 2.2
v1.21 - Added support for CDE stable (release) installations.
v1.20 - CDF new samples location updated to stable installation.
v1.19 - Corrected installCDF and installCDE to remove samples dir before installing
v1.18 - CDA samples installation to plugin-samples also in stable mode.
v1.17 - Change to CDA and CDE samples installation. Now installs to folder plugin-samples instead of bi-developers (for trunk snapshot only).
v1.16 - Added support for CDC and Saiku-adhoc installation - for now only available in dev/trunk mode.
v1.15 - Change to CDF samples installation. Now installs to folder plugin-samples instead of bi-developers (for trunk snapshot only).
v1.14 - Added support for CDF stable (release) installations.
v1.13 - Fixed issue in CGG download
v1.12 - Fixed typo in -Y option
v1.11 - Added support for -y option (assume yes) - Thanks to Christian G. Warden
v1.10 - Added support for Saiku trunk snapshots installations.
v1.9 - Added support for CDA stable (release) installations.
v1.8 - Added CGG; Script refactor
v1.7 - Changed url locations to new path of analytical labs
v1.6 - Changed saiku download path to 2.1
v1.5 - Changed default indicator values in prompts
v1.4 - Added Saiku for the list of installs
v1.3 - Added support for automatic updates
v1.2 - Silent mode for downloading
v1.1 - Minor bugfixes
v1.0 - First release


Disclaimer: we can't be responsible for any damage done to your system, which hopefully will not happen
Note: ctools-installer.sh will upgrade the plugins under system directory.
      Any changes you have made there (eg: cdf templates) will have to be backed up and manually copied after running the script
     CGG will need to change the server WEB-INF/lib too. Backup your server

ctools-installer.sh: 129: [[: not found
ctools-installer.sh: 135: [[: not found
ctools-installer.sh: 146: [[: not found
ctools-installer.sh: 155: [[: not found
ctools-installer.sh: 155: [[: not found

Install CDF? This will delete everything in biserver-ce/pentaho-solutions/system/pentaho-cdf. you sure? (y/N) read: 452: Illegal option -e

Install CDA? This will delete everything in biserver-ce/pentaho-solutions/system/cda. you sure? (y/N) read: 465: Illegal option -e

Install CDE? This will delete everything in biserver-ce/pentaho-solutions/system/pentaho-cdf-dd. you sure? (y/N) read: 478: Illegal option -e

Install CGG? This will delete everything in biserver-ce/pentaho-solutions/system/cgg. you sure? (y/N) read: 490: Illegal option -e
ctools-installer.sh: 510: [[: not found

No webapp path provided, will not install CDC

Install CDB? This will delete everything in biserver-ce/pentaho-solutions/system/cdb. you sure? (y/N) read: 524: Illegal option -e

Install CDV? This will delete everything in biserver-ce/pentaho-solutions/system/cdv. you sure? (y/N) read: 538: Illegal option -e

Install Saiku? This will delete everything in biserver-ce/pentaho-solutions/system/saiku. you sure? (y/N) read: 554: Illegal option -e

Install Saiku Adhoc? This will delete everything in biserver-ce/pentaho-solutions/system/saiku-adhoc. you sure? (y/N) read: 567: Illegal option -e
Nothing to do. Exiting

Prueba añadirle el -y al final de la cadena.

Buenos días, primero que nada les agradesco el interes. volvi a realizar la prueba y arrojo esto:

root@info-analista2:/opt/biserver-ce-4.5.0-stable# sh ctools-installer.sh -s biserver-ce/pentaho-solutions -w biserver-ce/tomcat/webapps/pentaho -b dev -y

CTOOLS

ctools-installer version 1.37

Author: Pedro Alves (webdetails)
Thanks to Analytical Labs for jenkins builds
Copyright Webdetails 2011


Changelog:

v1.37 - plugin-samples/cdv was not deleted. Fixed
v1.36 - CDV now installs samples too
v1.35 - Support for stable CDV, CDC and CDB installation
v1.34 - Support for CDV installation using -b dev switch
v1.33 - Added support for Saiku ad hoc stable (release) installations.
v1.32 - Added windows cr tolerance for this script's auto update
v1.31 - Support for CDB installation using -b dev switch
v1.30 - Support for CDC installation using -b dev switch
v1.29 - Changed saiku download path to 2.3
v1.28 - Support for CGG in 4.5, where webapp path is no longer required
v1.27 - Added support for CGG stable ( release ) installations.
v1.26 - -y flag now also works for ctools-installer update. ctools-installer update is now automated - Thanks to Mark Reid.
v1.25 - Removed overwrite, explicitly deleting marketplace definition
v1.24 - Added force overwrite to unzip to phase out overwrite confirmation
v1.23 - CDF trunk installation change due to js publish
v1.22 - Changed saiku download path to 2.2
v1.21 - Added support for CDE stable (release) installations.
v1.20 - CDF new samples location updated to stable installation.
v1.19 - Corrected installCDF and installCDE to remove samples dir before installing
v1.18 - CDA samples installation to plugin-samples also in stable mode.
v1.17 - Change to CDA and CDE samples installation. Now installs to folder plugin-samples instead of bi-developers (for trunk snapshot only).
v1.16 - Added support for CDC and Saiku-adhoc installation - for now only available in dev/trunk mode.
v1.15 - Change to CDF samples installation. Now installs to folder plugin-samples instead of bi-developers (for trunk snapshot only).
v1.14 - Added support for CDF stable (release) installations.
v1.13 - Fixed issue in CGG download
v1.12 - Fixed typo in -Y option
v1.11 - Added support for -y option (assume yes) - Thanks to Christian G. Warden
v1.10 - Added support for Saiku trunk snapshots installations.
v1.9 - Added support for CDA stable (release) installations.
v1.8 - Added CGG; Script refactor
v1.7 - Changed url locations to new path of analytical labs
v1.6 - Changed saiku download path to 2.1
v1.5 - Changed default indicator values in prompts
v1.4 - Added Saiku for the list of installs
v1.3 - Added support for automatic updates
v1.2 - Silent mode for downloading
v1.1 - Minor bugfixes
v1.0 - First release


Disclaimer: we can't be responsible for any damage done to your system, which hopefully will not happen
Note: ctools-installer.sh will upgrade the plugins under system directory.
      Any changes you have made there (eg: cdf templates) will have to be backed up and manually copied after running the script
     CGG will need to change the server WEB-INF/lib too. Backup your server

ctools-installer.sh: 129: [[: not found
ctools-installer.sh: 135: [[: not found
ctools-installer.sh: 146: [[: not found
ctools-installer.sh: 155: [[: not found
ctools-installer.sh: 155: [[: not found
Upgrade successful. Rerunning command 'ctools-installer.sh -s biserver-ce/pentaho-solutions -w biserver-ce/tomcat/webapps/pentaho -b dev -y'

CTOOLS

ctools-installer version 1.37

Author: Pedro Alves (webdetails)
Thanks to Analytical Labs for jenkins builds
Copyright Webdetails 2011


Changelog:

v1.38 - Added option -n for CBF integration
v1.37 - plugin-samples/cdv was not deleted. Fixed
v1.36 - CDV now installs samples too
v1.35 - Support for stable CDV, CDC and CDB installation
v1.34 - Support for CDV installation using -b dev switch
v1.33 - Added support for Saiku ad hoc stable (release) installations.
v1.32 - Added windows cr tolerance for this script's auto update
v1.31 - Support for CDB installation using -b dev switch
v1.30 - Support for CDC installation using -b dev switch
v1.29 - Changed saiku download path to 2.3
v1.28 - Support for CGG in 4.5, where webapp path is no longer required
v1.27 - Added support for CGG stable ( release ) installations.
v1.26 - -y flag now also works for ctools-installer update. ctools-installer update is now automated - Thanks to Mark Reid.
v1.25 - Removed overwrite, explicitly deleting marketplace definition
v1.24 - Added force overwrite to unzip to phase out overwrite confirmation
v1.23 - CDF trunk installation change due to js publish
v1.22 - Changed saiku download path to 2.2
v1.21 - Added support for CDE stable (release) installations.
v1.20 - CDF new samples location updated to stable installation.
v1.19 - Corrected installCDF and installCDE to remove samples dir before installing
v1.18 - CDA samples installation to plugin-samples also in stable mode.
v1.17 - Change to CDA and CDE samples installation. Now installs to folder plugin-samples instead of bi-developers (for trunk snapshot only).
v1.16 - Added support for CDC and Saiku-adhoc installation - for now only available in dev/trunk mode.
v1.15 - Change to CDF samples installation. Now installs to folder plugin-samples instead of bi-developers (for trunk snapshot only).
v1.14 - Added support for CDF stable (release) installations.
v1.13 - Fixed issue in CGG download
v1.12 - Fixed typo in -Y option
v1.11 - Added support for -y option (assume yes) - Thanks to Christian G. Warden
v1.10 - Added support for Saiku trunk snapshots installations.
v1.9 - Added support for CDA stable (release) installations.
v1.8 - Added CGG; Script refactor
v1.7 - Changed url locations to new path of analytical labs
v1.6 - Changed saiku download path to 2.1
v1.5 - Changed default indicator values in prompts
v1.4 - Added Saiku for the list of installs
v1.3 - Added support for automatic updates
v1.2 - Silent mode for downloading
v1.1 - Minor bugfixes
v1.0 - First release


Disclaimer: we can't be responsible for any damage done to your system, which hopefully will not happen
Note: ctools-installer.sh will upgrade the plugins under system directory.
      Any changes you have made there (eg: cdf templates) will have to be backed up and manually copied after running the script
     CGG will need to change the server WEB-INF/lib too. Backup your server

ERROR: Missing required 'unzip' command.


cual es ese comando unzip?

Tienes instalado el unzip? Prueba escribir unzip en una terminal para verificar si lo tienes instalado, en caso contrario procede a su instalación.

RSS

Distintivo

Cargando…

© 2019   Creado por Emilio.   Tecnología de

Emblemas  |  Reportar un problema  |  Términos de servicio