Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Slawo proposed to do a longer, hands-on PDI...

    Slawo proposed to do a longer, hands-on PDI Plugin Development workshop. Short version is two hours, the complete one probably 4. I think 4 is too much for the meetup but if there's enough interest...
  2. Replies
    21
    Views
    5,721

    You can easy get rid of the deprecated messages:...

    You can easy get rid of the deprecated messages:
    for jPivot, open /pentaho/server/biserver-ee/tomcat/webapps/pentaho/jsp/pivot.jsp, search for the div with the depracatedWarning id and comment it...
  3. Replies
    20
    Views
    19,574

    The Dutch crew will be happy to host #PCM12 in...

    The Dutch crew will be happy to host #PCM12 in Amsterdam this year, and if there's a US meetup in NY I seriously consider attending ;-)
  4. I promised to demo the Antonius dashboard...

    I promised to demo the Antonius dashboard developed by Webdetails; will only take a couple of minutes
  5. Hi Gretchen, What an excellent idea! We're...

    Hi Gretchen,

    What an excellent idea! We're coming with 4 people of the Antonius Intelligence team; Antonius hospital developed its own open source MRS, and Aly Hollander would be happy to give a...
  6. Lunch

    yes, count me in!
  7. Replies
    0
    Views
    829

    Data driven colors in a chart?

    We're building reports for the ER in a hospital, and one of the key KPI's is based on triage codes. These codes are color coded, so there's Red, Orange, Yellow, Green and Blue for different levels of...
  8. Use Solution name

    Fwiw: the 'domain ID' that the PRD asks for should say 'Solution Name' and has nothing to do with the domain or model ID specified in the metadata modeler. If you use the name of the solution on the...
  9. Replies
    2
    Views
    1,398

    Same here

    I experienced the same behavior, also with 4.0GA on WinXP. Since I'm not the only one anymore it looks like a bug. Just post it in Jira.
  10. Replies
    17
    Views
    12,616

    must be Sat/Sun

    Thu/Fri is the Pentaho Partner meeting where some of us need to be as well.
  11. Replies
    17
    Views
    12,616

    Weka session/demo

    As discussed on IRC already, I'd love to do a data mining session focused at Weka & possibly Kettle/Weka integration. Could be that it's going to be a joint presentation w. someone working on DM...
  12. Replies
    34
    Views
    20,521

    Last weekend of September sounds good to me; both...

    Last weekend of September sounds good to me; both Vienna and Lisbon are fine, but since I've never been to the latter my vote goes to Lisbon.
  13. Thread: Help~!

    by jvdongen
    Replies
    2
    Views
    1,540

    Brush up your SQL...

    If the data is really as clean as you describe, you can use

    SELECT l1.bm01 as gzz, l1.bm02 as gzz_name,
    l2.bm02 as bm, l3.bm02 as fgs, l1.bm06 as gs
    FROM bm_src l1
    inner join...
  14. Replies
    6
    Views
    7,736

    Version, database?

    Hi Serge,

    are you using a pre-Microsoft version of Navision, i.e. one with the C/Side database or SQL Server? It sounds like C/Side which is indeed horrible. You probably want to make selections...
  15. Use an alias and an outer join

    if your base table contains all the combination of months and product groups you want to display, you can alias that table, otherwise you'll have to use another one. In any case, your 'left' part of...
  16. Sticky: I agree with all previous repliers; Spoon CE...

    I agree with all previous repliers; Spoon CE should remain open. Having a separate download for an Analyzer plugin would be best imho.

    best, Jos
  17. Replies
    2
    Views
    2,388

    Use PRD 3.5 with BI server 3.5

    It sounds like you're publishing to an older Pentaho installation which will not work. PRD 3.5 doesn't generate xml nor xaction since it's not needed anymore. The platform can handle .prpt files...
  18. Replies
    3
    Views
    1,289

    There's a sample report for this in this thread...

    There's a sample report for this in this thread. And after looking at it again it seems like there's indeed a bug; if you set the Ignore All Page Breaks value to False the label is shown after the...
  19. Replies
    10
    Views
    4,164

    Hi Diddy, glad you like it; nice tutorial too....

    Hi Diddy,

    glad you like it; nice tutorial too. A source citation in it would have been nice too ;-)
  20. Replies
    10
    Views
    4,164

    That shouldn't be too hard to do; adjust your...

    That shouldn't be too hard to do; adjust your parameter query so that the 'All Media' value is added, like this:

    Select 'All Media' as Media from MediaTable
    UNION
    Select Media from MediaTable
    ...
  21. Thread: Need help ,

    by jvdongen
    Replies
    1
    Views
    969

    Starting new threads for a problem that you...

    Starting new threads for a problem that you already posted and also got responses to won't speed up the process. On the contrary I would say....
  22. Replies
    14
    Views
    3,077

    I don't think you can center the group value but...

    I don't think you can center the group value but maybe I'm wrong here. Otherwise, you should post a request for this feature in Jira. As for the XML output: why do you want/need this? With the Citrus...
  23. Replies
    14
    Views
    3,077

    Ok, that's something like this then, very quick...

    Ok, that's something like this then, very quick and dirty. And thanks for the hints, couldn't have done it without them ;-) Final challenge is the vertical positioning of the group values so that...
  24. Replies
    14
    Views
    3,077

    Yes, it's totally clear to me what you want, and...

    Yes, it's totally clear to me what you want, and if you were using Business Objects this would be a piece of cake (two breaks, remove headers and center values accross break). But this is PRD and I'm...
  25. Replies
    14
    Views
    3,077

    Can you create an example in XLS form?

    I'm not sure I fully understand your requirement, but I think you want a grouping by continent & country, where each country has several cities and you don't want to repeat the continent & country...
  26. Replies
    0
    Views
    1,158

    Ubuntu & Java upgrade warning

    Dear Pentaho fans,

    I've upgraded my Ubuntu machines to Jaunty and had several issues after doing that. One of them had to do with Pentaho; authentication didn't work, and on another machine I got...
  27. Replies
    8
    Views
    3,983

    Need a way to 'inject' the 'if field value is null' transform

    The described behaviour still occurs; the 'if field value is null' is a great way of handling all possible NULL values at once, but the dimension update step still generates a first id of 0 with all...
  28. Replies
    5
    Views
    6,205

    Forgot to mention one thing: have you looked at...

    Forgot to mention one thing: have you looked at BIRT yet? That can do crosstabs, tables with filtering, multi source, multi query, etc. The BIRT engine is included in the Pentaho platform so...
  29. Replies
    5
    Views
    6,205

    Some hints

    Hi Red,

    I'll try to answer your questions pointwise, but my answers are based on the development release, not the stable version:
    1. I agree with Paul; avoid the wizard. When you rename the query...
  30. Replies
    2
    Views
    1,344

    Passing parameters to MQL query

    How do I pass a parameter to an MQL query? I've tried ${param}, {PREPARE:param} , "{param}", "${param}" but nothing works. Nothing on Jira or Forums as well.
Results 1 to 30 of 30
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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