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 Jaspersoft CE v/s EE / Having Jaspersoft EE functionality in Jaspersoft CE By Nikhilesh Jaspersoft CE versus EE / Having Jaspersoft EE functionality in Jaspersoft CE Jaspersoft is world’s leading Open source BI software with more than 1.75 million download and usage. It comes in two variants, one is the community edition which...
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 Jaspersoft Default Passwords By Nikhilesh 1. Jaspersoft Corporation - Jasper Reports Server Method HTTP User ID : superuser Password : superuser Level Administrator Doc http://community.jaspersoft.com/documentation/jasperreports-server-install-guide-community-edition Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Grab The 30...
Business Intelligence Hire Jaspersoft Consultants / Hire Jaspersoft Developers / Hire ireport Developers By Nikhilesh Helical IT Solutions, with its deep expertise on Jaspersoft and being an open source DW BI expert, can help in designing and constructing your BI solution. Helical IT solutions is having experience on end to end Jaspersoft BI suite right...
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 ...
Business Intelligence Split Excel output of Jasper Report into multiple sheets By Nikhilesh Hi Jasperians ...!!!! A friend posted an interesting query on LinkedIn asking how to split Excel output into multiple sheets... !!! Just worked out and sharing it with you guys..!!! It's a sample one.. No parameters, No headers are used......
Business Intelligence Installing Jasper server with MySQL Database By Nikhilesh This blog will help you understand how to install Jasper Server with MySQL database Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. Get your 30 Days Trail Version Pre requisites 1....