Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 10 1 2 3 4

Search Forums: Search took 0.03 seconds.

  1. Spoon Step to read a file's custom properties

    Hi All,

    I using the "Get File Names" step, to extract the filenames of a certain Folder/Subfolder. I would like to further "filter" the existing files, based upon each file's "Custom Properties"....
  2. Replies
    2
    Views
    8,229

    Hola... Ojalá sea oportuno... En Pentaho PDI,...

    Hola... Ojalá sea oportuno...

    En Pentaho PDI, los drivers de conexión a las diversas BDD se ubican en (en mi caso...): C:\Pentaho\data-integration\libext\JDBC.

    Si aquello no funciona, tal vez...
  3. Any ideas on how to go about correcting the...

    Any ideas on how to go about correcting the alignment problem? The work-around of locking all crosstab reports to use pdf as output does really defeat the purpose of using html...

    Many thanks for...
  4. Many Thanks Taqua.... your example did in fact...

    Many Thanks Taqua.... your example did in fact solve my problem... Maybe you can find some time to provide or direct me where I could find an example of a multi-selection parameter.

    In...
  5. Problem setting an "All" Parameter in Filter Query

    Hi,

    I am trying to do something similar, but can't get it to work.

    Enclosed test report. The parameter is nor being accepted.

    The data of the dim_lines_of_business table is:
    ...
  6. Crostabs in PRD-3.9.0: HTML Alignment Problem

    Hi All,

    I am building a Crosstab using an MDX Query (Denormalized). When previewing on-screen as well as in PDF, all columns duely aligned; however the preview of the same report using HTML, shows...
  7. PRD Trunk 4.0 - Column/Cell Alignment Crosstab

    Hi All / Taqua,

    I was trying the 4.0 trunk for the new crosstab functionality. Alignment difficulties still persist. I am guessing it my not understanding how PRD distributes the content. Taqua,...
  8. Hi Thomas... I am running into a similar...

    Hi Thomas...

    I am running into a similar problem. Please see image enclosed. Can you advise where I can correct the incorrect encoding?

    8934

    Many thansk and kind regards
  9. Replies
    2
    Views
    3,392

    Hi SAVe, Just say your reply... can you...

    Hi SAVe,

    Just say your reply... can you provide a similar example to be used considering MS SQL Server 2008, where one has DB names and Schemas (ie. dbo)?

    Many thanks and kind regards, DMurray3
  10. Dimensions and fact tables in different Schemas/Catalogues - MS Sql Server

    Hi All,

    Sorry for what may be a newbie question...

    I have been requested to to build a mondrian schema considering dimensions and fact tables located on the same server, same catalogue (ie....
  11. Hi Slawo, You hit the problem right on the...

    Hi Slawo,

    You hit the problem right on the button.... Using the streaming cursor on my "mysql" coonection worked like a charm, with no need to change jdbc connector!!.

    I followed your...
  12. Kettle 4.2.0 Stable: Table Input does full table read

    Hi all,

    I am working with a large census data set (+/- 14.9 millon rows by 103 columns of varibale data type columns) in MySql which I managed to upload and transform from a text file. The large...
  13. Problem getting data from MS SQL Server Table with PDI 4.2

    Hi All,

    I am using PDI 4.2 against MS SQL Server 2008 R2.

    I transported a number of large text file to tables in Sql Server, and everytime I try to preview using a Table Input step against any...
  14. Replies
    2
    Views
    1,086

    Partial Apologies

    Hi Matt..

    I was finally able to get the Analyzer working, but not automatically from the right-click on Table Output step in a transformation (as shown in referenced youtube video).

    Ranther, I...
  15. Replies
    2
    Views
    1,086

    PDI 4.2 ce - Agile BI Perspective Problems

    Hi All,

    I am tring to get the Analyze / ReportWizard to work against a mysql table I already have.

    I start a new transformation and include the corresponding table input step (TI) and preview...
  16. AgileBi Analyzer Crashing in PDI 4.2 stabe

    Hi all,

    I have tried to use the Agile BI Analyzer component, against a table output step as indicated in various video tutorials.

    When doing so Analyzer is crashing with the following message:...
  17. Replies
    4
    Views
    2,015

    Excel Input Step: xlsx files too

    Great news Matt... the step works like a charm.... Kind regards.
  18. Mondrian in PRD 3.6.0GA Doesn't like Latin Characters - Stack Trace Provided

    Hi Tomas Morgner... and All PRD users....

    Reference is made to http://forums.pentaho.com/showthread.php?79016-Mondrian-in-PRD-3.6.0-GA-does-not-like-Latin-Characters..Please-Help&highlight=,...
  19. Mondrian in PRD 3.6.0 GA does not like Latin Characters..Please Help - Stack Traces

    Hi Tomas... Sorry for delay in getting back on the reported problem.

    Enclosed, please find the schema I am using, as well as images of the MDX statements that work correctly in JPivot, which are...
  20. Thank you Tomas... I confirm my MDX works...

    Thank you Tomas...

    I confirm my MDX works perfectly in JPivot and SchemaWorkbench (PSW); not son in PRD, so the problem is in the report.

    The error (in one of the cases) plainly says "...the Ñ...
  21. Mondrian in PRD 3.6.0 GA does not like Latin Characters..Please Help

    Hi All,

    I have been building reports that use Pentaho Analysis - OLAP queries. Everything is fine just as long as no "latin-characters" (é, ñ... and the like) are involved.

    I am using PRD...
  22. Some clarification on the "Drill Down" you recommend

    Hi microdisney,
    Understanding how to do it via the "links", is there any way to have the "expanded" details on the same report rather that having the details generated in a separate window (display...
  23. Replies
    2
    Views
    1,692

    May I suggest you take a look at Kimballs...

    May I suggest you take a look at Kimballs DataWarehouse Toolkit pages 199 thru 121 for some insights on handling MultiCurrency Fact tables.

    HTH, DMurray3
  24. Problem running a "Run All Trasnformations" Job

    Hi all,

    I am having trouble runninmg a "Run all transforms..", following the job contained in the 'samples' directory. I am using PDI 4.0 on Windows.

    I am enclosing the job I have constructed....
  25. Replies
    0
    Views
    760

    Re: Kettle 4.0 - LucibDbStreamingLoader

    Hi Matt and All..

    Congrats on 4.0... !!! (Still using "CE") Looks interesting....

    Reference is made to a thread I posted...
  26. Reports published to BI Server - Visible Quality

    Hi all,

    I am using PRD 3.60 with BI Server ce 3.5.2, on Windows, using FireFox as main browser.. I am creating reports with charts and publishinh them on the server, no problem.

    However, I am...
  27. Replies
    4
    Views
    1,215

    Hi rosselet.. Can you provide an example /...

    Hi rosselet..

    Can you provide an example / screen shot of that what you added to your Cube Schema? Just to to see how that works? Many Thanks, DMurray3
  28. Thanks Matt for the insight... If in fact MS...

    Thanks Matt for the insight...

    If in fact MS SQL Server is rounding off the miliseconds, should 't have this been factored in when using that specific DB (ie. as part of the jdbc conection...
  29. PDI 3.2 GA: Problem with Date range end field

    Hi all,

    I am working with PDI 3.2.0GA against an MS SQL Server 2000 RDBMS, specifically using the Dimension LookUp / Update step, on a W/X box.

    No problem specifying my "date_from" (1900/01/01...
  30. Hi Tomas, Again many thanks for your quick...

    Hi Tomas,

    Again many thanks for your quick response.

    I have basically the same set up of string-value and mdx query with the parameter function on a report (a test of the subreport I wanted to...
  31. PRD 3.6.0 - Problem passign Parameters to Subreport

    Hi all,
    I am working with PRD 3.6.0GA-11125 on W/XP against a MS SQLServer 2000 database. I am trying to build a Master (MASTER) report holding 4 subreports (SUBREPORT). MASTER provides a single...
  32. Gracias Maria y tdidomenico por su continuado...

    Gracias Maria y tdidomenico por su continuado apoyo e interes en mi consulta.

    tdidomenico: tu respuesta me da a entender que Mondrian estaria "limitandose" cuando se lo incorpora en Pentaho... lo...
  33. Replies
    0
    Views
    1,111

    Internationalization - JIRA Mondrian 553

    Hi all,

    In response to the referenced JIRA case, Mr. J.Hyde commented:

    "If you want a container for your BI application, I suggest you use the Pentaho platform. The Pentaho platform allows you...
  34. Gracias por atender mi pregunta. La guia a la...

    Gracias por atender mi pregunta.

    La guia a la hago referencia es "Mondrian Technical Guide 2.2.".

    Yo tengo mis schemas construidos en Ingles o Castellano; lo que necesito es...
  35. Thanks a bundle Thomas... I'm near-sighted......

    Thanks a bundle Thomas... I'm near-sighted... sorry to bother with something so trivial... I hope using the collector happens to be just as "easy".. Kind Regards, DMurray3
  36. Internacionalizacion de Schemas - Connect string

    Hola todos...

    Uso bi-server-ce 3.5.2. sobre W/XP

    Estoy tratando de "internacionalizar" un Schema siguiendo lo indicado en pag 39 (Internacionalizacion) del Manual Tecnico de Mondrian.

    Pero...
  37. Hi Gustavo... Dimension Usage is to be used...

    Hi Gustavo...

    Dimension Usage is to be used when you are working with "Virtual Cubes" (ie: Joined Cubes); this "usage" would make reference to the "Conformed Dimmensions" among the cubes you are...
  38. For W.Gorman / T.Morgner - Using the PivotCategorySetCollector

    Hi All,

    On page 156 of W.Gorman's Pentaho Reporting 3.5, it is mentioned that besides CategorySetCollector, one can use the PivotCategorySetCollector, topivot the category and series.

    For the...
  39. Replies
    1
    Views
    1,165

    You have to create a "parameterized" MDX Query. I...

    You have to create a "parameterized" MDX Query. I remember that among the report samples that ship with PCI-CEServer", their is one report that uses parameters and an MDX query. I suggest using that....
  40. Replies
    6
    Views
    2,633

    When I need this, I include a "clear / refresh...

    When I need this, I include a "clear / refresh mondrian schema cache" step in my analysis.view xaction. You can take this from the "clear / refresh mondrian schema cache" xaction that is included in...
  41. Replies
    5
    Views
    3,217

    Thanks Tom... I'll see what I can find on...

    Thanks Tom... I'll see what I can find on Lucid... Best Regards.
  42. Replies
    5
    Views
    3,217

    LucidDb and PDI 3.2

    Hi All...

    Three questions on Kettle/PDI 3.2 and LucidDb:

    (a) The existing bulk loader in PDI states it is only for use in Linux. Any idea of when this will be made available for Windows?
    ...
  43. Tal vez el problema sea que mi thread era para...

    Tal vez el problema sea que mi thread era para PCI 1.7 y quizas tu estas usando BI Server 3.0 o superior... si no has resuelto el problema, vuelve a postear un thread en el foro de espaniol... estoy...
  44. En el mismo web xml en el comentario del

    En el mismo web xml en el comentario del <context param> dice que si cambias de UTF-8 a otra, deberias tambien cambiar el URIEnconding en el server.xml del Tomcat...

    Acabo de revisar en PCI 1.7 y...
  45. Hola levi2805: Si no esto errado, puedes dar...

    Hola levi2805:

    Si no esto errado, puedes dar permisos a tus usuarios, sea individualmente (de reporte-en-reporte, ie.: de xaction-en-xaction) o bien a toda la carpeta de las soluciones.

    Trata...
  46. Gracias Titdomenico... tratare de esa forma ......

    Gracias Titdomenico... tratare de esa forma ... mientras alguien de la comunidad en ingles pueda recomendar otro camino.... Atentos saludos.
  47. Gracias....tdidomenico No se si te entiendo...

    Gracias....tdidomenico


    No se si te entiendo correctamente... El esquema de permisos al que te refieres... es un tema de "windows"? o se lo hace en Pentaho? Si lo 2do... donde?

    Estoy...
  48. Personalized JPivot Views - Save as: Limiting Destination

    Hi all,

    When my users save their personalized Analysis Views using JPivot (ie. Save As button), I would like them to be directed to a specific folder rather than allow them to access the solutions...
  49. Hola todos... en vista del silencio.... me veo...

    Hola todos... en vista del silencio.... me veo obligado a poner un thread parecido en inglés... Saludos.
  50. Vistas Analiticas Personalizadas - Grabar Como: Limitar Carpetas

    Estimadas(os),

    Necesito conocer donde / como se puede limitar las carpetas disponibles a los usuarios para guardar las vistas analiticas personalizadas por ellos.

    En JPivot al pulsar sobre la...
Results 1 to 50 of 487
Page 1 of 10 1 2 3 4
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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