US and Worldwide: +1 (866) 660-7555

Search Forums:

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

Search Forums: Search took 0.05 seconds.

  1. I finally used the dirty method I mentioned on...

    I finally used the dirty method I mentioned on the previous post, so I have 6 Agencies and 6 subreports

    That's not 100% clean as I wanted but anyway, it works, and if I need to add an Agency, I'll...
  2. Create a report with a dynamic number of columns and lines

    Hi everyone

    I need to create a report that will display an array.
    This array will have some columns (the number depends of a field from my request) and lines (same logic)

    I'll give an...
  3. Replies
    4
    Views
    544

    Once again, thanks a lot for these usefull and...

    Once again, thanks a lot for these usefull and fast tips
  4. Replies
    4
    Views
    544

    Wow it was a fast answer I feel so dumb I...

    Wow it was a fast answer

    I feel so dumb I tried with it but I didn't see we can reorder by just writing manually all the columns in the order we want

    Well, thanks a lot for this fast and...
  5. Replies
    4
    Views
    544

    re-order my columns in PDI

    Hi everyone

    I need to join (sorted merge) data from 2 inputs

    They have the same columns but not in the same order, so the sorted merge doesn't work.

    How can I re-order one of the 2 input to...
  6. I'm using PRD 3.9.1 the report footer is empty ...

    I'm using PRD 3.9.1
    the report footer is empty

    I just saw that this group i'm using is within another group that is useless, perhaps it comes from it
  7. Page break after group, except for the last group

    Hi everyone
    In PRD I do a page break after a group footer. It works fine but of course, add an empty page after the last group.

    How can I make the page break work for every group but the last?
    ...
  8. Replies
    2
    Views
    939

    ok thks a lot. I finally used PSW and I'll now...

    ok thks a lot.
    I finally used PSW and I'll now check a bit the file to understand the logic of it and customize it manually
  9. Replies
    2
    Views
    939

    Creating Datasource / Cube with PSW or PUC

    Hi everyone
    It's been few month that I'm working on Pentaho.
    I'm currently looking at Cube creation for analysis.

    I saw 2 ways of making cube, the first one is of course PSW that works fine for...
  10. PRD Open formula Substitute more than one character

    Hi everyone
    In one of my report I have text without space. Instead of space they have _ or -
    So i'm using the function SUBTITUTE to replace it

    =SUBSTITUTE([nom_Projet]; "_" ;" ")

    With this I...
  11. Replies
    3
    Views
    952

    Yeah my fonction was wrong, I did...

    Yeah my fonction was wrong, I did DATE_ADD(${DATEparamter},INTERVAL -7 day)

    I didn't know the DATE_SUB function, thks a lot
  12. Replies
    3
    Views
    952

    Using a PRD parameter in a MySQL function

    Hi everyone
    I have a parameter that is a date (monday of one week)
    In a subreport I want to use this parameter to have the week before, so I did

    t.date = DATEADD(day,-7,${DATEparameter})

    And...
  13. Replies
    2
    Views
    685

    thks a lot this is a good idea, i'll do it in a...

    thks a lot this is a good idea, i'll do it in a subreport so I keep my "general" data on the main report
  14. I found out the solution I select the Detail...

    I found out the solution
    I select the Detail header and in Style i put "repeat-header" to TRUE

    Now for every new page of the subreport, the header repeats itself
  15. Replies
    2
    Views
    685

    Creating a dynamic number of charts

    Hi everyone

    I need in one of my report to create a certain number of chart. The thing is I know the number of the chart to create in my SQL request.

    My example here is, I have a project...
  16. thks for the explanation I did the same...

    thks for the explanation

    I did the same subreport with banded option and I still just have my details header only on the first page of the subreport
  17. Creation sub report with report wizard + display detail header on each page

    Hi everyone
    I'm creating my first report with PRD
    I created a report with the report wizard, and I added in it, a subreport.

    So my first question is, can I create a subreport with the report...
  18. Replies
    8
    Views
    1,085

    Good idea for the disable-hop And yeah for my...

    Good idea for the disable-hop

    And yeah for my first "get rows from result" I wrote everything manually ant then I found the same solution as you, MUCH FASTER

    Thks a lot guys
  19. Replies
    8
    Views
    1,085

    ok thanks a lot i'll begin to work with job...

    ok thanks a lot i'll begin to work with job though.

    If what I saw is right, I think i'll need the "copy row to result" step to pass my data from job to job
  20. Replies
    8
    Views
    1,085

    Ok well it's the "parallelization". I understand...

    Ok well it's the "parallelization". I understand that it's a plus for performance but it is a pain in the ass when you want to do complex transformation with no parallelization.

    I think I have to...
  21. Replies
    8
    Views
    1,085

    I think the problem was coming from one of the...

    I think the problem was coming from one of the next step. When I changed this next step, my first step worked.

    I had the problem again and it prevents me from testing my output step by step. this...
  22. Replies
    8
    Views
    1,085

    Table input Preview problem

    Hi everyone

    I'm working on a transformation on the last PDI with SQL server DB

    When I double click on a "table input" step and click preview I got the result (62 lines)
    When i right click on...
  23. Well I think i'll have both SCD dimensions and...

    Well I think i'll have both SCD dimensions and normal dimension. So i can lookup / update for the SCD but the thing is, I'll need to insert some of the "normal dimensions" that are not yet in the...
  24. inserting data in many tables in one step or many

    Hi everyone
    I have a big SQL request that gives me all the data im gonna need in one of my stars.
    I'm wondering if I can put this big amount of data (that I got with "table input") in my DW with...
  25. I think that what you showed me was about the...

    I think that what you showed me was about the warning, not the fatal error

    Problem resolved by puting chmod -R 777 on the file data-integration

    New problem: spoon.sh works when I launch it as...
  26. Fatal error when launching spoon.sh on CentOS 6.4

    Hi everyone
    I'm using Centos 6.4 and the last PDI
    I installed sun/oracle JDK 1.6 cause I've heard of issues with openJDK.

    BI server works fine but when I launch spoon.sh I got a fatal error

    ...
  27. As I said I just have to put 'data cache' as...

    As I said I just have to put 'data cache' as false and It works perfectly
  28. I figured it out, in PRD I have to select master...

    I figured it out, in PRD I have to select master report -> attribute ->data cache and put it FALSE so I get the last data from my DB
  29. Data not available until I close and re-open session

    Hi everyone
    I'm new to pentaho and currently I make some test example with data I created in a MySQL database. I created some reports that use those data.
    When I launch the BI server and check a...
  30. Thread: Dashboard

    by Joris
    Replies
    1
    Views
    785

    I don't think so for what I know, you have cde...

    I don't think so

    for what I know, you have cde and cdf on server side and pdd as a client (not free) to create dashboard
  31. Go to the marketplace and install CDF and CDE. ...

    Go to the marketplace and install CDF and CDE.
    CDE (community dashboard editor) is the GUI to create dashboard in the community version
    Restart your server and then you have a CDE shortcut to...
  32. Replies
    3
    Views
    621

    ok I get it. So we can use carte if a user want...

    ok I get it.
    So we can use carte if a user want to make a big job (that is on his pc) and launch it to be run on the server (so I guess for big jobs mainly)

    Another question though. I want to...
  33. Replies
    3
    Views
    621

    install PDI on my server or use carte?

    I'm working on a project with pentaho. I'm gonna use the whole community edition solution.


    I'll have jobs and transformations that will be launch by user for some (so with PDI on their...
Results 1 to 33 of 33