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

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.06 seconds.

  1. Unknown Host Name error for Table Input

    Hi Team,

    I have a job which calls a transformation.

    The transformation has 'Table Input' and in which has the Database connection is defined in variables passed from the main job using 'Set...
  2. Thread: Merge Rows

    by Naseeruddin
    Replies
    5
    Views
    595

    Hi Mick, Thank you very much for your reply. ...

    Hi Mick,

    Thank you very much for your reply.

    What i mean is like:

    Whenever we run the transformation, in the 'Merge rows' component -
    'Is a complete dump of both the 'Source' & 'Target'...
  3. Thread: Merge Rows

    by Naseeruddin
    Replies
    5
    Views
    595

    Hi Mick, Thank you very much for the detailed...

    Hi Mick,

    Thank you very much for the detailed reply. It was very helpful.

    Also request for one small clarification:

    In the 'Merge rows' component, Is each iteration a complete dump of both...
  4. Thread: Merge Rows

    by Naseeruddin
    Replies
    5
    Views
    595

    Merge Rows

    Hi Team,

    I am using the following transformation as attached below.

    Is there any limitation on the data that the 'Merge Rows' component can process.

    If the 'Source' and 'Target' have large...
  5. Replies
    0
    Views
    367

    Printing the report on A4 size.

    Hi Team,

    I have a report which has around 20 columns and i need to print it on A4 size paper.

    For the same, i had to reduce the width of all the columns and also font to Arial 6 etc to fit &...
  6. Replies
    4
    Views
    453

    Thank you very much Taqua its working. Its...

    Thank you very much Taqua its working.

    Its giving a color for all the records that have a change in the 'Col1' value.

    Also is it possible to put 1 color to all same values of 'Col1' and and...
  7. Replies
    4
    Views
    453

    Hi Taqua, Thank you for your reply. Buti am...

    Hi Taqua,

    Thank you for your reply.

    Buti am not getting the same.

    I have used the forumlae as below in the 'bg color' :

    =IF(HASCHANGED([COL1]);"#ccffcc";"#ffffff")
  8. Replies
    4
    Views
    453

    Accessing Previous Rows value

    Hi Team,

    I have report output as below:


    Col1 col2 col3
    A 1 2
    A 3 4
    A 5 6
    B 1 2
  9. Replies
    2
    Views
    362

    Oh ok fine. Will check the same. Thank you Lal...

    Oh ok fine. Will check the same. Thank you Lal Gourav.

    Naseer.
  10. Replies
    2
    Views
    362

    PDI Server Status Not Changing

    Hi Team,

    I am executing a PDI transformation on Pentaho Data Integration Server.

    The transformation migrates a table with 2 records from Sybase to Greenplum.

    All the 3 steps show the status...
  11. Replies
    1
    Views
    545

    Table Output: Identity Column Value

    Hi Team,

    I am trying to transfer data from 'SQL server' to 'Sybase' database for a table which has 'identity column' in it.

    Since i want the identity column values also to be inserted in the...
  12. Thank you.

    Thank you Mick, will look into the same.

    Naseer.
  13. Table Output Special Character Conversion Error.

    Hi Team,

    I am facing a peculiar problem when trying to migrate data from Microsoft Sql sever to Sybase using 'Table Input' and 'Table Output' components. .

    I have table which has 'Desc' column...
  14. Replies
    1
    Views
    350

    Table output error

    Hi Team,

    I am trying to insert data from SQL to Sybase using Table Input and Table Output connections.
    I am getting the following attached error.

    Request to help on the same on whats the...
  15. Set Identity Insert on Multiple Tables.

    Hi Friends,

    I have a transforamtion which transfers data from source to desitnation (SQL table To Sybase table).

    The table has an identity column , hence i have written 'Set Indentity insert...
  16. Hi Gutlez, This is the perfect solution. I...

    Hi Gutlez,

    This is the perfect solution. I will try and see the same.
    Thank you.

    Naseer.
  17. Hi Kishore, Thank you for the detailed reply. I...

    Hi Kishore,
    Thank you for the detailed reply.
    I will check the same.
    (Actually i also want the blank values tobe copied as it is).
    Will update you.
    Thank you.
    Naseer.
  18. Thank you.

    Thank you very much Lal Gourav.It has helped me a lot.

    Naseer.
  19. Blank value columns or Zero length column values.

    Hi Team,

    I have a task of transferring records from SQL db to SYBASE db.

    I have columns in source(SQl) defined as :

    Name varchar(10) Not Null.

    This 'Name' column has 'Blank' ( zero...
  20. Replies
    2
    Views
    528

    Thank you very much Taqua for the information. ...

    Thank you very much Taqua for the information.

    Sure , will file the request in JIRA.

    Thank you.

    Naseer.
  21. Replies
    0
    Views
    574

    Export options restriction.

    Hi Team,

    Can we restrict the export options in Pentaho report designer?
    When we click on the exort option(green arrow buttion) , we get various export options like pdf,excel Excel,Excel 2007 etc....
  22. Replies
    2
    Views
    528

    Lock excel cells

    Hi Team,

    When i export to excel i want the cells to be locked (non editable) so that the user does not change the data in the excel report.

    Can you please help on the same ASAP like How to...
  23. Replies
    1
    Views
    527

    Excel export rows.

    Hi Team,

    When exported to excel 2003 i have the output on the lines in a sequence of 2.(2,4,6...).
    PFA the screen shot of the same.

    When i verified, i understood that there's another sub...
  24. Thread: Padding

    by Naseeruddin
    Replies
    1
    Views
    618

    Padding

    Hi Team,

    I have a column which has identation .Certain rows of the column have padding on the left.
    I am getting the padding space when i preview the report in the Pentaho report designer but...
  25. Replies
    1
    Views
    628

    Column width 255 error

    10774

    Hi Team,


    When i try to delete a sub report from the main report i get the following error. :

    " The maximum column widht of an individual cell exceeds greater than 255 characters".
    ...
  26. Replies
    2
    Views
    766

    Thanks for the reply, In my requirement I want...

    Thanks for the reply,
    In my requirement I want the stripes in bar chart, is it possible to get it?

    Thanks,
    Naseer
  27. Replies
    2
    Views
    766

    How to get Strips in Bar chart

    Hi,
    I want to get strips in Bar chat based on some condition.
    PFA.
    I want the strips in Column 'F' (like strips in above attachment). If it is not possible then is it possible to change the colour...
  28. Replies
    0
    Views
    345

    Performance Monitoring

    Hi Team,

    When i execute a report it takes around 2 mins to generate the report output.
    The report has many sub reports inside it which inturn also call sub reports.

    Is there any way we can do...
  29. Replies
    2
    Views
    568

    Thank you.

    Hi Taqua

    Thank you very much for the detailed reply.Will be very useful in understanding the performance better.

    Naseer.
  30. Replies
    2
    Views
    568

    Report Life cycle Performance

    Hi Team,

    Can anybody please provide any information on the lifecycle of a report desgined in Pentaho Report Designer.

    Like, if i have a report with multiple queries and multiple sub reports...
  31. Replies
    0
    Views
    364

    Charts in Excel 2007

    Hi,
    I have created a report in Business Analytics 4.8 -PRD 3.8 (some sub reports, a chart in the main report) and did a preview in Excel 2007. The problem is that the chart is not displayed. Export...
  32. Replies
    0
    Views
    436

    Columns in Report Analyzer

    Hi Team,

    I am trying to create a report using Pentaho Report Analyzer.

    When i drag and drop the columns from the left pane into the 'Columns' section, i am unable to drag more than 4 into the...
  33. Replies
    0
    Views
    425

    Dynamic XML file in PRD

    Hi Team,

    I have seen that we can use XML file as source in Pentaho report designer.

    But i want to have this as a 'parameter' , instead of static XML Source.
    Can user have this as a as a...
  34. Replies
    3
    Views
    658

    Views in Schema Workbench.

    Hi Team,

    I want to desgin a cube using Mondrian Schema Workbench.

    But i want to use 'Views' instead of 'Tables'. Is this possible? Can i use views instead of tables for buiding the cube?
    ...
  35. Replies
    2
    Views
    565

    Thank you very much Madhu for the reply. As...

    Thank you very much Madhu for the reply.

    As mentioned, I think we need to write Xquery when we have XML file as a source in Pentaho report desginer.

    I dont know how to write Xquery , but i...
  36. Replies
    2
    Views
    565

    Crosstab using XML input

    Hi Team,

    Can i use an xml file as input and design a cross tab report in Pentaho report designer?

    How do we do this?

    Please help.


    Thank you.
  37. Replies
    2
    Views
    709

    Cube

    Thank you very much for the reply.

    Regards,
    Naseer.
  38. Replies
    2
    Views
    709

    Cube in Report Analyzer

    Hi Team,

    I want to design a report in Report Analyzer.

    I want to desgin a cube in the Mondrian Work bench and use the same cube as source for designing the report in the Report Analyzer.
    Is...
  39. Replies
    0
    Views
    363

    Cross tab limiations

    Hi Team,

    The reports that i need to develop require Cross tab functionality.
    I am trying to do the same using the experiemental Cross tab feature in PRD 3.8.

    Can anyone please list out the...
  40. Replies
    4
    Views
    585

    Thank you very much. Will check the same. ...

    Thank you very much. Will check the same.

    Regards,
    Srikanth.K
  41. Replies
    2
    Views
    573

    Thank you very very much Tauqa , its really...

    Thank you very very much Tauqa , its really helped a lot.

    Regards,
    Naseer.
  42. Replies
    4
    Views
    585

    Hi Madhu, Thank you very much for the reply. But...

    Hi Madhu,
    Thank you very much for the reply. But also i need to get a line to the right side of it and not as a border . Is this possible?

    Thank you.

    Naseer.
  43. Replies
    2
    Views
    573

    Page Breaks in Sub reports.

    Hi Team,

    I have a main report which has 2 inline sub reports side by side.
    When i export to excel i want the output of each subreport to come into 1 single sheet of the excel.
    So i should get 2...
  44. Replies
    3
    Views
    736

    Thank you very much for the information....

    Thank you very much for the information.
    --Naseer.
  45. Replies
    3
    Views
    736

    Report Analyzer

    Hi Team,

    I have only OLTP database ( Relational Database) in the current environment ( DB2).
    I dont have cubes ( Dimensions and Fact tables.).

    I want to create reports using Report Analyzer...
  46. Replies
    2
    Views
    488

    Thank you very much Surya.

    Thank you very much Surya.
  47. Replies
    2
    Views
    859

    XML Version of .prpt file

    Hi,

    I want to generate the xml format of the .prpt file?

    How can i do that?

    Actually i have web service which takes XML input. So require the same.
    We want to call the report from a Java...
  48. Replies
    0
    Views
    389

    Group Formating

    Hi,

    I have a report which has a group.

    I want to have space after every group in the report just to differnetiate between the next group better.

    How do i do this?

    Pls help me.
    Thank ...
  49. Replies
    0
    Views
    382

    Group Borders/Formating

    Hi ,
    I have a report which has a Group Header.

    I want to put a border for every group and its details.

    How can i put borders at a group level.

    Please suggest.

    Thank you.
  50. Replies
    0
    Views
    399

    DB2 Stored Proc

    Hi ,
    Environment: DB2.

    We are trying to preview the results of a Stored procedure from Pentaho report designer , but it is giving an error.
    PFA the step and the error message.

    This error is...
Results 1 to 50 of 83
Page 1 of 2 1 2