Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    0
    Views
    3,998

    Trying to set up JNDI Datasource

    Having installed Pentaho successfully in the cloud, we are I am now attempting to install it in Linux on my desktop. I am able to get the BI console up and running and access it on the Web, but I am...
  2. Replies
    0
    Views
    2,831

    Trying to find Saiku log

    I've been actively using Saiku today and i'm looking for the saiku.log file "org.apache.log4j.DailyRollingFileAppender..."

    in the file:...
  3. Replies
    2
    Views
    2,313

    Pstollenberger: Error message requested

    this error occurs when you move any dimension to the rows after having moved a measure to the columns area
    IllegalArgumentException:...
  4. Replies
    2
    Views
    2,313

    Saiku query fails sporadically

    doing a query on a cube that has no problems in Jpivot/PUC. i click one dimension into the rows section, and the query works, then i click another, and it fails, getting no results. If i remove that...
  5. as a mondrian newb, I may not be the best person...

    as a mondrian newb, I may not be the best person to try to help because i don't completely understand myself how Mondrian manages connections, but i believe that what you are doing is not fully...
  6. Does this help? ...

    Does this help?
    http://forums.pentaho.com/showthread.php?79495-mondrian.rolap.RolapMemberBase-cannot-be-cast-to-mondrian.rolap.RolapCubeMember
  7. mvbt: The schema below works, (separate...

    mvbt: The schema below works, (separate dimensions for each attribute), i'm now able to see multiple attributes in the OLAP Navigator, thanks so much for all your help!

    I'd still like to see a...
  8. just tried the PropertyName syntax (see below),...

    just tried the PropertyName syntax (see below), still can't see SourceType in the OLAP navigator.

    Also i should say i'm still a bit confused by the schema you cut and paste in the previous post...
  9. Thanks so much!.. i think i'll get there now.....

    Thanks so much!.. i think i'll get there now.. but if you could possibly cut and paste a whole or partial schema using that Property name syntax that would be great

    Also i should say i'm still a...
  10. You are helping me very much, i understand...

    You are helping me very much, i understand Mondrian schemas better and better (Microsoft SSAS background). however i am still confused about something, could you cut and paste your schema into a...
  11. We solved the problem, yes the issue was...

    We solved the problem, yes the issue was datasource was'nt provided correctly.

    Thanks so much for all your help on this!
  12. This reply was very helpful in clarifying the...

    This reply was very helpful in clarifying the conceptual model of Dimensions, Hierarchies, and Levels.

    I have modified my schema and published it to the repository (see below), removing all but...
  13. 1. Very good point about the date dimension, i'll...

    1. Very good point about the date dimension, i'll modify the schema to get a proper date hierarchy

    2. The issue I'm having with OLAP Navigator is that i can't get it to 'see' dimensions (should...
  14. when browsing cube using User console, can only see first level within each dimension

    i have created and published a cube to the repository and am now browsing it using user console. The schema is below. As you can see there are only two dimensions, but each dimension has multiple...
  15. we have solved this problem by having someone...

    we have solved this problem by having someone with Java/linux expertise install the BI server in linux and create the datasource.

    As near as i can tell i had solved the publishing problem in...
  16. Tried restarting BI server (thanks Osmin!), have...

    Tried restarting BI server (thanks Osmin!), have a different symptom now, progress???

    Schema Workbench after 5 seconds of saying ...connecting to Repository, gives Error Message Publish Error:...
  17. thanks! however, i tried that modified...

    thanks! however, i tried that modified publisher_config.xml in that folder to look like below, and used the generic password = password for Publish password, restart Schema Workbench, but still same...
  18. Schema workbench password error when Publishing, how to change repository password?

    I'm using CE 3.7 (Schema workbench) and User Console (for analysis views). I'm trying to publish a cube. i've done this successfully before

    When i click publish, then click ok for the repository...
  19. Replies
    3
    Views
    2,585

    no molap, no writeback. trending has to be done...

    no molap, no writeback. trending has to be done with MDX

    i dont know what the company's plans are.
  20. Just tried refreshing cache with the same result,...

    Just tried refreshing cache with the same result, my schema does'nt show up. Thanks so much for your continued help..., any other ideas?
  21. how do you add new schemas to Analysis Views? any way to navigate to the schema

    i have a new schema called garys_end that i want to show up when I click Analysis View. i've modified datasource.xml to add my cube name (called garys_end) and it still doesnt show up when i click...
  22. i've modified my datasource.xml to add my cube...

    i've modified my datasource.xml to add my cube name (called garys_end) and it still doesnt show up when i click New Analysis View. Could anyone take a quick look at the schema below? dont know about...
  23. This is great! I am now able to see...

    This is great! I am now able to see SteelWheels... HOWEVER, i dont know how to browse to where my schemas are, i dont see any options for browsing. i even tried copying my schema into...
  24. For what its worth, none of the installation...

    For what its worth, none of the installation guides for Jpivot are complete.

    that is my main issue
  25. Replies
    1
    Views
    2,624

    Basic MDX with Mondrian

    i have a pretty simple cube, schema is below. i am only able to get access to Measures in the cube query 1 below. Queries with dimensions don't work . What do i need to understand about how Mondrian...
  26. 1. "Publish your cube and bang away you go". What...

    1. "Publish your cube and bang away you go". What program do i run or URL do i enter? tomcat doesnt have to be run separately? i have expertise in BI but little expertise in installing 3rd party...
  27. Seriously, pls help! there is no tool in Community Edition to browse/navigate cubes!

    if you look at the Community Downloads page (see below), you will find no tools available to do analysis on cubes! Mondrian and Schema Workbench are used to create and publish cubes (please correct...
  28. Advice on how to navigate cubes using Pentaho Community Edition

    Does anyone have a link and installation instructions to the Pentaho tool used to navigate,browse, create calculated members for Mondrian OLAP cubes?

    I have downloaded the jpivot olap tool,...
  29. When Publishing in schema workbench: a schema already exists with the specified name

    Subject: When Publishing, get a schema already exists with the specified name, cant get rid of it!https://na3.salesforce.com/s.gifDescription: Steps:
    file open a schema generated in Analyzer ...
  30. What does table is invalid mean? Please help!!

    I choose my MYSQL fact tables and dimension tables from the drop down menu. Schema workbench can even see the correct columns in each of these tables. So why does schema workbench say Table is...
  31. Table Dim (my dimension table) is invalid trying to get simple functionality to work

    I am trying to test Mondrian’s functionality with a very bare bones dimensional model, consisting of one dimension table (Subscriber related information) and one fact table (Clicks for those...
  32. Replies
    2
    Views
    2,301

    i don't see how since pentaho analysis is rolap...

    i don't see how since pentaho analysis is rolap only, and MS SSAS is MOLAP
  33. What happened to the preferences Option in schema workbench??

    I have installed Pentaho schema workbench version 3.22 and am trying to get started with a simple cube/dimensional model.
    I would like to modify the driverclassname,Connection_URL, Username, and...
  34. this is a new install, it can't seem to find...

    this is a new install, it can't seem to find mysql drivers. Do you have to modify CLASSPATH yourself when doing a Mondrian/schema workbench install?
    Classnotfound exception: org.gjt.mm.mysql.Driver...
  35. a follow up question - fixing a pentaho bug

    This is very helpful. How do i find the specific ticket 3553? also, do you have any thoughts on things i could do to diagnose and fix this problem? for example, do you know which class prepares the...
  36. Can’t get Connection working in Schema workbench, also Mondrian arch questions

    I’m a first time user of Schema workbench, trying to get it to work. I click Options, Then Connection, then enter exactly the same Hostname, databasename, Port number , username and password that...
  37. Q1. are there any guidelines published anywhere...

    Q1. are there any guidelines published anywhere for how to create a pentaho build in java (how to access the source, troubleshoot it, provide fixes)? our shop would like to get involved.

    Q2. How...
  38. Thanks Taqua! Q1. The use case we have here...

    Thanks Taqua!

    Q1. The use case we have here is view the data , drill down and up, then export. Is there a way to do that in Kettle?

    Q2. How does one access pentaho JIRA?
  39. Performance concerns with Pentaho reporting

    I am doing some performance testing of exporting CSV data in PRD. Our users would like to export pretty large volumes of data (possibly even millions) so that they can do analysis in Excel or Access....
  40. David, thanks! , i resolved the problem after...

    David, thanks! , i resolved the problem

    after looking at the stack trace from a print preview i saw that i had limit 25 before the where clause in my sql query which is incorrect
  41. tried curly brackets, getting same symptom...

    tried curly brackets, getting same symptom (unable to initialize report). although at one point i saw 'invalid parameter for this report'

    the value type is integer. i presume that data format is...
  42. First time parameterized report, ‘Unable to initialize report’ in print preview, par

    First time parameterized report, ‘Unable to initialize report’ in print preview, param.prpt attached
    I’m learning PRD, attempting to add a parameter to a simple report that works, I can change...
  43. Replies
    7
    Views
    2,247

    yes that works, thanks!

    yes that works, thanks!
  44. Replies
    7
    Views
    2,247

    that helps .. in part! i can preview data now....

    that helps .. in part! i can preview data now. but when i click ok, the columns still dont appear on the right, so i still can't build a report. How do i save the query so that the columns appear??
  45. Replies
    7
    Views
    2,247

    release is 3.8.0.GA.13698 , screenshot attached

    Taqua - thanks so much for taking a look. the release is 3.8.0 GA 13698

    i've attached a screenshot with OK and preview greyed out , can you see anything i'm missing or any next steps?
  46. Replies
    7
    Views
    2,247

    PRD basics don't work

    Pentaho report designer


    i am creating a new Report, and i am finding that the tool acts differently when i take exactly the same steps.

    Scenario 1: after a datasource is added, new...
  47. Thanks, fixed now! BTW when i click preview...

    Thanks, fixed now!

    BTW when i click preview on the previous step it says 'there are no rows to preview'
  48. No rows read or written in table output step

    I have created a simple Transformation that reads a table from a MYSQL Fact table, does a database lookup into another MYSQL (Dimension) table to get the surrogate key, then writes out the result to...
  49. Exporting to Excel - does 64K record limit still apply?

    In the thread below a limit of export 64K rows is discussed. What are the row count export limits now in 1. PRD? 2. Mondrian? 3. Pentaho analyzer (is this still an enterprise only feature?). are...
  50. data from Data source Doesnt persist in PRD

    When i add a datasource, highlights show for both the connection name and the query name, then preview the data, and click OK, the query is gone, and the columns dont show up in the data tab (next to...
Results 1 to 50 of 54
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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