Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 3 1 2 3

Search Forums: Search took 0.02 seconds.

  1. Replies
    10
    Views
    3,307

    Hi, Even after changing the empty fields to...

    Hi,

    Even after changing the empty fields to date format the i am getting the same error.


    Thanks
    Sreelatha
  2. Replies
    10
    Views
    3,307

    Hi, I went through the wiki and created a...

    Hi,

    I went through the wiki and created a transformation with csv file input postgresql bulk loader.
    I am running PDI on my local machine and postgresql is loacted on some other machine....
  3. Replies
    10
    Views
    3,307

    Hi, I tried PDI on the machine on which...

    Hi,

    I tried PDI on the machine on which postgres is installed .But still i am getting the same error.


    Thanks
    Sreelatha
  4. Replies
    10
    Views
    3,307

    Hi, Do we need to have postgresql installed on...

    Hi,

    Do we need to have postgresql installed on the machine on which PDI is running?

    Thanks
    Sreelatha
  5. Replies
    10
    Views
    3,307

    Hi, I tried to use postgresql bulk load...

    Hi,


    I tried to use postgresql bulk load with text file input.I am getting the below error when i run the transformation.

    2008/12/12 16:39:37 - PostgreSQL Bulk Loader.0 - Got previous step...
  6. Replies
    10
    Views
    3,307

    Postgresql bulk loader

    Hi,

    Where can I find Postgresql bulk loader provided by pentaho data integration .It is not available pdi-3.0.4.



    Thanks
    Sreelatha
  7. Replies
    7
    Views
    1,569

    Hi, How to use this tool?...

    Hi,

    How to use this tool?
    http://pgfoundry.org/projects/ora2pg/
  8. Replies
    7
    Views
    1,569

    Hi, Thanks for the quick reply. This is not...

    Hi,

    Thanks for the quick reply.
    This is not the problem with driver.I am able to connect to database and explore the database.
    But when I try to get fields of a table i am getting error "may be...
  9. Replies
    7
    Views
    1,569

    Kettle and Postgresql grid

    Hi,

    I am using pdi-open-3.0.4-GA.
    I am trying to load data from oracle to gridsql database.
    It is working fine with Postgresql.
    How can we copy tables from oracle to gridsql.
    If anybody has...
  10. Replies
    0
    Views
    1,724

    CUBE DESIGNER Query Browser

    Hi,

    It will be very good if we have query browser working in Cube Designer.So that we can use where condition in the query.

    Thanks
    Sreelatha
  11. Replies
    0
    Views
    1,208

    Reports in Pdf,CSV and Excel

    Hi,

    I have created a report with ReportDesigner-1.6.The report is displayed properly and fast when it the outtype is pdf or HTML.
    But when the outtype is CSv or Excel the report is very slow ....
  12. Hi, I have created an aggregate table as...

    Hi,

    I have created an aggregate table as suggested by AGGGEN for the second dimension.But mondrian still using fact table itself.


    Thanks
    Sreelatha
  13. Hi, Thank you very much for the reply. Do...

    Hi,

    Thank you very much for the reply.
    Do we need to generate aggregate tables for each dimension seperately.


    Thanks
    Sreelatha
  14. Fact table with 100 million records and Aggregate table

    Hi,

    I have a fact table with more than 100 million records per a day.
    I have create a aggregate table.
    I have created cube with three dimensions and one measure.
    Mondrian is using the aggregate...
  15. Thread: Drill Down

    by Sreelatha
    Replies
    0
    Views
    1,021

    Drill Down

    Hi,

    I have created a cube with cube designer .I have also created a aggregate table.
    When I click on the cube a query is fired on the aggregate table.
    Then When drill down on the first dimension...
  16. Replies
    0
    Views
    1,193

    Save Report in CSV format

    Hi,

    I have created a report with Report Designer.
    When I run the report from Pentaho pdf or html format it is taking less than 5 minutes.
    But when try to run it as a csv or excel it is lot of...
  17. Replies
    0
    Views
    1,073

    Mondrian Error

    Hi,

    I go t this error when i added

    mondrian.rolap.aggregates.Read=true
    mondrian.rolap.aggregates.Use=true to mondrian.properties
    How can we avoid this nd use aggregate tables in mondrian
    ...
  18. Replies
    0
    Views
    975

    Explicit and impicit aggregates

    Hi,
    I am trying to use aggregate tables in oracle.
    I have created a cube with product_id,customer_id,promotion_id,store_id as dimensions and store_sales,unit_sales,store_cost as measures using...
  19. Thread: SQL Query

    by Sreelatha
    Replies
    3
    Views
    1,455

    Hi, The problem is solved by deleting the...

    Hi,

    The problem is solved by deleting the hierarchy name property of a dimension when creating a cube or deleting it form the xml.


    Thanks
    Sreelatha
  20. Replies
    1
    Views
    1,184

    Single Table with dimensions and measures

    Hi,

    I have a single table which includes all dimensions and measures.
    I have created a cube with some of the dimensions and every thing is fine.I have created a aggregate table for the...
  21. Replies
    0
    Views
    911

    Aggregates Usage(Need help asap)

    Hi,

    I need your help in this issue .As I need to solve my problem as early as possible.

    How can me make mondrian use aggrgate tables.
    I read the documentation and set mondrian.properties...
  22. Replies
    0
    Views
    902

    Use of Aggregate tables

    Hi,

    I have created a cube with cube designer.All my dimensions and measures are in the same table.
    I have created a cube with 4 of the dimensions and one measure.
    I also created a aggregate...
  23. Thread: SQL Query

    by Sreelatha
    Replies
    3
    Views
    1,455

    SQL Query

    Hi,

    I created a cube with 4 dimensions and one measure using a single table.
    When click on cube in the Pentaho BI there are multiple quries created .
    subscriber_type,call_type,country and hour...
  24. Replies
    1
    Views
    1,446

    From Keyword not found in Drill Through

    Hi,

    I have created a cube using Oracle 10g and Tomact 5.5.5.
    When I try to drill through the cube it is giving an error.
    java.sql.SQLException: ORA-00923: FROM keyword not found where...
  25. Replies
    1
    Views
    1,329

    Problem with Subscription

    Hi,

    I am using Pentaho-1.6.0.GA-863 on linux with Oracle10g and Tomcat 5.5.5.
    I have created schedule in the UI.Then Used set contenet and selected a xaction.
    Then navigated to...
  26. Thread: Bursting

    by Sreelatha
    Replies
    0
    Views
    976

    Bursting

    Hi,

    I have created a report a report with total as one of the field.
    I would like to send a mail if that total exceeds a certain threshold.
    How can I do this?
    I went through bursting...
  27. Replies
    5
    Views
    1,629

    Hi, Can anybody telll me what are the changes...

    Hi,

    Can anybody telll me what are the changes to be done in quartz.properties.I have changed ny quartz.properties in pentaho-solutions.
    I am attaching my quartz.properties file.
    Do we need to...
  28. Replies
    5
    Views
    1,629

    Hi, I clicked the it but only subscribe is not...

    Hi,

    I clicked the it but only subscribe is not displayed.



    Thanks
    Sreelatha
  29. Replies
    5
    Views
    1,629

    Hi, Thanks for the reply. I created report...

    Hi,

    Thanks for the reply.
    I created report using report designer and it is working fine.I would like to schedule this report.
    First i went to subscription admin and added a schedule with Add...
  30. Replies
    5
    Views
    1,629

    Creating subscriptions and scheduling

    Hi,

    I would like to know about the subscriptions and scheduling in pentaho.
    I built with pentaho_j2ee_deployments-1.6.0-GA.863-a for oracle 10g on Tomcat 5.5.5.every thing wotks fine.
    I am...
  31. Replies
    1
    Views
    1,490

    Pentaho on Tomcat with Oracle 10g

    Hi,

    I am trying to use pentaho with Oracle10g.
    But when I start the server I am getting the problem:

    java.lang.NoClassDefFoundError
    ...
  32. Replies
    1
    Views
    1,185

    Work Flow and bursting

    Hi,

    I would like to use the workflow capabilities and bursting provided by pentaho.
    I am trying to use it on linux with tomcat and mysql.
    How can I use shark workflow and whar are the...
  33. Replies
    1
    Views
    911

    Transformation

    Hi,

    I am running a transformation.
    If there is an error while loading transformation will stop.So i would like to know is there any way to make a transfomation to run from the point where it got...
  34. Replies
    1
    Views
    1,067

    User friendly and simple reporting

    Hi,

    I would like to use pentaho in such a way that we can create the reports on the fly instead of creating action sequence for each report we would like to use.
    Every thing should be user...
  35. Replies
    2
    Views
    2,018

    Hi, Even I got the same problem.It was solved...

    Hi,

    Even I got the same problem.It was solved after reinstall.I don't know what the problem was actually.
    publish password should be the one specified in publis-config.xml.
    Server userid is joe...
  36. Replies
    3
    Views
    1,257

    Hi, I looked the documentation and added ...

    Hi,

    I looked the documentation and added

    mondrian.rolap.aggregates.Use=true
    mondrian.rolap.aggregates.Read=true

    in pentaho-solutions/system/mondrian.properties.
    Is that what should be...
  37. Replies
    3
    Views
    1,257

    Hi, I am following the mondrian documentation...

    Hi,

    I am following the mondrian documentation .
    I am totally lost and confused.
    Actually I created foodmart database and using foddmart.xml .
    But now I would like to use my own mysql...
  38. Replies
    3
    Views
    1,257

    Mondrian and Aggregates

    Hi,

    I need some help that will solve my problem.I posting to the forum but I didn't get any replies.Please if anybody has some solution please help me.

    Actually I created aggregate table for my...
  39. Replies
    1
    Views
    1,099

    Aggregate matching

    Hi,

    I am using Cubedesigner to create cubes and it is working fine.
    mondrian.jar is in my pentaho/lib.Do we need to change aggreagate matching rules to make mondrian choose aggregates.How do we...
  40. Replies
    1
    Views
    1,074

    Persistency in Mondrian

    Hi,

    I would like to know does mondrian provide persistence and how mondrian uses an aggregate table instead os base table?


    Thanks
    Sreelatha
  41. Replies
    0
    Views
    1,018

    Mondrian and aggregates

    Hi,

    How does Mondrian choose aggregates?
    I am creating aggregates using Kettle.Do we need to follow any naming conventions in creating aggregates?
    How can we create a cube in mondrian?Do we need...
  42. Replies
    0
    Views
    981

    Creating aggregates and CmdRunner

    Hi,

    I am trying to create aggregate tables for my database.
    I followed the steps and created a cmdrunner.jar.
    It was mentioned that cmdrunner has a utility called AggGen which is used to create...
  43. Replies
    4
    Views
    1,836

    Hi, Go through the mondrian installation at...

    Hi,

    Go through the mondrian installation at the following link.
    http://mondrian.pentaho.org/documentation/installation.php
    You need to configure some files in mondrian/web-inf.

    Thanks...
  44. Replies
    0
    Views
    832

    Mondrian and Cubedesigner

    Hi,
    I am using cubedesigner to create cubes and it is working fine.
    I would like to use mondrian and workbench.How do we need start?
    How CubeDesigner and Mondrian are related.I read in a post that...
  45. Replies
    5
    Views
    3,876

    Hi, I haven't used any spaces in names and...

    Hi,

    I haven't used any spaces in names and preview is also giving the same result.
    How can we solve this?
    I have created cubes with local database and are working fine.


    Thanks
    Sreelatha
  46. Replies
    5
    Views
    3,876

    Create a cube using remote database

    Hi,
    I have a created cube using database on remote machine.Every seemed fine.I published the cube .But When I try to view that cube I am getting this page cannot be accessed directly.
    How can we...
  47. Generate cube using remote data base

    Hi,
    I have a created cube using database on remote machine.Every seemed fine.I published the cube .But When I try to view that cube I am getting this page cannot be accessed directly.
    How can we...
  48. Replies
    1
    Views
    1,640

    Adding derived measures

    Hi,

    How can we add derived measures to a cube in cube designer?
    That is I have a numeric column and I want to get the sum of that column for each country .This is simple group by.So now I would...
  49. Replies
    8
    Views
    2,754

    Hi, Thanks for the replies. The problem is...

    Hi,
    Thanks for the replies.
    The problem is solved.I got that problem because of the database permission.
    I gave all permissions to all database users and it is working fine.

    Thanks
    Sreelatha
  50. Replies
    3
    Views
    2,088

    Hi, It is working fine.I changed my jdk...

    Hi,

    It is working fine.I changed my jdk version from 1.4 to 1.5.Even with 1.6 there is some problem in cube designer.
    But I got the problem while publishing.Even though gave valid user and...
Results 1 to 50 of 128
Page 1 of 3 1 2 3
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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