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

Search Forums:

Type: Posts; User: darrell.nelson; Keyword(s):

Page 1 of 15 1 2 3 4

Search Forums: Search took 0.05 seconds.

  1. It's not a totally crazy approach but was it...

    It's not a totally crazy approach but was it available in 3.2.5? That's so far back I have no idea!
  2. You could use a JavaScript step. Be sure to sort...

    You could use a JavaScript step. Be sure to sort your rows on the STUDENT_ID first though.


    var ROW_ID;

    if (ROW_ID == null) {
    ROW_ID = 0;
    _previous = -1;
    }
  3. No. It is the step just below the Add sequence...

    No. It is the step just below the Add sequence step, in Spoon version 4.4.0-stable anyway.

    13158
  4. Replies
    1
    Views
    50

    You will probably have to write a User-defined...

    You will probably have to write a User-defined Java Class to perform a transpose. Obviously, you will have to accumulate all the input data rows before transposing and writing the output rows. Look...
  5. Try using the "Add value fields changing...

    Try using the "Add value fields changing sequence" step.
  6. You may have to dig into the source code to...

    You may have to dig into the source code to determine what happens at cube initialization. I was thinking it was the fact table that was being scanned. Or you could probably increase the query...
  7. Yeah, 35 flags is a bit more involved than 3. ...

    Yeah, 35 flags is a bit more involved than 3.

    For the handling of the description, I think you could do it either way - degenerate dimension or regular dimension. My preference is to keep my fact...
  8. Yes, a WHERE clause in the SQL query of a Table...

    Yes, a WHERE clause in the SQL query of a Table input step should work.

    You can compute the time for the WHERE clause in several ways. Here's one way utilizing JavaScript:


    calendar =...
  9. Replies
    3
    Views
    103

    That's good detective work! If this is not...

    That's good detective work! If this is not already reported as a bug, you should do so.
  10. Can you clarify your data a little? Is it...

    Can you clarify your data a little? Is it acceptable for more than one of those flags to have a value of 1 in the same event?

    If No: Change those flags to "enumerated" and move them into a normal...
  11. I have used the JDBC-ODBC bridge driver on Access...

    I have used the JDBC-ODBC bridge driver on Access files in the past with some success. I recall getting this type of error when the data was corrupt or invalid but I don't remember getting different...
  12. Replies
    7
    Views
    145

    You have to add a Hierarchy to your Dimension...

    You have to add a Hierarchy to your Dimension first. Then you can add Levels to the Hierarchy. I think what you are calling attributes (in the first half of your xml fragment) are actually Levels....
  13. You can easily write the data out from within the...

    You can easily write the data out from within the transformation you read it with; just add a Microsoft Excel Output step or a Table output step as the next step.

    Ultimately, you will probably...
  14. Replies
    10
    Views
    190

    Ah, I didn't realize the folder structure was...

    Ah, I didn't realize the folder structure was changed from 4.4.
  15. Replies
    10
    Views
    190

    I think you want to put the jar in the...

    I think you want to put the jar in the libext/JDBC folder and then restart Spoon. That's where all the rest of the jdbc driver jars are located.
  16. Your are on the right track. Here are my comments...

    Your are on the right track. Here are my comments and recommendations:

    The lookups will always add new fields to each row. If you have duplicate names, the lookup will actually modify the name...
  17. Another Get data from XML step and then a Stream...

    Another Get data from XML step and then a Stream lookup step should do what you are looking for. The attached sample2.ktr performs a lookup into the configuration data based on an ID in the...
  18. Whew! I have dozens of transformations that use...

    Whew! I have dozens of transformations that use that step. So attached is a whopping one-step sample transformation the uses Get data from XML on your data. Doesn't get much easier than that. (Note...
  19. Sure, security should be considered. In either...

    Sure, security should be considered. In either case, PDI will work well to populate the data warehouse. In the XML case, I would most likely use the Get data from XML step - just select the file on...
  20. Okay then, do you really even need to go through...

    Okay then, do you really even need to go through XML files? Is there any reason you can't just use Kettle to pull the transaction data directly from the MS SQL Database(s) and populate a Data...
  21. Do you even need Kettle? There are reporting...

    Do you even need Kettle? There are reporting tools, such as Pentaho PRD and BIRT, that can read XML directly and produce reports.
  22. Replies
    2
    Views
    115

    Each step in a transformation is a "row...

    Each step in a transformation is a "row processor". The Table Input step, in your case, will send 12000 rows (with 1 column in each) to the downstream-connected step(s). Each downstream step (such as...
  23. Did you try placing the jar in the folder...

    Did you try placing the jar in the folder ..\data-integration\libext\? I believe you will have to restart Spoon in order for it to pick up new jars.
  24. Do you really need to use PDI to clone database...

    Do you really need to use PDI to clone database A? I would simply use mysqldump.exe (because I use MySQL databases, of course) on database A and then restore it to database B. PDI is not the best at...
  25. You need to account for the time zone offset...

    You need to account for the time zone offset that's included in your input data. Change your date format string to "dd/MMM/yyyy:HH:mm:ss Z".
  26. Thread: replace

    by darrell.nelson
    Replies
    4
    Views
    255

    If you try to replace a string that isn't there...

    If you try to replace a string that isn't there it will do nothing and proceed. Why do you think you need to search first?

    Also, what is all this "pms" you keep referring to? That's an English...
  27. You could try editing Spoon.bat and adding the...

    You could try editing Spoon.bat and adding the -verbose option to the java command in order to troubleshoot further. You will probably want to redirect the output to a file because there will be a...
  28. From the folder with Spoon.bat in it, is there a...

    From the folder with Spoon.bat in it, is there a sub-folder libswt\win32 with the following files in it?

    12555
  29. Try removing the "\bin" from your JAVA_HOME...

    Try removing the "\bin" from your JAVA_HOME environment variable.
  30. I still think denormalizing is not necessarily...

    I still think denormalizing is not necessarily the best way to go but I have a few questions/concerns to help the thought process along:

    You say you have 155 lines to denormalize but do you...
  31. Do you really need to denormalize? Is it possible...

    Do you really need to denormalize? Is it possible to just update each field one-row-at-a-time with a carefully crafted Execute SQL Script step?
  32. Can you attach to your post the text file or at...

    Can you attach to your post the text file or at least a portion of it? You will have to "Go Advanced" to do so.
  33. Replies
    4
    Views
    232

    Hey that's nice! Thinking back, I'm sure I didn't...

    Hey that's nice! Thinking back, I'm sure I didn't use the quoting of the table identifier in the manner that you did.
  34. There is a Delay Row step that can be inserted in...

    There is a Delay Row step that can be inserted in order to slow down the processing of the rows by a fixed time value.

    Another option would be to build up the rows in a job and then execute them...
  35. This can be done in two steps: Calculate a...

    This can be done in two steps:

    Calculate a group number that increments every time Col1 is 1. The Modified Java Script Value step will work nicely for this.
    Use the Group By step with the...
  36. Replies
    4
    Views
    232

    I've tried a few times but haven't been able to...

    I've tried a few times but haven't been able to make views work in Schema Workbench. However, when I define the view on the database itself, i.e., using MySQL Workbench, the views appear the same as...
  37. Replies
    2
    Views
    280

    No, you aren't. You are setting it to an empty...

    No, you aren't. You are setting it to an empty string. There is a difference.

    Try using this for your test:

    if (man_date_val.equals(""))
    {
    ...
  38. I normally use that connection pool class for my...

    I normally use that connection pool class for my data in a standalone instance of Tomcat. I'm not an enterprise console user. Hopefully, increasing the timeout parameter will solve your problem.
  39. I normally use this connection pool class:...

    I normally use this connection pool class: org.apache.tomcat.jdbc.pool.DataSourceFactory. Perhaps your issue is a hibernate issue? (which I have absolutely no experience with.)

    Have you tried...
  40. Using SchemaWorkbench, Mondrian doesn't seem to...

    Using SchemaWorkbench, Mondrian doesn't seem to allow multiple JDBC connections. You can see the full stack trace in the .schemaWorkbench\workbench.log file located in your "home" directory.
  41. You are right! MySQL does support those SQL...

    You are right! MySQL does support those SQL statements across different database schemas. I've never tried that before but it does indeed work.
  42. Replies
    1
    Views
    332

    I think it would be more efficient to use a...

    I think it would be more efficient to use a "format string" or a user-defined "formatter" instead of a KeyExpression.
  43. I seriously doubt that would be supported....

    I seriously doubt that would be supported. Mondrian relies on the JOIN and GROUP BY features of SQL and those operations are not supported across multiple databases.
  44. Off the top of my head I think it would be...

    Off the top of my head I think it would be easiest to create another measure called market_cap_count with the "count" aggregator and use that in your query.
  45. I think a timeout is happening in your connection...

    I think a timeout is happening in your connection to MySQL server. Are you using a database connection pool in Tomcat? If so, you might try adding this parameter to your database url.
    ...
  46. Replies
    15
    Views
    505

    You should be able to get the Auto Increment...

    You should be able to get the Auto Increment field back from the database by entering person_id in the "Return auto-generated key" box on the "Main options" tab of the Table output step.
  47. Replies
    15
    Views
    505

    You have a couple of errors in your...

    You have a couple of errors in your transformation.

    Do you see that your last two fields are person_index and person_index_1? The first person_index field (ranges from 1 to 5) is coming from the...
  48. Replies
    15
    Views
    505

    Please add a CSV output step instead of a Table...

    Please add a CSV output step instead of a Table output step so you can see what keys are duplicate. Perhaps your sequence calculation is not functioning as expected.
  49. Replies
    15
    Views
    505

    Are all the records coming directly from the CSV...

    Are all the records coming directly from the CSV file? Or are you duplicating some of the rows and thus reusing the person_index that comes out of the sequence calculation?

    Are you by chance using...
  50. OMG did Pat Smith have a sex change in 2000 or...

    OMG did Pat Smith have a sex change in 2000 or was that just a typo? Funny stuff.
Results 1 to 50 of 744
Page 1 of 15 1 2 3 4