Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    1
    Views
    2,593

    Spreadsheet Services

    Hi, I want to try Pentaho Spreadsheet Services with Mondrian 2.3.2

    Anyone know if it works with Excel 2003 or 2007?

    If there isn't an evaluation version I want to buy a license (I know this is...
  2. Replies
    6
    Views
    3,548

    I can't achieve this too

    Hi. I have a shared snowflake time dimension.

    I have a cube wich uses this time dimension aggregated by month, I have specified in dimension usage Level="Month".

    But it doesn't work in a...
  3. Replies
    0
    Views
    1,067

    Problem with snowflake schema granularity

    Hi All.
    Mondrian 2.3.2
    I have a snowflake dimension with 3 levels (and multiple hierarchies).
    I have 2 cubes using this dimension, one of them linked to level 3 and the other one linked to level...
  4. Replies
    14
    Views
    2,560

    Last result

    I have restore the last production backup to the old server, and with the last changes (commit size > 0) there isn't a better performance.

    Both file systems (new server and old server) have ext3...
  5. Replies
    14
    Views
    2,560

    Yes I know it

    But the same ETL in an older machine performs better.
    I think this is SATA disk issue!!!
    By the way I have put the corresponding commit size to each transformation and know the hole process takes...
  6. Replies
    14
    Views
    2,560

    Has the same setup of development

    I leave more memory to the SO, and stop JBoss with the same performance.
    I didn't change the transformation setup, it's the same!!!
    In table output I have Commit size = 0 and checked use batch...
  7. Replies
    14
    Views
    2,560

    I have had Postgres 8.1.9 before I updated to Postgres 8.2.4

    Before I have complain about performance here, I have spent 4 days trying to improve hardware, SO and Postgres.
    With Postgres 8.1.9 I have experience worst performance, then I decided to upgrade to...
  8. Replies
    14
    Views
    2,560

    There isn't a memory problem

    I have stop jboss and I have obtained the same performance.
    When running there are a lot of disk i/o access.
    Doing dstat I see a lot of 1000k to 1200k writes.
    But I don't know how to find if this...
  9. Replies
    14
    Views
    2,560

    I'm testing with no success

    I have found the jobs bottleneck are in insert steps.
    I have a text file input step which puts data in a table output step.
    In the old server it takes 13 seconds and in the new server it takes 40...
  10. Replies
    14
    Views
    2,560

    Maybe it's about memory

    Because I have tunned JBoss and Postgres to use all the memory, there is only 300MB free memory.
    I don't have any error in log messages and develpment and production are running the same jobs and...
  11. Replies
    14
    Views
    2,560

    Weird performance Issue

    Hi all.
    I've been running Kettle 2.4.0 ETL jobs from about 3 or 4 months, las week I set up a new server and nightly run now takes 40 or 50 minutes more.

    My old server (development) is a P4 3.0...
  12. Replies
    9
    Views
    2,646

    Mondrian has Security Holes?

    Hi all, I'm beginning to read about mondrian security and a lot of question came out!!!
    The only way to have security roles is passing throught the connection? I think it's unacceptable in an...
  13. Replies
    4
    Views
    5,115

    Take care about system/BIRT/resources

    With my fix you need to create resources dir insdide pentaho-solutions/system/BIRT!!!

    Ok, I'll will try to give you the files to upgrade to BIRT 2.2 but I have follow this thread instructions...
  14. Replies
    2
    Views
    1,445

    Be carefull when upgrading from 2.4 to 2.5

    Hi all, 2 days ago I upgrade my Kettle from 2.4 to 2.5 (repository upgrade) without problems. But yesterday none of the jobs have worked.
    Then I opened a principal transformation and I see that...
  15. Replies
    3
    Views
    1,474

    HELP!!! I have upgrade to the lastest mondrian with no success

    Is this a bug or am I doing something wrong?
    When I have a parent-child dimension without closure table it only shows me the first leve!!!
    I'm accessing via XMLA!!!
    I need to solve this in some...
  16. Replies
    3
    Views
    1,474

    I'm using Mondrian 2.2

    I saw a bug fix related this issue but I don't know in wich version is corrected!!!
  17. Replies
    3
    Views
    1,474

    I gave up!!! Julian can you help me?

    I have this shared parent-child dimension but it only shows me the first level I can't see children.
    I thought it was an issue of shared dimension but when I put it private has the same behavior!!!...
  18. Replies
    5
    Views
    1,465

    Yes, I didn't realized that without the calculatedmember tag!!!

    I think there is some recursion!!! Can you tell me the levels of the hierarchy of the project dimension?
    And give me the full mdx you are trying to solve?
  19. Replies
    5
    Views
    1,465

    Can you give me more details?

    I don't know what <formula> do!!! It's like a calculated member?
    Can you give me the mdx and explain me what are you trying to do?
    Some explain of schema (dimensions and levels) would ve...
  20. Replies
    5
    Views
    1,465

    Try this

    <Formula>
    Iif([Project].level.name = "Project",
    [Measures].[Calls] * [Project].CurrentMember.Properties("Price"),
    [Measures].[Umsatz Sic]
    )
    </Formula>
  21. Replies
    1
    Views
    894

    Question with mapping

    Hi all
    I don't know if it's an error or it's ok.
    I have a transformation with several database lookups.
    After that I put all lookup values in a table output with a mapping!!!
    But in a lookup...
  22. Replies
    3
    Views
    1,474

    Can I share a parent-child dimension?

    Hi all, I'm using mondrian 2.2
    I have parent-child account dimension which I need to share between 3 cubes and a virtual cube with 3 cubes in 2 of them uses this shared dimension.
    First Approach:...
  23. Thread: BIRT resouces

    by vectorr3
    Replies
    5
    Views
    2,980

    Solved

    It's not perfect but it works!!!!
    http://forums.pentaho.org/showthread.php?goto=newpost&t=55727
  24. Replies
    4
    Views
    5,115

    It works!!!

    Finally it works!!!
    I didn't know that I have to refresh solution repository too!!!
    I could load my library!!!
    Birt 2.2 with resource libraries!!!
    Yeahhhhh

    This is the last file,
    I hope it...
  25. Replies
    4
    Views
    5,115

    Possible solution

    I don't know which version of BIRT has pentaho actually because I put 2.2, but with BIRT 2.1 it should work too.
    In pentaho-solution/system/BIRT I have created a resources directory.
    I have...
  26. Replies
    4
    Views
    5,115

    Birt BIRT_RESOURCE_PATH

    Hi all, I'm trying hard to get my reports to work on pentaho due to pentaho doesn't support birt resource libraries.
    I have upgrade lastet release of PCI to BIRT 2.2 (I have a lot of report with...
  27. Thread: BIRT resouces

    by vectorr3
    Replies
    5
    Views
    2,980

    Is it solved?

    I can't figure out how to configure set BIRT_RESOURCE_PATH!!!
    This is the way I have done in a stand alone application, but I don't know how to do it in pentaho or if it break something else!!!...
  28. Replies
    3
    Views
    2,178

    The last one solved my problem!!!

    I have open the xml and put the ampersand code!!!
    I couldn't make it with alt+185 because I'm using Linux!!!
    Thank yo very much!!!
    Regards
    Agustin
  29. Replies
    0
    Views
    1,229

    Xls JPivot Action

    Hi all.
    I have copied and modified Pivot servlet and make a PivotXls servlet wich returns an Xls file instead of html (the only change is the calling of xls_mdxtable.xsl and I've removed useless...
  30. Replies
    1
    Views
    1,352

    Solution

    Hi, I had have the same issue and I solved doing this!!!

    in pentaho-solutions dir, go to system then quartz

    edit quartz.properties and search

    org.quartz.jobStore.driverDelegateClass =...
  31. Replies
    3
    Views
    2,178

    Text File Input with special char separator

    Hi all, I have a text file with a special char separator ASCII 185. I couldn't find how to put this char in separator property for text file input.
    I can't replace separator because the file isn't...
  32. Pentaho attempt to connect to internet for each click

    Hi, I want to configure pentaho to stop its attempts access to internet. How can I do it?
    In each portal click it attempts connecting!!!
    Thanks in advance
    Agustin
  33. Replies
    0
    Views
    1,522

    Scalability and separate installation

    First of all, sorry my poor English!!!
    Hi, I wanted to know if there is a possibility of add tutorial for separate installation of each component. I have successfull installed mondrian, but I'm...
  34. Replies
    3
    Views
    1,695

    The result returns few rows

    Yes if I put result.limit.rows = 150000 it returns ok. But I insist, I think this is a bug, because cube scheme is just a few rows (I think less than 100) not greater than 50000. Why in Sun...
  35. Replies
    3
    Views
    1,695

    MDSCHEMA_DIMENSIONS Bug?

    Hi, I have installed Mondrian on Sun Application Server without problem and I can query well with XMLA. I have a large dimension with 110000 members.
    Recently I decided to migrate to JBoss, but when...
  36. Replies
    4
    Views
    3,635

    Ok, I undesrtand

    Yes I know that every row must have the same structure, I'm not modifying the row structure, I'm trying to change a field value. I'm teaching databases at University and I know very well relational...
  37. Replies
    4
    Views
    3,635

    Thanks!!!

    Thanks for the answer, but I don't understand what you mean with mixing of rows. I'm trying to replace values for each returned row.
    Sorry but I don't speak English very well and sometimes there is...
  38. Replies
    4
    Views
    3,635

    How to ask row count in javascript step!!!

    Enviroment: Kettle 2.4.0, Java 1.5.0_08, Fedora Core 5.
    Sorry if it's already answered but I didn't find in forums.
    I have a javascript step that looks for a field value and makes a replacement,...
  39. Replies
    13
    Views
    2,574

    Ok, I will try later with new version

    Thank you very much for fixes and for such great tool!!! With help of Kettle we are migrating our ETL process from integration services (SQL Server) to Kettle and we don't miss any feature of it. I...
  40. Replies
    13
    Views
    2,574

    Doesn't work

    I have downloaded lastest jar and I have tested in Windows and Linux but it didn't work. Before entering repository password kettle hang up.

    09:55:46,918 INFO [Spoon] Spoon - Trying to open the...
  41. Replies
    6
    Views
    2,760

    Sorry but

    I thought she asked about fully migration of database, if she talking of moving data from a database to other, yes Kettle is a big help. But if she has to migrate structures, procedures, views,...
  42. Replies
    6
    Views
    2,760

    About migration

    Hi, I'm not an expert in Kettle but I have enough to tell you that Kettle it's an ETL tool, is good to transform data, applying complex calculations, load from different sources and repetitives task....
  43. Replies
    13
    Views
    2,574

    No, mixed setting doesn't work

    Yes I have tried mixed format with same results.
    I can't change file export format because they are used in other systems.

    This is the only solution I have found:
    With a javascript step with...
  44. Replies
    1
    Views
    858

    Bug in log level restoring a job

    Kettle 2.4.0, Postgres 8.1.5, Fedora Core 5, Java 1.5.0_08.
    When you specify Loglevel = Error in a Job a log file for a transformation step this changes are not saved to repository. When you open...
  45. Replies
    13
    Views
    2,574

    Can it be a @nix file type problem?

    I didn't try with DOS file format because I'm working on Linux but I think it can be a trim problem with end of line in @nix files.
  46. Replies
    13
    Views
    2,574

    Bugs

    Ok I have attached example with bug of this issue, the file is bug1.zip and I have attached another file (bug2.zip) of other issue I have found yestarday, it's a bug when you limit records in Text...
  47. Replies
    13
    Views
    2,574

    Use case

    Ok, lets see!!!

    I have to import data from plain text files (we don't have a relational database). Files are csv (@ separated). I have several files with many fields as 30 and the little ones with...
  48. Replies
    13
    Views
    2,574

    I have found a work around!!!

    I have a temporal solution puttin this

    if((fieldname.getValue()).isNull){
    fieldname.setString("NOT DEFINED");
    }

    But I think here is a bug when the last field is empty.
  49. Replies
    13
    Views
    2,574

    Text Input Bug?

    Kettle 2.4.0
    I have a Text Input step with 2 string fields defined (@ separated).
    For the second field I have put Default = NOT DEFINED and Trim Type = both, but and I have an error trying to put...
  50. Replies
    3
    Views
    1,726

    I'v done something similar

    <?xml version='1.0'?>
    <configs>
    <parameters>
    <parameter>
    <category>subjectdatabase</category>
    <name>url</name>
    <description>String de conexion a la base de datos...
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.