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

Search Forums:

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

Page 1 of 40 1 2 3 4

Search Forums: Search took 0.13 seconds.

  1. Yes, you can do this in mysql by adding the...

    Yes, you can do this in mysql by adding the rewriteBatchedStatements true property to the connection.
    As the JDBC driver does this it'll depend on the database you are using.
  2. Recent changes to error handling in PDI5 trunk?

    Hi, this is probably one for devs, or those guys who keep a close eye on the PDI codebase.

    I had a problem with error handling on the user defined java expression step. The step handles 500k...
  3. great thanks. Turns out the PRD bug is fixed in...

    great thanks. Turns out the PRD bug is fixed in CI, so may be a better option to upgrade the libs instead! Good to know I have 2 options.
  4. Downgrade Pentaho reporting - Will PRD output step still work?

    Hi, due to a bug i need to downgrade PRD in PDI 5.0 back to 3.9.1. If I just downgrade the libraries will this work?

    I guess I'll try it and see! Seems unlikely that the step is using any new...
  5. Replies
    1
    Views
    171

    OK, so it works if it's a separate stream. Don't...

    OK, so it works if it's a separate stream. Don't link a hop into it otherwise you'll hang!
    And the lack of steps in the dropdown is already reported here: http://jira.pentaho.com/browse/PDI-9727
  6. Replies
    1
    Views
    171

    Output steps metrics

    Hi,

    Any hints as to how this works?

    There's no sample, I tried a few ways to make it work in current trunk build and both times:

    1) I can never get the step names to appear in the dropdown...
  7. Replies
    4
    Views
    2,636

    Formal response:...

    Formal response:
    http://jira.pentaho.com/browse/BISERVER-10529
    So yeah, go with saiku, or pivot4j
  8. Replies
    5
    Views
    558

    Errm, does...

    Errm, does http://jira.pentaho.com/browse/PDI-2565 help? This is being fixed and/or about to be comitted shortly... May be worth trying a CI build once this issue is fixed!
  9. Replies
    13
    Views
    3,669

    an individual step is not typically parallelised...

    an individual step is not typically parallelised - if it is then you have to use "partitioning" to work around these issues - essentially ensuring all the right records go to the right thread.
  10. dont use sort rows - use the blocking step to...

    dont use sort rows - use the blocking step to achieve this ( altho it still spools to disk so will still be slow )
    Question is why didnt blocking step do what you want? its definately the step to...
  11. Replies
    6
    Views
    253

    thanks, the group rows step will do it for me...

    thanks, the group rows step will do it for me with the all rows option after all - i had somehow misunderstood that step.
    I wanted to avoid splitting and merging because of the risk of a hang in...
  12. Replies
    2
    Views
    840

    with luck the session should be recorded and...

    with luck the session should be recorded and available online. Thats no excuse for those local though!
  13. Replies
    2
    Views
    840

    Pentaho London Usergroup - MongoDB

    Hi, just a quick note to promote the next Pentaho London Usergroup, which will be on 30th January at Skillsmatter. This quarter the event takes on a distinct MongoDB theme. Details can be found here:...
  14. Replies
    6
    Views
    253

    Ooh; an interesting one. A quick glance at it...

    Ooh; an interesting one. A quick glance at it however and it only passes rows once the "step" you're interested in has finished. I need this to stream through. i.e. i just want a count of 2 on the...
  15. Replies
    6
    Views
    253

    Running sum/count without aggregation

    Hi,

    Came across something today which sounds simple, but turns out I can't see a native way to do it!

    Essentially i want a running total/count, possibly I want it conditional in the future.
    ...
  16. Replies
    3
    Views
    638

    good question - see this jira - I and others on...

    good question - see this jira - I and others on the forum cannot get it to work either :(
    http://jira.pentaho.com/browse/PDI-11082
  17. Replies
    1
    Views
    762

    I'm having the same issue, so I raised this jira....

    I'm having the same issue, so I raised this jira. I hope samples can be provided to show how it should work!
    http://jira.pentaho.com/browse/PDI-11082
  18. yeah can't find any doco on those or how to use...

    yeah can't find any doco on those or how to use them??

    I found a workaround for anyone else with this issue. Do it as a CDA query, define a selector with no html element which never appears and...
  19. Replies
    7
    Views
    307

    we are EE. I tried the master build, but it...

    we are EE.


    I tried the master build, but it has no jars in the lib folder. So it seems broken. Also the download is 25mb where the 3.5 one is more like 60mb. However i found a mondrian.jar...
  20. Replies
    7
    Views
    307

    hmm ok which build on ci is 3.6 then? Or isnt...

    hmm ok which build on ci is 3.6 then? Or isnt there one? In which case where can i get the 3.6 jar?
  21. Replies
    7
    Views
    307

    oh; according to jira that fix has not been...

    oh; according to jira that fix has not been backported to 3.x mondrian :( only fixed in 4.0!
  22. Replies
    7
    Views
    307

    ahhhh ha. Many thanks, that is _exactly_ it. I'll...

    ahhhh ha. Many thanks, that is _exactly_ it. I'll download a 3.6jar and check.
  23. Replies
    7
    Views
    307

    Count distincts and agg tables

    Hi,

    I read somewhere that mondrian is very aware that count distinct's can't be aggregated if you're using agg tables.

    So; It seems to me therefore that this means if it can't find an exactly...
  24. How to get values of session variables into JS code?

    Hi,

    Been trying to do this on and off a few times recently, in various different cases. I.e. a classic one, i want to default a parameter to a value from a session variable.

    I can see you can...
  25. Replies
    0
    Views
    750

    Next Pentaho London Meetup!

    Hi, the next Pentaho London Usergroup will be on 16th Oct.

    Register below and find more details, don't miss it if you're in the area!

    http://www.meetup.com/Pentaho-London-User-Group/

    Dan
  26. Replies
    4
    Views
    1,423

    Actually I think a safer fix is to say default 0...

    Actually I think a safer fix is to say default 0 instead....
  27. Replies
    2
    Views
    242

    Are you using the dev version of CTools? If not...

    Are you using the dev version of CTools? If not then upgrade to that first, I found it fixed some pretty terminal issues.
  28. Replies
    0
    Views
    223

    Custom Parameters - Functions not Strings

    Hi,

    Custom parameters are great for defaulting initial values of parameters, e.g. setting a date parameter to today.

    However there is an issue with them. The first time you access a "custom...
  29. Replies
    8
    Views
    1,163

    I had the same problem, but "upgrading" CDE/CDF...

    I had the same problem, but "upgrading" CDE/CDF to the dev branch fixed the problem ( -b dev with ctools-installer.sh )
  30. Replies
    2
    Views
    419

    Turns out you have to use dev CDF/CDE and then it...

    Turns out you have to use dev CDF/CDE and then it works.
  31. Replies
    2
    Views
    419

    Ah, here is the full error stack. IT seems like...

    Ah, here is the full error stack. IT seems like jquery doesnt even get going:

    SCRIPT1028: Expected identifier, string or number
    scripts.js, line 6372 character 298
    SCRIPT5009: 'jQuery' is...
  32. Replies
    2
    Views
    419

    CTools dashboards not rendering in IE8

    Hi,

    I saw a post from Pedro back in December saying the dashboards should broadly work in IE8.

    However they don't even render at the moment.

    Here is the error:

    SCRIPT5007: The value of...
  33. Replies
    4
    Views
    318

    ah interesting. Hope we hear more about that at...

    ah interesting. Hope we hear more about that at #PCM13!
  34. Replies
    4
    Views
    318

    great that works thanks! That ticks off one of...

    great that works thanks!

    That ticks off one of your jiras then - about graduations in pies!
  35. Replies
    4
    Views
    318

    Faded/graduated bars?

    Hi,

    Is it possible to do faded / graduated colours on the bars in a Pentaho report chart?

    Reading online I thought I may be able to do this in a beanshell, but it doesnt make any difference:
    ...
  36. lol genius. I like it.

    lol genius. I like it.
  37. Replies
    0
    Views
    343

    Interval Measures

    Hey guys,

    Is supporting interval measures on the radar yet for Mondrian?

    Here's one of probably several Jiras that exist for it:

    http://jira.pentaho.com/browse/MONDRIAN-520

    Pretty basic...
  38. Support are asking for samples - I tried a very...

    Support are asking for samples - I tried a very simple example and annoyingly it worked, not sure why that is. PDI version perhaps.
    If you could attach your example to the jira that would rock!...
  39. excellent thanks! I've raised it here:...

    excellent thanks! I've raised it here: http://jira.pentaho.com/browse/PDI-10380
  40. XML Input bombing when getting an optional node, but not when getting a string

    Hi,

    Not sure if anyone has seen this, but we have an XML which has repeating values. So I wanted to get the XML for the whole node then loop on it in the next step.

    However; Whilst you can get...
  41. Thread: PDFA support?

    by codek
    Replies
    0
    Views
    303

    PDFA support?

    Hi,

    Are there any plans to support PDFA in reporting?

    Apparently PDFA is a version independent archive format that is supposedly guaranteed to be able to be opened even in 20 years time. (??)
    ...
  42. Replies
    8
    Views
    1,806

    I've just seen this. In my case I get "Report...

    I've just seen this. In my case I get "Report validation failed" when trying to run as streaming html, but it runs fine as pdf. I guess it must be an overlapping issue, but not sure what, there is...
  43. Can you use a formula for the query name in a subreport?

    Hi,

    I'm trying to conditionally use one query or another in a subreport. So I tried a formula on the query name of the subreport

    =IF(condition;QUERY_1;QUERY_2)

    This seems to work for query_1...
  44. Call for talks - Pentaho Community Meetup - Portugal - 2013

    Hi,

    This is a call for talks for PCM13. I created a template wiki page where we can build an agenda here:

    http://wiki.pentaho.com/display/COM/Community+Meetup+Portugal+2013

    So; If you have...
  45. Replies
    0
    Views
    631

    Pentaho London Usergroup is back!

    Hi,

    The Pentaho London Usergroup is back, our next meet is scheduled for 20th June

    Join the group and find out more here:

    http://www.meetup.com/Pentaho-London-User-Group/

    Dan
  46. Replies
    39
    Views
    7,949

    How about an editor that is a little less buggy?...

    How about an editor that is a little less buggy?

    For example, frequently it doesnt let you scroll down far enough to see the bottom line, so the workaround is to always leave white space at the...
  47. the sql syntax is fine for postgresql - the...

    the sql syntax is fine for postgresql - the problem is that for some reason cda hasnt done the parameter replacement. Never mind i found another way to write the sql.
  48. Replies
    4
    Views
    1,423

    Interesting. Sounds like a bug then of some sort...

    Interesting. Sounds like a bug then of some sort with 4.8, possibly specific to postgresql version - as I say i have 4.8 working fine locally!

    Obviously the SQL is simple, but for completness this...
  49. full error: 16:17:10,650 ERROR...

    full error:

    16:17:10,650 ERROR [CdaContentGenerator] doQuery
    pt.webdetails.cda.dataaccess.QueryException: Found an unhandled exception:
    at...
  50. Problem in CDA parameterising specific piece of SQL?

    Hi,

    I've not had any problems so far with CDA, but seem to have finally hit something I can't parameterise.

    The SQL is like so:

    >= now() - interval '${timeLag} day'

    i.e. it should end up...
Results 1 to 50 of 1984
Page 1 of 40 1 2 3 4