Hitachi Vantara Pentaho Community Forums

Search Forums:

Type: Posts; User: gonzalo.gatica; Keyword(s):

Search Forums: Search took 0.02 seconds.

  1. thanks for the reply! My problem is that I...

    thanks for the reply! My problem is that I actually can´t see any column longer than 50 characters, besides I can´t actually cut the size of the column, I need all the information.
  2. Hi, did you find any solution for this problem?

    Hi, did you find any solution for this problem?
  3. Replies
    1
    Views
    1,691

    Multi Snapshots ETL

    In the company where we are implementing a BI solution where they have a data base where there is all the information necessary. Every month they take some snapshots of the db to reflect the changes...
  4. Replies
    4
    Views
    972

    I looked at the step-Metric and here is the...

    I looked at the step-Metric and here is the result. If someone could take a look at it and help me.


    4648
  5. Replies
    4
    Views
    972

    Missing rows

    Hi,

    I have executed an ETL which fills my output table with around 86,000 rows. The problem is that I know for a fact that some rows are missing. I executed my ETL once more, and this time...
  6. Replies
    3
    Views
    4,252

    Finally I used Strings, which by the way was very...

    Finally I used Strings, which by the way was very usfeul because CDF uses two columns for georeferencing the points, so it works perfectly with the two columns as strings.
  7. Replies
    6
    Views
    1,267

    Thanks for the help. I got it working already....

    Thanks for the help. I got it working already.

    The solution:

    Used a GetVariable from the JOB section, and then did the trimming and then transfromed the string to Date with select values.
  8. Replies
    6
    Views
    1,267

    Currently I am retrieving the substring with...

    Currently I am retrieving the substring with "Replace In String" or ""Strings Cut". I have A Job where I get variables from command line, then a Transformation where I Set the variables and in...
  9. Replies
    6
    Views
    1,267

    thanks for the quick reply... Actually I have...

    thanks for the quick reply...

    Actually I have managed to get the substring 2009-09-23, but I have NO idea why it doesn't appear in the output. It only appears if I use it as a variable for the...
  10. Replies
    6
    Views
    1,267

    Extract Variable from Command Line

    Hi,

    I am using PDI v 3.2 Stable and I passing an argument through command line via Kitchen.bat.

    This argument is: macropanel_snapshot_2009-09-23

    This argument is the name of the db, but...
  11. Replies
    5
    Views
    1,453

    Yes, I took a look and this could be a solution,...

    Yes, I took a look and this could be a solution, but what I really want is to Group the other results that I am not using. For example to have only:

    2R 2B-------2
    3R 3B-------3
    OTHERS---3
  12. Replies
    5
    Views
    1,453

    Yes, currently I have the information of...

    Yes, currently I have the information of Bathrooms and Beds in different colums, but my problem is that I have no idea how to create the calculated member for "Others" (All minus everything you want...
  13. Replies
    5
    Views
    1,453

    Does anyone know if this is possible and how to...

    Does anyone know if this is possible and how to do it?

    I'll try to explain better.


    Types of Apartments----------------- Quantity Sold
    2R 3B -------------------------------------- 2
    3R 3B ...
  14. Replies
    9
    Views
    1,870

    Thanks Peter, Actually I already did the...

    Thanks Peter, Actually I already did the is_current dimension in my Cube, because the information we are working on, it is important to know if the information is the latest one or not.

    I am very...
  15. Replies
    9
    Views
    1,870

    Thanks, but I dont want to update the fields, I...

    Thanks, but I dont want to update the fields, I want to add a new record with the modified column and a new version.

    It is how Peter said, with the 3.2 version this is posible, but I want to be...
  16. Replies
    9
    Views
    1,870

    Hi, thanks for the help. I downloaded version...

    Hi, thanks for the help. I downloaded version 3.2 and I am currently trying to implement what you advised me. Just a couple of questions:




    1- Do I have to add that new field "is_current"...
  17. Replies
    9
    Views
    1,870

    Currently I am using PDI 3.1. Thanks for the...

    Currently I am using PDI 3.1. Thanks for the quick reply. I will try to do what you told me and come back and tel how it went.

    The thing is that this is the first time I am using Pentaho, and I...
  18. La solucion es bastante mala y facil a la vez. ...

    La solucion es bastante mala y facil a la vez. Creo que debe haber un error del porque no aparece en el AnalysisView.

    Lo unico que tienes que hacer es ir al MDX, y hacer la consulta de la...
  19. Has anyone found a nice solution? I don't like...

    Has anyone found a nice solution? I don't like to rewrite my MDX, besides not all final users know how to do this!
  20. Replies
    2
    Views
    1,808

    Any solution?

    Has anyone found a nice solution for this problem? I know it is as simple as going to the MDX and querying for the VirtualCube, bit I still think that they should appear in the AnalysisView options?
  21. Replies
    9
    Views
    1,870

    Different Versions of Data

    Hi, I am actually using the Lookup/Update transformation for my DW, so this means that I have different versions of the data.

    As it is working right now, and how it should always be, the DW has...
  22. Replies
    5
    Views
    1,453

    Combinations in Mondrian

    Hi, I am working in a project where buildings and their characteristics are involved, for example:

    1 Room 2 Bath; 2 Room 2 Bath; 2 Room 3 Bath....etc (and several other combinations).

    I want...
  23. Replies
    9
    Views
    1,857

    problem

    I couldnt finf any solution. The only thing you can do is using the second set in a subreport. Every report can have only one dataset. They should improve this
  24. Replies
    1
    Views
    1,399

    Removing Ad-Hoc

    Hi,

    I've recently created some Ad-Hoc Reportin using Metadata Editor, and publishing it to my solution, creating a metadata.xmi. Everything works perfect, but when I click NEW REPORT in my web...
  25. Replies
    3
    Views
    4,252

    Thanks...for the quick reply. Hopefully PDI...

    Thanks...for the quick reply. Hopefully PDI could do this soon!
  26. Replies
    3
    Views
    4,252

    POINT data type in postgres

    Hi,

    I have a column in my postgres DB, that has the data type of point (-33.4213126,-70.6607933) which will be used to show some information in Google Maps. I wanted to know how to populate these...
  27. Replies
    9
    Views
    1,857

    solution

    Hi, how did you solve this probelm? I have the same issue! Please help
  28. Replies
    1
    Views
    977

    HI, I am haaving the same problem. Did you find...

    HI, I am haaving the same problem. Did you find any answer for this problem? Hope you can help me out.
  29. Replies
    5
    Views
    2,048

    Hi acbonnemaison, Is there any chance you...

    Hi acbonnemaison,

    Is there any chance you could help me out in writing the script that you mentioned below. I am really new at this of scripting and have very little idea on how to check the...
  30. Replies
    4
    Views
    1,206

    I am working in Linux Ubuntu! sorry, I forgot to...

    I am working in Linux Ubuntu! sorry, I forgot to point my OS out!
  31. Replies
    4
    Views
    1,206

    yes matt, thanks for the link. I had seen that...

    yes matt, thanks for the link. I had seen that before, but my question is another. How do I get these error codes? How can I know wich one was thrown?
  32. Replies
    4
    Views
    1,206

    Getting Kitchen/Pan Error Codes

    Hi, I've been looking around and haven't seen any answers to the following question:

    Once executing a command through Kitchen or Pan, how can I obtain the Error Codes?

    I want to do this...
Results 1 to 32 of 32
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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