Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    3
    Views
    10,525

    Sticky: Szia! Bocs a késői válaszért. Nem vettem észre...

    Szia!

    Bocs a késői válaszért. Nem vettem észre a post-od.
    A problémád már biztos megoldottad, de a jövőben idetévedőknek ajánlom Roland Bouman és Jos van Dongen könyvét, amely Pentaho Solutions-...
  2. Replies
    3
    Views
    4,177

    Can anyone tell, that it is an actual bug, or am...

    Can anyone tell, that it is an actual bug, or am i doing something wrong?
  3. Replies
    3
    Views
    4,177

    Oracle Bulk Loader error?

    Hi Everyone!

    I have a strange error with my Oracle Bulk Loader step. It doens't want to run. The error message in the log is always:
    Oracle Bulk Loader.0 - ERROR>Message 2100 not found; No...
  4. Replies
    3
    Views
    1,650

    Yes, but my table is a fact table, and to run the...

    Yes, but my table is a fact table, and to run the query for all the products is too much time.
    I would prefer to run the query for only Count(group_id) times.
  5. Replies
    3
    Views
    1,650

    Parametrized Table input

    Hi Everyone!

    I have a given input, with 2 columns. The 1st column is a group id, the 2nd colums are id-s of a product. Like this:
    G_ID P_ID
    1 15
    1 420
    2 154
    ...
    And I want...
  6. Replies
    4
    Views
    1,686

    Try 0. I've checked. In my transfo-s it is always...

    Try 0. I've checked. In my transfo-s it is always blank.
  7. Exit program & restart it. In some Forum or Blog...

    Exit program & restart it.
    In some Forum or Blog post I read, that in version 4.2 the memory handling will be more effective.
  8. Replies
    4
    Views
    1,686

    Hi Pacos! The Interval logging is an optional...

    Hi Pacos!

    The Interval logging is an optional parameter. It shows that periodically how often (in seconds) writes the log table. If you leave it blank, the log table will be updated only at the...
  9. Try to modify your column in the Oracle db to...

    Try to modify your column in the Oracle db to NUMBER(38, 0).
    Then the PDI will recognize it to Integer. Unless it will recognize it as BigNumber.
  10. Replies
    2
    Views
    2,292

    Ohhhhh, I feel myself so dumm rigth now :) ...

    Ohhhhh, I feel myself so dumm rigth now :)

    Slawo thanks for your fast answer.
  11. Replies
    2
    Views
    2,292

    Table Exists Step - Bug?

    Hi!

    I'm tring to use the Table Exist Step, but I can't.

    I made a connection (tried JNDI and normal JDBC too, but the same result), added an existing schema name, but the Tablename field...
  12. Replies
    13
    Views
    10,707

    I have an idea, but I can't guarantee this is the...

    I have an idea, but I can't guarantee this is the best solution, or even if it works at all!

    So if your data is sorted, and you used a Sequence, you should try the LAG or LEAD funciton of...
  13. Replies
    0
    Views
    2,333

    How to test OLAP (XML/A) connection is alive

    Hi!

    I want to ask, is there any kind of "official" solution, or step to test if an OLAP (XML/A) connection for MDX queries is alive? Just like "Check Db connections" step. I think Ping-ing a host...
  14. Solved

    Hi!

    I've managed to solve my problem in a very easy way.
    I used 4.0.0, when I noticed this issue, so I made a test Transformation, that I saved.
    And after that, every time I opened the .ktr in...
  15. FYI: I've tried with 4.2.0M1 release, and the...

    FYI: I've tried with 4.2.0M1 release, and the problem still exists.
  16. Another strange thing: (First time in my life) I...

    Another strange thing: (First time in my life) I tried to run a Trace, whit SQL Server Profiler during I run a preview on my Olap input step. But there was no error in the trace file.

    Isn't there...
  17. Matt, what this log entry means? 2011/06/27...

    Matt, what this log entry means?
    2011/06/27 11:09:20 - OLAP Input.0 - Stopped while putting a row on the buffer

    It happens after a successful preview (that returned 1000 rows), about 100 times.
  18. It is sure, that my query is 2 dimensional. ...

    It is sure, that my query is 2 dimensional.

    Here is it:


    SELECT NON EMPTY
    {[CURRENCY].[CURRENCY].[EUR], [CURRENCY].[CURRENCY].[USD]
    } ON COLUMNS,

    NON EMPTY
  19. Hi! I have a same issue with Microsoft SQL...

    Hi!

    I have a same issue with Microsoft SQL Server 2005 Analysis Services. If I run my query on the MS Studio, works fine, but when I try to preview my rows in the OLAP Input Step, always give me...
  20. Replies
    0
    Views
    1,727

    Kettle vs. TM1 - How export works?

    Hi!

    Has somebody experience in exporting data from IBM (former Applix) TM1?

    Is it possible with standard "OLAP Input" step? If the answer is yes, can someone tell me (or send a link) how to...
  21. Replies
    0
    Views
    3,337

    Metaadatok és az ékezet

    Örök tanács: metaadat modell készítésekor ne adjunk ékezetes neveket a Business Modelleknek és a Business Category-knak, mert nem fog menni.
  22. Replies
    5
    Views
    3,149

    Antoher question: at Select Values the Decimal...

    Antoher question: at Select Values the Decimal column means what is the decimal separator? Am I right? Because I set comma (,) and don't want to work, still uses a dot(.).
  23. Replies
    5
    Views
    3,149

    Thanks Matt! It worked. Now I feel myself a bit...

    Thanks Matt! It worked.
    Now I feel myself a bit dumm. I tried to operate with precision, but hasn't helped.
  24. Replies
    5
    Views
    3,149

    I use Oracle Bulk Loader to load the data, so I...

    I use Oracle Bulk Loader to load the data, so I have to write the data to CSV.
    Is there any workaround to handle this problem?
  25. Replies
    5
    Views
    3,149

    Data loss at Table Input step with MySQL?

    Hi!

    I have to Unload a MySQL (5.1) database, and load it into an Oracle (10gR2) with PDI (4.0.1 - Win XP). The job runs fine, but I have some data loss because of number rounding.

    A use Table...
  26. Replies
    14
    Views
    10,571

    I found a solution. The problem was a space...

    I found a solution.
    The problem was a space character. In my kettle.properties the parameter looked like this: DB_PASSWORD = Encrypted 2be98afcxyzyxyxzyxzyxyz
    If I used plain text password, with no...
  27. Replies
    14
    Views
    10,571

    Aha, now I understood it :) Yes please. But...

    Aha, now I understood it :)

    Yes please. But isn't it stange, that only I have this problem around the globe?
    Or am I the only one, who use Oracle Bulk Loader step? :)
  28. Replies
    14
    Views
    10,571

    And where should I set this? I mean which window...

    And where should I set this? I mean which window of Spoon, or which file should I edit to make this?
  29. Replies
    14
    Views
    10,571

    I use a normal JDBC connection, but my login...

    I use a normal JDBC connection, but my login creditentals are stored in the Kettle.properties file as parameters. (The password is encrypted). In the normal password there is no space or any special...
  30. Replies
    14
    Views
    10,571

    I tried both, but as I mentioned, it is always...

    I tried both, but as I mentioned, it is always the same. Like I wrote in my first post. :(
    LRM-00112: Multiple values not allowed for parameter 'userid'

    But check my prevoius post, it says:...
  31. Replies
    14
    Views
    10,571

    Additional info

    Hi there!

    Some additional info:
    If I check "Fail on error" check box, then my log looks like this:
    Oracle Bulk Loader.0 - ERROR>LRM-00112: a(z) 'userid' paraméternek csak egyetlen érték adható...
  32. Replies
    14
    Views
    10,571

    Damn Forum Engine. It resized my pic too little...

    Damn Forum Engine. It resized my pic too little :(
    Here's a link for it:
    http://picturepush.com/public/5150192
  33. Replies
    14
    Views
    10,571

    Oracle Bulk Loader problem - LRM-00112

    Hi Everyone!

    I have a terribly annoying issue, with the Oracle Bulk Loader. I always get LRM-00112 error, which stands for: Multiple values not allowed for parameter 'userid'

    See attached...
  34. Replies
    1
    Views
    2,059

    CSV export: Change , to ;

    Hi!

    It there any possibility to change the , separation to ; in CSV, when the user want to export a report from User Console?

    E.g:
    Now the csv looks like: one,two,three
    And i want:...
  35. Replies
    1
    Views
    2,559

    I had the "HttpWebService.ERROR_0001 -...

    I had the "HttpWebService.ERROR_0001 - MESSAGE_TBD java.lang.NullPointerException" problem too.
    My solution was, that I forget to give an ID for my Business View in the Metadata Editor. After I gave...
  36. Replies
    4
    Views
    2,663

    I reply to myself :) I found a half-solution. If...

    I reply to myself :)
    I found a half-solution. If I open the datadefinitions.xml (found in the report prpt file), and change
    <attribute...
  37. Replies
    8
    Views
    7,839

    Nice. Thanks for the link. Is there a solution...

    Nice.
    Thanks for the link.
    Is there a solution that works for multiple inputs, like Check Box, or Multiple Value Buttons?
  38. Replies
    4
    Views
    2,663

    Forgot to tell: I use 3.5 Report Designer, and...

    Forgot to tell: I use 3.5 Report Designer, and 3.5 BI server.
  39. Replies
    4
    Views
    2,663

    Configuring Checx Box on User Console

    Hi!

    I have some question about report parameter look.

    I'm trying to make a report parameter, with a check-box. But list is too long.
    If I run a Preview in Report Designer, it has a...
  40. Replies
    3
    Views
    8,505

    Hi TomS! Nice :) It is easier, faster and...

    Hi TomS!

    Nice :)
    It is easier, faster and simpler than my way.
    Thank you!
  41. Replies
    3
    Views
    8,505

    Sorry, I was too sleepy to think before writing:...

    Sorry, I was too sleepy to think before writing:
    So first I used a Calculator, to duplicate my attribute. Second I used a Replace in Sting. I searched with rexexp for .*\+.*\+.*\+ and left blank...
  42. Replies
    3
    Views
    8,505

    Replace in String with Regexp - is it possible?

    Hi Everyone!

    I want to know, if it is possible to use the Replace in String with Regexp, in a different way?
    I have a String attribute, and some of them looks like: abc + def + hij + jklm ..and...
  43. Replies
    3
    Views
    10,525

    Sticky: Magyar Pentaho dokumentáció

    Egy egyetemi tárgyam kapcsán készítettem egy áttekintő dokumentációt a Pentaho Open Suite-ról.

    Akit érdekel az elérheti a következő linken: http://centaur.sch.bme.hu/~hose/PENTAHO.pdf

    Egy-két...
  44. Thread: Wild chars?

    by hose
    Replies
    2
    Views
    2,055

    Thanks gutlez, it worked. I ususally try to...

    Thanks gutlez, it worked.
    I ususally try to avoid Regular Expressions, because I always make a mistake :)
  45. Thread: Wild chars?

    by hose
    Replies
    2
    Views
    2,055

    Wild chars?

    Hi!

    What are the wild characters in Kettle?
    Here is my problem:
    I have a string field and I want to select rows where it contains like bla + bla + bla + bla
    (bla can be anything). In other...
  46. Replies
    4
    Views
    1,528

    Thanks!

    Thanks Matt!

    That worked.
    First I thoughed, you talking about SQL Group by, but finally I found that step. :)

    I never used this step, untill now :)
  47. Replies
    4
    Views
    1,528

    It is a CSV input. So I can't use SQL.

    It is a CSV input. So I can't use SQL.
  48. Replies
    4
    Views
    1,528

    Row de-normalising question

    Hello Everyone!

    I have a task, and I don’t know how to do it.
    I have a table like this:
    [See attachment: table_1.]

    and I want to make a table like this:
    [See attachment table_2.]
  49. Replies
    3
    Views
    3,086

    It is working....

    Yeah, it works. Thanks a lot.
  50. Replies
    3
    Views
    3,086

    Cleaning String with RegExp - Help needed

    Hi Everyone!

    I have a task: clean a string field.
    I have a tons of 'x' in the string (stands for multiplicate) for example: 1xBLABLA and 1x BLABLA (of course there can be a lot of different...
Results 1 to 50 of 57
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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