Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.02 seconds.

  1. Replies
    2
    Views
    1,582

    report output type as pdf

    Hi,

    In generating a report there are different report output types provided like pdf,html,word etc.
    when i select output type as pdf and click on update an error is displalying "A file I/O error...
  2. Replies
    2
    Views
    4,076

    Can we use Oracle OLAP Cube

    Hi All,

    We are using Pentho Cube and generating the Pivot Analysis View.
    Can we use Oralce OLAP Cube instead of Pentaho Cube and generate the Pivot Analysis View?


    Regards,
    sriman.
  3. Replies
    4
    Views
    1,317

    Hi Rosselet, Thank you for sparing your...

    Hi Rosselet,

    Thank you for sparing your valuable time on giving me a solution. As you said i have
    1,Jan
    2,Feb
    3.Mar,
    4,Apr
    5,May etc in database, eventhough in am not getting sort in order....
  4. Hi Ravi, How to generate a report when no...

    Hi Ravi,

    How to generate a report when no parameters are passed through parameter screen?

    Regards,
    sriman.
  5. Replies
    4
    Views
    1,317

    Any solution for my problem? Regards, sriman.

    Any solution for my problem?

    Regards,
    sriman.
  6. Replies
    4
    Views
    1,317

    Month Hierarchy dispaly problem

    Hi All,

    I am having a dimension of Time and levels year, quarter and Month. When displaying the last level month it is not showing hierarchially like Jan, Feb, Mar instead it is showing Feb, Jan,...
  7. Replies
    2
    Views
    1,209

    Hi Tomas, Thanks for your solution, it...

    Hi Tomas,

    Thanks for your solution, it resolved my problem.


    Regards,
    sriman.
  8. Replies
    2
    Views
    1,209

    How to filter data

    Hi All,

    I want to filter the data displayed in pivot table, iam using the hypersonic data and my MDX query is
    select NON EMPTY {[Measures].[Actual]} ON COLUMNS,
    NON EMPTY...
  9. Replies
    5
    Views
    2,610

    Hi Basus, I could able to see only...

    Hi Basus,

    I could able to see only arrows.jsp, colors.jsp, fourhier.jsp, mondrian.jsp, tesquery.jsp files under path:
    pentaho-demo\jboss\server\default\deploy\pentaho.war\WEB-INF\queries

    My...
  10. Replies
    5
    Views
    2,610

    Hi, In which jsp file i need to add that....

    Hi,

    In which jsp file i need to add that.
    Can you give me the path.

    Regards,
    sriman.
  11. Replies
    5
    Views
    2,610

    Pivot Table Title

    Hi All,

    How can i change the name(Heading) of Pivot Table. By default i am getting the Cube name.

    Regards,
    sriman.
  12. Hi Will, Thanks for your help i could able...

    Hi Will,

    Thanks for your help i could able move further.

    Regards,
    sriman.
  13. Hi Will, I did as per your suggestion, but...

    Hi Will,

    I did as per your suggestion, but the same problem.
    I installed:
    pentaho-demo-1.2.1.625-GA
    design-studio-1.2.1.357-GA
    designer-1.2.0.219-RC2
    cubeDesigner-0.7.2.0_Win32

    Any thing...
  14. Hi Will, My database connecton is ok. The...

    Hi Will,

    My database connecton is ok.
    The steps i followed:
    1. Opened Report Desinger
    2.To Add Dataset
    Selected SampleData in Connection Type.
    Checked Use Mondrian Cube Definition...
  15. Hi Will, OK it's fine Thank you. But when i...

    Hi Will,

    OK it's fine Thank you.
    But when i create a report i am not getting data, it is showing:
    All region All department etc.
    I simply dragged region,department and position into Item...
  16. Hi Will, I am using...

    Hi Will,

    I am using PentahoReportDesigner-1.2.0.219-RC2.
    My MDX query is:
    select NON EMPTY {[Measures].[Actual],[Measures].[Budget],[Measures].[Variance]} ON COLUMNS,
    NON EMPTY...
  17. How to user Cube Definition as data source in Desinger?

    Hi All,

    Any one has the solution for this.
    When i select a Cube Definition in data source the error message is showing:
    Could not fetch data: Mondrian Error:Failed to parse query”.

    Can't...
  18. Hi, I am also facing the same problem. When i...

    Hi,

    I am also facing the same problem. When i selected the Mondrian XML fiile an error message is displayed:
    Could not fetch data: Mondrian Error:Failed to parse query”.

    How to resolve this?...
  19. Replies
    6
    Views
    7,772

    Hi Marc, Thanks for your clarification. ...

    Hi Marc,

    Thanks for your clarification.

    Regards,
    sriman.
  20. Replies
    6
    Views
    7,772

    Hi, I tried as you said, it's working fine....

    Hi,

    I tried as you said, it's working fine. But is the need to edit the MDX query? i already selected the other two measures (Budget, Variance) while designing the CUBE.

    Regards,
    sriman.
  21. Replies
    6
    Views
    7,772

    Hi, Here is my MDX query. select NON EMPTY...

    Hi,

    Here is my MDX query.
    select NON EMPTY {[Measures].[ACTUAL]} ON COLUMNS,
    NON EMPTY {([Region.Region].[All region], [Department.Department].[All department], [Position.Position].[All...
  22. Replies
    6
    Views
    7,772

    How to show multiple measures

    Hi,

    I have created a cube with hypersonic data on table Quadrant_Actuals.
    As measures i selected Actual,Budget, Variance.
    As Dimensions i selected Region,Department,Positiontitile.
    The cube is...
  23. Could not view Cube from Browser.

    Hi Clement,

    Thanks, i installed jdk 1.5 and now i could able to create a cube.
    After creating a cube i tried to open it through browser, when i click on CubeName i am getting the following...
  24. Problem in designing a new cube.

    Hi clement,

    I am new to Pentaho Cube Desinger, but i am working for the past 2months on Pentaho Reporting.
    I followed your post Cube Desinger's Quick Start and i am facing a problem in F.III.2nd...
  25. Thread: Pagenation

    by sriman
    Replies
    1
    Views
    1,292

    Pagenation

    Hi All,

    How to show Pagenation for each page.
    I have created a report and displaying it in html format. In the designer i took PageofPagesFunction for Pagenation. In Page Footer i mapped this...
  26. Replies
    0
    Views
    1,072

    Desinger palette objects

    Hi All,

    What is the purpose of objects: Resource Field, Resource Message, Resource Label and Anchor Field in Report Desinger Palette and how these can be used. Any existing examples used these...
  27. Replies
    8
    Views
    4,034

    Loading Parameter Values

    Hi bsingleton,

    For loading parameter values based on previous selected parameter I followed:
    1. Query for Type
    2. Prompt/Secure filter for Type
    3. Query for Make
    4. Prompt/Secure filter for...
  28. Replies
    3
    Views
    2,142

    Dear Ingo, Any solution to my problem? ...

    Dear Ingo,

    Any solution to my problem?

    Regards,
    sriman
  29. Replies
    3
    Views
    2,142

    Changing where clause of a query dynamically.

    Hi Ingo,

    As you said the problem is in framing the SQL statement.
    I have two parameters in a report. The SQL statement looks like:
    select * from emp where hiredate between ('{fromdate}') and...
  30. Replies
    3
    Views
    2,142

    No values passing for Report parameters

    Hi All,

    I generated a report with two input parameters fromdate and todate. when i give values to the parameters the report is generating its fine, but when i doesn't give any values to the...
  31. Replies
    2
    Views
    1,224

    Hi Analufaria, Thanks for your solution. I...

    Hi Analufaria,

    Thanks for your solution. I did as per your instructions it is working fine.

    Regards,
    sriman
  32. Replies
    2
    Views
    1,224

    Publishing reorts to another folder

    Hi All,

    How can i publish the reports in my own created working folder instead of publishing to Samples\reporting path.


    Regards,
    sriman
  33. Replies
    1
    Views
    1,175

    Sorting on columns dynamically

    Dear All,

    I generated a report and able to view, Now in report i want to sort the information on a selected column.
    Can we do a sorting on columns dynamically.

    Thanks & Regards,
    sriman.
  34. Replies
    3
    Views
    1,236

    Dear mlowery, Thanks for your reply, i...

    Dear mlowery,

    Thanks for your reply, i visited the site as per your suggestion and got relevant information.
    Can you guide me for documentation on Pentaho Workflow.

    Thank You.

    Regards,...
  35. Replies
    3
    Views
    1,236

    Workflow and Security

    Dear All,

    Where can i get more information on Pentaho Workflow and security.

    Thanks & Regards,
    sriman
  36. Replies
    0
    Views
    914

    Calling Oracle Stored Procedures

    Dear All,

    How to call oracle stored procedures from Designer/Design Studio.


    Thanks & Regards,
    sriman.
  37. Replies
    20
    Views
    11,571

    Dear Ingo, I corrected, now it's working...

    Dear Ingo,

    I corrected, now it's working fine.
    Thanks for your solultion.

    Regards,
    sriman.
  38. Replies
    20
    Views
    11,571

    Dear Ingo, I tried as you said, but an error...

    Dear Ingo,

    I tried as you said, but an error is produced.
    Error: Base.ERROR_0002 - Component execution failed - java.lang.NullPointerException.

    Iam enclosing the XML and xaciton files.
    ...
  39. Replies
    20
    Views
    11,571

    Date Parameters Passing

    Dear Ingo,

    I facing a problem in selecting date parameters.
    I have a date datatype field in my database, i need to generate a report between two selected date values. For this i need to provide...
  40. Replies
    0
    Views
    1,053

    Common report in page header and footer.

    Dear All,

    I need to share a common report in page header and footer.
    I tried with Include option in Designer Wizard, but i couldn't succeeded.
    How to achieve this?

    Thanks & Regards,...
  41. Replies
    20
    Views
    11,571

    Thanks Ingo

    Dear Ingo,

    Thanks for sparing your time and providing me the solution.
    I followed the steps you provided. Its working absolutely fine.

    Can i have your mail-id, you can mail me to this...
  42. Replies
    20
    Views
    11,571

    How to show parameters/filters in Report header

    Hi All,

    I created a report which consists of paramters using Desing Studio. I could able to run the report. Here i need to print selected parameter values in report header, How this be achieved....
  43. Designer Wizard - Deploying reports into BI Server

    Hi All,

    I have generated a report using Designer Wizard and i published to server successfully. I copied all the published files to path:
    pentaho-demo/pentaho-solutions/samples/reporting/.
    I...
  44. Replies
    2
    Views
    1,236

    Hi Chris, Thanks for ur solution. In wizard...

    Hi Chris,

    Thanks for ur solution. In wizard there is no problem by selecting appropriate check boxes we can get group totals, but my problem was while creating a report using Designer. But i got...
  45. Replies
    2
    Views
    1,236

    Report Desinger - Group Totals

    Hi All,

    Iam generating a report with two groups (REGION and DEPARTMENT) using sample data. The group by totals are getting accumulated. How to get individual group by totals, is there any setting...
  46. Replies
    0
    Views
    1,072

    Representing unit in charts

    Hi All,

    Can we define unit in charts i.e. instead of showing 4,000,000 I need to show 4m. How is this possible.

    Thanks,
    Sri
  47. Replies
    0
    Views
    1,737

    Representing units in charts

    Hi All,

    Can we define units in charts i.e. instead of showing 4,000,000 I need to show 4m. How is this possible.

    Thanks,
    Sri
Results 1 to 47 of 47
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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