Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.03 seconds.

  1. That is just messed up! But, I suppose versions...

    That is just messed up! But, I suppose versions less than 1 deserve to have some disturbing simple issues.

    Done it, works fine.
  2. Replies
    3
    Views
    2,610

    but which version should we opt for? For the demo...

    but which version should we opt for? For the demo install.
  3. Replies
    4
    Views
    3,783

    it is just totally hosed and has been for several...

    it is just totally hosed and has been for several months. I think it is dead for the time being.
  4. Replies
    4
    Views
    3,783

    is cube builder dead?

    The cube builder has been in version 0.7.0 for quite sometime now, my own download file has a date of 10/26/2006. This version of the cube builder, for many, was broken upon arrival and never...
  5. cube designer 2.2? I only see version 0.7 on the...

    cube designer 2.2? I only see version 0.7 on the download latest tab.... am I missing something?
  6. Replies
    2
    Views
    4,603

    There is also jRubik, but I don't think you can...

    There is also jRubik, but I don't think you can get rex or jrubik up and running against the pentaho demo server due to the lack of XMLA url.... you need a standalone mondrian install in order to do...
  7. I get exactly the same freeze with a super simple...

    I get exactly the same freeze with a super simple cube defintion, so simple it would do anything anyway...

    1 fact table, with one key (but not a foriegn key though, my warehouses dont have FK...
  8. Replies
    6
    Views
    1,345

    Okay, I rebuilt as per tip #5, but it still doe...

    Okay, I rebuilt as per tip #5, but it still doe snot work. The error message in chef is along the lines of "expected 1 value, received at least 2"....

    Which is a case "well yes, I am trying to...
  9. Replies
    6
    Views
    1,345

    Here is a word document with a screen shot of...

    Here is a word document with a screen shot of both transforms and my job.
  10. Replies
    6
    Views
    1,345

    kettle version 2.3.1 Tip #5 is not quite the...

    kettle version 2.3.1

    Tip #5 is not quite the same. It uses a set variable step to carry one value from one job into a second. I have 8 records and thus, I think, I need to use the copy results to...
  11. Replies
    6
    Views
    1,345

    get rows from result and chef issue?

    I have two transforms connected in Chef.

    Transform 1 consists of a quick table input and "copy rows to results".

    Transform 2 consists of "get rows from results" (PBTNAME) and connects to a...
  12. Or: job 1 - get table names from reference...

    Or:

    job 1 -
    get table names from reference table, copy results to rows

    job 2
    get results from rows (variable mytablename) and get table input with SELECT * FROM ${mytablename}

    CHEF has...
  13. That makes sense, but I must be doing something...

    That makes sense, but I must be doing something wrong, still. Do you use this in one of the examples?

    What I have is:
    1) table input - get partitioned table names from reference table
    connect to...
  14. That would likely explain it then. But that also...

    That would likely explain it then. But that also screws my idea about having a single table input object do a select * from 8 individual tables.....

    I have a physical partitioned table source...
  15. I must be dumb. Set Variable has the following...

    I must be dumb.

    Set Variable has the following columns #, field name, variable name, variable scope type. If I have
    1, my.table.name, FRED
    or
    1, FRED, my.table.name

    With a table input of...
  16. Replies
    1
    Views
    10,385

    getting a column value from previous row

    I have tried various combinations of getName and X.getInteger in the code below in order to get a value of a column from the previous row through the JS transform. But I keep getting an "undefined"...
  17. analysis reports not running in background

    when I test the background execution of analysis reports all I get upon their completion is a page syaing "action successful" and then the MDX that would have been used.

    windows xp. using the...
  18. Replies
    2
    Views
    1,405

    Re:growth and opportunities of pentaho?

    I also use it monitor the clients I work at with respect to the growth of their team or the end of the engagement.... (i.e. if they are hiring but not telling you, they might be aiming to end the...
  19. Replies
    6
    Views
    5,250

    Re:Mondrian Cube Designer

    Yep, a feature list would be great. The builder being a part of the free non-professional would be even better.... but I suppose that $90 is not that much..... or did I misread it and it is actually...
  20. Replies
    2
    Views
    1,405

    growth and opportunities of pentaho?

    as a consultant, I tend to use sites such as monster, dice and hotjobs as a guage of how important a particular skillset is. Just because industry pundits and vendors are hyping particular toolsets,...
  21. Replies
    2
    Views
    2,242

    Re:window 1.2 RC2 - no start_pentaho.bat

    Strange, the zip I downloaded from EasyNews or whatever in Phoenix, was incomplete by just a few files. I re-DLd this morning and all is fine.

    I think this was likely due to my wifi dropping the...
  22. Replies
    2
    Views
    1,466

    Re:missong metadata component?

    Actually, it is the business and technical metadata about the warehouse as opposed to a centralized metadata store for the pentaho platform I am interested in.

    I fully understand the value of a...
  23. Replies
    2
    Views
    1,466

    missong metadata component?

    You know, we might be missing something from the pentaho platform in the form of a metadata tool that we can use to store all the meatadata (obviously) with respect to the data we use in our...
  24. Replies
    2
    Views
    2,242

    window 1.2 RC2 - no start_pentaho.bat

    Which makes starting the demo a little on the hard side.

    stop_pentaho.bat is also missing.
  25. footer on analysis demo not scrolling properly

    Just downloaded and set up the 1.1.7 demo installation and tried the analysis demo. When drilling on "all positions" or indeed any of the rows that will cause the page length to be greater than the...
  26. Replies
    1
    Views
    1,518

    Re:MDX issue with JPivot?

    Can calculated members, specifically measures, not be used in the where clause of MDX?

    The following works:
    with member [Measures].[Average Price] as '([Measures].[Sales] / [Measures].[#...
  27. Replies
    1
    Views
    1,518

    MDX issue with JPivot?

    The followin MDX works with REX warehouse explorer, but fails within pentaho.

    WITH MEMBER [Measures].[Average Price] as '([Measures].[Sales] / [Measures].[# Units])'
    select NON EMPTY...
  28. Replies
    6
    Views
    5,106

    Re:editing jpivot mdx fails

    The following edit works:

    select NON EMPTY {[Calendar.Calendar].[Quarter].[2003 Q1]:[Calendar].[Quarter].[2004 Q1]} ON COLUMNS,
    NON EMPTY {[Products.Products].[All Products].Children} ON ROWS...
  29. Replies
    6
    Views
    5,106

    Re:editing jpivot mdx fails

    I don't think it is my cube defintion that is wrong, it certainly appears to be something within JPivot / Mondrian. For exmaple, the following MDX is displayed by JPivot within the browser:

    select...
  30. Replies
    6
    Views
    5,106

    editing jpivot mdx fails

    Similar to another post I left:

    If I use JPivot to drill to a particular level within my cube, say with 3 metrics displayed on the columns. Click on the MDX icon in order to view the generated MDX...
  31. Replies
    0
    Views
    1,232

    JPivot gen'd MDX fails in XAction

    If I copy the following MDX from JPivot and paste it into an XAction:

    select NON EMPTY {[Measures].[Sales], [Measures].[# Units]} ON COLUMNS,
    NON EMPTY Crossjoin({[Calendar.Calendar].[All...
  32. Re:Trouble with Analysis Examples - Slice and Dice

    PMML = predictive modelling markup language, or in laymans terms XML for defining data mining algorithms.

    As for mondrian - I know squat currently. I am expert in other enterprise class BI tools...
  33. Re:Trouble with Analysis Examples - Slice and Dice

    No, teeny-tiny DW really, just slightly poor SQL running against a slightly poor database on my laptop with everything else. Performance is not my interest at this time, I am focusing on the...
  34. Re:Trouble with Analysis Examples - Slice and Dice

    Is there a session timeout or similar that could cause this page is not accessible error?

    I receive it when I drill following a slow query (35 minutes say) or similar. The drill which caused the...
  35. Replies
    1
    Views
    2,009

    Alias problems in snowflake dimension

    This does not make sens to me: I have a four level dimension in a snowflake dimensions. When building the schema at first and defining the three joins, I took RIGHTALIAS to mean the smaller, higher...
  36. Replies
    4
    Views
    2,500

    Re:good schema, good SQL, still fails

    Does Mondrian not support using the same integer based column for both ID and DESCRIPTION fields?

    Damn. That is annoying.

    FIX confirmed.

    Post edited by: andydempsey, at: 05/16/2006 19:06
  37. Replies
    4
    Views
    2,500

    Re:good schema, good SQL, still fails

    server log
    http://forums.pentaho.org/archived_att/files/Tutorial1.server.log

    Post edited by: andydempsey, at: 05/16/2006 17:12
  38. Replies
    4
    Views
    2,500

    good schema, good SQL, still fails

    I have what appears to be a good schema and what appears to be good SQL generated by mondrian, yet I am receiving a "trouble rending table01" error message.

    Attached are both the server.log and...
  39. Replies
    1
    Views
    2,127

    mondrian/xmla url

    Is there an "mondrian/xmla" url available that will allow REX (warehouse explorer, sourceforge) to be able to browse existing schemas (and help me write MDX!).

    Or will I need to set up a separate...
  40. Replies
    8
    Views
    7,477

    Re:assert failed with mondrian xaction

    The members are actually unique, as the DW is built as per Ralph Kimball - each month in the entire calendar has it's own integer based ID (surrogate key, non-intelligent).
  41. Replies
    8
    Views
    7,477

    Re:assert failed with mondrian xaction

    my schema has changed to....

    ?xml version="1.0" encoding="UTF-8"?>
    Schema name="MSTR_TUTORIAL">
    Dimension name="Product">
    Hierarchy allMemberName="All Products" hasAll="true">
    ...
  42. Replies
    8
    Views
    7,477

    assert failed with mondrian xaction

    I have the following MDX query in my xaction (for JPivot):

    select NON EMPTY {[Measures].[Units Received], [Measures].[Month Duration]} ON columns, NON EMPTY {([Product].[All Products],...
  43. Replies
    2
    Views
    3,843

    Re:How much does BI related work pay?

    I agree. I have been in BI for over a decade, both as a full time employee and as a consultant for a vendor and now a consultant for a independant services firm.

    It may be a niche currently, but...
  44. Re:cannot parse traffic lighting in a JFreeReport

    Removal of decimals works.
  45. Replies
    6
    Views
    5,042

    Re:DataSource Connection to MySql

    PCI 1.1.5.262

    I have the same issue, but I do not have my JNDI source within the mondrian.xml file, it is within the xaction file.

    Changing the JNDI entry in the xaction file to java:datasource...
  46. Re:cannot parse traffic lighting in a JFreeReport

    That would help, wouldn't it?

    All the latest and greatest stuff from 1.1.5. Specifically 1.1.5.190 for the RDW and 1.1.5.262 for the PCI.
  47. cannot parse traffic lighting in a JFreeReport

    I get the following error message when I try to execute an xaction (published from the report wizard) of:

    JFreeReport.ERROR_0007 - Could not parse report samples\\Andrews Play Area\\Tutorial...
  48. Replies
    4
    Views
    4,952

    JPivot input xml for xaction

    Is there any documentation with respect to the various tags available to JPivot when creating an xaction with a mondrian data source?
  49. Replies
    0
    Views
    1,968

    where do I find...

    The files and folders that relate to:

    #1 the home page, so that I can introduce my own section.
    #2 the current portal link, so that I can start creating my own layout.
  50. Replies
    3
    Views
    2,139

    Re:Saving Report

    Same issue here. However I can publish the report to a selected folder, but trying to open the resulting XML file gives a null pointer exception.
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.