Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: Robin Sarac; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. Cube Uses Table From More Than One Schema?

    Is it possible to create a cube using tables from more than one schema? Everytime I have to enter connection information I end up having to specify a database.
  2. Replies
    1
    Views
    1,525

    Is it possible to include tables from two...

    Is it possible to include tables from two different schemas in a given cube?
  3. Replies
    1
    Views
    1,525

    Choose Schema

    I can't seem to select the schema in Cube Designer when I'm adding tables? Am I doing something wrong? I need to be able to add tables from different schemas. The schema dropdown is disabled / not...
  4. Ugh. I said leverage. Please excuse. ;)

    Ugh. I said leverage. Please excuse. ;)
  5. Thanks for that, Matt. I was speaking with Dave...

    Thanks for that, Matt. I was speaking with Dave this morning and we're definitely re-evaluating our subscription...we'll almost certainly expand it to something a bit more strategic so we can...
  6. Looks like the server setting -- bumping...

    Looks like the server setting -- bumping net_write_timeout -- has helped me like it has helped others. I'll wait and hopefully the whole transformation will run, but it's already quite a bit further...
  7. I did see that link but I never even thought that...

    I did see that link but I never even thought that it was a client issue versus server. I'll post with my results as soon as I can get this changed and tested again.
  8. Excellent, I'll give this a whirl. I've also got...

    Excellent, I'll give this a whirl. I've also got a support call in. Hopefully I can resolve this as this is impacting our deployment. Thanks!
  9. Setting netTimeoutForStreamingResults to 1800 on...

    Setting netTimeoutForStreamingResults to 1800 on both the Table input and Dimension lookup/update steps didn't help. It dies at the same spot...about 40k rows in to the dimension update.

    These...
  10. I'm getting a new set of errors, but it looks...

    I'm getting a new set of errors, but it looks like the process made it 40k rows...

    2008/05/02 15:16:08 - Dimension Source.0 - linenr 50000
    2008/05/02 15:16:08 - Dimension lookup/update.0 -...
  11. How does this relate to fetch size? Is this the...

    How does this relate to fetch size? Is this the same as setting the defaultFetchSize option?

    Thanks for joining in! :)
  12. I don't think changing the memory buffer size...

    I don't think changing the memory buffer size will help when it comes to bringing over millions of rows? Could you please elaborate on your comment and how it might help? This seems to be a very...
  13. I guess what I would really appreciate (thanks...

    I guess what I would really appreciate (thanks for your help so far) is someone to tell me which settings I need to tell the Table input step in Kettle (2.5.0) not to buffer results, but to deliver...
  14. It's not clear in that article that what it talks...

    It's not clear in that article that what it talks about is actually done through setting that option for a connection. Doesn't it talk about setting the option defaultFetchSize and userCursorFetch?...
  15. Thank you for the link...I can't have that table...

    Thank you for the link...I can't have that table locked and there will be queries launched against that table while the transformation is taking place. I'll keep fiddling with options I guess. ...
  16. Hmmm, this option is not so good, it seems. I've...

    Hmmm, this option is not so good, it seems. I've turned it back off and now have my out of memory problem again. Ideas?
  17. Forgot to mention that it's the size of the...

    Forgot to mention that it's the size of the source that seems to be the problem as this transformation works when I limit the source to something like, 100k rows. Connecting natively (JBDC)...
  18. Out Of Memory Problem...Result Streaming Helped?

    Kettle 2.5.0

    I was having the out of memory problems and tried everything I could findhere on the forums and elsewhere on the Net, with no success. I have a very simple transformation that has...
  19. Replies
    1
    Views
    2,940

    Get ID Of Last Inserted Row?

    Is there a way to get the ID of an inserted row without having to do another lookup? If I insert a row in a dimension table and I want to retain that ID for inserting the fact, do I need to look it...
  20. Guidance?

    I did read the User's Guide, but I'm still a bit confused.

    If I have a database join component and I want to pass the results from that on to another transformation, I create a mapping output...
  21. Excellent, I'll give that a whirl. Thanks!

    Excellent, I'll give that a whirl. Thanks!
  22. Call A Xformation From Another Xformation?

    Is it possible to pass a stream on to another transformation and call it from another transformation, then return execution back to the calling transformation?
  23. Design Studio On Windows - BI Platform On Linux?

    The documentation I've looked at seems to suggest that the Design Studio examples only work when both the Design Studio and the platform are on the same machine or OS. I'm sure that's not the case....
  24. I was just thinking that...trying another...

    I was just thinking that...trying another program. I was using the built in XP unzip. 7-Zip did the trick, thank you.
  25. Can You Download & Extract Design Studio?

    While extracting, I keep getting an error that the system cannot find the file specified. I've already downloaded it twice and tried. Anybody else got this error and worked around this problem?
  26. Replies
    10
    Views
    4,037

    I had to follow the instructions for running as a...

    I had to follow the instructions for running as a server...everything seems OK now.
  27. Replies
    10
    Views
    4,037

    I've got rid of the errors, but I still can't...

    I've got rid of the errors, but I still can't connect with a browser. I'll have to do some digging on my own with this problem before I bother you lot. Just the generic "IE cannot display the...
  28. Replies
    10
    Views
    4,037

    From the command prompt, I can log on just fine...

    From the command prompt, I can log on just fine with 'mysql -u hibuser -p' entering the default password.
  29. Replies
    10
    Views
    4,037

    No, I'm not being silly, it's on the same machine...

    No, I'm not being silly, it's on the same machine and localhost is right. :)
  30. Replies
    10
    Views
    4,037

    Thanks for that, but that file seems to be OK. I...

    Thanks for that, but that file seems to be OK. I don't see anything wrong with it.
  31. Replies
    10
    Views
    4,037

    BI Platform Pre-Configured...Help!

    I'm trying to get the pre-configure dinstallation running.

    I downloaded and extracted the file...

    pentaho_demo_mysql5-1.6.0.GA.863.tar.tar

    I then went into the pentaho-demo/data directory...
  32. Is There Not One Set Of Coordinated Instructions?

    Is there not one set of up to date instructions for getting Mondrian up and running, building your own cube, and accessing it with JPivot?

    I have the Mondrian FoodMart example working, but now...
  33. Replies
    3
    Views
    1,335

    This is handy to know, even if it is very...

    This is handy to know, even if it is very frustrating to finally find this out her. But could you offer any more help? I just want to enable tracing in an effort to figure out the XML schema...
  34. Replies
    2
    Views
    2,007

    Java 1.6 was the problem. Have to downgrade to...

    Java 1.6 was the problem. Have to downgrade to 1.5 to get XMLA to work.
  35. Only upgrading to 3.0.2 worked for me. One thing...

    Only upgrading to 3.0.2 worked for me. One thing to note is that XMLA doesn't work with Java 1.6...
  36. Replies
    2
    Views
    2,007

    XMLA Queries...Tough Config!

    I've found all sorts of references to getting Mondrian to work with XMLA, but I still have had no success. I can get to the Mondrian examples page. Every link, including the XML for Analysis tester...
  37. Replies
    8
    Views
    11,335

    Upgrade

    It seems that the thread talking about JPivot problems with 3.0.1.10736 was right. Simply upgrading to 3.0.2.10775 solved my problems. Thanks for your help. :)
  38. Replies
    8
    Views
    11,335

    It looks like all of the queries in XML for...

    It looks like all of the queries in XML for Analysis tester work. I get data sources, cubes, the HR query works. But the JPivote pivot table by XMLA does not work. I get this error:
    ...
  39. Replies
    8
    Views
    11,335

    Actually, it did work for the ad hoc queries, but...

    Actually, it did work for the ad hoc queries, but the JPivot part seems to have another problem:

    org.apache.jasper.JasperException: javax.servlet.jsp.JspException:...
  40. Replies
    8
    Views
    11,335

    This worked, Julian...thanks! :)

    This worked, Julian...thanks!

    :)
  41. Replies
    8
    Views
    11,335

    Tried setting the connectString in web.xml in...

    Tried setting the connectString in web.xml in both places to this:

    <init-param>
    <param-name>connectString</param-name>
    ...
  42. Replies
    8
    Views
    11,335

    Sorry, the MDX Query Servlet connect string seems...

    Sorry, the MDX Query Servlet connect string seems to reference to property too...

    <servlet>
    <servlet-name>MDXQueryServlet</servlet-name>
    ...
  43. Replies
    8
    Views
    11,335

    Mondrian Examples: Connect String

    I've tried to sort this out by reading what I can find, but I'm stumped. When I go to the Mondrian examples page and click on Basic interface for ad hoc queries, I get the list of queries and I can...
Results 1 to 43 of 43
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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