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

Search Forums:

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

Page 1 of 53 1 2 3 4

Search Forums: Search took 0.22 seconds.

  1. Replies
    4
    Views
    407

    You can configure Firefox to pass NTLM...

    You can configure Firefox to pass NTLM information to the server. (See here)
    I'm not sure how you configure the server to understand it.

    Short answer: I can get you one step closer, but not all...
  2. Replies
    10
    Views
    76

    Two ways I can think of: 1) Your calling Job...

    Two ways I can think of:

    1) Your calling Job would specify the carte server as an "Execute on remote server" for an additional job that would collect the file, and process it.
    2) Your calling Job...
  3. Replies
    10
    Views
    76

    Another option is to have a Carte server running...

    Another option is to have a Carte server running "near" the database, which will grab that text file, and process it into the DB... Thus your network roundtrip times are a lot shorter.
  4. Replies
    10
    Views
    76

    After you swap the Insert / Update with an Update...

    After you swap the Insert / Update with an Update step, you still have to select the "Don't perform lookup" box, or it will still do a lookup first. Don't ask - I don't know why it does that.
  5. Replies
    10
    Views
    76

    You might be able to squeeze a little bit more...

    You might be able to squeeze a little bit more out of it by using an Update step, and disabling the lookup. But that shouldn't improve the speed much. Do you have cache turned on on the Combination...
  6. Have a good look at:...

    Have a good look at:
    http://wiki.pentaho.com/display/EAI/Dimension+Lookup-Update
  7. Replies
    1
    Views
    60

    Something like:...

    Something like:...
  8. Replies
    1
    Views
    73

    You'll get a better response if you either fill...

    You'll get a better response if you either fill out the form at http://www.pentaho.com/contact
    or call one of the numbers found on that page.
  9. You could define error handling for the step that...

    You could define error handling for the step that is having issues, and then redirect the "error" rows to a text file to review.
  10. Thread: Update Step

    by gutlez
    Replies
    2
    Views
    76

    Are you using the Update step, or the Insert /...

    Are you using the Update step, or the Insert / Update step?

    Insert / Update has to do a query first to determine if the row exists, and then do an Insert if it doesn't.
  11. Replies
    4
    Views
    185

    But if you have to edit the entry anyway to...

    But if you have to edit the entry anyway to update the filename that you are calling, then you can edit the log file at the same time.
  12. Replies
    5
    Views
    129

    Usual answer - make it work in Spoon first. Then...

    Usual answer - make it work in Spoon first. Then get it to work in API.
  13. "Group By...

    "Group By", OrderNo, Concatenate strings with , ?
  14. Replies
    2
    Views
    91

    So in theory, you should be doing at most 22M...

    So in theory, you should be doing at most 22M roundtrips to the DB... (Ouch, but can't be helped much)

    Did you turn on the "Enable Cache" in Database Lookup?
    What is the round-trip time from the...
  15. Walk us through it very slowly... (and maybe even...

    Walk us through it very slowly... (and maybe even post your transform - be sure to clean your DB connection information first!)

    What is your incoming stream?
    What are you trying to accomplish...
  16. Replies
    4
    Views
    185

    I find that ${Internal.Transformation.Name} is...

    I find that ${Internal.Transformation.Name} is not set at the Job level (others claim to see differently). However, ${Internal.Job.Name} is. That however will not help you, since you want the log...
  17. Your generate rows step is generating 10 rows,...

    Your generate rows step is generating 10 rows, not 1.
    So your Execute All Stored Procedures step is being called 10 times, so each of the SP that it calls will be called 10 times...

    So, if that...
  18. Have a look at the Group By...

    Have a look at the Group By steps.
    One of the grouping options is "Concatenate strings separated by , (comma)"
  19. Replies
    16
    Views
    358

    Yes, I used to do it with 3.6 regularly.

    Yes, I used to do it with 3.6 regularly.
  20. Replies
    16
    Views
    358

    Try 3.8 and see if it plays nicer

    Try 3.8 and see if it plays nicer
  21. Replies
    16
    Views
    358

    I'm trying to remember what version you need for...

    I'm trying to remember what version you need for BIServer 4.8.
    The thing is you reported using PSW 5.3 - How are you doing that when the latest you can find is 3.8?

    You don't want to be on trunk...
  22. Replies
    16
    Views
    358

    The only other suggestion I would have is Use PSW...

    The only other suggestion I would have is Use PSW 4.8 if you are going to use BIServer 4.8 ... Generally, you want to keep your tools at the same version.
  23. Nope -it's more of a DBA level thing... ...

    Nope -it's more of a DBA level thing...

    Basically your Database Administrator creates a view that merges the appropriate rows where Date_Key and Campus_Key are the same, which would then have all...
  24. Short answer: Yes, it can be done. Have a quick...

    Short answer: Yes, it can be done.
    Have a quick look through: http://mondrian.pentaho.com/documentation/schema.php#Virtual_cubes

    If your fact tables are in the same database, then it may be...
  25. Replies
    3
    Views
    125

    Ok. So short version: Dimension - Part that you...

    Ok. So short version:
    Dimension - Part that you want to break the data by.
    Hierarchy - A pathway down through the dimension.
    Level - A group of the part above (you can have multiple levels)
    ...
  26. Replies
    3
    Views
    125

    I would have thought that Campus would be a...

    I would have thought that Campus would be a dimension of its own, not a level of dimension GL_Default

    Since you can have the same Campus within different Account Category values, this is why you...
  27. Replies
    16
    Views
    358

    With Pentaho-BI-Server versions below 5, you have...

    With Pentaho-BI-Server versions below 5, you have to set the publish password, and the account has to have admin level permissions.

    This is documented at...
  28. Replies
    4
    Views
    173

    Not if the actual use-case requires something to...

    Not if the actual use-case requires something to be completed in Job 1 before Job 2 happens.

    Usually, "Get Rows from Result" consumes those rows, so that the next job can't also "Get Rows from...
  29. It's not intuitive, but calculator has the...

    It's not intuitive, but calculator has the Calculation: "First letter of each word of a string A in capital"

    More intuitive, but still not obvious: String operations: Lower/Upper: Lower, InitCap: Y
  30. Replies
    8
    Views
    140

    Generally, I've found Linux ETL to be faster, but...

    Generally, I've found Linux ETL to be faster, but again, without a complete picture, we're all shooting in the dark here.
  31. Replies
    8
    Views
    140

    So, if your transform has the file paths directly...

    So, if your transform has the file paths directly written in them (can't say for sure without the KJB/KTR), then it's possible that your server is trying to pull the data from your workstation. That...
  32. Replies
    8
    Views
    140

    "call the job remotely" Care to expand on that a...

    "call the job remotely"
    Care to expand on that a little?

    Are you copying the KJB/KTR to the remote linux box and running it via SSH and command line?
    Are you using carte and telling spoon to run...
  33. Do you mean like: http://www.ibridge.be/?p=199

    Do you mean like:
    http://www.ibridge.be/?p=199
  34. Replies
    3
    Views
    179

    Please DO NOT do this. Use the correct Oracle...

    Please DO NOT do this. Use the correct Oracle JDBC driver, as marabu previously recommended.
  35. That's not what I've experienced.

    That's not what I've experienced.
  36. As long as there is a Key defined in the...

    As long as there is a Key defined in the database, then the DB Engine will not allow the insert (duplicate key error, or Unique Index Constraint violation). This can then be caught with error...
  37. Replies
    4
    Views
    212

    So you want to transform some data, and then send...

    So you want to transform some data, and then send ONE email. That sounds like a set of requirements for a Job, not a transformation.


    Because the use-cases between the job step and a...
  38. So... RepositoriesMeta.writeData() is for...

    So... RepositoriesMeta.writeData() is for writing the metadata about a stream within a transformation or job to an existing Repository, rather than writing about a repository.

    kettle-servlets.xml...
  39. Why not use the Calculator step which has a built...

    Why not use the Calculator step which has a built in "Date A - Date B (seconds)" calculation?
    You can then use the Group By step to Sum across the values in a group.
  40. Did you read the documentation you linked to? ...

    Did you read the documentation you linked to?



    Keys to match

    Specify fields containing the keys on which to match
  41. Are you saying that you want to capture the rows...

    Are you saying that you want to capture the rows that you can't do a Table Output on because they already exist?
    Then why not use a Table Output, with Error Handling defined to capture those rows?
  42. Well, How about I help you answer your own...

    Well, How about I help you answer your own question...

    Given 1411154919 , what is the data type? Note: That could be a date, an integer, a string, a floating point, a binary, or a timestamp.
    ...
  43. Well, somewhat neither. You should declare a...

    Well, somewhat neither.
    You should declare a calculated measure when you're building your schema. See: http://mondrian.pentaho.com/documentation/schema.php for reference

    When you create your MDX...
  44. You would need to config JBoss to provide the...

    You would need to config JBoss to provide the JNDI to the PDI Instance.
    See: http://docs.jboss.org/jbossweb/3.0.x/jndi-resources-howto.html for reference.

    When JBoss is providing the JNDI...
  45. Replies
    13
    Views
    296

    Simply use the format string in your CSV Input....

    Simply use the format string in your CSV Input.
    The other ways are simply not as efficient.

    The string "yyyy/MM/dd" cannot be used to parse "20140923" because there are no /'s in it. you would...
  46. Replies
    3
    Views
    150

    The Get System Info step *IS* passing data....

    The Get System Info step *IS* passing data.
    However the Table Input is not designed to pass incoming rows onwards, unless they included in the select statement.

    You can update it to do something...
  47. If it's a Tab delimited file, then all the TABs...

    If it's a Tab delimited file, then all the TABs in the file disappear, leaving the line as NULL.
  48. You are assuming that I have access to an Oracle...

    You are assuming that I have access to an Oracle system.
    I do not.

    Explain what you are trying to accomplish, since you seem to have jumped directly to solution, without working through the HOW...
  49. I'm not fully following how you are trying to do...

    I'm not fully following how you are trying to do what you're trying to do.

    The only part that should work from your Transform that should work as you expect it to would be the Max CDC -> Track...
  50. If you use the correct JDBC URL, then you will go...

    If you use the correct JDBC URL, then you will go JDBC -> Oracle directly.

    URL Format:
    http://www.oracle.com/technetwork/database/enterprise-edition/jdbc-faq-090281.html#05_03

    Class Name:
    If...
Results 1 to 50 of 2627
Page 1 of 53 1 2 3 4