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 Return Values in Jasper Reports By Nikhilesh Return Values from Sub Dataset to Main Dataset in Jasper Reports Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Sometime it is required to return values from sub dataset to main...
Business Intelligence Hiding Items in Schedule Output Options Tab of Jaspersoft By Nikhilesh How to Hide Some Items in Schedule Output Options Tab Dynamically According to Roles --> In this case, my aim is to hide File Handling & Output Destination to the Role_user so that he cant able to save schedule to...
Business Intelligence Date Field Format Customisation in Adhoc View on Jaspersoft UI By admin Date Field Format Customisation in Adhoc View on Japser UI Often while working with Adhoc Reports on jasper we get limited option for the available date format in jasper. There are number of ways to fix this but one I...
Business Intelligence Points to Remember While Developing JRXML By Nikhilesh Few Points Needs to Remember While Developing JRXML 1) Use .equals() comparison operator for String fields If you want to compare string fields then use .equals() function instead of == operator. In Java, the == operator compares if the objects...
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 How to Disable Columns in Jasper Report Dynamically? By Nikhilesh Disabling Columns from JasperReport Dynamically We can disable columns dynamically from Jasper Report based on our requirement. Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Grab The 30 Days Free Trail...
Javascript Service in Linux By Somen Sarkar Service in Linux The service are set of programs that run as background process, so it is ready to use anytime by the users. The service gets started when the machine is rebooted automatically. How to create a Service? The...
Business Intelligence Repository Checkbox in Output Options Tab Dynamically By Nikhilesh How to uncheck Output to Repository checkbox in output options tab dynamically for job Schedule in JasperReportServer 6.2 & 6.1 Respectively. Changes for JasperServer 6.2 : We have make changes in JobModel.js which is located in the Path: <Tomcat Home>\webapps\jasperserver-pro\scripts\bower_components\jrs-ui\src\scheduler\model....
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...
Business Intelligence Charts in BIRT – A Simple Chart Example By Shraddha Tambe Charts in BIRT - A Simple Chart Example In this tutorial, we will create a BIRT report with a simple Bar chart showing the monthly sales in 3 different states of the US. We will be using the same food...
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...