Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Replies
    1
    Views
    1,369

    Best Solution

    My boss was thinking completely out of the box when he proposed the following solution:
    Piggyback the configuration on another variable at the kettle.properties as follow:

    # SOURCE DATABASE...
  2. Replies
    1
    Views
    1,369

    Configure SSL with Postgresql

    Hi Everyone

    I have been trying to configure SSL with Kettle on a Postgresql connection. There are many articles in the internet in relation to this, however everything points to
    change the...
  3. As a possible solution to this problem, I also...

    As a possible solution to this problem, I also try using captionColumn instead of name column. This solve the problem with the filtering, however it brings the key "column" ids on the results set...
  4. Search only match first element when dimension nameColumn use the same description.

    I have the following level declaration at a Payers dimension hierarchy:

    <Level name="payer" visible="true" column="payor_id" nameColumn="payor_name" ordinalColumn="payor_id" type="String"...
  5. Replies
    5
    Views
    3,811

    I am having the exact same error, except that I...

    I am having the exact same error, except that I am using PDI Ver 5.3.0 It is really hard to believe that there is a limit in the extract. Is there a configuration for in Kettle to allow bigger...
  6. Update Transformation fails when running multiple step copies.

    I have the transformation below that selects records from an intersect query and then update a table. The updates are in the hundreds of thousands .
    ...
  7. Unfortunately the only apparent way to use...

    Unfortunately the only apparent way to use aggregation tables is using the field description at the level column. The problem using the "nameColumn" is that Mondrian use the name column to match the...
  8. This is Mondrian Release 5.0.1.stable.

    This is Mondrian Release 5.0.1.stable.
  9. The solution to this problem is to remove the...

    The solution to this problem is to remove the "nameColumn" from the dimension level if the level is associated as a level at the declared aggregation table. I consider this a big bug on Mondrian,...
  10. Mondrian generates the wrong SQL (SqlTupleReader) when aggregations is called.

    I have a problem when using aggregate tables and querying all members (No Filter) of a dimension level.
    I believe the problem have something to do with the definition of the level column and...
  11. Replies
    4
    Views
    3,250

    I have been looking everywhere for this error and...

    I have been looking everywhere for this error and it seems to be an open bug at the Mondrian engine. I will like to know if there is a fix or work around this problem?
  12. Replies
    4
    Views
    3,250

    Full error stack: ...

    Full error stack:

    location=jdbc:mondrian:Catalog=mondrian:/Charg...
    driver=mondrian.olap4j.MondrianOlap4jDriver
    -- listing properties --
    location=jdbc:mondrian:Catalog=mondrian:/Charg......
  13. Replies
    4
    Views
    3,250

    Thanks MCampbell The MDX is very simple, see...

    Thanks MCampbell

    The MDX is very simple, see below:

    SELECT
    NON EMPTY {Hierarchize({[Measures].[submission_charge_count]})} ON COLUMNS,
    NON EMPTY...
  14. Replies
    4
    Views
    3,250

    NullPointerException

    I am using Mondrian Community edition. I have a cube that contains aggregation tables.
    When adding a dimension and selecting the last level on a dimension hierarchy as part of an MDX query I get a ...
  15. Replies
    0
    Views
    648

    Does Mondrian Support subqueries???

    I have the following MDX query using a subquery approach ...

    SELECT
    NON EMPTY {{[Measures].[totalpayments]}} ON COLUMNS,
    NON EMPTY {[organization_masterentity.bemaster].[master].Members} ON ROWS...
  16. Replies
    7
    Views
    1,633

    Thanks for your feedback Gutlez. The attribute...

    Thanks for your feedback Gutlez.

    The attribute is referenced in multiple documentations, including the "Mondrian In Action (Open source in business analytics)" Book. See the XML schema elements...
  17. Replies
    7
    Views
    1,633

    Thanks for your input Nelson. I know you have to...

    Thanks for your input Nelson. I know you have to define hierarchy->Level, but the question is in relation to the "Attribute" level that accordingly to multiple documentations is the closer thing to...
  18. Replies
    7
    Views
    1,633

    Attribute Level at the schema xml

    I am trying to add dimensions attributes to the Schema Workbench designer (Community Edition) but the tool doesn't allow you add attributes, only Hierarchies. I added the attributes manually as for...
Results 1 to 18 of 18
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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