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...
Business Intelligence Input Control Labels Collapsible in Jasper Server By Nikhilesh How to Make Input Control Labels Collapsible in Jasper Server Using Optional JSP We need to create our own JSP Example : lets say Optional.jsp is our jsp which should be kept under location in your jasperserver jasperreports-server-6.2.0\apache-tomcat\webapps\jasperserverpro\WEBINF\jsp\modules\inputControls In this...
Business Intelligence Dimensions in Data Warehouse By admin What are Different Types of Dimensions in DataWarehouse? What is Dimension in Datawarehouse? Anything which measure facts like time,length,status,ID,date,place,codes,flags with its description,audit and other attributes is stored in table is called as dimension. It contains the description of the buisness, without...
Business Intelligence Scheduling Jobs in Pentaho Data Integration By Nikhilesh Scheduling Jobs in Pentaho Data Integration The following are the steps to schedule a kettle job: In the main kettle job (.kjb) , there is a START icon should be there. Double click on the icon and it will pop...
Business Intelligence Parameterized BIRT Reports Multi Select Parameter By Shraddha Tambe Parameterized BIRT Reports – Multi-Select Parameter This blog will help you add a multi-select parameter in BIRT report and filter the data. In the last blog, we parameterized a “sales report” by adding a single select parameter “store city” to...
Business Intelligence Implement Rollback in Pentaho By Nikhilesh A Simple yet Effective way to implement Rollback in Pentaho What is a Rollback mechanism? In database technologies, a rollback is an operation which returns the database to some previous state. Rollbacks are important for database integrity, because they...
Business Intelligence Parameterized BIRT Reports By Shraddha Tambe Parameterized BIRT Reports – Simple Parameter In this tutorial, we will parameterize a simple BIRT report by adding a single select dynamic parameter to filter the report. (To learn how to create a simple BIRT report without parameter you may...
Business Intelligence How to use Angular Gauge in iReports By admin Angular gauges are essentially like the speedometer or the fuel gauge of a car. They use a radial scale to display the data range and a dial to indicate the data value. Database used:- Foodmart(Mysql) Query :- "select salary from...
Business Intelligence Memory Group By Vs Group By in Pentaho DI By Nikhilesh Memory Group By Vs Group By in Pentaho DI Group By and Memory Group By: These steps are useful to calculate aggregate values for the group of fields. Make data easy with Helical Insight. Helical Insight is the world's best...
Big Data JSTL SQL Tag Lib By Somen Sarkar The <sql:> tag lib in JSTL The sql tag lib helps to develop a simple jsp database application. This taglib comes in handy with dataSoursetDataSource, query, transaction and update tags The tag lib can be used by putting the following...
Business Intelligence The Print When Expression By Sohail The Print When Expression The print when expression in Jasper Studio or Jasper iReport is very useful in so many requirements and it is defined as the name itself implies i.e Print /Show a String, Column and so on Based...
Business Intelligence PDI Variable Parameter Behaviour By admin This article is specifically for those who are new to using PDI and are facing difficulty in understanding how the variables behave when being passed from one job / transformation to another job / transformation. PDI provides set variable component...