US and Worldwide: +1 (866) 660-7555

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.11 seconds.

  1. Exporting report to excel are very slow for large of fields

    Hi every one,

    Whene export large of fields to excel via user console it is slow, can someone guide me to solve this i ssuer.


    Thank you in advance
  2. Replies
    0
    Views
    152

    pentaho user console exce/pdfl output

    Hi all,

    I am trying to get excel/pdf report output from 'pentaho user console'. If i select less then 10 columns the report looks ok else the report appear with cut data for column that contain...
  3. Replies
    2
    Views
    236

    Job to run all transformations

    Hi all,
    My mind is in dark, i need your help.

    Am trying to create job to run all transformations first for the dimensions tables and then to run transformations for facts tables. So i dont know...
  4. Replies
    5
    Views
    334

    I have in my transformation 4 steps: Table input...

    I have in my transformation 4 steps:
    Table input --» Add sequence --» Select values --» Insert/ Update
    Am using the Add sequence to generate de dimension key but every time i have to insert the...
  5. Replies
    5
    Views
    334

    Duplicated value for key

    Hi,
    Every time when i have to run the transformation to update the database i get the error duplicated value for key, so a have to change the value of the add sequence step to the value thet is more...
  6. Replies
    2
    Views
    237

    Hi gutlez, Thank you, its working good.

    Hi gutlez,
    Thank you, its working good.
  7. Replies
    2
    Views
    237

    Data from column cells

    Hi all,

    I trying to get the follow result. What i have is:

    column1 column2 column3
    X A S
    X B S
    X C S
    Y A L
    Y B L
  8. Replies
    4
    Views
    321

    Hi, I tryed setting de log level to Rowlevel...

    Hi,
    I tryed setting de log level to Rowlevel (very detailed), Detailed logging but i canot see the detailed log. I still get error

    014/03/10 10:15:53 - Spoon - PREVIEW!!!
    2014/03/10 10:15:53 -...
  9. Replies
    4
    Views
    321

    General error, i cant update dimension

    Hi all,
    I can not update my postgresql dimensions table, i'm getting the follow error:

    2014/03/07 16:15:10 - DIM_CONTAS - Dispatching started for transformation [DIM_CONTAS]
    2014/03/07 16:16:14...
  10. Thread: Error in cube

    by dimy
    Replies
    2
    Views
    233

    Error in cube

    Hi all,
    I was able o create analysis report but now am getting error "An error occurred while rendering Pivot.jsp. Please see the log for details."
    Please see the log file attached.

    Thank you in...
  11. Replies
    5
    Views
    403

    Hi malibu, As i said the problem occurs in...

    Hi malibu,

    As i said the problem occurs in PUC, so i changed the memory value of start-pentaho.sh
    setting CATALINA_OPTS=-Xms512m -Xmx512m -XX:MaxPermSize=256m...
  12. Replies
    5
    Views
    403

    Pentaho Report Performance

    Hi all,

    I am genereting reports via PUC (biserver-ce-4.8.0) but its taking 4 or 5 minutes.

    Can someone help me to increase the performance for report generation please.

    Thank your advice.
  13. Thank you.

    Thank you.
  14. I have a query: SELECT column1, column2 FROM...

    I have a query:

    SELECT column1, column2 FROM A
    UNION
    SELECT column1, column2 FROM B;

    The result of the query is:
    column1 column2
    id1 y
    id1 n
  15. How to filter rows that comes from another step

    Hi everyone,
    I would like to know how to filter rows that the data come from Table input step.
    I have a Table input step that contain a query with union all statement, the query result have...
  16. Replies
    0
    Views
    776

    Can not login in PUC

    Hi,
    Anybody could explain about the messages below. I'm using version 4.8.0 ce, is something related to connetion?


    WARN [org.pentaho.telemetry.TelemetryEventSender] Exception caught while...
  17. Replies
    3
    Views
    504

    Thank your advince.

    Thank your advince.
  18. Replies
    1
    Views
    315

    Fixed.:) I had to recreate the databases...

    Fixed.:)
    I had to recreate the databases (hibernate,quartz and sampledata):o
  19. Replies
    1
    Views
    315

    PacService.ERROR_0029

    Hi, i followed the tutorial in http://helicaltech.com/blogs/pentaho-bi-server-community-4-8-installation-in-existing-tomcat-with-postgresql-in-linuxubantu-os/ and...
  20. Replies
    3
    Views
    504

    Done. Just alter pentaho_user, pentaho_admin,...

    Done.
    Just alter pentaho_user, pentaho_admin, hibuser to superuser.
    The error is gone
    So now have another error:
    ERROR [org.pentaho.platform.plugin.action.sql.SQLLookupRule] Error Start: Pentaho...
  21. Replies
    3
    Views
    504

    Pentaho Initialization Exception

    Hi,

    Configuring pentaho and postgresql error occurs:


    The following errors were detected


    One or more system listeners failed. These are set in the systemListeners.xml.
  22. Replies
    0
    Views
    418

    Warn " Connection refused: connect"

    I have created a Model with pentaho meta-data Editor and published to server. But when i logged as admin the model is visible where as when i logged as non admin user the model is not available...
    ...
  23. Replies
    2
    Views
    1,179

    Hi, I give access to business tables, business...

    Hi,

    I give access to business tables, business view but is not working.

    What more i have to do.

    I'm using Pentaho 4.8.0 stable

    Thank in advance.
  24. Replies
    1
    Views
    304

    im using biserver-ce-4.8.0

    im using biserver-ce-4.8.0
  25. Replies
    1
    Views
    304

    grant data source permission for simple user

    Hi all,
    I know that have so many posts about pentaho data source permissions but i'm still not able to grant data source permission for simple user.
    I published sucessful the metadata to server and...
  26. Hi there, To customize pdf page header and...

    Hi there,
    To customize pdf page header and footer edit file fo_mdxtable.xsl.
  27. Replies
    1
    Views
    399

    Hi all, Problem solved I made the mistake...

    Hi all,
    Problem solved
    I made the mistake relate the tables so could not export the metadata

    Thanks
  28. Replies
    1
    Views
    399

    Error exporing to xmi

    Hi all,
    I'm trying to export my metadata to folder/metadata.xmi so i'm getting exportig error, "org.xml.sax.SAXParseException: An invalid XML character (Unicode: 0x{2}) was found in the value of...
  29. Customize pdf report from analysis in pentaho user console

    Hi all,

    I'm customizing my pdf report layout "print page via pdf"
    so can someone please tell me where is the file to customize pdf reports from user console.

    Thank you
  30. Replies
    0
    Views
    407

    what to do to provide ad hoc report

    Hi,

    I'm a PRD new baby and i realy like to know what to do to provide ad hoc report.

    I used the PDI tool to transform datas,
    I used workbench to create cube then publish,
    I used PUC to...
  31. Thread: fact table

    by dimy
    Replies
    1
    Views
    426

    fact table

    Hi there,
    I'm trying to run fact table, what I have is

    table input 1 ...
  32. Replies
    0
    Views
    601

    connection refuse conect

    Hi there,
    I'm tryng to create a cube, i create a data source in PUC and connection test in PSW it seems ok,
    i checked the log file, in pentaho.txt have:
    "2013-09-26 09:02:09,717 WARN ...
  33. Thread: Mondrian error

    by dimy
    Replies
    1
    Views
    506

    Mondrian error

    Hi,
    i'm trying to solve error of my cube in PSW that saying "cube mycube is invalid" and error that "all tables, dimensions, levels does not exist in database"

    i dont know exacly whats wrong...
  34. Replies
    0
    Views
    379

    Create a datasource for MS Access

    Hi, I'm pentaho BI Platform new user.
    I'm trying to create datasource for MS Access database, can someone tell me how can i do this.
    I tryed to create datasource in user console also in...
  35. Thank your advice and for reply

    Thank your advice and for reply
  36. Mondrian connect to database but can not show tables

    Hi there,

    I dont know what's going on with mondrian and my cube, the connexao is okay but the tables are not shown, I'm using CE-3.5.0-PSW.

    Can anyone help me!

    Thank your advice
  37. Replies
    2
    Views
    562

    Thank you for reply Theres no table listed

    Thank you for reply
    Theres no table listed
  38. Replies
    8
    Views
    1,246

    Thank you for reply. Problem solved! First i...

    Thank you for reply.
    Problem solved!
    First i optimized my query,
    The error was caused by the database, the column name in database was not the same of the output in my transformation.

    Thank you
  39. Replies
    2
    Views
    562

    fact table saldos does not exist in database

    Hi,
    I'm trying to create cube, i create connection from schema workbanch to MS Access database via odbc the connection looks like ok i tested, but
    im getting mesage "Fact table fct_saldos does not...
  40. Replies
    8
    Views
    1,246

    The query belowSELECT A_HIST.Date AS DATA, ...

    The query belowSELECT A_HIST.Date AS DATA,
    A_HIST.ID,
    A_HIST.CNUMAS [NUMERO AA],
    A_HIST.OFFICER AS [CODIGO DO GG],
    ACCOUNT_HIST.CATEGORY AS [CODIGO DO PP],
    A_HIST.CODE AS [CODIGO DO BB], ...
  41. Replies
    2
    Views
    605

    narges I do not quite understand what you're...

    narges
    I do not quite understand what you're trying to say, but as I understand that you want to know what should include in your input data, well you really need the key fields to look up in table...
  42. Replies
    8
    Views
    1,246

    Thank you for raply. I tryed to Optimize my...

    Thank you for raply.

    I tryed to Optimize my query and now I have only 2 tables combined, but the now i'm getting another error
    "Couldn't get row from result set
    Unable to get value...
  43. Replies
    8
    Views
    1,246

    I have 2GB of RAM and 465GB of free hard drive...

    I have 2GB of RAM and 465GB of free hard drive space.

    When I run the transformation the Execution result in field Active is Stopped and I get one error in Table input step

    in the query when I...
  44. Replies
    8
    Views
    1,246

    Error using database/fetch

    Hi,

    Can someone tell me what to do i'm getting this error "[Microsoft][ODBC Microsoft Access Driver] The query cannot be completed. Either the size of the query result is larger than the maximum...
  45. Thread: Fact table load

    by dimy
    Replies
    9
    Views
    890

    Hi there, just to thank you for reply.

    Hi there,
    just to thank you for reply.
  46. Thread: Fact table load

    by dimy
    Replies
    9
    Views
    890

    Thank you I think I was not clear Maybe then...

    Thank you

    I think I was not clear
    Maybe then I solve my problem, how to use DATABASE LOOKUP step to lookup DATE DIMENSION or how to create a connection with the input table step.
  47. Thread: Fact table load

    by dimy
    Replies
    9
    Views
    890

    i'm using MS Access database by ODBC lalgourav...

    i'm using MS Access database by ODBC

    lalgourav

    I tested the connection, looks ok

    Thank you
  48. Thread: Fact table load

    by dimy
    Replies
    9
    Views
    890

    i tryed but now in the logging text i'm geting...

    i tryed but now in the logging text i'm geting
    2013/08/30 09:47:07 - Table input.0 - Finished reading query, closing connection.




    in the input table step have a query that return only total...
  49. Thread: Fact table load

    by dimy
    Replies
    9
    Views
    890

    Hi, when creating the transformation to load the...

    Hi,
    when creating the transformation to load the fact table, the input step must have the codes of dimension tables.
    in my transformation input table step contains only the (metric) mensure, also...
  50. Thread: Fact table load

    by dimy
    Replies
    9
    Views
    890

    Fact table load

    Hi,
    i'm trying to load my fact table but i'm having below error

    2013/08/29 15:03:33 - FCT_MOVIMENTOS - Dispatching started for transformation [FCT_MOVIMENTOS]
    2013/08/29 15:03:52 -...
Results 1 to 50 of 90
Page 1 of 2 1 2