Business Intelligence Bar chart with Target lines in pentaho CDE – making bars as lines using java script in pentaho CDE By Nikhilesh Hi guys, This post teach you how to make bars as lines in pentaho CDE. Scenario : Some end users wants visualization of grouped bars as lines where one of the bar is as bar and remaining bars as targeted...
Business Intelligence Embedding BI Reports (Jasper Reports/ Jasper Server/ Pentaho Reports/ Pentaho Server) By Nikhilesh There are many methods of embedding BI reports, this blog tries to explain the meaning of Embedded BI, different approaches which can be used, their respective advantages and disadvantages A) What is embedded BI? Lets say you have developed...
Business Intelligence Change Data Capture (CDC) – Methods, Approaches, Alternatives By Nikhilesh Change data capture : It’s the process of tracking the data that has changed so that corresponding action can be taken. Its nothing but capturing the changes which are made on the data source and applying it at all the...
Business Intelligence Pentaho CDE Basics By Nikhilesh Pentaho Community Dashboard(CDE) basics - Creating a Simple Dashboard Pentaho Community Dashboard Editor (CDE) What is CDE ? Where you can get the plug-in in Pentaho Community Server ? How to download the plug-in & what are the dependencies? Where...
Business Intelligence Reading data from single data source(Single SQL Query) for two charts in pentaho CDE By Nikhilesh Hi guys...!!! Community Dashboard Editor is the best reporting/dash boarding tool that I have worked. It's smart functionality made me love to work with it and exploring the things time by time. In this post you'll learn how to fetch...
Business Intelligence Extract year,quarter,month & day from date input control in pentaho CDE using java script – MDX Query Scenario By Nikhilesh Hello guys...!! Some times you need to extract the parts(year,month,day) of Date for some specific use.. For example: Assume you are creating a report with MDX query which has dimension called "Date" having levels "Year", "Quarter","Month" & "Day". (Note :...
Business Intelligence Pentaho BI Server community 4.8 Installation in existing tomcat with PostgreSQL in Linux/ubuntu OS By Nikhilesh This post teach you how to install the Pentaho BI Server community 4.8 Installation in existing tomcat with PostgreSQL in Linux/ubantu OS. I've gone through many posts but could not find all the stuff in a single place. I just...
Business Intelligence Sorting and limit the bars on bar charts in Pentaho CDE without ORDER BY and limit functions in SQL Query ( Descending order) By Nikhilesh Hi Guys...!!! This post helps you how you can make your bar chart dynamic.. You can limit the number of bars on bar charts with out using the "limit" function in your query as well you can also sort the...
Business Intelligence Tech Tips in Pentaho Server – publishing password setting for server – Disable the folder names in Browser panel in the Server By Nikhilesh Hi guys.. The below tips are very useful in Pentaho Server for BI developers. 1) publishing password setting for server You need to publish the reports or schema(s)[developed in PSW] once you done with developing. For this you need set the...
Business Intelligence Date Input Controls/ Components in Pentaho CDE with a working example By Nikhilesh Hello guys...!!! In this post you will learn about how to create date input controls in CDE. The dashboard images which I am going to show below are having lots of .css code. I'm not covering all the things but...
Business Intelligence Pentaho Community Dashboard (CDE) Basics – Creating a Simple Dashboard By Nikhilesh Pentaho Community Dashboard Editor (CDE) CTools Website – Community Tools https://github.com/webdetails What is CDE ? * CDE is one of the plugins for Pentaho BI Server, contributed and maintained by Pentaho Partner webdetails. * We create dashboards using...
Business Intelligence Hire Pentaho Consultants / Hire Pentaho Developers By Nikhilesh Hire Pentaho Consultants / Hire Pentaho Developers Helical IT Solutions Pvt Ltd, with its deep expertise on Pentaho and being an open source DW BI expert, can help in designing and constructing your BI solution. Helical IT solutions Pvt Ltd ...