Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 5 1 2 3 4

Search Forums: Search took 0.02 seconds; generated 41 minute(s) ago.

  1. Replies
    13
    Views
    15,577

    Hi,Just follow the lines, I'm not sure of what is...

    Hi,Just follow the lines, I'm not sure of what is Pentaho Open BI Suite. I think this might come without database but only scripts to create it. I think you should get the version with the included...
  2. Replies
    6
    Views
    34,330

    Hi,Try WITH SET [myset] AS...

    Hi,Try WITH SET [myset] AS {[Time].[2008].[March].[24]:[Time].[2008].[March].[25]} instead of WITH MEMBER

    a+, =)
    -=Clement=-
  3. Replies
    8
    Views
    3,791

    Hi, Do you successfully run another Pentaho...

    Hi,


    Do you successfully run another Pentaho Cube ?
    If not, following the Quick Start you should be able to do it.
    If yes, tell me

    a+, =)
    -=Clement=-
  4. Thread: Cube error

    by clement
    Replies
    3
    Views
    2,116

    Hi, Do you successfully run another Pentaho...

    Hi,


    Do you successfully run another Pentaho Cube ?
    If not, try to follow the Quick Start to do so.
    If yes, tell me.

    a+, =)
    -=Clément=-
  5. Replies
    5
    Views
    4,896

    Hi, I think that what you are searching...

    Hi,



    I think that what you are searching for is Pentaho Design Studio
    You may find it on http://sourceforge.net Search for Pentaho, open Pentaho Business Intelligence, highlight Download,...
  6. Replies
    5
    Views
    4,896

    You may try to follow this :...

    You may try to follow this :
    http://forums.pentaho.org/showthread.php?t=56531
  7. Replies
    11
    Views
    18,926

    Bonjour, Tu seras peut-être intéressé par la...

    Bonjour,

    Tu seras peut-être intéressé par la lecture de ce document :
    http://switch.dl.sourceforge.net/sourceforge/pentaho/Pentaho_Dashboard_Building-1.5.4.pdf
    (sur sourceforge.net tu tapes...
  8. Hi, On the theorical point of view, you need :...

    Hi,

    On the theorical point of view, you need :
    -an axis Product to do analysis by "single value"
    -an axis Product Category to do analysis by "group of values"
    -a position attribute to do your...
  9. Replies
    13
    Views
    15,577

    Hi, If you see an empty page the cube you made...

    Hi,

    If you see an empty page the cube you made may have been be badly done.
    I updated my Quick Start guide in which there was still some errors and have made it working again.
    If you are not...
  10. Thread: Pentaho Cubes

    by clement
    Replies
    1
    Views
    2,891

    Hi, Cube Designer does not allow to open an...

    Hi,

    Cube Designer does not allow to open an existing Cube.
    Use Workbench to do this.

    To publish a Cube, go where you saved it.
    See that there are 3 files that are the Cube.
    Copy/Paste them...
  11. Replies
    3
    Views
    3,202

    Bonjour, Tu as utilisé quoi comme...

    Bonjour,

    Tu as utilisé quoi comme configuration pour ADS ? Login required=on/off ? Check rights=on/off ?

    a+, =)
    -=Clément=-
  12. Replies
    3
    Views
    3,202

    Bonjour, Quels logiciels utilises-tu (et...

    Bonjour,

    Quels logiciels utilises-tu (et quelles versions) ?
    Pentaho est une suite de différents logiciels et il y a plusieurs logiciels qui peuvent graviter autour d' Advantage Database Server....
  13. Replies
    1
    Views
    2,213

    Bonjour, Quelle version de PDI utilises-tu ?...

    Bonjour,

    Quelle version de PDI utilises-tu ?

    a+, =)
    -=Clément=-
  14. Virtual machine with a Pentaho demo installed on it

    Hi,

    I think this would be great to have a virtual machine on a virtualization server with Pentaho demo installed on it.
    A public access throught the web to this virtual machine would give a very...
  15. Replies
    10
    Views
    8,534

    Hi, StrToSet( "{[Per�*odos...

    Hi,


    StrToSet( "{[Per�*odos Cortes].[Per�*odos Corte Todos].[" +
    CAST([Per�*odos Cosechas].CurrentMember.Lag(-4).Parent.Parent.Name AS STRING) + "].[" +
    CAST([Per�*odos...
  16. Replies
    10
    Views
    8,534

    Hi, In fact, there is an excess ")" in...

    Hi,



    In fact, there is an excess ")" in the CAST code, there is no need to put one before AS if I remember the function specs well.

    a+, =)-
    -=Clément=
  17. Hi, Maybe the first argument is not seen as a...

    Hi,

    Maybe the first argument is not seen as a String by MDX StrToSet Function. I would try
    'StrToSet(CAST([Perêodos Cosechas].[Perêodos Cosechas Todos].[2006].[2do Trim].[Jun] AS...
  18. Replies
    10
    Views
    8,534

    Hi, There seems to be a CAST mdx specific...

    Hi,

    There seems to be a CAST mdx specific function :
    http://mondrian.pentaho.org/api/mondrian/olap/fun/CastFunDef.html
    I think that you could replace CStr() with
    CAST([Per�*odos...
  19. Replies
    8
    Views
    3,819

    Hi, You may need to go further with one...

    Hi,

    You may need to go further with one exemple.You provide ˫® without the correct word so I could not do.If you are able to read binary data from your mysql field, know that ˫® has Unicode 02EB...
  20. Replies
    8
    Views
    3,819

    Hi, As said I would check if my database's...

    Hi,

    As said I would check if my database's charset is ISO-8859-1
    This thread may help you http://forums.pentaho.org/showthread.php?t=27604
    It says to change the encoding in a web.xml parameter....
  21. Replies
    2
    Views
    2,990

    Pentaho Demo Online

    Hi,

    I was wondering why there is no Pentaho Demo Online that could be accessed by anybody who would like to discover Pentaho BI server in few clicks.
    Maybe somebody here have the...
  22. Replies
    13
    Views
    2,559

    Hi, I may be wrong that does not seem to be...

    Hi,


    I may be wrong that does not seem to be a Pentaho question ;)
    A look at wikipedia's crontab article would have answered your question : they are for unix.
    You may search another external...
  23. Hi, I try to make an output as a Fixed width...

    Hi,

    I try to make an output as a Fixed width file with the Text file output step.
    I notice that when using a header, this one won't respect the fixed width configuration made in the Fields tab....
  24. Thread: Efficience

    by clement
    Replies
    5
    Views
    3,053

    Hi, I tried to. Hope this helps. Anyway...

    Hi,



    I tried to.
    Hope this helps.
    Anyway you were cunning to ask here as I subscribe every topic I reply in.

    a+, =)
    -=Clément=-
  25. Hi, I don't know how works the Mondrian Engine...

    Hi,

    I don't know how works the Mondrian Engine but I am almost certain that using a Star Schema instead of a Single Fact Table w/No Dimension Tables will be faster. I see many reasons for this :
    ...
  26. Replies
    4
    Views
    1,670

    Hi, I don't know the answer to these...

    Hi,

    I don't know the answer to these questions.
    I can just give you a workaround to try with.
    It consists in an Add constants step which add a field MyOffset=1 to each rows then a Calculator...
  27. Replies
    4
    Views
    2,069

    Hi, That's when I realize that I...

    Hi,



    That's when I realize that I misunderstood what you meant with "nulls".
    You were talking about 0 above 7 like in 0000007.
    I thought that you wanted to squeeze NULL rows.
    Sorry.

    a+,...
  28. Hi, Have you good or bad news about that...

    Hi,


    Have you good or bad news about that feature ?
    Were you eaten by the forum software monsters ?
    Let us know.

    a+, =)
    -=Clément=-
  29. Replies
    1
    Views
    1,814

    Hi, The Zip file name should not be...

    Hi,


    The Zip file name should not be relative. Use absolute file name instead (that means including path) (eg c:\x1.zip)
    You may specify the file name using the Browse button to do this easily....
  30. Replies
    4
    Views
    1,670

    Hi, Did you try to (...)find out why...

    Hi,



    Did you try to


    (...)find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.database

    like specified in your log ?
  31. Replies
    4
    Views
    2,069

    Hi, Maybe the 00000007 issue may be...

    Hi,



    Maybe the 00000007 issue may be resolved by specifiying a length=1.
    To switch the nulls off you may use a Filter Rows steps with the condition "IS NULL" and link the "false" output to...
  32. Replies
    4
    Views
    1,398

    Hi, Yes, that's what I suggested on...

    Hi,


    Yes, that's what I suggested on dbdesigner fork project forum.
    I have not been using xml files a lot in Kettle but I think It's actually not a Kettle job. Thanks for you ideas.

    a+, =)...
  33. Replies
    4
    Views
    1,398

    Hi, Let's give some more informations. This...

    Hi,

    Let's give some more informations. This first xml file is a 'DBDesigner fork' sourceforge project database model file.The second is from PowerAMC, another database design tool. They are both...
  34. Replies
    4
    Views
    1,398

    xml files structure mapping v3.0.0.GA

    Hi,

    I have 2 xml files with different structures. I would like to map the 2nd's structure on the 1st's one. My idea was to Input both XML, then Table output the 1st one and Edit Mapping between...
  35. Thread: Efficience

    by clement
    Replies
    5
    Views
    3,053

    Hi, I think the first thing to check is your...

    Hi,


    I think the first thing to check is your datawarehouse database architecture. It should be multidimensionnal and you may create index tables.DK

    a+, =)
    -=Clément=-
  36. Replies
    1
    Views
    1,177

    Debugger still available in PDI v3.0.0.GA ?

    Hi,

    Just to be sure, is the debugger supposed to work ?
    I think the debugger has been turned off since 3.0.0.GA's first release.
    Am I wrong ?

    Configuration :
    Windows XP Pro SP2
    Kettle...
  37. Thread: value mapper

    by clement
    Replies
    1
    Views
    3,287

    Hi, You almost asked your question in the...

    Hi,



    You almost asked your question in the right place, try again a little more down, in the Pentaho Data Integration / Kettle forum. ;)

    a+, =)
    -=Clément=-
  38. Thread: Efficience

    by clement
    Replies
    5
    Views
    3,053

    Hi, I don't speak spanish enough to read...

    Hi,




    I don't speak spanish enough to read you, you may ask your question either in english here, or in the spanish internalization forum.
    Thanks,

    a+, =)
    -=Clément=-
  39. Replies
    7
    Views
    1,717

    Hi, Let's start simple, alright ? Create a...

    Hi,

    Let's start simple, alright ?
    Create a New Transformation.
    In this transformation create a Table Input Step and a Table Output Step.
    Make a hope between these two steps.
    You're done. Do...
  40. Hi, Please see the attached file : this...

    Hi,

    Please see the attached file : this transformation generates 5001 rows and send them to a "Sort rows" step with 5000 rows in memory and "pass only unique rows" checked. In 1 second, you should...
  41. Replies
    1
    Views
    1,324

    Hi, I don't think so. You may search / ask...

    Hi,


    I don't think so.
    You may search / ask for this new feature here : http://jira.pentaho.org

    a+, =)
    -=Clément=-
  42. Hi, I have changed 512m to 1024m. I also...

    Hi,

    I have changed 512m to 1024m. I also changed the java io temp directory to a place it does can have it's required 10GB. I changed the pagefile.sys (windows swap file) to be 3.4GB large. I...
  43. Replies
    1
    Views
    1,161

    Hi, Can you check this ? : -file...

    Hi,


    Can you check this ? :
    -file kettle.properties is in C:\Documents and Settings\<your user name>\.kettle\ directory (Windows XP path)
    -your kettle.properties contains lines like this ...
  44. Replies
    12
    Views
    8,198

    Hi, Thanks, this issue is fixed by the...

    Hi,



    Thanks, this issue is fixed by the latest jar http://forums.pentaho.org/images/icons/icon14.gif

    a+, =)
    -=Clément=-
  45. Replies
    2
    Views
    2,454

    Hi, You may have post your question in the...

    Hi,


    You may have post your question in the wrong forum section : it seems to be a Pentaho Analysis (Mondrian) problem.
    Well, try to check your cube xml file, you may find the format attribute...
  46. Hi, I have read somewhere that the -Xms...

    Hi,


    I have read somewhere that the -Xms parameter could be changed to higher value in case of OutOfMemoryError.

    I have only a workaround for you : once the command line window is opened,...
  47. Replies
    12
    Views
    8,198

    Hi, I don't know how to do that. I tried...

    Hi,



    I don't know how to do that. I tried to find some jar files on the forum, and did found but once downloaded I did not manage to know what was their version number/release date. e.g. the...
  48. Java Heap Space OutOfMemoryError in a Sort step

    Hi,

    I have a sort step that stops after reading 97 095 675 lines.
    The error message is :
    2007/11/26 15:03:51 - Sort rows.0 - ERROR (version 3.0.0, build 500 from 2007/11/14 14:59:11) : at...
  49. Replies
    3
    Views
    2,473

    Hi, Your Cube is bad. Note that if you have...

    Hi,


    Your Cube is bad. Note that if you have snowflake schema with the larger groups on the borders cubedesigner will generate unusable xml.


    -add your datasource-ds.xml file in...
  50. Replies
    2
    Views
    2,868

    Hi, I don't think so, you may ask this New...

    Hi,


    I don't think so, you may ask this New Feature on Jira.


    You may try the Get Fields button in XML Input step Fields tab after having set the name of the root Element(s) in Content tab.
    ...
Results 1 to 50 of 216
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.