by XTIVIA | Oct 7, 2013 | Blog, Business Intelligence, Databases
At XTIVIA we often receive requests from clients who require somewhat more than the average database administration tasks. Recently I had a request to help a client pull normalized data from one object in one data source and merge that data with data in two...
by XTIVIA | Oct 2, 2013 | Blog, Business Intelligence, Data Warehousing, Perspectives
As professionals working in the business intelligence (BI) and data warehousing field, if we’re not posing questions of our data warehouse, we’re asking ourselves questions–especially about how to do our job better or maximize the value of our warehouse. Here...
by XTIVIA | Sep 19, 2013 | Blog, Business Intelligence
Combining different chart types and adding a secondary vertical axis in SSRS can enhance data visualization significantly. This guide explains how to achieve these features, focusing on the steps to implement a client-side solution for creating complex charts. By...
by XTIVIA | Sep 19, 2013 | Blog, Business Intelligence
Columns can be hidden dynamically by using Jaspersoft iReport’s Table Component (Note: Styling & Group/Sub Group Totals will have to be manually added). To use the Table Component, first add a dataset to the report (select the report in the ‘Report Inspector’ and...
by XTIVIA | May 7, 2013 | Blog, Business Intelligence
Often times when implementing data integration projects – we come across a need to implement a row/key based lookup and based on the found/not-found condition update or insert a row. I started implementing a simple data flow in SSIS. The idea was simple and has...
by XTIVIA | Mar 1, 2013 | Blog, Business Intelligence
I am not a regular ETL developer but I do “dabble” in developing code from time to time. One requirement that I come across is looping (while, for, infinite) in a job and performing a task based on condition and then going to sleep for a period of time....
by XTIVIA | Feb 18, 2013 | Blog, Business Intelligence
It is refreshing to see Microsoft finally acknowledging the business as well as technical framework under which Business Intelligence projects are typically run. By taking this approach, Microsoft is definitely building upon the core competence it has gained over the...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence
Absolutely! The reports from Gartner are great (at least from my perspective) and there is a lot of useful information in them. I found the latest one particularly engaging. As I read through the report, I started thinking about what it means to us (as practitioners...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence
Two bits of Information I picked up from our principal Informatica Architect. When I used these, it did really work wonders. Aggregators and joiners should have sorted input. The Sorter Transformation sorts rows more efficiently that the Aggregator...
by XTIVIA | Feb 13, 2013 | Blog, Business Intelligence, Data Warehousing
Lately, we at XTIVIA have seen a marked uptick for interest in open source ETL tools. Each customer situation is unique, but I would like to propose a few factors that you should review before making the decision: Incumbent Tool Set: Decisions around your choice...
