Business Intelligence Relative Date Parameters in Jasper Server – Usage with Examples By Shraddha Tambe Relative Date Parameters in Jasper Server - Usage with Examples Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. This blog gives a brief introduction of how Relative Date Parameters can be...
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 Converting TimestampRange to Timestamp By Nikhilesh Converting TimestampRange to Timestamp with default value expression and passing it into the Dataset Here when we are using our parameter class as net.sf.jasperreports.types.date.TimestampRange with default value expression like new java.sql.Timestamp((new Date()).getYear(), (new Date()).getMonth(),1,0,0,0,0) then it will return (2016-01-01 00:00:00)...
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 Introduction to ETL By Sohail Introduction into E.T.L (Extract, Transform and Load) This a process related to data warehousing which involves the extracting of data out of the source system/Systems and placing it into a repository or Target. Extraction Extracting the data from source systems...
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 Organization Security In Jaspersoft By admin Organization Security In Jaspersoft Security implied on the report based on the organization details of the logged in user can be brought into reality through the use of parameter “'$P!{LoggedInUserAttribute_organization}'”. Here we have called this parameter in the Input control...
Business Intelligence New Jaspersoft 6.3 By Nikhilesh What’s new in Jaspersoft 6.3? Jaspersoft is majorly known for Pixel Perfect Reporting. But Jaspersoft has always lagged behind when it comes to Dashboards when compared to other tools available in the market. The capabilities one has for Dashboards in...
Business Intelligence Localisation of Text, Images and Input Control Labels in Jasper Reports Server By admin Introduction : Jasper gives users the freedom of configuring the text, images and Input control labels according to the client language. This blog shows the process of localizing the reports by defining the exact translation of the text and input...
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...