Business Intelligence Delete Duplicate Records Without Primary key By Nikhilesh Delete Duplicate Records From a Table without Primary key To find the duplicate records in the data and delete them Specifications: There is a table tbl1 with columns as follows The data is as follows: Query...
Business Intelligence Helical Insight for ETL Tester (QA) By nitin sahu Helical Insight for ETL Tester (QA) Let's take an example that your ETL developer has just wrote an ETL script, which loaded the data into the Data Warehouse, few millions of records got inserted into the Data Warehouse. For QA,...
Business Intelligence Why Helical Insight -ADHOC? By admin HI (Helical Insight) is a reporting tool (BI tool) that helps in Data Visualization of various kinds like Tables, BarCharts, LineCharts, etc. It is a very good tool since its use is simple and easy. HI has a feature called...
Business Intelligence Virtual Cubes and their Significance in Mondrian By Nikhilesh What is a Virtual Cube and What is its Significance in Mondrian Before going into the Virtual cubes, first lets just refresh our memory about what is a cube. A cube is basically a multi dimensional views of data,querying and...
Business Intelligence How to use List (Component) in Ireport Jaspersoft By Nikhilesh How to Use List Components in Ireport : Make data easy with Helical Insight. Helical Insight is world's best open source business intelligence tool. Click Here to Free Download When dragging over a list component to one of the report's...
Business Intelligence Jaspersoft 6.2 Features and Upgrades By Nikhilesh Dear Jaspersoft Users, In this blog we would be talking about the latest version of Jaspersoft i.e. Jaspersoft 6.2 new features. a. Advanced multi-tenant server administration capabilities Jaspersoft in its latest release is providing more options to for administration of...
Business Intelligence Passing Parameters in Pentaho Data Integration Part 1 By Nikhilesh Passing Parameters From Parent Job to Sub-Job/Transformation in Pentaho Data Integration (Kettle) - Part 1 Part -1 : Using setter and getter methods : 1.Set variables in parent job/transformation. 2.Get variables in sub-job/transformation. Make data easy with Helical Insight. Helical...
Business Intelligence Passing parameters in Pentaho Data Integration Part 2 By Nikhilesh Passing Parameters From Parent Job to Sub Job/Transformation in Pentaho Data Integration (Kettle) -Part 2 In part 1, I have mentioned about passing parameter values down to sub-job/transformation using setter/getter methods. Please refer my previous post for part 1 Passing...
Business Intelligence Creating a Project in SpagoBI Studio By Nikhilesh Creating a project in SpagoBI Studio SpagoBI Studio is an eclipse based BIRT reporting software and creating a project in SpagoBI studio is very much easy and recommended too as all our reports / documents will be organized in better...
Business Intelligence Creating a Folder in SpagoBI Server By Nikhilesh Creating a folder under Functionalities Tree in SpagoBI Server In general Spago BI uses its own functionalities tree which allows to better organize documents / reports by grouping them in folders. Although in built Folders are provided to organize (Analytical...
Business Intelligence How to Replace Various Characters Using Jasper Studio By Sohail How to Replace Various Unwanted Characters during Reporting Using Jasper Studio Reporting in Business Intelligence is the representation of Data in a more meaningful manner so at times we need to follow some few formats to make our data to...
Business Intelligence Introduction To HBASE By admin Introduction To HBASE HBASE is the database which stores huge amount of data and we can retrieve data in a random manner. HBASE is distributed column-oriented database which is built on top of the haddop file system.Tables in it are...