Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Search Forums: Search took 0.03 seconds.

  1. Replies
    2
    Views
    1,702

    Read Variable length columns file

    Hi All,
    I have a file with variable length columns separated by semicolon like this

    c1;c2;;c3;c4
    c1;c2;;c3;c4;c5;;c6

    I have tried to read it using csv file input and also with text input...
  2. Replies
    4
    Views
    1,413

    Thanks for all who think about it. It is solved...

    Thanks for all who think about it. It is solved now by changing the base-url.
  3. Replies
    4
    Views
    1,413

    taqua, I have changed the base-url to ip...

    taqua,

    I have changed the base-url to ip address of that machine where i am deploying the report. Here is the snip shot

    <<context-param>
    <param-name>base-url</param-name>

    ...
  4. Replies
    4
    Views
    1,413

    "Also: Check your web-xml file. You have no set...

    "Also: Check your web-xml file. You have no set your base-url correctly."

    Well...I have just created in report designer and deploy it over bi server. but not sure how to set base-url ? Can you...
  5. Replies
    4
    Views
    1,413

    Report Formatting ?

    Hi
    I have two questions

    1- I have values like 100, 99.564, 33.56564. Now i want to restrict them two decimal places only in the case when I have numbers after decimal. e.g 99.564 should become...
  6. Unable to load Adhoc Reporting Interface: Access is denied

    Hi All

    I have deployed the pentaho Bi server on the server and now i am trying to create new Report but it is giving the following error.

    Unable to load Adhoc Reporting Interface: Access is...
  7. Replies
    3
    Views
    7,009

    Hi Slawo, Thanks for quick response. I have...

    Hi Slawo, Thanks for quick response.

    I have change the JAVAMEMOPTIONS to my maximum available memory and it was able to read more rows(604964 rows) than previous but then again stops working, This...
  8. Replies
    3
    Views
    7,009

    Java Heap Size

    Hi
    I have make the transformation which gets the input from single source, perform some operations and save the data to other multiple tables. The transformation is running fine when records are low...
  9. Replies
    1
    Views
    3,290

    HBase and ETL

    Hi

    I am wondering if anyone can tell me whether we can put data in Hbase using PDI.

    Thanks
    Shuja
  10. Concatenate Two Columns to make single column

    Hi
    How to concatenate the values of two columns to make single column value for destination table,

    I am using CSV input

    Thanks
  11. Hi, I am getting values from csv format and i...

    Hi, I am getting values from csv format and i need to enter both type of rows in database which matches and which not. Also let me know how to trim the string from both ends?

    Thanks in advance...
  12. Select Values Dependant on other Column Value

    The problem is best described according to following scenario.

    Suppose I have source table with three columns A, B,C

    Now I want to check the column A value if it is 1 then i want to sent the...
  13. Replies
    2
    Views
    1,186

    I am creating cube using New Analysis view and...

    I am creating cube using New Analysis view and displaying data through it.
  14. Replies
    4
    Views
    1,611

    Hi mgei Thanks for reply I need to know will i...

    Hi mgei
    Thanks for reply
    I need to know will i just need to replace the servername in the above url or how i get this url according to my server?
  15. Replies
    0
    Views
    921

    Roll Up Formula/ Aggregator Formula

    Hi Folks

    The problem can be best described using this scenario.

    Suppose I have a dimension time with following hierarchy.

    Year
    Quarter
    Month
    Day
  16. Replies
    4
    Views
    1,611

    Cube Data Not Updated

    Hi All
    I have made a new analysis view. The problem is that it did not show the new data whenever ETL runs so i have to create the new analysis view every time whenever data is updated.

    can...
  17. Replies
    2
    Views
    1,246

    Hi All I try to integrate with Bi-server 3.0 now...

    Hi All
    I try to integrate with Bi-server 3.0 now but same error.

    Any Luck??

    Regards
    Shuja
  18. Replies
    2
    Views
    1,246

    IPhone Extension Error

    Hi All
    I am trying to integrate iphone extension according to following tutorial

    http://wiki.pentaho.com/display/COM/Enabling+the+iPhone+BI+Extension

    but i am getting the following error on...
  19. Replies
    2
    Views
    1,393

    Performance w.r.t Time

    Hi All
    I have made a transformation with two things Table Input and Table output.

    The database is on remote location. The transformation is reading data from one table and writing to other table...
  20. Replies
    2
    Views
    3,054

    Thanks Taqua. Actually My scenario is that i am...

    Thanks Taqua.
    Actually My scenario is that i am getting thousands of log files daily which need to be processed to clean the data and get useful information, resulting in millions of rows daily. If...
  21. Replies
    2
    Views
    3,054

    Hadoop Data Source for Cubes and Reports

    Hi
    I am checking the new ETL which is providing the support for hadoop. Now my questions is that suppose i get my data from hadoop, clean it and put back to hadoop (instead of mysql which i am using...
  22. Replies
    1
    Views
    3,767

    Schema Workbench Log

    Hi All
    I am using schema workbench to create the cube. when i clink on new mdx then following error appears

    Exception: Mondrian Error:Named set in cube 'AvcCbe' has bad formula

    See workbench...
  23. Replies
    2
    Views
    1,186

    Display user defined value in Cube

    Hi All

    The problem is best described by following example.

    I have a cube which have one measure and one calculated member (M1,CM1). M1 can have floating values including zeroes like this

    M1 ...
  24. Replies
    3
    Views
    6,738

    thanx mike, Can u also tell the syntax of if...

    thanx mike, Can u also tell the syntax of if statment?
  25. Replies
    3
    Views
    6,738

    Calculated Members (Divide by zero)

    Hi All

    The following scenario describes the problem in better way.

    Suppose I have two measure in cube M1, M2. Now I want to have a calculated member based on these measures. The formula is...
  26. Thanks for the help. the problem is solved now. I...

    Thanks for the help. the problem is solved now. I created the new cube, restart the server then try to make new analysis view and wow...it works

    Anyhow can u tell this how logging will enabled...
  27. Replies
    0
    Views
    707

    Adding Measures in Cube

    Hi All

    I am making cube using schema workbench. I have a fact table which contains more than 30 columns which need to be added as measures.

    Currently, I am adding measure one by one. By right...
  28. I have checked the log file in this directory ...

    I have checked the log file in this directory

    D:\Pentaho\biserver-ce\tomcat\bin\pentaho.log

    Is the log generated in any other location?

    Regards
    Shuja
  29. Well... I am new to this and not sure which thing...

    Well... I am new to this and not sure which thing is causing the error message. Can you guide me how i can figure out?

    Thanks
  30. This page cannot be accessed directly. It must be linked to from other pages

    Hi All
    I am facing the same issue. I have checked the log file which contains the following message.

    2010-07-19 05:53:48,546 WARN [org.pentaho.platform.util.logging.Logger]...
  31. Replies
    1
    Views
    1,419

    MetaData not running

    Hi All

    I have just downloaded the meta data editor and try to run it on windows but it not showing me interface and giving me following error.


    C:\Documents and...
  32. Replies
    4
    Views
    18,534

    Changing Data Type

    Hi All

    I need to change the data type of input stream. I am using table input to get data. now i want to change the data type. Which control is used to change it?

    Thanks
    Shuja
  33. Replies
    7
    Views
    1,109

    Thanks Maria, It works.

    Thanks Maria,
    It works.
  34. Replies
    7
    Views
    1,109

    one quick question, i have used Table Input and...

    one quick question, i have used Table Input and it outputs table 2 records now what i want that i put some control and it outputs me in table3 format with id (no insertion at the moment so i can...
  35. Thanks a lot chamel.

    Thanks a lot chamel.
  36. Thanks for quick solution. so it means that it...

    Thanks for quick solution. so it means that it can not be achieved in one transformation?
  37. the structure of both tables is different means...

    the structure of both tables is different means number of columns. actaully i am new to etl and do not have much idea abt sortorder. can u explain a bit more?
    Thanks
  38. Delay 2nd insertion until 1st completes

    Hi

    I have to make a transformation where i need to insert data into two tables but the case is that i want to insert the data into 2nd table when insertion in first table completes.

    it means...
  39. Replies
    7
    Views
    1,109

    so will i need to use Execute Sql script contol?...

    so will i need to use Execute Sql script contol? is it possible by some other control?
  40. Replies
    7
    Views
    1,109

    Replacing Values with Ids

    Hi All
    I am trying to figure out how to implement following use case in kettle.

    1- Suppose I have two tables Table1 and Table 2.

    Table 1 has the following structure.

    Id, Value
    1 val1
    2 ...
  41. Replies
    2
    Views
    1,595

    yes it works Thanks Maria.

    yes it works
    Thanks Maria.
  42. Replies
    2
    Views
    1,595

    Fitler Rows

    Hi All
    I have question. I have two tables one is master and other is slave. Suppose both have 1 column ABC, Now I want to insert only those rows from master which are not present in slave table. e.g...
  43. Replies
    1
    Views
    3,953

    Well...Ali I am also trying to do so but can't...

    Well...Ali I am also trying to do so but can't get the solution at the moment. If some one know how to connect BIRT Reporting to mondrian cube please let me know.

    Thanks in advance
    Shuja
  44. Replies
    2
    Views
    2,610

    I also face the same problem..when i once made...

    I also face the same problem..when i once made the cube then publish it. now i want to change the cube later.but i did not find any way to do so.can any body tell me how to change the cube dimensions...
Results 1 to 44 of 44
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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