Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 4 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Replies
    2
    Views
    952

    When configured properly, the use of aggregates...

    When configured properly, the use of aggregates will be used whenever possible. Spend some time reviewing the documentation:
    ...
  2. Replies
    2
    Views
    1,079

    The performance issues was due to the Olap4J...

    The performance issues was due to the Olap4J library, here are links to the issues:

    http://sourceforge.net/p/olap4j/discussion/577988/thread/161c048e/ (forum thread with issue identified)...
  3. Replies
    2
    Views
    1,079

    Performance issue with Mondrian / Olap4J.

    I am experiencing a performance issue with Mondrian / Olap4J. The dataset is small, the tables are an optimized star schema. Database query has a very low cost, and according to the MDX logs the...
  4. Replies
    8
    Views
    11,082

    Refresh Oracle Materialized View

    As previously mentioned, just create a simple Oracle function (see example below) and call it from your PDI transformation using the Call DB Procedure step.

    create or replace PROCEDURE...
  5. Thread: Hive Issue

    by clavigne
    Replies
    0
    Views
    648

    Hive Issue - JDBC Connection Problems

    Edited to reflect the solution:

    I am running PDI 5.2 GA and the Cloudera Quickstart VM 4.7 running on VirtualBox. Despite my best efforts, I can not create a JDBC connection to Hive (hive2...
  6. Replies
    4
    Views
    1,432

    Sorry, meant to circle back on this thread. I...

    Sorry, meant to circle back on this thread. I used a case statement to pass a null when the date value from the source system was 0000-00-00 00:00.
  7. Replies
    4
    Views
    1,432

    Works in Spoon, not Kitchen - pdi-ce-4.2.1

    I'm seeing an odd transformation error, only when I run using Kitchen . There is no problem when I'm running via Spoon. Here is the error from the log (STAGE_SERVICE_CATEGORY is the table input...
  8. Pentaho BI and/or Pentaho PDI Resource(s) Needed

    I need a consultant experienced with Pentaho BI and/or Pentaho PDI (preferably both) for a long-term contract. Much of the work can be done from home, with occasional on-site work at client sites in...
  9. Replies
    0
    Views
    680

    Pentaho BI & Pentaho PDI Resource Needed

    I need a consultant experienced with Pentaho BI and/or Pentaho PDI (preferably both) for a long-term contract. Much of the work can be done from home, with occasional on-site work at client sites in...
  10. Pentaho Contractor Needed - Sacramento, California Area

    I'm looking for an contract resource with PDI, Reporting, and Analysis experience for a long term contract (1 - 2 years). Contractor must be eligible to work in the US (no sponsorship), and able to...
  11. Pentaho Contractor Needed - Sacramento, California Area

    I'm looking for an contract resource with PDI, Reporting, and Analysis experience for a long term contract (1 - 2 years). Contractor must be eligible to work in the US (no sponsorship), and able to...
  12. Pentaho Contractor Needed - Sacramento, California Area

    I'm looking for an contract resource with PDI, Reporting, and Analysis experience for a long term contract (1 - 2 years). Contractor must be eligible to work in the US (no sponsorship), and able to...
  13. Get_Mondrian_Role.xaction

    Here is mine: 6225

    Regards,

    Chris
    BreadboardBI.com
  14. Replies
    3
    Views
    2,919

    Mystery Solved

    This was unrelated to Kettle, the problem was missing data in an admin table.
  15. Replies
    3
    Views
    2,919

    Variable Substitution Mystery

    I have a job that utilizes a transformation that reads rows from a table and copies the "rows to result". A subsequent nested job is run once for every row returned in the previous transformation. ...
  16. Replies
    0
    Views
    1,043

    Expose Job as a Web Service

    Does EE provide the ability to expose a job as a web service? What would be the best way to go about tackling this?

    Thanks,

    Chris
  17. I also see this error behavior on IE 7.0.5730.13...

    I also see this error behavior on IE 7.0.5730.13 using Pentaho 3.5.1.RC1.39705 (EE).
  18. It looks like your Get_Mondrian_Role.xaction...

    It looks like your Get_Mondrian_Role.xaction retrieves the roles from a SQLLookupRule, then attempts to hand over the resultset as a string. This is not possible. You need to add an action to...
  19. Replies
    1
    Views
    1,718

    Oracle and Role Based Constraints

    The problem was caused by one of my role-based constraints. Don't use TRUE() in the constraint formula with Oracle as the DBMS, use instead 1 = 1.
  20. "error resource not found" when accessing report files

    I'm running 3.5.1 EE over XP, Oracle 10g as the repository database. When clicking on Pentaho Report or Pentaho Analyzer files from the user console, an error message is raised "error resource not...
  21. Replies
    1
    Views
    1,718

    Change Underlying DBMS Possible?

    I have a model orignally built over MySQL tables, but I would like change it to run over Oracle tables. I tried changing the connection details in Metadata Editor and republishing the xmi fiile to...
  22. Replies
    1
    Views
    1,072

    Connection Type as Parameter

    I would like to pass the connection type (e.g., MySQL, Oracle) as a parameter to a JNDI connection. Is this possible?

    Thanks,

    Chris
  23. It seems to have been the query used to populate...

    It seems to have been the query used to populate the Date Picker. Everything works now. 1.5 days wasted :-(

    Thanks for your help.
  24. For the "date" parameter: SELECT ...

    For the "date" parameter:

    SELECT
    DIM_TIME.DATE
    FROM
    DIM_TIME

    And for the report content:

    SELECT <columns>
  25. my bad, 3.5.1-RC1. needed the new OLAP analyzer.

    my bad, 3.5.1-RC1. needed the new OLAP analyzer.
  26. Yes. I tried both MySQL date and datetime...

    Yes. I tried both MySQL date and datetime datatypes for the date column. On the parameter tried date and object value types. mandatory and non-mandatory. never tried a default value. pentaho...
  27. no, it is a new report. the problem seems to be...

    no, it is a new report. the problem seems to be date handling in the parameters, at least with mysql. my ugly workaround is to convert the values to strings, but now i can't use the date picker. ...
  28. thanks. sadly, none of these solved my problem. ...

    thanks. sadly, none of these solved my problem. i've opened a case in the customer portal. this sort of thing should not be happening with EE.
  29. Issue

    Could you elaborate on your parameter issue? I am encountering the same problem. Multi-page Report renders fine in PRD 3.5 - will not render on the server after two prompts are selected.

    This...
  30. date picker

    Thanks, Vaibhav. I don't know why, but now everything is now working fine in the PRD. However, it fails on the server due to...
  31. Date Picker and MySQL

    Has anyone managed to make this work for MySQL? If so, could you please provide a sample? Using >= or <= as work-arouund won't cut it for me. I need to use = only.
  32. Replies
    11
    Views
    6,849

    Using IN

    Back to the original question, is there an equivalent of using IN when multiple values are expected?
  33. Replies
    7
    Views
    3,868

    Try making the domain name the same as your...

    Try making the domain name the same as your solution folder name. Also, make sure that you don't use any forward or backslashes in your domain id. These work ok in the report designer, but cause an...
  34. Leeds

    Isn't there a way to move Leeds closer to London :-) I sometimes do get work that can, in part, be done remotely.
  35. Still Looking for One More Person

    We are still looking for one additional person. Please contact jobs@breadboardbi.com if you are interested.
  36. Seeking Open Source Business Intelligence Consultant Based in UK

    Breadboard BI (breadboardbi.com), a leading U.S. open source business intelligence consultancy, is seeking an experienced, UK-based, business intelligence consultant to help us grow our UK practice. ...
  37. Mondrian Internationalizaton & Pentaho 3.x

    It is my understanding that changes in Mondrian 3.1 have modified the way internationalization works on the BI server. Formerly, it was pretty straightforward to set the...
  38. Replies
    9
    Views
    3,404

    jacksoar

    you think it is a coincidence that "jacksoar" and windward are both from boulder, colorado ;-)

    he has been at this before, elsewhere - http://forums.techsoup.org/cs/forums/p/28384/99465.aspx#99465
  39. Pentaho Server 2.0 CE and Mondrian Internationalization

    When an existing xaction is referenced, I'm find that internationalization works fine. However, this is not working when a new analysis view is created on the server. In this case I see only...
  40. Thread: Amazon S3

    by clavigne
    Replies
    7
    Views
    9,554

    S3

    Great, I'll be at the MySQL UC this year - speaking on the last day - http://en.oreilly.com/mysql2009/public/schedule/detail/5593
  41. Thread: Amazon S3

    by clavigne
    Replies
    7
    Views
    9,554

    S3

    Hi Matt,

    I was also looking at using something like Jungle Disk ($20) - http://www.jungledisk.com/index.aspx. Then I could mount the S3 to the PDI server. JungleDisk would handle file transfer...
  42. Thread: Amazon S3

    by clavigne
    Replies
    7
    Views
    9,554

    Amazon S3

    Hi Matt,

    In this case, I'm taking about files. Thanks for the links, I'll take a look. I was thinking about an S3 writer. Then I could create a PDI job to extract data from source systems,...
  43. Thread: Amazon S3

    by clavigne
    Replies
    7
    Views
    9,554

    Amazon S3

    Hello. Does anyone have exprience using Kettle to push data to Amazon S3? I'm interested in learning about approaches others may have used.

    Thanks,

    Chris
  44. Replies
    5
    Views
    1,462

    Calculator or Modified JavaScript Values

    Either the Calculator or Modified JavaScript Values steps should work.

    Chris
    BreadboardBI.com
  45. These are reports embedded in .jsp dashboards...

    These are reports embedded in .jsp dashboards that have worked without problems with the last several versions of Pentaho server. Now all include the text...
  46. 1.7.2 GA - Reports Embedded in .jsp Dashboards

    While upgrading to server 1.7.1, I've noticed a problem with all .jsp dashboards that have embedded reports. The data seems fine, but at the tail of each report I see the error: ...
  47. Replies
    3
    Views
    1,288

    RE: Best Practice For Updates Without A Select?

    I don't know a way around the select, but do you have an index on the key column(s) used to lookup the values? Performance will vastly improve with this index.

    Chris
    Breadboard BI...
  48. Replies
    8
    Views
    3,647

    Estimates

    Your numbers look good based on what you've provided. To underline crafter's point, involve users at every stage of your project. You don't want to burn through your project hours, then present...
  49. SVG Image & Drawable Field

    A hint on how to do this with Report Designer 1.6 would be very appreciated. I included a drawable field in my report footer, created a column in my dataset that maintains the URL to the SVG image,...
  50. Replies
    1
    Views
    3,282

    Decimals in Bar Chart Value Axis

    I'm using Report Designer 1.6 to create bar charts against a MySQL 5.1 database. One of the bar charts adds decimals to the value axis (see image attached). Only one of the many charts does this,...
Results 1 to 50 of 168
Page 1 of 4 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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