Tableau uses the concept of hyper extracts – a compressed snapshot of data stored on disk and loaded into memory when required to render a tableau visualization. Hyper extracts are very beneficial and even essential to Tableau users. To refresh an extract on a daily, weekly or monthly basis users …

Business(s) and their units send hundreds to thousands of emails out via report scheduling. Delivering the correct reports to the right person is mission critical for efficient business process. Currently, a recall email feature exists for incorrect emails sent within network, but the recipients are notified of the email recall. Verifying the report and …

In one of my recent client engagements, there was a requirement to replace Microstrategy reports to Crystal Reports. The business users were not ready to compromise on the format of Excel. I created a crystal report with Microstrategy SQL and used InfoBurst – Infosol’s flagship bursting product to deliver these excel …

It’s been a while since I published part 1 but hey, better late than never.  So here’s Part 2 of my previous blog “Crystal Reports Export to Excel – Part 1”. I have used the same report from Part 1. The following tips & tricks will help you in providing a perfect/clean …

We have seen various ways to create reports like Top 10 Customers by Sales, Top 10 Cities by population, Top 5 countries by profit Margin etc. It’s usually Top N by a <Measure>. What if there’s a requirement Top N by a <Date> or Most Recent N by a <Date>? …

In my previous blog I had explained a technique for dynamic Report field selection on a crystal report. If the order of the fields selected is changed we end up having empty spaces as shown below:   Here are the steps to be followed to avoid these inevitable spaces, when certain fields …

Crystal Reports are very good for printable reports, but what if you don’t need every single field on the report? What If you had to dynamically change the report fields. This blog will help you in designing a crystal report with dynamic report fields. Consider a crystal report with the …

In my previous blog, I talked about “5 Easy Steps for Designing a Dynamic Y-Axis Web Intelligence Report Leveraging Derived Tables in IDT”. In this post I am going to show how the same derived tables concept designed in IDT can be utilized to create a performance optimized dashboard. Consider …

“Create a sales report by state, by city, by store, by year, by quarter, by month…” and the list goes on. This is a very common report requirement from a business. The usual procedure for designing this report in Web Intelligence is to create different reports for each dimension or …