Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    1
    Views
    1,467

    tricky sql query in a xaction

    Hi there!!

    I have the following question in one of my xaction files to fill a combo with the available options:

    SELECT TBESPECIALIDAD.ID_GEN_SUBESPEC AS "ID_SUB", TBESPECIALIDAD.DESC_SUBESPEC...
  2. Replies
    0
    Views
    1,436

    Reports and Logs configuration issue

    Hi everyone!!! Thanks for reading my post.

    (jboss 4.2.3 + pentaho 3.0 + BIRT )

    I've developed a BI application with pentaho 3.0 using the BIRT plugin for eclipse and it is...
  3. Replies
    4
    Views
    2,833

    It works like a charm!!! Thanks :)

    It works like a charm!!! Thanks :)
  4. Why don't you use the same (or almost the same)...

    Why don't you use the same (or almost the same) query with a select count(*) for your IF statement?
  5. Replies
    1
    Views
    1,010

    Deleting system/tmp files

    Pentaho 3.0 CE on Windows.

    As far as I know, clean_repository.xaction (under /Admin options) or Clean Repository (Under Administration Console) are not deleting system/tmp files, am I right?

    If...
  6. Replies
    6
    Views
    1,392

    Just a thought. What about change...

    Just a thought.
    What about change report-definition value with javascript?
  7. Replies
    3
    Views
    3,815

    As gutlez says, you can't remove hibernate DB. ...

    As gutlez says, you can't remove hibernate DB.

    Hibernate DB is configured in hibernate.cfg.xml and applicationContext-acegi-security-hibernate.properties under system directory.

    You must...
  8. Replies
    0
    Views
    2,025

    BI Server log configuration

    I'm using Pentaho 3.0.

    I have added to default log4j.xml

    <logger name="org.pentaho.di">
    <level value="INFO"/>
    <appender-ref ref="PDIFILE"/>
    </logger>

    All the other...
  9. Replies
    2
    Views
    1,098

    You are right!! I was using...

    You are right!!

    I was using localhost/pentaho... while I write my ip in base-url parameter.
  10. Thread: Report Caching

    by jrlopez
    Replies
    7
    Views
    2,203

    If it helps, check this post (I haven't tried...

    If it helps, check this post (I haven't tried myself)

    xaction for generating reports and save them as pdf
    http://forums.pentaho.org/showthread.php?t=50008&page=2
  11. Replies
    2
    Views
    1,098

    run xaction asks for login again

    I'm using Pentaho 3.0 demo
    Some reports work fine but other like Top Ten Customer Product Line Analysis.xaction . I guess is related to parameter selection page.

    Anybody knwos why?
  12. Replies
    3
    Views
    1,461

    Thanks!! It's really what I need. :D I've just...

    Thanks!! It's really what I need. :D

    I've just need to change NavigateComponent.js to use table instead of ul-li elements.
  13. Replies
    3
    Views
    1,461

    Navigate.jsp alternatives

    I'm using Pentaho 3.0 CE

    I want to use the Navigate.jsp to display a list of available xaction for a user.

    It only works for the pentaho administrator. For other user nothing is displayed

    Is...
  14. Replies
    1
    Views
    904

    I've remembered Navigate servlet!!! Now other...

    I've remembered Navigate servlet!!!

    Now other issue appears: it seems Navigate doesn't work properly for other users than pentaho admin.
  15. Replies
    1
    Views
    904

    Display xaction list for a user

    I'm using Pentaho 3.0 CE

    I want to display a page with a list of all xaction a user has execute permit.
    Also I want to put a link to run the xaction. And it would be even better if I can show the...
  16. Replies
    0
    Views
    1,060

    solution-repository in pentaho.xml

    Using Pentaho 3.0CE + Oracle10g + JBoss 4.2.3

    pentaho.xml file has this entry:
    <solution-repository>
    <!-- Insert solution-repository -->
    <cache-size>0</cache-size>
    ...
  17. Replies
    1
    Views
    816

    A little bit of more info. Inactive sessions are...

    A little bit of more info.
    Inactive sessions are used to perform this query

    SELECT datasource0_.name name21_0_, datasource0_.maxactconn maxactconn21_0_,
    datasource0_.driverclass...
  18. Replies
    1
    Views
    816

    KettlePlugin runs out of sessions

    Using Pentaho3.0CE + JBoss 4.2.3 + Oracle10g.

    Database configuration
    1.-Quartz and Hibernate tables are in the same Oracle schema; it's defined in JBoss as <local-tx-datasource>. I've added some...
  19. Replies
    3
    Views
    1,692

    scheduling parameters - how it works

    Just to complete this post for anyone interested.

    The parameter page being displayed is the same for both normal execution and scheduling creation (Public schedules must exist).
    The parameter...
  20. Replies
    3
    Views
    1,692

    Thanks! I was really confused with this...

    Thanks! I was really confused with this feature.:)

    Just to be sure that I understand the whole process:

    1. -Create a public schedule (via Administration Console, it's the only way to create...
  21. Replies
    3
    Views
    1,692

    scheduling with parameters

    Using Pentaho 3.0CS + Oracle10g+ JBoss 4.2.3

    I can schedule a report:
    1.- creating a new private schedule with a CRON expression
    2.- using a public job

    But can we schedule a report with...
  22. Thanks. Well, right now I want to write a doc...

    Thanks.

    Well, right now I want to write a doc with main input fields/main output fields and an image for each transformation. My purpose is to have a single descriptive doc, so other people don't...
  23. HowTo Write documentation about transformations

    In any project, there's a requirement of writing documentation about transformations and jobs. So...

    1.How do you generate documentation about your transformations and jobs?
    What info do you...
  24. Replies
    0
    Views
    770

    PDI scheduing error

    Pentaho 3.0CE + Oracle10g+ JBoss4.2.3

    I create a Public schedule using /Admin options with a CRON expression as
    (0 15 12,13 * * ?). A xaction that calls a kettle job is associated to this...
  25. Replies
    2
    Views
    2,451

    THanks codek! Well, I've found that /Admin -->...

    THanks codek!

    Well, I've found that /Admin --> new Suscription creates a public schedule. At least this is what Workspace shows. However only the administrator (who has access to /Admin or...
  26. Replies
    2
    Views
    2,451

    HowTo create Public Schedule?

    Using Pentaho 3.0CE + Oracle 10g + JBoss4.2.3

    Public schedules can be created using Administration Console. Is it possible to create them using just Pentaho UI (Mantle) or /Admin page?
    ...
  27. Replies
    0
    Views
    823

    Understanding Mondrian Cache

    I have cube definition with cache="true" . If I change my DB data, changes are reflected in JPivot view without using "Refresh Mondrian Schema" button.
    So I wonder if this button is only reloading...
  28. Replies
    2
    Views
    1,123

    I think a closure table needs a dedicated table...

    I think a closure table needs a dedicated table with all parent - child relations, even parent-parent. At least, I know this way it works.

    You can find an example here...
  29. Replies
    0
    Views
    1,739

    Hibernate Managed Configuration

    My installation is: Pentaho 3.0CE + JBoss 4.2.3 + Oracle 10g

    I'm trying to figure out how to configure Hibernate in a managed environment.

    I've adapted the...
  30. Replies
    0
    Views
    999

    Workspace schedule info

    I create two different schedules for the same xaction. Workspace shows two entries in the first table with: xaction name, schedule creation date, and Delete option (button says Cancel). So, user...
  31. Replies
    1
    Views
    2,546

    I've changed

    I've changed <property name="transaction.factory_class"> to use org.hibernate.transaction.JDBCTransactionFactory instead of org.hibernate.transaction.JTATransactionFactory

    and now the error is:...
  32. Replies
    1
    Views
    2,546

    Admin page & Hibernate configuration

    I'm using Pentaho 3.0 CE + JBoss 4.2.3 + Oracle 10g
    Hibernate is configured as a managed datasource, my configuration file looks like hibernate-jboss-managed.xml with the proper changes for Oracle....
  33. Replies
    1
    Views
    1,333

    running xaction from java

    Anybody knows where to find a sample to run a xAction from java?

    Wiki has a reference to an old RuntimeTest, but no way to found in Pentaho 3.0CE

    Also how are runned startup actions, configured...
  34. Replies
    0
    Views
    1,183

    dril-through number format

    I'm using Pentaho 3.0CE.
    Drill-through tables are showing integers with a decimal format for dimensions, how can I change this? I want to display 2000 instead of 2.000,00

    JPivot table is showing...
  35. lookup/update step: why two updates for a single row?

    Pentaho pdi 3.2.0. I'm using dimension lookup/update step.
    I see 2 updates are performed when just one row has been updated. You can see this in the log. It's not a logging error, I've tested this...
  36. Are your reports running ok using localhost:8080?...

    Are your reports running ok using localhost:8080? Are report images and cubes images displayed?
    My base-url is the load-balancer url.
  37. Replies
    4
    Views
    2,945

    uhmm.. I see, bugg_tb. Anything about the...

    uhmm.. I see, bugg_tb.

    Anything about the other tables? I just need to know what these tables are ... a short description ... don't need a full explanation.
  38. Replies
    4
    Views
    2,945

    Description of Pentaho Hibernate tables

    I use Pentaho 3.0.
    I wonder where I can find a description or purpose for Hibernate tables. Some of them are obvious ,acl management for example, but no other like CPLXPARAMS or RTELEMENT.
    ...
  39. Replies
    10
    Views
    3,374

    Sorry, is this feature possible in Pentaho 3.0 or...

    Sorry, is this feature possible in Pentaho 3.0 or only for 3.5? is it possible to completely disable User Console?
  40. Replies
    2
    Views
    1,255

    ToolBar options and security

    My purpose is to show Save and Save As buttons just for those users having one fixed ROLE. I've found that toolbar is defined in main_toolbar.xul, where events are configured.

    1.- Is it possible...
  41. Replies
    3
    Views
    2,305

    I didn't tried but... If you use an xaction with...

    I didn't tried but... If you use an xaction with an already prepared MDX with some parameters like @@my_param@@ you can show a Prompt/Secure Filter component to display a form to select values. Then...
  42. Replies
    0
    Views
    855

    ACL for new analysis view

    I'm using Pentaho 3.0.

    When I save a new cube view, the xaction file has an acl with:
    - user creator All Permission
    - Role_Admin All Permission

    This acl allows the user to use Properties tab...
  43. Replies
    1
    Views
    1,044

    I guess you can redirect (using jsp code) your...

    I guess you can redirect (using jsp code) your launch.jsp (in mantle directory) to call an xaction where you show a default cube view.
  44. Replies
    1
    Views
    1,175

    Publish schema and security-acegi

    Pentaho is currently using existing users and roles from another application. Everything is working fine. Acegi related files have been configured properly.

    When I try to publish a schema from...
  45. Replies
    1
    Views
    1,145

    Well, I've found this bug 'Cannot set permissions...

    Well, I've found this bug 'Cannot set permissions on a published .xml file' http://jira.pentaho.com/browse/BISERVER-3314.

    Permissions can not be edited.
  46. Replies
    1
    Views
    1,145

    New Analysis and Roles

    New Analysis button shows different Schemas for different users, how is this managed/configured? I'm not able to found any difference between my cubes (published with user Joe) and demo cubes, which...
  47. You can get user from session in any xaction. Put...

    You can get user from session in any xaction. Put an input parameter with name ='name' in session scope and you got it.:D
  48. If jetty does not know nothing about jboss, and...

    If jetty does not know nothing about jboss, and the file oracle10g.hibernate.cfg.xml is shared between jboss and pentaho admin console (both read the file to set up hibernate session factory), why...
  49. Do you have Pentaho and a load balancer? How is...

    Do you have Pentaho and a load balancer? How is the Pentaho configuration for doing that? can you tell us, please? I'm really interested on that.

    sorry, I can't answer your question :(
  50. Well, you can redirect your launch.jsp to any...

    Well, you can redirect your launch.jsp to any xaction you choose. The xaction can take care of showing the proper report to each user.

    Maybe you can also change web.xml

    Take into account that...
Results 1 to 50 of 79
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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