US and Worldwide: +1 (866) 660-7555

Search Forums:

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

Search Forums: Search took 0.01 seconds.

  1. Yes Matt, thanks, that makes sense. That's what...

    Yes Matt, thanks, that makes sense. That's what we have been leveraging since the start.
    Where-ever applicable, we use Redshift bulk load(Using S3 and Copy Command) and for the rest, we use direct...
  2. Thanks codek for the reply back. Yes,...

    Thanks codek for the reply back.
    Yes, rewriteBatchedStatements works for mysql, but looks like there is nothing such for Redshift(which is based on postgres engine) driver.

    Have been in a real...
  3. Replies
    19
    Views
    3,221

    Pentaho has a new plugin "Pentaho JCR...

    Pentaho has a new plugin "Pentaho JCR Synchronizer", you may want to check this and see if this helps...
    http://pedroalves-bi.blogspot.com/2013/12/new-pentaho-application-pentaho.html

    Sujen
  4. Having problem using Mondrian Datasource Import API

    Hello,

    I am working on pentaho-plugin development, I need to leverage the Mondrian Datasource Import API(especially, org.pentaho.platform.plugin.action.mondrian.catalog.MondrianCatalogHelper) to...
  5. make "batch inserts in table output" generate single multi-rows insert statement

    Hello All,

    The option "Use batch update for inserts" in table output step seem to generate a group of insert statements, as opposed to "single multi-row insert statements", as stated in wiki ...
  6. Configuration to enable Pentaho Analyzer DrillDown Link by default

    Hello All, Is there any configuration within Pentaho Analyzer, to enable drill down links on Pivot cells by default, i.e. show the links when the report opens, so that we don't have to enable the...
  7. Slow insertion in Amazon Redshift with Table Output step

    Hello All,

    I have been facing a performance issue with using Table Output step to write records into Amazon Redshift. Is it due to step firing single insert statment? If yes, how can we use...
  8. Customizing the default drillthrough behaviour of Pentaho EE Analyzer

    Hello All,

    I am just wondering if anyone has come across the requirement of customizing the default behaviour of Pentaho EE Analyzer's drillthrough feature. As of now, it displays the source data...
  9. Replies
    0
    Views
    353

    Pentaho Datasource Impersonation

    Hello All,

    Is there any workaround to imperonate datasource? We require to have each tenant access the database via its own db logon.

    Thanks,
    Sujen
  10. Replies
    2
    Views
    1,111

    Hi Luc, thanks for the info. Really...

    Hi Luc,

    thanks for the info. Really appreciated.
    So, yes I will definitely keep eye on new releases.

    We are good with mondrian-redshift so far.

    Will keep you posted if we confront any...
  11. Replies
    2
    Views
    1,111

    Mondrian - Redshift

    I just did a quick test on mondrian(3.3 version)-redshift connection. I have been able to get my cube working so far. Redshift is based on postgre 8.0...and mondrian already has support for postgres...
  12. Any thoughts on this????

    Any thoughts on this????
  13. How to skip DB scan for implicit aggregation tables

    Hello All,

    Is there any way to skip the DB scan done by mondrian to find the implicit agg tables but make it use the explicit agg tables defined in the mondrian schema file??

    Was expecting, ...
  14. Replies
    0
    Views
    360

    Salesforce Plugin and the bulk API

    Does the SalesForce Plugin steps leverage the bulk API http://wiki.developerforce.com/page/Loading_Large_Data_Sets_with_the_Force.com_Bulk_API ?????

    Thanks,
    Sujen
  15. Hi, Could you please also post the "dimension...

    Hi,

    Could you please also post the "dimension section from the mondrian schema", for the date dimension??? Also, which version of Mondrian are you using????

    Thanks,
    Sujen
  16. You may want to have a look at this post re HCD...

    You may want to have a look at this post re HCD on mondrian (http://devdonkey.blogspot.com/2011/03/mondrian-high-cardinality-dimensions.html)
  17. Replies
    2
    Views
    1,316

    Recalling the old post.. Any further details...

    Recalling the old post..

    Any further details to figure out the workaround for such cases??

    Thanks,
    Sujen
  18. Replies
    1
    Views
    989

    Hello all, Any suggestions on this???

    Hello all,

    Any suggestions on this???
  19. Replies
    1
    Views
    989

    Multitenancy and Aggregate Tables

    Recently we implemented multitenancy using the mondrian's custom dynamic schema processor. We have a filter expression in the schema definition file, that is replaced by appropriate query expression...
  20. Parallel loading of transformation for every input row

    Hi,

    I am having performance problem with loading fact tables using PDI.
    After getting records from source , multiple database lookups are performed in dimension tables for key value before...
  21. Hello Mark, Thanks for sharing, very much...

    Hello Mark,

    Thanks for sharing, very much appreciated.
    Yes, not sure abt the exact reason behind the idea of storing mapping definition in HBase. Seems like , need to open an enhancement in JIRA...
  22. Hello Mark, Thanks for your response. It makes...

    Hello Mark,

    Thanks for your response. It makes sense.

    But my HBase Server is running on Amazon EC2 instance, and as such, the client(PDI in our case) is not able to connect to it via zookeeper...
  23. Thrift Connection Support in PDI's HBase Output Step

    HBase Output Step has support for Zookeeper connection only, so how to load data into remote HBase via Thrift gateway?

    Thanks,
    Sujen
  24. Replies
    7
    Views
    1,633

    Reports Off HBase

    Pentaho 4 version has come out with good support for NoSql technologies. I was wondering, if we could create the pentaho reports directly off the HBase datasource , without having to use PDI to...
  25. Integrating pentaho analyzer independently into java web application

    Pentaho analyzer's been developed as a Pentaho plugin based on its plugin architecture, so I dont see any straightforward approach to integrate it into other java based web application independently....
  26. A parent/child hierarchy is not visible in Pentaho Analyzer tool

    We have a dimension with default hierarchy set as parent/child hierarchy. But it's not visible in analyzer tool , while Jpivot presents the hierarchy as standard hierarchy.
  27. Replies
    5
    Views
    3,258

    Any help on this????

    Any help on this????
  28. Replies
    5
    Views
    3,258

    However, it works with the saved report created...

    However, it works with the saved report created by the pentaho's analyzer tool. Tried with pentaho's enterprise evaluation version.

    Sujen
  29. Replies
    5
    Views
    3,258

    I guess, you must have defined your dynamic...

    I guess, you must have defined your dynamic schema processor parameter in datasources.xml file. The datasource related settings in datasources.xml is for XML/A based connections only. When you first...
  30. It worked when specified the dynamic schema...

    It worked when specified the dynamic schema processor parameter in the DatasourceInfo under Catalog tag element. Also, the custom schema processor implementation is working as expected. The...
  31. Replies
    2
    Views
    818

    http://forums.pentaho.com/showthread.php?73131-How...

    http://forums.pentaho.com/showthread.php?73131-How-to-create-cube-in-New-Analysis-View
  32. Did you check foodmart schema and its source mart...

    Did you check foodmart schema and its source mart tables?

    Sujen
  33. Yes there should be some error messages in your...

    Yes there should be some error messages in your console or check the pentaho.log file under the biserver-ce/tomcat/bin folder location.

    BR,
    Sujen
  34. Dynamic Schema Processor Implementation

    I am trying to implement a custom dynamic schema processor to filter the data based on the user logged into the pentaho BI server, that corresponds to each client. So, for this, I have planned to use...
  35. Replies
    0
    Views
    483

    measures visible property

    Hello,

    Why is Mondrian Xmla server returning the measures with the "visible" property set to "false"?

    Regards,
    Sujen
  36. Replies
    1
    Views
    654

    Any suggestion on this? Thanks in advance. ...

    Any suggestion on this?

    Thanks in advance.

    Sujen
  37. Replies
    1
    Views
    654

    Specifying hierarchy name

    Hello,
    I made few changes in foodmart sample schema. I specified name attribute in case of Hierarchy tag , the start of the schema looks like

    <Schema>
    <Cube name="Sales">
    <Table...
Results 1 to 37 of 37