ETL Java Annotation By Somen Sarkar Java Annotation Annotation Quick Tips 1. Annotations were introduced since java 1.5 2. Annotation are data about the code. They are tags that may be useful while compilation or execution. 3. @Override, @author etc are some defualt annotations. 4. We...
Business Intelligence How to Create a Batch File to Run a Scheduled Pentaho Transformation By Nikhilesh HOW TO CREATE A BATCH FILE TO RUN A SCHEDULED PENTAHO TRANSFORMATION Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Make data easy with Helical Insight. Helical Insight is the world's...
Business Intelligence How to Write Basic MDX Query By Nikhilesh How to write basic MDX query When writing MDX queries you need to make a clear distinction between the data and metadata. Cube data is what is being presented to the users, for example you would show the sales amount...
Business Intelligence Drill Down in Same Panel in Pentaho CDE By admin Drill Down in Same Panel in Pentaho CDE First create dashboard having two three panels as in example shown below :- Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your...
Business Intelligence Mondrian Cache Refresh Automation Mechanism in Pentaho BA Server By Nikhilesh REFRESH MONDRIAN CACHE ON THE BA SERVER One of the strengths of mondrian's design is that you don't need to do any processing to populate special data structures before you start running OLAP queries. More than a few people have...
Business Intelligence Beginner’s Guide to E.T.L (Extract, Transform and Load) – Connection Set-Up By Sohail Connection Setup for connection type: PostgreSQL [We are now setting up a connection to A database i.e if your source is a database] There are 3 ways of access provided for Connections using PostgreSQL a. Native (JBDC) b. ODBC c....
Business Intelligence Pentaho BA Server 6.0 : How to enable Pentaho Marketplace and Pentaho CDE(CTools) in the Enterprise Edition By Nikhilesh Enable Pentaho Marketplace and Pentaho C-Tools in Pentaho BA Server 6.0 EE Pentaho 6.0 is the first version of the Pentaho enterprise-class server with new features to automate, manage and enhance every stage of the data pipeline. Pentaho 6.0 also...
Business Intelligence Functions For Linking Two Dashboards in Pentaho CDE By Nikhilesh Use of Setparam() and GetParam() function for Linking Two Dashboards in Pentaho CDE In order to link two dashboards using Pentaho CDE, we can define two set of functions one which could set the parameters and the other where one...
Business Intelligence Remove Duplicate Values using Pentaho Kettle PDI ETL Tool By Nikhilesh How to avoid duplication of values in the columns in PDI if column names are same? Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your 30 Days Trail Version There...
Business Intelligence WITH Clause in MDX Pentaho By Nikhilesh WITH clause in MDX In MDX queries, the WITH clause has an important role to play. WITH clauses are used to define some members which will be used in the SELECT clause for analysis purposes. The WITH clause contains either...
ETL Get the Row Count in PDI Dynamically By admin Get the Row Count in PDI Dynamically Often people use the data input component in pentaho with count(*) select query to get the row counts. And pass the row count value from the source query to the variable and use...
Business Intelligence Cross Tabs in Pentaho Report Designer By Nikhilesh CROSSTABS in Pentaho Report Designer (EXPERIMENTAL FEATURE) Crosstabs are easy and relatively easy way to visualize tabular data along two or more axis. Crosstabs are still experimental feature, and as such are not up to mark in BI...