Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 5 1 2 3 4

Search Forums: Search took 0.02 seconds.

  1. Replies
    1
    Views
    1,181

    You might be able to do some thing with the...

    You might be able to do some thing with the javascript step and calling Java code to get access to the itext libs which make it pretty simple to join PDFs together.

    Not sure if there is a better...
  2. Inputs for reports with more complex validations...

    Inputs for reports with more complex validations
    Creating parameter dependent MDX for analysis queries with Jpivot
    I think we still have one of those old style cross tab reports kicking around some...
  3. The problem your having is that you can only use...

    The problem your having is that you can only use parameters in the where section of your query. To use parameters in other parts you will need to use an advanced jdbc query. This is a limitation of...
  4. Yes look at the bursting examples good luck ...

    Yes look at the bursting examples

    good luck

    Wil
  5. Replies
    1
    Views
    905

    Create an input to your xaction called user of...

    Create an input to your xaction called user of type string set the source to be session.

    Or you could have searched the wiki...
  6. Thread: HUdson site

    by wselwood
    Replies
    2
    Views
    4,752

    If you want the pat one it is now at...

    If you want the pat one it is now at http://ci.analytical-labs.com/
    If your after the pentaho ci system its in http://ci.pentaho.org/

    Good luck

    Wil
  7. A calculated measure wizard is some thing that...

    A calculated measure wizard is some thing that they have been talking about but at the moment they are working on a big push to get every thing that's there stable and working to get version 1 out...
  8. Replies
    1
    Views
    993

    Unfortunately I don't think its possible at the...

    Unfortunately I don't think its possible at the moment. This thread from the end of last year seems to suggest its some thing they want to build but haven't had the time yet. Well its saying about...
  9. What version of the reporting engine are you...

    What version of the reporting engine are you using? I have just tried a simple test and it seems to work ok.

    Created a multi page report, enabled the watermark section, created the page function,...
  10. Replies
    3
    Views
    2,312

    You need to use the function Parameter("Param...

    You need to use the function Parameter("Param Name", [Dimension Name], [Default].[Dimension].[Value])

    Check this out for more information:...
  11. Quotes, some thing like ["[time].[year]"] should...

    Quotes, some thing like ["[time].[year]"] should do the trick.

    Good luck

    Wil
  12. Brackets don't match up if that's an exact copy...

    Brackets don't match up if that's an exact copy and paste, you need another one after the end of the VALUE function to close the ISODD function

    Also don't think you need the VALUE() function, but...
  13. Replies
    0
    Views
    688

    Append-body on subreports and bands

    Hi Guys

    Has any one managed to get html:append-body to work with sub reports or bands? I have tried all kinds of html and nothing seems to end up in the resulting web page. I have got the...
  14. Replies
    4
    Views
    2,141

    Ah yes, swift update and set the encoding-quality...

    Ah yes, swift update and set the encoding-quality to 1 and the chart image comes down to 248Kb from 12Mb and I cant see any difference in the images. Even gimp compressing the big image only got to...
  15. Replies
    4
    Views
    2,141

    Really big charts format question

    I have a bit of an odd requirement, a customer wants a chart showing the number of events each hour for the last month. So about 720 (Ends up being about 703 as some hours have no events) entries in...
  16. Replies
    6
    Views
    1,683

    Play with the capitalisation. Look in the samples...

    Play with the capitalisation. Look in the samples for examples of the javascript step using java classes. Or if that fails try Google.

    Good luck

    Wil
  17. Replies
    6
    Views
    1,683

    Try the full path Java.lang.System.out.println...

    Try the full path Java.lang.System.out.println then

    Good luck

    Wil
  18. Replies
    6
    Views
    1,683

    You could try using the javascript step and the...

    You could try using the javascript step and the System.out.println trick to write to the log.

    Good luck

    Wil
  19. Replies
    11
    Views
    3,523

    http://www.prashantraju.com/2010/03/customising-th...

    http://www.prashantraju.com/2010/03/customising-the-pentaho-user-console-part-3/
  20. Sounds like you could almost do this with a...

    Sounds like you could almost do this with a normal chart. Apart from the fact I have never found a way to get rid of the axis lines which makes the normal charts look a bit pants if you make them...
  21. Replies
    3
    Views
    1,281

    For Q1 I think you need to use the advanced...

    For Q1 I think you need to use the advanced version of the jdbc query, which lets you use a formula to define the sql to be run.

    For Q2 Add a column to your sql with some thing like:


    case...
  22. Replies
    5
    Views
    3,798

    Have you tried =NOT(ISNA([field])) ? Good luck...

    Have you tried =NOT(ISNA([field])) ?

    Good luck

    Wil
  23. Replies
    2
    Views
    3,275

    You might want to look at the functions Left...

    You might want to look at the functions Left Right and Mid

    Good luck

    Wil
  24. Replies
    13
    Views
    14,958

    The great bug hunt 2.0

    So with Tom and Paul fighting to get PAT to 1.0 we need all the help testing we can get. In an effort to nail down all the bugs in the basic stuff we need as many people as possible to test the...
  25. Replies
    1
    Views
    874

    Nope....

    Nope. http://forums.pentaho.org/showthread.php?t=76492

    Good luck

    Wil
  26. Replies
    13
    Views
    3,749

    If you have done the cross tab the old way this...

    If you have done the cross tab the old way this might be of help: http://forums.pentaho.org/showthread.php?t=64279

    Good luck

    Wil
  27. Replies
    6
    Views
    1,335

    The following should work with the old xml report...

    The following should work with the old xml report types, however the new (.prpt) ones it most likely won't, you will probably be better off just creating two reports.

    While the thing passed into...
  28. Put the data in the details sections of the sub...

    Put the data in the details sections of the sub reports like you had before. Then put the sub reports them selves into the header or footer of your master report.

    The details band gets displayed...
  29. Replies
    10
    Views
    3,243

    Hi Samatar Interesting idea. Just tried it....

    Hi Samatar

    Interesting idea. Just tried it. That causes me to get a different error message: "Error putting files to remote Host : Publickey authentication failed." when I use the key with a...
  30. Replies
    10
    Views
    3,243

    Right after a quick dig into the SSH2 put step...

    Right after a quick dig into the SSH2 put step code I think I have found the problem. I need to be able to send both a public key and a password to authenticate with. However in the code there is an...
  31. Replies
    2
    Views
    5,824

    In the calculator step there is a calculation...

    In the calculator step there is a calculation called "Date A + B days" does what you want if you put a -1 in B

    Good luck

    Wil
  32. Replies
    10
    Views
    3,243

    Thanks gutlez but I don't think it is. When I use...

    Thanks gutlez but I don't think it is. When I use it the test connection button always seems to work. but the check folder button and actually running the step don't
  33. Replies
    10
    Views
    3,243

    SSH2 put job step

    I am having some issues getting this step to work and want to confirm I am putting the right things in the right places. The documentation for this step doesn't exist on the wiki that I could see...
  34. Replies
    9
    Views
    4,860

    Don't think there is one by default. You probably...

    Don't think there is one by default. You probably want to have a look at the guide that's around here some where for adding date pickers to the secure filters. You can probably do some thing like...
  35. Replies
    1
    Views
    849

    http://wiki.pentaho.com/display/ServerDoc2x/Email...

    http://wiki.pentaho.com/display/ServerDoc2x/Email

    Apparently you can pass it a property map of all the addresses and they will all get the email.

    Good luck

    Wil

    PS this is an xaction...
  36. Replies
    5
    Views
    1,289

    That should be ok for the bi-server and report...

    That should be ok for the bi-server and report designer. Not 100% sure about the design studio, but it should be ok.

    Good luck

    Wil
  37. Replies
    10
    Views
    9,128

    I've just had a poke into the code for the log in...

    I've just had a poke into the code for the log in screen. The reason it doesn't use the base url is that it passes into the login box function the URL that you want to go to if the log in request is...
  38. Replies
    10
    Views
    9,128

    Hi Francesco No Idea I am afraid. I don't know...

    Hi Francesco

    No Idea I am afraid. I don't know what versions are compatible Apache is not my speciality I am afraid. Like I said I sorted this out a while ago so don't remember it exactly.

    My...
  39. Replies
    10
    Views
    9,128

    That thing is annoying. Took us a while to work...

    That thing is annoying. Took us a while to work out as well. It seems to one of the only places in the entire platform that ignores the base-url setting.

    In your site config on Apache you need to...
  40. instead of using the normal JDBC datasource under...

    instead of using the normal JDBC datasource under advanced there is a custom(JDBC) option, this then lets you put a formula in for your query which allows you to do any normal formula functions to it...
  41. You could use a custom (JDBC) data source and...

    You could use a custom (JDBC) data source and then have the entire where clause in an if.

    Good luck

    Wil
  42. Replies
    2
    Views
    1,609

    http://forums.pentaho.org/showthread.php?t=75131...

    http://forums.pentaho.org/showthread.php?t=75131
    http://jira.pentaho.com/browse/BISERVER-2266

    Short version. No one has worked out a good way to do this yet.

    Good luck

    Wil
  43. Replies
    9
    Views
    7,166

    Hi Giuseppe Yeah I have seen that before. If...

    Hi Giuseppe

    Yeah I have seen that before. If you have both drivers in the class path they conflict. No idea why, just removed one to make it work. Seems to be a problem with the jvm or drivers...
  44. As far as I know you can't get to the values of...

    As far as I know you can't get to the values of any thing but the current row in the functions and formula. Your going to need to find another way. Maybe some way of getting the values you need from...
  45. Replies
    2
    Views
    793

    This is just an idea so take with a pinch of salt...

    This is just an idea so take with a pinch of salt

    Could you do it with a couple of if blocks that set the mapping for the output fields from the reports. IE

    if x = 0
    then run report a with...
  46. Replies
    18
    Views
    7,413

    Looks like bugg_tb has fixed the first one. Damn...

    Looks like bugg_tb has fixed the first one. Damn you guys are quick
  47. Replies
    18
    Views
    7,413

    No neither did I. Nice feature that one. Makes...

    No neither did I. Nice feature that one. Makes things a bit quicker if you want them all.
  48. Replies
    18
    Views
    7,413

    OK thanks to some video capture magic we have...

    OK thanks to some video capture magic we have worked out what's going on. Its possible to drag all the measures over in one go using the box that surrounds them. My self and codek seem to have been...
  49. Replies
    18
    Views
    7,413

    I have just flushed my cache for about the forth...

    I have just flushed my cache for about the forth time today, and tried again and I am still getting the same results.
  50. Replies
    18
    Views
    7,413

    Just Another Bug Hunt

    Hi Guys

    I am currently experiencing a few problems with PAT that we need some extra help confirming. Unfortunately bugg_tb and pstoellberger are unable to replicate the problems so I am trying to...
Results 1 to 50 of 236
Page 1 of 5 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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