Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: franboeing; Keyword(s):

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    3
    Views
    3,593

    Hola

    Hola cómo va??
    vuelvo a la carga despues de unas semanas de inactividad.

    Dime, tienes las herramientas ReportDesigner y CubeDesigner?

    Has conseguido publicar?
    Un saludo

    Fran
  2. Replies
    4
    Views
    2,480

    I have the same problem

    Hi, I am trying to find out exactly the same thing, but I haven't received any answer.
    I made a little research and it seems that microsoft SQL Server provides some functionality for that, but since...
  3. Replies
    0
    Views
    3,253

    como usar parametros y variables en MDX

    Hola a todos. Tenemos este nuevo proyecto en el que hemos de dejar al usuario meter unos datos para hacer sus propios calculos (what-if analysis), y mostrar los resultados.

    Ahora el problema es...
  4. Replies
    0
    Views
    1,842

    How to use parameters with MDX

    Hello everybody.

    We want the users to make calculations based on the data they enter.

    So the goal is having the user to input a (x,y) point and pass these values to calculate the measure with...
  5. Replies
    2
    Views
    1,116

    I used sql dialect

    I solved the issue using

    <Measure name="my_measure">
    <MeasureExpression>
    <sql dialect="my_db">

    ( sqrt( db.column_name ) )

    </sql>
    </...
  6. Replies
    2
    Views
    1,116

    Square roots calculations

    Hello everybody.
    I have to calculate some distances, and I need to get some square roots(hypotenuse).

    I have the distance already calculated and my plan was to get the square root of that...
  7. Replies
    2
    Views
    1,003

    Syntax issue

    I would check the syntax in line 1, the 'select' clause. There is something the program does not understand. Try enclosing the hierarchies in square brackets and separate them by dots.

    Hope this...
  8. Replies
    0
    Views
    720

    Problems with Charts in Excel

    Hello everybody.
    When I export to Excel, I can not save the chart, so when I want to refer to the document at a later time with the server shut down, the graph is gone.

    I am not using Excel but...
  9. Replies
    1
    Views
    793

    Check Measures attributes formatString

    If you amount is a measure, it has the attribute 'formatString' where you can format the obtained value.
    If it is a calculated member you may need to set a

    <CalculatedMemberProperty>

    The...
  10. Replies
    1
    Views
    993

    Mondrian Foodmart documentation

    Hello everybody. I am looking for documents that explain the Mondrian OLAP Foodmart example, I mean, what the icons are for and what are the different options.
    Any help would be appreciated...
  11. Replies
    2
    Views
    1,257

    Thanks

    Thanks, I was looking into mdxtable.xls so no wonder i couldn't find it.

    Regards,
    Fran
  12. Replies
    7
    Views
    1,801

    Check the syntax

    Hi, I have some similar problems. I have three cubes and a virtual one that relates the measures of the other three.

    If a single cube works, but not the two of them, mi guess is that there must...
  13. Replies
    4
    Views
    1,449

    Delete row

    Then, I think you should remove that row from your tables manually.
  14. Replies
    7
    Views
    1,437

    It is probably your query

    I had these error sometimes. iI thought it was because the query result is 'null', I would check the MDX query or the syntax in your schema.

    hope this helps,
    Fran
  15. Replies
    9
    Views
    4,044

    Thanks

    Thanks for your answer,
    Fran
  16. Replies
    2
    Views
    1,257

    Export to PDF

    Hello all.
    I just produced a nice report and I want to have it in a PDF document. However in the PDF document, I can see a default header 'HEADER TEXT (e.g Company Name)'
    and a default footer...
  17. Replies
    4
    Views
    1,449

    Check database

    Hello, my guess is that the null value comes from your tables.
    Maybe there is a row with null values.

    Hope this helps,
    Fran
  18. Replies
    1
    Views
    755

    How to display data in charts

    Hello everybody.
    We want to be able to display the data that correspond to the part of the pie / column, but I am not sure if this is posible

    Does somebody know how to display the data within...
  19. Replies
    6
    Views
    1,242

    Set chart properties

    Great, I am glad to help.
    I think we are in the 'same wave' (spanish saying).

    In chart properties you can set the 'Axes Tick Label font' to 0, 30, 45, and 90 degrees. The default is 30 but if...
  20. Might be the driver

    Hello, I am not an expert but I am using mysql as well.

    In my set up, I have included the default mysql port 3306:
    jdbc:mysql://localhost:3306/myfolder.

    Hope this helps
    Good luck,
    Fran
  21. Replies
    6
    Views
    1,242

    It works for me

    I am sorry it does not work for you, but it is working for me.
    I think is a html issue, maybe is the browser, i do not know.

    try this:

    <div style="margin-left:10%; margin-right:10%">
    <!-- ...
  22. Replies
    9
    Views
    4,044

    Mondrian Error: duplicate table alias

    Hello again.

    I would like to know if it is posible to get two dimensions from the same table but use them differently in one cube.

    I tried two shared dimensions from the same table and then...
  23. Replies
    3
    Views
    3,478

    El manual está bien

    Con Cube Designer viene un manual sobre como utilizar el software, sin embargo no genera esquemas complejos.

    Yo diseñé un cubo sencillo, generé el documento XML y después lo fui mejorando...
  24. Replies
    5
    Views
    11,847

    It worked, thanks

    Thank you, now is working.

    I have to get all the different events and display a chart.
  25. Pentaho y Mondrian

    Hola muy buenas desde Madrid.

    Para empezar puedes bajarte la demo de pentaho y seguir las instrucciones de instalación ya sea para windows o linux.

    Mondrian es el server OLAP y tambien te lo...
  26. Replies
    6
    Views
    1,242

    i used HTML tag

    To center the chart, I used the <center> tag in testpage.jsp.
    Look for the comment <!-- render chart --> close to the bottom of the page:

    <p>
    <center>
    <!-- render chart -->
    <wcf: render...
  27. Replies
    5
    Views
    11,847

    MeasureExpression syntax

    Hello, we are dealing with statistical data over here. I have to measure how many ocurrences of several events happened, so I have to count within a column how many times one ocurrence happens...
  28. Replies
    7
    Views
    7,994

    Gran Interes..

    Me parece una iniciativa estupenda. Cuenten conmigo. Soy Español y hablo y leo inglés muy bien (estudié en los states).

    Hasta pronto,
    Fran
  29. Replies
    1
    Views
    2,092

    Measure expression

    Hola a todos.
    estoy intentando sacar olap analisis de unas encuestas, con lo que las medidas no se pueden sumar sino sólo contar.

    el caso es que quiero contar cuantas ocurrencias hay en una...
  30. Replies
    0
    Views
    1,807

    Problems with XMLA

    Hola a todos. Estoy usando JBoss y MySQL
    En Mondrian/Jpivot, no consiguo hacer funcionar el ejemplo de XMLA for Analysis tester. el documento en cuestión es xmlaTest.jsp
    El error que me da es:
    ...
  31. Replies
    1
    Views
    874

    NullPointerException

    Hello everybody.

    I am receiving a null pointer exception when running this adhoc query (#15 in adhoc.jsp) from the Mondrian demo:

    select
    CrossJoin(
    {[Measures].[Unit Sales],...
  32. Check url's and catalog name

    in your files:
    Jdbc='jdbc:postgresql://localhost/foodmart'
    JdbcDriver=org.postgresql.Driver;

    I also have the port for MySQL in all my Jdbc properties:
    jdbc:mysql://localhost:3306/foodmart;
    ...
  33. Replies
    3
    Views
    3,593

    Documentacion va en el package

    Hola mauricio, que clase de problemas tienes para la documentación? Yo llevo un mes evaluando Pentaho y sobre todo Mondrian.
    Saludos,
    Francisco
  34. Check URLs and directory paths

    I have some problems too, but my database is MySQL. Mondrian package is set up to work with Tomcat so if you are using a different server you should check the directory path in all your files
    I had...
  35. It is in the installation guide

    check the installation guide:
    I did it with MySQL first with Tomcat and later with JBoss. This latr gave less trouble but the XMLA examples never worked (I am still waiting if anybody knows why)....
  36. Replies
    3
    Views
    2,751

    Tomcat should do it for you

    If you deploy you .war file in Tomcat webapp folder, when Tomcat starts should create this file for you.
    A problem could be the .war file is corrupted.
    If nothing works, try to download again.
    By...
  37. Replies
    63
    Views
    53,265

    Haz click en el enlace

    Hola carlos, yo también soy nuevo en Pentaho
    Si los ejemplos de Pentaho te han funcionado, se supone que todo va bien y deber
  38. Replies
    1
    Views
    2,270

    Tuve problemas similares

    Según entiendo, estás intentando visualizar los ejemplos desde tu base de datos. Si has seguido las instrucciones de instalación, has de cambiar tu JDBC driver en los ficheros datasources.xml y...
  39. Replies
    1
    Views
    1,823

    Mondrian cache

    hola a todos. Aún estoy en la fase de evaluación hasta despues de las vacaciones por lo menos. Hay una cosa que me preocupa.
    En la documentación se dice que Mondrian no guarda nada en disco, sino...
  40. Replies
    1
    Views
    2,287

    Buena suerte y ánimo

    Hola Tamuz, yo estoy en tu mismo caso.
    No sé a qué altura estás de tu proyecto, pero yo probar
  41. Replies
    63
    Views
    53,265

    Otro nuevo miembro

    Hola a todos. Soy nuevo en todo esto de la BI y el open source, las bases de datos y en general de la informática pero me han enconmendado este proyecto basasdo en open source que consiste en usar...
  42. Replies
    1
    Views
    946

    Mondrian by itself

    I am just wondering if Mondrian needs a database server necesarily or it can be implemented as a standalone olap server. ?
  43. Replies
    0
    Views
    1,131

    Stuck in Mondrian demo

    I've been stucked with the Mondrian's demo for a few days now, and I cannot find why.

    I have followed the instalation guide, install Tomcat 5.0 , and move the files to its destination. I am able...
  44. Replies
    2
    Views
    2,089

    Connection to data source is not valid

    I am trying to run a simple test retrieving some data from MySQL database. I created a cube with Designer and the conection was successful (es_400 ). I have the .xaction in place, but when i try to...
  45. Replies
    1
    Views
    1,523

    I just reloaded the package. It seems some files...

    I just reloaded the package. It seems some files were missing
    :)
  46. Replies
    0
    Views
    1,095

    JPivot had an error

    I installed mondrian on Tomcat, and the page displays when i run localhost:8080/mondrian. But none of the examples work except 'adhoc queries'.
    The links to Jpivot examples are giving me the same...
  47. Replies
    0
    Views
    859

    JPivot had an error

    I am running Mondrian with MySQL and Tomcat.
    When I run the test pages the only one that works is 'Basic interface for ad hoc queries' the other links give me errors.
    JPivot have almost the same...
  48. Replies
    1
    Views
    1,523

    Falied deployment on Windows XP

    Hello again. I downloaded pentaho demo on SUSE 10.0 and everything was ok.
    However, on Windows when I try to start the server, (start-pentaho.bat) the deployment fails.
    I have the directory on...
  49. Replies
    0
    Views
    728

    MySQL and Mondrian

    I have to implement Mondrian over MySQL, but after a couple of days i am unable to do it as the tutorial reads.
    I am pretty sure I have all the files in the correct place, but still It doesn't give...
  50. Replies
    1
    Views
    1,969

    where to begin?

    I just began working with Penatho on a SUSE platform
    After trying the demo, I am trying to build a solution, but i do not know where to go from there. I unzipped the design studio, but when i try...
Results 1 to 50 of 51
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.