Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 5 1 2 3 4

Search Forums: Search took 3.72 seconds.

  1. When you setup and test your connection, does...

    When you setup and test your connection, does that work? Do you have the right DB driver in the drivers folder?
  2. If its doing 25 dimensions on the x-axis and 25...

    If its doing 25 dimensions on the x-axis and 25 on the y, yeah. The 400 row count isnt the problem, its the overhead of doing the math once it gets the data (which should be quick)
  3. So if you take 50% of the dimensions out, is it...

    So if you take 50% of the dimensions out, is it 50% faster?

    What is the hardware this is running on? What is the CPU doing during this time? Do you only have 256MB allocated to tomcat?
    ...
  4. then no, I dont think there is a way to start up...

    then no, I dont think there is a way to start up the initial screen with no data. never done that or seen it before.
  5. Your posts would be helpful if you included the...

    Your posts would be helpful if you included the applications you're using. Mondrian isnt a presentation layer, and there are many ways to get after the data.

    Some olap tools allow a blank slate to...
  6. Search the forum first. There have been a few...

    Search the forum first. There have been a few recent issues on setAllTables
  7. A few quick observations - can you put your time...

    A few quick observations - can you put your time dimensions into one dimension with multiple hierarchies?

    The top level of any hierarchy should be unique. I dont know if this has any performance...
  8. Why do you want to build it? What else does it...

    Why do you want to build it? What else does it say when build failed? Have you searched the forums already?
  9. Turn on logging for mondrian and sql - how much...

    Turn on logging for mondrian and sql - how much time is spent in mdx vs sql?

    You have 25 columns? Is this in a property for a level, or you have 25 DB columns equalling levels?

    Post your...
  10. First, why do you want to build it, as there are...

    First, why do you want to build it, as there are numerous compiled downloads available?

    Second, search here.. and if you really can't find your answer....check the pentaho freenode IRC channel,...
  11. Replies
    11
    Views
    2,344

    What does the log say? Do the queries to your...

    What does the log say? Do the queries to your database return values?

    It would be hard to know if there is anything wrong with your schema, as I havent seen it.
  12. Replies
    11
    Views
    2,344

    it is still pointing at mondrianfoodmart - change...

    it is still pointing at mondrianfoodmart - change that. prob in the jsp file.
  13. Replies
    11
    Views
    2,344

    There are samples for jpivot and you should be...

    There are samples for jpivot and you should be able to figure out how to change it... it really isn't supported anymore. Load up Pentaho community edition - you can then setup the datasources per...
  14. Replies
    11
    Views
    2,344

    jpivot, or pentaho analysis

    jpivot, or pentaho analysis
  15. Replies
    4
    Views
    1,672

    Where is the performance bad? Have you analyzed...

    Where is the performance bad? Have you analyzed the SQL mondrian is creating and made sure appropriate indexes are there?

    The docs have a section on performance tuning, have you reviewed that?
    ...
  16. Replies
    11
    Views
    2,344

    You need to create a new OLAP schema that points...

    You need to create a new OLAP schema that points at your own data. The Mondrian documentation on schema is helpful - http://mondrian.pentaho.com/documentation/schema.php

    Or, download Schema...
  17. Replies
    9
    Views
    12,335

    Guess not - looks like it could be jpivot on...

    Guess not - looks like it could be jpivot on steroids... but unsure - why dont you email pentaho? Since EE is a paid product I'm sure they'll be quick to answer. I deal in the open source stuff :-)...
  18. Replies
    1
    Views
    1,809

    In your schema, do you have

    In your schema, do you have <Table name="tablename"/> in each hierarchy? I had this happen to me a while back, not sure if a specific version of schema workbench didnt do it , or the cube worked...
  19. Replies
    7
    Views
    1,983

    Are you using HTTPS or plain HTTP?

    Are you using HTTPS or plain HTTP?
  20. Replies
    4
    Views
    1,422

    Just add another schema XML as a new datasource.

    Just add another schema XML as a new datasource.
  21. Replies
    5
    Views
    2,533

    You can create the schema from any xml file......

    You can create the schema from any xml file... The mondrian documentation outlines it, and with the foodmart sample you could probably write it from scratch.. However, I like schema workbench to get...
  22. Replies
    2
    Views
    6,666

    "PAT" as it sat, is dead. ...

    "PAT" as it sat, is dead.

    http://analytical-labs.com/ is the new shiny.

    regards,

    Mike
  23. Replies
    7
    Views
    1,983

    Does it occur when running the same queries on...

    Does it occur when running the same queries on the server locally?

    What is the server's CPU usage?

    How many users are accessing this?
  24. Floppy disk, USB stick, carrier pigeon? Its just...

    Floppy disk, USB stick, carrier pigeon? Its just a file... What did you try and not have success with??
  25. Replies
    1
    Views
    1,021

    Search the forums - this is asked and answered...

    Search the forums - this is asked and answered almost weekly.
  26. Replies
    1
    Views
    914

    A few questions.. Why is this urgent and you...

    A few questions..
    Why is this urgent and you haven't even built the app yet?
    Why are you building the app rather than using the compiled binaries?
    Why did you enable the log before the app is...
  27. Replies
    5
    Views
    2,533

    The short answer to your question is yes, it is a...

    The short answer to your question is yes, it is a standalone app that does not require any server running.

    What version are you using? What DB? What jars? What OS?

    -Mike
  28. Replies
    1
    Views
    1,027

    It is, if you can do the xml change from your...

    It is, if you can do the xml change from your app.... I'm unaware of anything that will just add a new role into your schema.

    regards,
    Mike
  29. What version is this? What OS?

    What version is this? What OS?
  30. Try putting a slash in front of steel-wheels...

    Try putting a slash in front of steel-wheels
    <Definition>solution:steel-wheels/analysis/SampleData.mondrian.xml</Definition>
    to...
  31. Replies
    7
    Views
    1,983

    Post the relevant pentaho log file. Also, turn...

    Post the relevant pentaho log file. Also, turn on mdx/sql logging for mondrian. Search this forum for a recent how-to on that, it involves modifying log4j.xml

    regards,

    Mike
  32. Replies
    2
    Views
    1,223

    WHERE [DimModTests.DimModTest].137 ?Or are you...

    WHERE [DimModTests.DimModTest].137 ?Or are you trying to filter on a measure here?
  33. Thread: JPivot error

    by mikegreen
    Replies
    1
    Views
    2,043

    What app server? What OS? What version of...

    What app server? What OS? What version of Mondrian? Which package - embedded or standalone?
  34. Replies
    2
    Views
    1,631

    Is your app passing in "1.2345E-8" or the actual...

    Is your app passing in "1.2345E-8" or the actual number for comparison? I'm unclear what this is in the log...

    regards,

    Mike
  35. Replies
    2
    Views
    2,808

    100m rows could be cake walk or could be...

    100m rows could be cake walk or could be impossible task depending on the structure and hardware...
    I switched from mysql to Postgresql as one of our vendors stopped supporting mysql and I wanted...
  36. What version of Mondrian? What ver of Postgre? ...

    What version of Mondrian? What ver of Postgre? Is the right jdbc driver in the right places?

    Is your dialect set to postgres or generic?

    regards,

    Mike
  37. Replies
    1
    Views
    1,060

    As usual here.... plz post your schema and a...

    As usual here.... plz post your schema and a screenshot. It might also help to see the generated SQL mondrian is creating.

    Also - what DB? What ver of Mondrian?

    regards,

    Mike
  38. Turn on all the loggers.. search for log4j.xml on...

    Turn on all the loggers.. search for log4j.xml on this forum and there are instructions to do so.

    There is no magical checklist to troubleshootnig - although there is a sticky on the cryptic...
  39. Replies
    8
    Views
    2,118

    Wait wait wait - your subject says mondrian...

    Wait wait wait - your subject says mondrian 2.3.2... can you confirm what version you are using?
  40. Replies
    8
    Views
    2,118

    If you're not changing anything else it does...

    If you're not changing anything else it does appear to be a bug. I would recommend getting it to a smaller cube to troubleshoot - try just two cubes and see if you still get the strange behavior. ...
  41. Replies
    3
    Views
    1,161

    Country code and country name are the same level...

    Country code and country name are the same level of data... you shouldnt make additional levels for this, but add a property to be displayed along with it.. So you'd add country code to the Country...
  42. Replies
    8
    Views
    2,118

    Odd - if you rearrange your schema to make the...

    Odd - if you rearrange your schema to make the second cube atop the first one, does that work?

    If you remove the first cube from the schema, does the next one work?
  43. Did you name the folder PAT or leave it with the...

    Did you name the folder PAT or leave it with the version? I think it wont work unless its named PAT.

    I always exploded the war on my own, then moved the folder... moving the war into the webapps...
  44. Replies
    4
    Views
    3,027

    Did you resolve this?

    Did you resolve this?
  45. Replies
    1
    Views
    1,411

    If you just browse the Gender dimension, do you...

    If you just browse the Gender dimension, do you see F? Just asking to make sure the data is loaded..
  46. Replies
    2
    Views
    1,240

    Check out the PAT tool - they're working on a...

    Check out the PAT tool - they're working on a rest service as well as some other new cool stuff.

    Find out more on the ##pentaho and ##pentaho.pat IRC channel (on freenode)... the guys hang out...
  47. Thread: mdx query

    by mikegreen
    Replies
    2
    Views
    1,438

    What error are you getting? Posting the log for...

    What error are you getting? Posting the log for the error will help.

    Why are "names" in your measures?
  48. Replies
    2
    Views
    1,360

    I'm unclear what you are trying to do... what do...

    I'm unclear what you are trying to do... what do you mean "select this dimension". Why did you add dimensions for contract_id and account_no rather than make them properties of a dimension?
    ...
  49. alexandredneto - Start a new thread with your...

    alexandredneto -
    Start a new thread with your specific error messages, log, and data sources xml.

    regards,

    Mike
  50. This log indicates a cross join - what is the MDX...

    This log indicates a cross join - what is the MDX are you trying to run?
Results 1 to 50 of 205
Page 1 of 5 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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