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.
Etiquetas:
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.
Bienvenido a
Open Business Intelligence
© 2024 Creado por Emilio. Tecnología de