Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Replies
    2
    Views
    876

    Hi Pedro, Thank you very much for your...

    Hi Pedro,

    Thank you very much for your response. It is very clear to me now and sorry for late response.

    Want to confirm is the CDA project is here at GitHub?
    ...
  2. Replies
    2
    Views
    876

    Stand Alone CDA

    Is it possible to have a stand-alone CDA that is not part of Pentaho's add-on?
  3. Reading Data Source with Kettle Transformation File in BI Server 5.0

    I realized that BI Server 5.0 use Jackrabbit as repository for all solution files including Kettle's transformation file. I manage to upload it, but cannot execute the transformation file. Then I...
  4. Create HTML Upload Form in BI Server 5.0

    Is there any pointer or documentation that guide us on how to create a HTML page with upload form?
  5. Referencing Element Name Instead of Data Field

    Hi Everyone,

    I understand that in formula and other scripting available in PRD, I can reference to data field using [FIELD_NAME].

    But how can I get element name's reference that bind to the...
  6. Flash Auto Reload Problem When Switching Tab

    Hi All,

    In Pentaho User Console 3.6, I have several pages contain flash object. And notice that when we switch tab between the pages, the flash object reload automatically ?

    How do I override...
  7. Replies
    0
    Views
    1,036

    FORMAT_STRING to format a Text / String

    Hi All,

    I've tried hard to format a string / text using this style :

    (|value|style=''...|....|)

    for example :

    with member [Measures].[Test] as '"My Text"', FORMAT_STRING='|@|style="red"'
  8. Replies
    0
    Views
    1,801

    Mail Validator

    Hi All,

    Today I try to use Mail Validator step both in job and transformation. But failed on both using smtp checks, all valid emails are thought to be invalid.

    SMTP Server configured is a...
  9. Replies
    0
    Views
    1,062

    Mondrian/MDX, PRPT and XAction

    Hi All,

    As the title suggested. Is there any clue / tutorial how to link MDX query resulted in one flow feed into Reporting (PRPT) component in XAction ?
  10. Replies
    0
    Views
    7,041

    Sticky: Jangan Dibaca !!

    Nyasar ?? Anggota baru ?? ;)

    Silahkan kunjungi http://forums.pentaho.com/showthread.php?77750-Baca-Terlebih-Dahulu-!
  11. Replies
    9
    Views
    41,145

    Sticky: Baca Terlebih Dahulu !

    Selamat Datang di forum Pentaho Bahasa Indonesia !

    Saya mengucapkan terima kasih atas kunjungan Anda ke forum ini. Namun, sebelum Anda melakukan posting pastikan Anda membaca guideline dan aturan...
  12. Replies
    0
    Views
    710

    Parameter - Query Flow ?

    Hi All,

    I have a report than eventually lead me to create this flow :

    Parameters :
    param_level1
    param_level2
    param_alllevels

    JDBC Sources :
  13. Replies
    5
    Views
    2,950

    Hi Thomas, Thanks for the helpful information....

    Hi Thomas,

    Thanks for the helpful information. I can deploy it now :)

    Regards,

    Feris
  14. Replies
    5
    Views
    2,950

    Hi Taqua, Thank you very much for responding....

    Hi Taqua,

    Thank you very much for responding. On using PRD 3.6, do I also need to upgrade to BI Server 3.6 ?

    Thanks,

    Feris
  15. Replies
    5
    Views
    2,950

    Solved

    Hi All,

    I've solved this issue using post processing openformula to process string and send it back to MDX.

    I modified my SQL query so that ID and MDX member is in the "value" part.

    Thanks,
  16. Replies
    5
    Views
    2,950

    SQL in filter and MDX in query selection

    Hi All,

    I have quite complex report that I decided to have eight parameters / filters that related each other, for example : area, sales manager, product, etc.

    Now, I can have that related each...
  17. Replies
    0
    Views
    788

    Is it a bug ?

    Hi,

    I'm developing a report using Mondrian's schema as data source. Since I'll have many filters, so I'm using parameter() function across all the report.

    They are working fine, except when the...
  18. Replies
    0
    Views
    738

    PDI XAction Step with Customized Look

    Hi All,

    Can we customize the pdi's xaction output with a HTML template ?

    Thanks,
  19. Batch Update with Postgresql 8.1 (Table Output)

    Hi All,

    Here I'd like to share and to ask if anyone has same problem issue with me. I'm using Kettle 3.1 in one of my clients for dumping several big databases into one PostgreSQL database....
  20. Replies
    0
    Views
    1,006

    PivotView Component & Mondrian Role

    Hi All,

    Is there any plan to integrate Roles list gathered from principalRoles into Mondrian Pivot View ?

    Regards,

    Feris
  21. Replies
    7
    Views
    4,113

    Hi Matt, Thanks for the confirmation. In...

    Hi Matt,



    Thanks for the confirmation. In that case, I will try to manipulate the Environment Variable to change the SQL Queries.

    Regards,

    Feris
  22. Replies
    7
    Views
    4,113

    RowDataUtil.removeItems

    I'm trying to remove items dinamycally using these script



    java

    newRow = createRowCopy(getOutputRowMeta().size());
    var hasil = org.pentaho.di.core.row.RowDataUtil.removeItems(newRow, 0);...
  23. Replies
    1
    Views
    1,726

    Hi Gonzalo, This problem is called Change Data...

    Hi Gonzalo,

    This problem is called Change Data Capture (CDC). Seems easy but it is a very difficult task and actually beyond ETL capabilities.

    If system that produced the source tables has...
  24. Replies
    7
    Views
    4,113

    Hi, I have same problem. I now successfully...

    Hi,

    I have same problem. I now successfully drop a column / header from output rowset using getOutputRowMeta().removeValueMeta(index).

    For example using getOutputRowMeta().removeValueMeta(0)...
  25. Replies
    1
    Views
    1,208

    Preview Binary Data

    Hi All,

    I have successfully get and stored binary data use to detect row changed (CDC - Change Data Capture) in SQL Server 2008. I dump the CDC range fields into MySQL converted into longblob by...
  26. Hi Julian, Sorry for late reply... Yes,...

    Hi Julian,



    Sorry for late reply... Yes, I've found that there's no entry in JIRA for Mondrian. But I will investigate the bug you mentioned in next reply first before logging it.


    ...
  27. Hi Julian, Thanks for the confirmation. I will...

    Hi Julian,

    Thanks for the confirmation. I will log it now in the jira.

    I have tried ParallelPeriod for a calculated measure and it works fine, except that when I change to other time hierarchy....
  28. Hi Roland, Yes.. it helps very much. Very...

    Hi Roland,

    Yes.. it helps very much. Very confused on the where the actual configuration resides.

    Thank you very much !

    ps : still waiting for your upcoming book ;)

    Regards,
  29. How to remove user selections in BI-Server 2.0 PCI ?

    Hi All,

    How do I remove user selection list in login dialog box preconfigured in Pentaho BI-Server 2.0 and leave out only user / password textbox ? I look at MantleLogin.jsp but find no clue...
  30. Scheme and Error Details

    I thought it was Mondrian's nature.

    Ok, here's my scheme




    <Dimension name="Time" type="TimeDimension">
    <Hierarchy hasAll="true" allMemberName="Semua Waktu" primaryKey="date_tk">
    ...
  31. Multiple Time Hierarchies and MDX Calculated Members (Time Related)

    Hi All,

    I used multiple time hierarchies in my scheme. One with Year - Month - Day hierarchy, and the other with Year-Quarter-Month-Day hierarchy.

    If I use time related calculated member's...
  32. Hi Matt, I never used to convert date to...

    Hi Matt,

    I never used to convert date to Integer. But have tried it and appears to be simpler.

    Thanks for this useful tip :)

    Regards,

    Feris
  33. Replies
    7
    Views
    3,006

    Hi Tom ! How're you doing ? It's great to be...

    Hi Tom !

    How're you doing ? It's great to be active again in the forum :)

    Btw, Mantle project is great... once it deployed as a default PCI BI-Server 2.0, it make us easier to understand...
  34. Replies
    7
    Views
    3,006

    Hi Harris, Have you restarted the server ? I...

    Hi Harris,

    Have you restarted the server ? I never do anything with Hibernate.

    Attached are the working screenshots if that can convince you that the method is working.

    Regards,

    Feris
  35. Replies
    7
    Views
    3,006

    Hi Harris, To do that, you need to edit...

    Hi Harris,

    To do that, you need to edit /pentaho-solutions/system/olap/datasources.xml and add a catalogue.

    For example :



    <?xml version="1.0" encoding="UTF-8"?>
    <DataSources>
  36. Replies
    1
    Views
    2,048

    Can you post the table scheme (DDL) you are using...

    Can you post the table scheme (DDL) you are using right here and attached the .ktr file ?
  37. Hi Nashrul, Based on your case, I've created a...

    Hi Nashrul,

    Based on your case, I've created a wiki article answering your question. You can check it in :
    ...
  38. Replies
    4
    Views
    7,943

    Hi Fauzul, You can use PrevMember mdx...

    Hi Fauzul,

    You can use PrevMember mdx function. For example, you can see my wiki article at :

    http://pentaho.phi-integration.com/mondrian/mdx-menghitung-pertumbuhan-penjualan-tiap-periode
    ...
  39. Replies
    2
    Views
    1,857

    Thanks Matt for the confirmations. It's ok for me...

    Thanks Matt for the confirmations. It's ok for me now to edit it manually.

    Regards,

    Feris
  40. Thanks for the alternative solution I once...

    Thanks for the alternative solution

    I once had this problem and resolved by force it to use Axis for SOAP and the Xalan libraries in JPivot :
    ...
  41. Replies
    2
    Views
    1,857

    Changing Database

    Hi Everyone,

    I'm now working quite extensively with PME. But I haven't swith database for all domains that I created. Is there any issue with that ?

    What if the underlying tables have different...
  42. Replies
    2
    Views
    1,445

    Hi Sven, Thanks for the comprehensive reply....

    Hi Sven,

    Thanks for the comprehensive reply. Actually I need to do it for a particular database system, but as I go I will keep your notice as the first thing in my mind.


    Regards,

    Feris
  43. Replies
    2
    Views
    1,445

    DDL Generation API

    Hi Kettle Developers,

    Which part of the API that calls the auto generation of DDL (Data Definition Language) in "Table Output" step when we click SQL ? I'm working on developing a plugin and need...
  44. Replies
    10
    Views
    4,094

    Hi Sita, Yes, have writing the path...

    Hi Sita,



    Yes, have writing the path myself... experimenting with \ and / and both return the same result. And when I'm not using file:// it returns inexpected error: null.

    Trying to look...
  45. Replies
    10
    Views
    4,094

    Hi Sita, That output was returned by the...

    Hi Sita,

    That output was returned by the logger.. I used kettle internal variable for the target folder: ${Internal.Job.Filename.Directory }.
  46. Replies
    10
    Views
    4,094

    Hi Sven, Is it something that has to do with...

    Hi Sven,

    Is it something that has to do with Apache Virtual File System ?

    Look at the trace log.... the error is :

    Inexpected error: file:\c:\data\email\feris_20082406_193624281_1.mail

    Is...
  47. Replies
    10
    Views
    4,094

    Hi Sven, Hm...weird. My space is still 14 GB....

    Hi Sven,

    Hm...weird. My space is still 14 GB. Is it something that has to do with Microsoft Win XP SP3 ?

    What else may cause the warning/error ? I'm checking the source but not familiar with...
  48. Replies
    10
    Views
    4,094

    Anyone has ever experienced this issue ?

    Anyone has ever experienced this issue ?
  49. Replies
    10
    Views
    4,094

    Pop Mail Error

    Hi,

    I have pop mail step in my job which connect successfully to retrieve mail but failed to save file.

    I have tested it against POP with SSL and non SSL and have same result. And it applies...
  50. Replies
    1
    Views
    1,313

    Mondrian ? ...

    Mondrian ?



    http://mondrian.pentaho.org/documentation/installation.php
Results 1 to 50 of 77
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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