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

Search Forums:

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

Page 1 of 3 1 2 3

Search Forums: Search took 0.08 seconds.

  1. We have added a dialect specific to RedShift...

    We have added a dialect specific to RedShift inside of Mondrian over a year ago. You can use postgres driver to connect to RedShift. Let us know if you find any issues.
  2. Try this for inspiration. This is an example...

    Try this for inspiration. This is an example servlet which provides olap4j connections to the DefaultXmlaServlet super-class.
    ...
  3. Replies
    3
    Views
    379

    Have you tried upgrading Mondrian and olap4j...

    Have you tried upgrading Mondrian and olap4j only? I think that APIs are still the same, so in theory it should work. I might be forgetting something though, so give it a try, run a bunch of queries...
  4. This should be fixed now.

    This should be fixed now.
  5. Replies
    2
    Views
    1,258

    There were a couple things to customize in our...

    There were a couple things to customize in our dialecting classes to support RedShift. They were checked into our main codeline, and was only recently backported to 3.5.X. It should appear in our...
  6. Mondrian does not support SQL queries coming from...

    Mondrian does not support SQL queries coming from the user. It generates SQL to answer queries expressed in MDX.
  7. Replies
    3
    Views
    661

    Please put all this information in a Jira ticket...

    Please put all this information in a Jira ticket and we will check it out.

    http://jira.pentaho.com
  8. Mondrian doesn't let you define the TTL of cached...

    Mondrian doesn't let you define the TTL of cached elements. The JVM's garbage collector maintains this for us.

    If you are thinking about "cell" cache (as opposed to members caches) you can...
  9. When you create the CacheControl object, pass a...

    When you create the CacheControl object, pass a PrintWriter as the parameter and paste here what you get. This will help debug.
  10. Replies
    2
    Views
    787

    Search for the MDX function CurrentDateMember....

    Search for the MDX function CurrentDateMember. This how-to might help.
  11. Replies
    1
    Views
    539

    You will need to file a Jira case...

    You will need to file a Jira case to get things moving. This forum is for Mondrian only.
  12. Please post a full stack trace along with a...

    Please post a full stack trace along with a schema snippet.
  13. Looks like you have a version of olap4j that...

    Looks like you have a version of olap4j that doesn't work with your version of Mondrian. What are the exact version numbers you are using?

    Also, I'd recommend using ant to load foodmart. Create a...
  14. Replies
    4
    Views
    557

    To understand why the DTDs are not exactly...

    To understand why the DTDs are not exactly "valid", I suggest that you consult this email thread on the subject. It is recent. In a nutshell, we can't generate DTDs which represent inheritance of...
  15. If by "final query" you mean the loading of the...

    If by "final query" you mean the loading of the cells (in the logs, this shows up as Segment.load: [sql]") then I suggest you take that particular SQL query and run in your DB and profile it. You...
  16. Replies
    4
    Views
    557

    We use concept inheritance when we define...

    We use concept inheritance when we define Mondrian schemas, so a Table element happens to be a RelationOrJoin subclass. We generate those DTDs automatically and I don't think that our generation tool...
  17. Replies
    1
    Views
    1,091

    Try this. Connection connection; ...

    Try this.



    Connection connection;
    CacheControl cacheControl = connection.getCacheControl(null);
    for (Cube cube : connection.getSchema().getCubes()) {
    cacheControl.flush(
    ...
  18. Have you turned on the role mapper in the BI...

    Have you turned on the role mapper in the BI server config?

    ref: http://infocenter.pentaho.com/help/index.jsp?topic=%2Fsecurity_guide%2Fconcept_using_role_mapping_mondrian.html
  19. One of the pieces of this stack is caching it....

    One of the pieces of this stack is caching it. You have to ask the people at SpagoBI.
  20. Would you mind attaching the full logs and the...

    Would you mind attaching the full logs and the complete offending query?
  21. Replies
    2
    Views
    796

    ditto.

    ditto.
  22. Replies
    1
    Views
    631

    To pool Mondrian connection, you should use...

    To pool Mondrian connection, you should use olap4j. Connections created through olap4j are JDBC compatible and can be pooled.
  23. Replies
    1
    Views
    1,130

    AFAIK, no one has ever used Mondrian directly...

    AFAIK, no one has ever used Mondrian directly through Excel. Excel does not support XMLA directly. You have to use a XMLA/DBO bridge between the two.
  24. Replies
    3
    Views
    673

    Drillthrough cannot work in REX because they...

    Drillthrough cannot work in REX because they hardcoded the data format it requires as part of the XMLA payload.
  25. You can't use non-collapsed levels because you...

    You can't use non-collapsed levels because you are using a single table for your dimension. This feature only works with snowflaked dimensions, or else the join will create a carthesian product.
    ...
  26. Replies
    5
    Views
    914

    You've probably put a library in there that you...

    You've probably put a library in there that you shouldn't have. Remove all retroweaver libraries and all builds of Mondrian marked for JDK 1.4 (it should be called something like mondrian-jdk14.jar...
  27. Replies
    2
    Views
    1,048

    This is the XML equivalent:

    This is the XML equivalent:



    <appender name="MDXLOG" class="org.apache.log4j.RollingFileAppender">
    <param name="File" value="mdx.log"/>
    <param name="Append" value="false"/>
    ...
  28. Try this example to load foodmart in HSQLDB. ...

    Try this example to load foodmart in HSQLDB.

    - Stick the following properties in a file called mondrian.properties at the root of the project:
    ...
  29. Replies
    14
    Views
    2,671

    I don't think CDC ever worked without the BA...

    I don't think CDC ever worked without the BA server. You should contact the makers of the plugin @ WebDetails.
  30. Replies
    14
    Views
    2,671

    Pentaho has a "enterprise ready" implementation...

    Pentaho has a "enterprise ready" implementation that we do support. There is also a community project called Community Distributed Cache ( http://cdc.webdetails.org/ )

    To implement your own...
  31. Replies
    4
    Views
    915

    This is fixed in our next release. Stay tuned for...

    This is fixed in our next release. Stay tuned for 3.5.0.
  32. I don't think JPivot ever supported the...

    I don't think JPivot ever supported the visibility (or lack of) of the levels. You will need to contact the people developing JPivot.

    Please also note that Pentaho isn't supporting JPivot anymore...
  33. I could also present the use case we have worked...

    I could also present the use case we have worked on with Yahoo. Mondrian underwent a major architectural overhaul to extend its scaling capabilities. I can elaborate on these enhancements and how...
  34. Replies
    14
    Views
    2,671

    It is on CI at...

    It is on CI at http://ci.pentaho.com/view/Analysis/job/mondrian-git/lastSuccessfulBuild/artifact/

    You can also grab it off from Pentaho's maven repo under pentaho:mondrian:TRUNK-SNAPSHOT.

    ...
  35. Replies
    14
    Views
    2,671

    Your issues was logged as...

    Your issues was logged as http://jira.pentaho.com/browse/MONDRIAN-1209

    It was also fixed and will be part of the 4.8.0 suite release.
  36. Replies
    3
    Views
    1,154

    If you get a 405, then you're very close to...

    If you get a 405, then you're very close to success. Try using Warehouse Explorer.

    http://sourceforge.net/projects/whex/
  37. Can you share your full batch script that you use...

    Can you share your full batch script that you use to launch the loader?
  38. Jans, this thread was created by 'ronin'. It is...

    Jans, this thread was created by 'ronin'. It is rude to hijack's someone's thread with your own issues. Please create your own forum thread and we will gladly help you.
  39. You should use level properties. (...

    You should use level properties. ( http://mondrian.pentaho.com/documentation/schema.php#Member_properties )

    But first, you will need to modify your schema so that the hierarchy is based on a view...
  40. Replies
    14
    Views
    2,671

    You are right. This might be the cause. Please...

    You are right. This might be the cause. Please log a Jira case at http://jira.pentaho.com and link it to this forum post. Our project managers will look at it, prioritize and assign ASAP.
  41. You could create 3 hierarchies within the same...

    You could create 3 hierarchies within the same dimension.

    Alternatively, if you are using Pentaho Analyzer, you can define "business groups". They are roughly equal to groups for the UI.
    ...
  42. Replies
    4
    Views
    1,303

    What tests have you performed? Can you turn on...

    What tests have you performed? Can you turn on debugging infos and share your logs?
  43. Replies
    2
    Views
    818

    Did you define a JDBC connection? Did you press...

    Did you define a JDBC connection? Did you press the "connect" button?
  44. Julian and I would like to present the Mondrian 4...

    Julian and I would like to present the Mondrian 4 BETA program. This would be a flash talk.
  45. Replies
    1
    Views
    814

    Mondrian's only parameter regarding case...

    Mondrian's only parameter regarding case sensitivity is related to the MDX parser. Besides that, it shouldn't tamper with the case used in the schema. If you can reproduce a case where Mondrian...
  46. Replies
    1
    Views
    2,047

    Switch the connection type to Generic JDBC. From...

    Switch the connection type to Generic JDBC. From there you can pass any arbitrary JDBC url, including the one required for MongoDB.
  47. Replies
    1
    Views
    1,426

    http://forums.pentaho.com/showthread.php?95951-Acc...

    http://forums.pentaho.com/showthread.php?95951-Access-Control-Mondrian-One-To-One-UserRoleMapper
  48. The message is clear enough. Your user doesn't...

    The message is clear enough. Your user doesn't belong to any roles defined in the schema. One way to work around this is to add the default role in the BI platform, "Authenticated". Add a role to...
  49. Replies
    2
    Views
    1,223

    Since you are already using the localizing schema...

    Since you are already using the localizing schema processor, you are just a stone throw away from getting this working. The processor is really only a simple key/value substitutor. If you create a...
  50. Replies
    4
    Views
    1,675

    Mondrian doesn't support semi-additive measures...

    Mondrian doesn't support semi-additive measures for the time being. It is currently scheduled on our post 4.0 roadmap. You can track the issue here:

    http://jira.pentaho.com/browse/MONDRIAN-962
Results 1 to 50 of 142
Page 1 of 3 1 2 3