Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 3 1 2 3

Search Forums: Search took 0.02 seconds.

  1. Thanks, SoulSpirit. I'm not sure I understood...

    Thanks, SoulSpirit. I'm not sure I understood everything, but it might be a hint where I could do some further testing. I can drill-down the "Standzeitkategorien" without a problem and I can build...
  2. Replies
    2
    Views
    1,184

    Thanks. I misunderstood the use of the visible...

    Thanks. I misunderstood the use of the visible attribute.
  3. How do you tackle "Error while executing query" problems

    I'm getting Mondrian internal error "Error while executing query" in different queries without any further exception line pointing me to the possible problem. It happens when I try to drill down on...
  4. Replies
    3
    Views
    4,671

    Taking a stab, I'd first tell you to look at the...

    Taking a stab, I'd first tell you to look at the MySql date and time functions at MySql date and time functions. Other than that, you can build in "pure" sql into mondrian's schema at different...
  5. Replies
    2
    Views
    1,184

    Making Measures visible ?

    Even though I set the attribute 'visible="true"' for all of my measures in the mondrian.xml file, only the first measure is shown. I'm using the MDX 'default' in the xaction of the 1.6.0 PCI. Is...
  6. Replies
    2
    Views
    1,693

    It might help to turn on tracing in the...

    It might help to turn on tracing in the mondrian.properties with 'mondrian.trace.level=1', if not already set. This outputs the sql statments Mondrian uses for a particular MDX query on the console...
  7. Replies
    5
    Views
    3,490

    I don't know of any possibility in the earlier...

    I don't know of any possibility in the earlier Pentaho version. We too use the 1.2 version still and have not found a good solution for the cache problem. I'm trying to convince management to...
  8. Replies
    1
    Views
    1,676

    Syntax error when using range symbol ':'

    Hi,

    I'm trying to back-port a runnable MDX query from 1.6 to 1.2 and get the message "Mondrian Error:Syntax error at line 1, column 39, token ':'" and a following jpivot error stating pretty much...
  9. Where to add locale.properties and which connection url

    The docs about Mondrian schemas refer to internationalizing captions by creating locale.properties files and adding two extensions to the connection, like


    Provider=mondrian;
    Locale=en_US;...
  10. Replies
    2
    Views
    1,861

    The Pentaho components usually are set up to get...

    The Pentaho components usually are set up to get data from the RDBMS via JDBC. So, if you're connected to your operative database, then you get the up-to-the-second data. Pentaho Analysis...
  11. Replies
    2
    Views
    3,395

    I recall seeing in the 1.6.0 PCI under "Admin"...

    I recall seeing in the 1.6.0 PCI under "Admin" that you can schedule "cache clearing". Other than that, there are two xactions there that deal with clearing the two type of Mondrian caches -...
  12. Replies
    5
    Views
    3,490

    There's two xactions under the admin folder in...

    There's two xactions under the admin folder in the 1.6.0 PCI that do what you're looking for:

    clear_mondrian_data_cache.xaction and clear_mondrian_schema_cache.xaction.
  13. Replies
    2
    Views
    1,412

    Thanks, Antonius. It worked.

    Thanks, Antonius. It worked.
  14. Replies
    2
    Views
    1,412

    How do you apply a rolling date range?

    Hi,

    After pulling my hair out for a while, I finally got the calculation for a 30 day rolling time period based on the last day with data. Now I have a 'Last30Days' set, but how do I actually...
  15. Schema Workbench MDX query always returning an error

    Hi,

    I'm using a proprietary JDBC driver on a WinXP host with Java 1.5.0_12. I usually get my desired results using Mondrian/JPivot outside of the schema workbench (2.3.2.9247), but in the...
  16. Replies
    0
    Views
    1,016

    Standalone creates empty output files

    Hi,

    I finally got around most of the installation blues with the Standalone project, in my case, under NetBeans 5.5.1. Those using Eclipse had similar problems - missing jars, pentaho.xml, etc. ...
  17. Any way to suppress the tablename prefix in the column aliases?

    Hi,

    The Query Designer in Report Design Wizard prepends the tabelname onto the column alias. The field lengths in RDW for columns is rather short, so this results in chopped column names. I know...
  18. Replies
    0
    Views
    1,102

    Can't change size of query designer window

    The query designer window used in the 1.6 pentaho tools should be able to be resized. From one of the tools, I could at least maximize it, but in most of the tools, I can't resize the window at all...
  19. Replies
    2
    Views
    2,144

    Thanks for the statement.

    Thanks for the statement.
  20. Replies
    2
    Views
    2,144

    Minimum java version for 1.6 PCI?

    The 1.6 PCI is delivered with a 1.5 JRE. Strangely enough, I could not find an explicit "system requirements" topic for the PCI. I know some of the designer tools require at least 1.5. What is the...
  21. Thanks, Thomas. I DL'ed the RC3.855 and didn't...

    Thanks, Thomas. I DL'ed the RC3.855 and didn't see the message in the log aynmore.
  22. Replies
    4
    Views
    5,294

    I got around my problem.

    I got around my problem.
  23. Thanks for getting back. I can't tell you if...

    Thanks for getting back. I can't tell you if Quartz was working or not. After digging (blindly) into the MDR, I happened upon a repository.properties setting late yesterday that suppresses the...
  24. SringIndexOutOfBound Exception getting Windows Fonts

    I've ported the 1.6RC2 to the Sun Java System App Sever (Glassfish) using its JavaDB (Derby) database. Everything's working pretty well, but I get the following Exception in the server.log when the...
  25. sql exception with quartzscheduler using derby

    I'm about 95% done with a port of the 1.6RC2 PCI to the Sun Java System Application Server (Glassfish) and using its JavaDB (Derby). Most everything is working with the file based repo. I do get...
  26. Replies
    4
    Views
    5,294

    Hi Doug, I'm having the same errors while trying...

    Hi Doug,
    I'm having the same errors while trying to implement the Derby DB. Could I ask you what the typo actually was?
    Thanks,
  27. Replies
    2
    Views
    1,701

    Thanks! That worked and got me going in the...

    Thanks! That worked and got me going in the right direction.
  28. Replies
    2
    Views
    1,701

    How-to get date range to work

    I'd like to enhance the cube from the "Cube Designer Quick Start Guide" with a parametrized from/to date range, but can't seem to get the right syntax together. Could someone please help me with...
  29. Thanks! Worked like a champ!

    Thanks! Worked like a champ! :)
  30. How do I translate the JPivot toolbar tooltips

    Hi,

    Is there a way to translate the JPivot toolbar tooltips externally, e.g. via properties file? I saw references to a resources.properties while searching the web, but can't find it in the...
  31. Replies
    4
    Views
    1,835

    Help with JBOSSWS Update

    I followed the directions given by mlowery (and JBOSS) in another thread here to update the JBOSSWS to get rid of those pesty and very long wsdl/wsrp exceptions at startup, but the ant script looks...
  32. Replies
    10
    Views
    4,810

    I followed the directions given by mlowery for...

    I followed the directions given by mlowery for our freshly installed Pentaho 1.2.1 GA, but it looked for a jboss-client.jar. There is only a jbossall-client.jar in the installation under...
  33. Replies
    1
    Views
    2,076

    I knew it'd be something easy. You just have to...

    I knew it'd be something easy. You just have to stumble over it! When I added the locale dir to the src\org\pentaho dir, and rebuilt, it worked and I could run the standalone app. The log shows a...
  34. Replies
    1
    Views
    2,076

    pentaho-standalone - can't find bundle

    I downloaded the Pentaho 1.2.1 source and compiled it under NetBeans 5.5.1 with JDK 1.5. Went clean.
    I downloaded the Pentaho Library and created a "Pentaho Library" with the contents of the...
  35. Thread: Shutdown hang

    by rlance
    Replies
    4
    Views
    1,675

    Here you go. I brought up Pentaho's Home page...

    Here you go. I brought up Pentaho's Home page and executed only the "Hello World" solution in my browser. After trying to stop pentaho, I did notice that there were errors from DBConnectionFactory...
  36. Thread: Shutdown hang

    by rlance
    Replies
    4
    Views
    1,675

    I'm having this problem on my WinXP Pro with a...

    I'm having this problem on my WinXP Pro with a freshly installed 1.2.1 Platform using Java 1.5. I did notice that if I didn't actually call up any of the demo's pages in the Browser (MS IE 7), then...
  37. How-to turn off connection pooling in query designer

    Hi,

    The JDBC driver to the proprietary DB we use does not have connection pooling yet. Kettle reports this in its "Feature List" of the driver ("USE_POOLING=N") and can deal with the DB...
  38. Replies
    4
    Views
    2,434

    Hi Julian and the other members looking for...

    Hi Julian and the other members looking for answers here in the thread. Please see my thread starting with "Desperately need...". I got the example I needed at a level I could understand and was...
  39. Will's suggestions were the most useful and I got...

    Will's suggestions were the most useful and I got it to work. The selected value from the secure filter, in our case the company number, can be used in the Pivot view/mdx query, for example in the...
  40. Thanks for the tips, Will. I know about secure...

    Thanks for the tips, Will. I know about secure filters, but never got the {my-selected-value-from-the-filter} to work with mdx. I'll immediately take a look at the two examples you suggest.
  41. Replies
    4
    Views
    2,434

    Hi Julian, I feel you're much to deep or...

    Hi Julian,

    I feel you're much to deep or taking a lot of technical know-how for granted. The PARAMETER()/PARAMREF() functions don't show how, for example, one would parameterize and pass the...
  42. Desperately need example of using secure filter result in MDX query

    We're using Pentaho Analysis 2.2.2. How does one pass the user's chosen value from a secure filter, say a company number, on to an MDX query in an action sequence to filter the result accordingly? ...
  43. You guessed it, Julian. They wrote: >After...

    You guessed it, Julian. They wrote:

    >After looking at it further, we have clarified the problem and understand it
    >better. The problem is actually in the ORDER BY clause. BBj only allows...
  44. Any way to influence internal sql AS-Name or its use?

    Our software supplier replied as follows as I asked about a problem in using their jdbc driver with Mondrian+JPivot. The 5.031, 6.20 and 6.21 references are versions of their product.

    I wrote:...
  45. Here is a sample of using variables in JDBC connection

    This is a real use case of having to dynamically change the JDBC connection string to loop through N companies, where each company would otherwise require a separate JDBC connection string. The...
  46. Replies
    1
    Views
    1,369

    Solution Exchange - Never!

    I have to chuckle as I read the description for the Solution Exchange forum and the "answer" next to it:

    "Share your Pentaho solutions, Mondrian cubes, Kettle transforms and jobs, JFreeReport...
  47. Replies
    4
    Views
    1,833

    Thanks, Gretchen. You're a (christmas) angel!

    Thanks, Gretchen. You're a (christmas) angel!
  48. Replies
    1
    Views
    1,839

    The general forum description vs. use

    Hi,

    The description for the General forum infers that inquiries and comments about the company, its philosophy, vision, etc. are solicited. It's bombarded with everything but that, but it's a...
  49. Replies
    4
    Views
    1,833

    I second it that descending order would be...

    I second it that descending order would be better! Maybe, a selection like the message order within threads under Options would be more appropiate.
  50. Replies
    1
    Views
    1,402

    Here or there for feedback

    Hi,

    The link in the email from Gretchen, sends me to this migration support forum in the test forums for feedback. The link in the header from the test forums though sends me to the old fourms...
Results 1 to 50 of 104
Page 1 of 3 1 2 3
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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