Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. SQL Having Clause in Metadata Based Query

    I have a fact_purchases table and a dim_customer table in a star schema. I want to build a pentaho report that takes a start and end date as a parameter and then returns all customers who purchased...
  2. Replies
    0
    Views
    521

    Calculator Locale

    I'm trying to use the Calculator's "Week of year of date A" function to figure out the number of the week for a particular date (i.e. - January 1 is week 1 and Dec 31 is usually week 52). The problem...
  3. Replies
    0
    Views
    1,048

    MaxOpenPreparedStatements

    When configuring the jdbc data source, on the conection pooling tab, one of the options is for the MaxOpenPreparedStatements. I currently have it set to a value of 20. My pentaho server is still just...
  4. Replies
    1
    Views
    544

    I actually figured it out. The parameter involved...

    I actually figured it out. The parameter involved querying a table which my bi-server user did not have access to via the metadata security (although it would have been nicer if the error message was...
  5. Replies
    1
    Views
    544

    Report Designer Parameter

    I have a report with a single parameter. When I run the report from my local pentaho report designer, it prompts for the parameter and runs the query with the provided parameter. When I publish the...
  6. Replies
    6
    Views
    1,722

    Yes, I'm stuck on version 4.3 of pdi. I did...

    Yes, I'm stuck on version 4.3 of pdi. I did search jira to try to see if this was fixed (to see if I could think of a workaround for it).
  7. Replies
    6
    Views
    1,722

    PDI Crashes while running large job

    I have a large nested job which calls other jobs and sometimes when I run it in PDI, the entire PDI interfaces crashes and closes. When looking through the logs, the stacktraces says:


    ERROR...
  8. From the main sourceforge page, try clicking...

    From the main sourceforge page, try clicking 'Files' which takes you to:

    http://sourceforge.net/projects/pentaho/files/?source=navbar

    From that page, you can choose the 'Business Intelligence...
  9. Replies
    1
    Views
    1,325

    In the stacktrace that you posted it says: ...

    In the stacktrace that you posted it says:



    This means that pentaho is not using your jdk 1.8 setup, but your java classpath is pointing to a java 4 or older JDK. You should update your java...
  10. Replies
    1
    Views
    1,152

    Closure Generator with Cycles

    I'm trying to use the Pentaho Closure Generator to model a supervisor-subordinate relationship (see http://wiki.pentaho.com/display/EAI/Closure+Generator). When I use the step, I get the following...
  11. Replies
    0
    Views
    1,367

    BI-Server Database Tables

    I'm running pentaho bi-server 4.5 and it is throwing the following error in its console:


    Table 'mydb.cdf_storage' doesn't exist

    I'm looking for a listing of all the tables needed for the...
  12. Report Designer Function Referencing another Function

    I have a report with rows which look like this:

    Customer, Number Ordered, Number Received, Number Returned
    Bob, 3, 1, 0
    Susie, 8, 7, 3

    At the bottom of the report, I have a summary row with...
  13. Replies
    1
    Views
    2,160

    In your screenshot, change from the 'Style' tab...

    In your screenshot, change from the 'Style' tab to the 'Attributes' tab with the 'Details Header' selected (instead of the label). Then, change 'hide-on-canvas' in the common section from false to...
  14. Replies
    1
    Views
    1,137

    I came across a nice tutorial that gives an...

    I came across a nice tutorial that gives an example of a cascading parameter in pentaho which sounds similar to what you are trying to do:
    ...
  15. Replies
    2
    Views
    1,862

    Here is a link to a sample xaction XML document...

    Here is a link to a sample xaction XML document from the pentaho documentation:

    http://wiki.pentaho.com/display/ServerDoc2x/1+-+Example+Action+Sequence+XML

    I would also suggest that you might...
  16. I'm not sure if Pentaho can restrict by IP...

    I'm not sure if Pentaho can restrict by IP address, but your web server can definitely restrict access by IP address.

    Here is a link to directions for tomcat:
    ...
  17. Replies
    0
    Views
    1,007

    HTTP 400 from ServiceAction Call

    I have a client application which makes a call to the pentaho ServiceAction servlet. When my request starts to get long, it gets back the following exception:


    java.io.IOException: Server...
  18. Replies
    0
    Views
    770

    IAuditEntry Logging Location

    I'm trying to debug a stacktrace on my local pentaho bi-server and I've been reading about the IAuditEntry logging interface. From what I've read, it sounds like the community edition logs the audit...
  19. If you just want to see the source code for that...

    If you just want to see the source code for that class, it is available here:
    ...
  20. Maximum Number of Columns in Adhoc Report

    I have an adhoc report where we would like to include more than 100 columns and export it as Excel/CSV for analysis. However, whenever I add more than 100 columns, the report's resultset suddenly...
  21. Replies
    0
    Views
    981

    Restrict Column to Specific Role

    In my database table, I have one column which contains sensitive data that should be restricted to a specific role. In the pentaho documentation, they describe how to restrict a column by adding a...
  22. Replies
    0
    Views
    977

    Publishing Large Metadata

    My metadata model is greater than 10 MB and I encounter this error message when I try to publish:


    ERROR [GetContent] an exception occurred...
  23. Thanks for the reply. I've attached two sample...

    Thanks for the reply. I've attached two sample files (sample_parent.ktr and sample_sub_transform.ktr).

    In my attached example, I would like column 'Third' to be available after calling the...
  24. SubTransforms with Varying Number of Stream Fields

    Suppose that I have 3 kettle transforms - process_main_table, process_backup_table, and common_sub_transform logic.

    In the process_main_table transform, I have a stream with 8 values.
    In the...
  25. Multiple Star Schemas in Same Business Model

    I have two different fact tables with their corresponding dimensions.

    Is it possible to put them in the same business model?

    If I put both fact tables in the same business model and connect all...
  26. I spent some more time researching this and it...

    I spent some more time researching this and it was a problem specific to my environment. My SSL certificate was mis-configured and causing the problem. Fixing the SSL certificate fixed this issue.
    ...
  27. Multiple BIRT Reports in Adhoc Web-Based Reporting Tool

    I'm using the BIRT pentaho plugin described here:

    http://b-e-o.blogspot.com/2011/08/running-fully-functional-eclipse-birt.html

    The plugin works great when I run just one BIRT report. However,...
  28. Replies
    3
    Views
    5,483

    I actually had a similar question a few months...

    I actually had a similar question a few months ago. There is another thread that has some good ideas about how to get the username:

    ...
  29. Replies
    1
    Views
    897

    SQL Group By

    I have a report which I am designing in the pentaho ad-hoc web based reporting tool.


    The report has several fields and is set to group on the region (in level 1). No other groupings are defined...
  30. Replies
    5
    Views
    4,359

    You might actually have better luck posting about...

    You might actually have better luck posting about this in a BIRT specific forum. Once you figure out how to do it in BIRT, it should also work in pentaho once you get it working in BIRT. Two good...
  31. Replies
    2
    Views
    2,584

    Thanks for the info. When I searched google on...

    Thanks for the info. When I searched google on this issue, I didn't see an automated publish method either, but I wanted to make sure.
  32. Determine Currently Logged in Pentaho User from BIRT Report

    I have a BIRT report that I'm planning to run from inside the Pentaho bi-server. I currently have BIRT prompt for the user's username and password as a BIRT parameter. BIRT then uses those...
  33. Replies
    2
    Views
    2,584

    Publish BIRT .rptdesign Files

    I've used the BIRT pentaho metadata plugin to create some reports that I would like to publish to my Pentaho BI-Server. However, I don't see an option inside of the BIRT Report Designer to "Publish"...
Results 1 to 33 of 33
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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