Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Nicolas.Raoul; Keyword(s):

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    0
    Views
    1,704

    Typo on website

    Can't see any link to reports errors to the webmaster, so here it goes:

    "Integraton" http://www.pentaho.com/partners/oems/
  2. Replies
    6
    Views
    4,112

    Can Kettle import SPSS data?

    Hello all,

    I have data generated by SPSS (or open source equivalent PSPP).
    The extension is .sav and the file is binary, containing a header "$FL2@(#) SPSS DATA FILE".

    Can this file be read...
  3. Thanks Taqua, that was the problem! The...

    Thanks Taqua, that was the problem!
    The sub-reports were OK, but the main report was not (actually I don't use its data source).

    Thanks!
    Nicolas Raoul
  4. Replies
    3
    Views
    1,247

    Matt, Ben, thanks for your feedback! Indeed, I...

    Matt, Ben, thanks for your feedback!

    Indeed, I just tried, using the "Number of copies to start" setting allows me to get good results, so the feature I described would indeed be over-engineering....
  5. Replies
    3
    Views
    1,247

    Feature suggestion: parallelism zone

    As explained in Matt's blog, a way to make ETL faster is sometimes to duplicate steps in parallel. For instance, if you have a powerful SAN you will increase performance by duplicating the CSV input...
  6. Poll: OK, I fixed the NamingException by defining the...

    OK, I fixed the NamingException by defining the data source in pdi/simple-jndi/jdbc.properties too :-)

    So now, I am sure PDI, PRD and the BI server are configured to use the same JNDI data source....
  7. Thank you Taqua, it works! I added my data...

    Thank you Taqua, it works!
    I added my data source to pdi/simple-jndi/jdbc.properties and now it works :-)
    Very slow because no cache is used, but that's a different problem!
    Thanks again!
    Nicolas...
  8. Strange warning message: None of the data-factories was able to handle this query

    My report (containing many subreports) makes this warning appear:


    Deprecated behavior: None of the data-factories was able to handle this query. Returning empty tablemodel instead of failing...
  9. Poll: Using the Administration Console only, I was...

    Using the Administration Console only, I was getting a NamingException. So, as I was told here, I specified the same data source via both simple-jndi and the Administration Console.

    Same result:...
  10. Thank you!

    Thanks for your help!
    So I specified the same data source via both simple-jndi and the administration console.
    Now the report runs successfully from PRD.

    That's probably another problem, but...
  11. NamingException despite same JNDI name as defined in Administration Console

    Hello all,

    I can't seem to be able to use JNDI connections. Here is how I do:


    In the Administration Console, I create a "bjs" database connection and test it, it works.
    In Report Designer,...
  12. Poll: Empty reports with JNDI data connection

    Hello all!

    I modified my report to use a JNDI data source.
    Problem: generated reports are all empty files (file size is zero).

    Even though they are generated correctly when I use the PRD GUI....
  13. Hi indiefan23! Could you explain in detail which...

    Hi indiefan23!
    Could you explain in detail which JAR you had to put where in order to get it work?

    I didn't touch any JAR yet on my biserver-ce-3.7.0.RC1 so I just have those two ones:


    ...
  14. Replies
    7
    Views
    5,148

    My workaround works for File Output, but it does...

    My workaround works for File Output, but it does not work for Table Output, which is actually my goal :-/
    Error: There was a data type error: the data type of java.lang.Integer object [1] does not...
  15. OK, I will use "Valid in the current job". Also,...

    OK, I will use "Valid in the current job". Also, I will just place the transformations sequentially (there are more than 2 actually).
    Thank you very much!
    Nicolas Raoul
  16. Replies
    7
    Views
    5,148

    Sorry, I should have mentioned it. It is here:...

    Sorry, I should have mentioned it. It is here:
    http://jira.pentaho.org:8080/browse/PDI-4946
  17. Job launching same transformation with different parameters?

    I wrote this job, which calls a transformation with COUNTRY=FR and also with COUNTRY=PT. It is actually the same transformation, but called with different COUNTRY parameters.
    6474

    In the "Set...
  18. Replies
    7
    Views
    5,148

    I have found a workaround. Warning: it is quite...

    I have found a workaround.
    Warning: it is quite a painful workaround in terms of maintainability.

    1) Between the Mondrian Input and the File text output, insert sequentially a "Select values"...
  19. Howto: Using the Aggregate Designer with Infobright

    Hello all,
    I met a lot of difficulties using the Aggregation Designer with Infobright, so I wrote this howto explaining the solution I finally came up with.
    Hope this helps someone!
    Nicolas Raoul
  20. I have found a workaround: Export the schema, and...

    I have found a workaround: Export the schema, and then publish it using the Schema Workbench. That works (published schema tested with JPivot)
  21. Aggregation Designer: NullPointerException when I click "Publish"

    Hello all!

    I am trying to publish my aggregation schema to my BI server, but always get a NullPointerException. Here is what I do:
    1) Start BI Server
    2) Open Aggregation Designer
    3) Open my...
  22. Replies
    1
    Views
    805

    Hi pawansavani! The image is too small, I can't...

    Hi pawansavani!
    The image is too small, I can't read.
    Could you please copy-paste the error as text?
    Nicolas Raoul
  23. Actually, Infobright does not really like INSERT...

    Actually, Infobright does not really like INSERT statements.
    I guess the best would be if PAD generated a LOAD statement instead.
  24. Aggregation Designer DML error: Table storage engine doesn't have this option

    I am new to Aggregation Designer and may be missing something obvious.
    I created a new aggregation, executed the DDL, and when I execute the DML I get this error:


    StatementCallback;...
  25. Replies
    1
    Views
    3,222

    I ended up reinstalling with the newest version...

    I ended up reinstalling with the newest version and now it works fine.
    biserver-ce-3.7.0.RC1
  26. Replies
    1
    Views
    3,222

    Error 505 when publishing schema

    When I try to publish my schema from Schema Workbench, I successfully log into the repository, then I am presented with the usual "Publish Schema" dialog:


    Schema Name: XYZ Schema 5
    Schema...
  27. Poll: Modifying this plugin

    Building this plugin from source is very easy, because all libraries are included:


    svn checkout svn://source.pentaho.org/svnkettleroot/plugins/ReportingPlugin/trunk/

    ant zipThe most...
  28. Replies
    7
    Views
    5,148

    Baffling data type error

    Hello all!

    I want the result of an MDX query to be written to a text file, so I wrote this 6449 :

    6448

    Unfortunately I get this error:
    [Measures].[rank] Integer : There was a data type...
  29. Poll: Thanks Taqua for this information! (I am...

    Thanks Taqua for this information!
    (I am actually using JDBC everywhere, I have not tried with JNDI)
  30. Poll: Could it be the case that if this step generates...

    Could it be the case that if this step generates 1000 reports, it opens and closes the Mondrian connection 1000 times?
    That would explain why Mondrian does not cache.
    If it could open the...
  31. Mondrian not caching results when used from PRT

    As a test, I had PDI generate the same report 1000 times.
    The report just shows a single value, computed by a complex MDX query.
    The first report took 10 seconds to generate, which is OK.
    ...
  32. Hi Jeff! Thanks for your fast reply. Your...

    Hi Jeff!

    Thanks for your fast reply.
    Your link opens a page that says "You are not authorized to view this forum", even though I am logged in as user Nicolas Raoul over there.
  33. Poll: As a test for this step, I had PDI generate the...

    As a test for this step, I had PDI generate the same report 1000 times.
    The report just shows a single value, computed by a complex MDX query.
    The first report took 10 seconds to generate, which is...
  34. Infobright loader replaces UTF-8 with question marks

    Hello all,

    When I load data using the command line the UTF-8 characters appear correctly:

    mysql> LOAD DATA INFILE '/home/nico/sales.csv' INTO TABLE sales;But when I use Pentaho's "Infobright...
  35. Poll: Hi chenkeongyap! Stupid question but your...

    Hi chenkeongyap!

    Stupid question but your report works fine in PRD, right?
    Could you please post your .ktr file so that I can have a look?
    I have no idea about the saving problem though.
    ...
  36. Poll: I just wrote how to use this step to...

    I just wrote how to use this step to automatically send reports to a data warehouse's shops.
    Not a major piece of literature, but well, feedback is welcome :-)
    Hope this can help someone,
    Nicolas...
  37. Poll: That is a feature I really needed, thanks so...

    That is a feature I really needed, thanks so much!
    I just tested it, it works well with PDF, but when generating an HTML report I can't see the charts. I assumed they would be generated as image...
  38. Report parameter: ReportDataFactoryException

    Hello all!

    My report's MDX query uses an "area" parameter:

    Parameter("area",[Area],[Area].[沖縄])When I run with area=北海道, I get an exception:

    ReportDataFactoryException: No member matches...
  39. Solution: I reformulated my MDX query to output...

    Solution:
    I reformulated my MDX query to output two cells: shop_sales and total_sales
    Then I divide using an Open Formula.
    Hope this helps someone,
    Nicolas Raoul
  40. How to divide the (numerical) result of two queries?

    In PRD, I need to show the share (shop sales divided by total sales) so I thought I would:

    1) Calculate shop_sales in subReport1
    2) Calculate total_sales in subReport2
    3) Define them as export...
  41. Thank you Taqua and anupjoshi7! I am using...

    Thank you Taqua and anupjoshi7!
    I am using Pentaho Report Designer to define a report and publish it.
    Now using this query:

    select age,city from sales where gender=${GENDER} limit 10;But same...
  42. Report allowing a user parameter: Parameter not asked for

    I want to create a report allowing a user parameter, as described at the bottom of this page:
    http://wiki.pentaho.com/display/Reporting/8.+Publishing+a+Report

    So I created a report with a GENDER...
  43. UTF-8 corrupted in pivot (even though Infobright contains correct UTF-8 characters)

    My Infobright database contains UTF-8 characters, they show fine when running queries from the SQL command line.

    But when I use it from Pentaho EE' User Console's pivot tool, it shows corrupted...
  44. ConnectionException using Infobright Loader

    In Spoon, I have an Infobright Loader step using the following database connection:

    6136

    When I launch the transformation, I get:


    An error occurred, processing will be stopped:
    Error...
  45. Infobright Loader step: No "New..." button

    I installed Infobright CE on my Ubuntu.
    In Spoon, I created an "Infobright Loader" step.

    Problem:
    In the "Infobright Loader" step's configuration dialog, near the "database connection" field...
  46. Error "One or more system listeners failed" when starting BI server

    Yesterday I installed Pentaho Enterprise, and it automatically launched everything, I used the User Console without problems.

    But after a reboot, I launched "start-pentaho.sh", and I can't use the...
  47. Is the iPhone extension usable with Pentaho 3.6?

    Is the iPhone extension usable with Pentaho 3.6?
    The doc only says 3.0

    I installed it on 3.6 but get an error 500 with "Only a type can be imported" and "iphone/Login.jsp ... LocaleHelper cannot...
  48. Thanks Taqua it works! :-)

    Thanks Taqua it works! :-)
  49. Also, in Format→Advanced Font Settings, I checked...

    Also, in Format→Advanced Font Settings, I checked "Embed Fonts" and set "Encoding" to "UTF-8 (8 Bit UCS Transformation Format)".
    But still no luck.
  50. Thanks! So: In...

    Thanks!
    So:


    In File→Configuration→output-pageable-pdf I set "~.Encoding" from "Cp1252" to "UTF-8".
    I switched the chart's font (by selecting it with the mouse and using the drop-down list...
Results 1 to 50 of 61
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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