Hitachi Vantara Pentaho Community Forums

Search Forums:

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

Page 1 of 2 1 2

Search Forums: Search took 0.02 seconds.

  1. Pentaho Authentication using Third Party APIs

    Hello Folks,

    We are trying to authenticate pentaho BI server with a third party APIs and want to set a session(authentication token) is it possible ? Please suggest your views.

    Basically we...
  2. Time Out Issue : org.postgresql.util.PSQLException: An I/O error occurred while sendi

    Hello Folks,

    I have a pentaho report which is using data source as PDI transformation, This pdi transformation is combining the data from postgressql and mongoDB. it was working fine with a less...
  3. Hello, I have tried same way in pentaho CE 6.0...

    Hello,

    I have tried same way in pentaho CE 6.0 but it's not working for me could you please assist me ?

    Thanks

    Nitesh
  4. Hello, Is it possible to use a CDC cache in a...

    Hello,

    Is it possible to use a CDC cache in a pentaho server cluster ?


    @pedro : could you please give me some suggestion in this situation ?

    I have implemented the CDC for...
  5. Pentaho BA server cluster with CDC not working

    Hello,

    We have 3 pentaho server in a cluster with single repository and implemented CDC cluster on these nodes. now when I execute a MDX query from pentaho node1 data is cached over the CDC nodes....
  6. Mondrian Role Parsing and Dynamic Role

    Hello,

    We have a schema(cube) with more then 1000 roles when I publish the cube and try to access this from saiku plugin taking too much time in loading approx 20 minutes for 1000 roles.

    I have...
  7. Replies
    4
    Views
    1,522

    Hello mcampbell, Thank you forlooking in the...

    Hello mcampbell,

    Thank you forlooking in the issue, I am following same steps here I am attaching the mdx log with queries and both queries are only from Steels Wheels data source from pentaho.
    ...
  8. Replies
    4
    Views
    1,522

    Hello mcampbell...

    Hello mcampbell ,

    Thanks for quick reply, is there any chances to reduce this time also to a extent.

    Regards

    Nitesh
  9. Replies
    4
    Views
    1,522

    Pentaho CDC and mondrian cache

    Hello Folks,

    I have implemented CDC cache in pentaho 5.4 and modified saiku plugin configuration to utilize CDC cache.Everything is working fine. But I have observed few things which are like :
    ...
  10. Replies
    1
    Views
    1,163

    Hello, I have solved this by editing...

    Hello,

    I have solved this by editing mondrian.jar and added spark dialect.

    Community Rocks !!

    Regards

    Nitesh
  11. Replies
    1
    Views
    1,163

    Sub Query Not working in CUBE

    Hello,

    I am using pentaho 5.0 and hadoop 2.0 for my current scenario, I have created a cube with some fact and dimensions when i add a dimension with a view in dimension it's not working and...
  12. Replies
    1
    Views
    703

    Outer join in saiku cubes

    Hello Folks,

    Is it possible to have a outer join in fact and dimension tables while designing a schema ? because by default it is inner join between face and dimension tables.

    Like below...
  13. Hello Joey, I think to loop you second...

    Hello Joey,

    I think to loop you second transformation you will need to check "execute for every input row ?" in properties and then in first transformation copy rows to result and in second get...
  14. Hello, Can you send me the sample ktr you have...

    Hello,

    Can you send me the sample ktr you have written so that I can look into this ?

    Regards

    Nitesh
  15. Execute Saiku files from kettle or any other option

    Hello,

    I am trying to execute a saiku file using pentaho kettle by http client component but it's not working with below URL :
    ...
  16. pentaho 5.0 with postgres could not get jdbc connection

    Hello,

    I am trying to configure pentaho 5.0.1 stable version with postgres 9.5 but getting below error I have checked all the configuration and tried a lot but didn't got much success.

    Below is...
  17. You can achieve with a trick

    Hello,

    You can select data source as a kettle transformation and then can manage the things dynamically,I have done same thing by this way.

    Regards

    Nitesh
  18. Too many queries when cube with roles using mondrian in hadoop

    Hello Folks,

    Let me explain you the case : We are using a cube with multiple roles in this we have database as hadoop-spark,it is generating too many queries when I start saiku/jpivot(please have...
  19. Too many queries when cube with roles using mondrian in hadoop

    Hello Folks,

    Let me explain you the case : We are using a cube with multiple roles in this we have database as hadoop-spark,it is generating too many queries when i start saiku(please have a look...
  20. Hello Vijay, You can write a log file for your...

    Hello Vijay,

    You can write a log file for your execution by slightly modifying the statement you are executing as below :

    C:
    cd /E "E:\Utils\PENTAHO_ETL\data-integration\"
    call pan.bat...
  21. Virtual Cube not showing values for a dimension with hierarchy

    Hello Folks,

    I have two cubes with shared dimensions. In these cubes I have one time dimension and one dimension with a parent-child hierarchy in it.

    To join these two cubes I have created a...
  22. Replies
    1
    Views
    1,143

    Hello, Can any one through some light on this...

    Hello,

    Can any one through some light on this ?

    Thanks & Regards
  23. Replies
    1
    Views
    1,143

    Dynamic Data Source Selection

    Hello All,

    I want to implement multi tenancy for multiple clients who have different databases. I have created a single pentaho application for all customers.

    I'd like to deliver this...
  24. Error parsing parameter information. In BA server.

    I have created a report using data source as postgres SQL. Report is working fine in pentaho report designer.

    When I publish this report and trying to access this report throws "Error parsing...
  25. CDE with MS SQL server geometry data type

    Hello All,

    I am using sql server 2013 with data type as geometry (map stored in binary data). I am trying display this geometry data type data in cde component so how could I use.

    Currently it...
  26. Hello, It is solved thanks for your support. ...

    Hello,

    It is solved thanks for your support.

    Regards

    Nitesh
  27. Hello emicarnicero...

    Hello emicarnicero

    This is the content of webapps\pentaho\META-INF\context.xml file

    <?xml version="1.0" encoding="UTF-8"?>
    <Context path="/pentaho" docbase="webapps/pentaho/">

    <Resource...
  28. Pentaho BI server 5.2 with mysql EmbeddedQuartzSystemListener.ERROR_0007_SQLERROR

    Hello All,

    I have configured pentaho 5.2 CE with mysql by following below steps :

    https://anonymousbi.wordpress.com/2013/12/15/pentaho-bi-server-5-0-1ce-mysql-installation-guide/
    and ...
  29. Replies
    1
    Views
    614

    Hello All, I have solved issue and build...

    Hello All,

    I have solved issue and build successfully.

    Thanks
  30. Hello, Could you send me your transformation...

    Hello,

    Could you send me your transformation and dashboard file ?

    Which community edition of pentaho you are using ?

    Thanks
  31. Hello Upload your kettle transformation in...

    Hello

    Upload your kettle transformation in same directory where dashboard resides. Now in data source just write your transformation name instead of with directory path.
    For e.g write only...
  32. Replies
    1
    Views
    614

    Pentaho CBF

    Hello Team,

    I am trying to implement pentaho CBF in pentaho ce 5.0 but didn't got success.

    I have followed below links :
    ...
  33. Thank you so much it solved my problem........:)

    Thank you so much it solved my problem........:)
  34. Access Dimension Value in Calculated Member

    Hello All,

    We have a requirement where a measure value is depend on a dimension Suppose "Country" Dimension.

    Means if country dimension have value "USA" then it should display Some Calculated...
  35. Connection reset by peer: socket write error

    Hello All,

    I have few dashboards developed in pentaho CE 5.0 on database server HP vertica. I am getting "Connection reset by peer: socket write error" error frequently earlier i was getting same...
  36. Replies
    0
    Views
    615

    Pentaho Cache mechanism

    Hello All,

    I have implemented CDC as a caching mechanism for my mondrian server but I want to move now from hazlecast to gigaspace as IMDG's.

    Any way to move from one caching mechanism to...
  37. Replies
    3
    Views
    1,001

    Hello, Thanks for your quick and useful...

    Hello,

    Thanks for your quick and useful reply,Here I want to cache whole cube data is it possible any how ??
    Instead of cretain queries on startup.

    Regards,Nitesh
  38. Replies
    3
    Views
    1,001

    Mondrian Cube data Cache Using CDC

    Hello All,

    Happy New Pentaho Year To All !!

    I am have created a cube with very large amount of data in FACT Table. I have approx 4 Billion records fact table. I have implemented CDC to cache...
  39. Tree Map Chart Conditional Color on vallues

    Hello Folks,

    I have created CCC Tree Map chart successfully.I want to change color of each box on range of values assigned to it.
    I have tried alot but didn't got success.

    Waiting for you...
  40. BI Server Plugin development solution repositroy file access.

    Hello All,
    We are developing BI server plugin. We go though this WIKI (http://wiki.pentaho.com/display/ServerDoc2x/Developing+Plugins ) and added new file extension for Solution repository. By...
  41. Wants read postgres OID images in pentaho data integration

    Hello All,

    I have case in which i want to access postgres OID images files. I want to migrate that images in other database BLOB. Any one have solution help me.


    Thanks & Regards
    Nitesh...
  42. Https Only

    Hello,

    by adding the following <security-constraint> element to the application's WEB-INF/web.xml file you will be able to forward all requests on Https :

    <security-constraint>...
  43. Replies
    6
    Views
    5,060

    Clear CDA Cache in ETL

    Hello All,

    I have tried using this ("http://admin: password@localhost:8080/pentaho/content/cda/clearCache") url to clear CDA cache but not get success.

    I am using Pentaho CE 5.0.1

    Please...
  44. Pentaho ce 5 Initialization Exception

    While working on pentaho bi server, I got following error

    Pentaho Initialization Exception



    The following errors were detected


    One or more system listeners failed. These are set in...
  45. Kettle Job executing using xaction in Pentaho 5.0.1 CE BI server

    Hello All,


    Don't able to access Kettle job from xaction. For that I copy my kettle job and xaction in pentaho solution repository e.g public/phantomjs.


    In that folder I have following...
  46. Replies
    3
    Views
    1,328

    Hello Suresh, To open the dashboard please...

    Hello Suresh,

    To open the dashboard please change *.cdfde file:
    1.Open the *.cdfde file.
    2. Move at last and change filename tag.
    3. Please change the directory Name.

    Regards

    Nitesh
  47. Meta data Security Violation(Meta data Editor)

    Hi Folks,

    I have created a metadata model in that one Business view is created(Category).

    and i have assigned row level security to a user X by this way :
    ...
  48. Replies
    3
    Views
    1,328

    Hi Suresh, Here I have attached some drill...

    Hi Suresh,

    Here I have attached some drill down files for your reference.

    Please let me know if still you are not clear.

    Regards
    Nitesh
  49. Replies
    3
    Views
    967

    Hello, It is quite easy take a text file...

    Hello,

    It is quite easy take a text file output and set extension as "ini" and seprator as ",".

    Please have a look at attached file for sample.

    Regards

    Nitesh
  50. Ok,Pedro I will wait......................Thanks...

    Ok,Pedro I will wait......................Thanks for your support..............
Results 1 to 50 of 64
Page 1 of 2 1 2
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

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