Tech Tip

Join Adam Lange in a fantastic and informative webinar dedicated the what’s new with Web Intelligence 4.1. The charts offered in Web Intelligence XI 3.1 were notoriously limited in their functionality and effectiveness. In the latest version, Web Intelligence 4.1, SAP introduced many improvements to the chart engine which allow …

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>? …

Question: I would like a user to have a menu option to select ALL values in a dynamic prompt list, instead of having to set up the prompt to allow multiple values and the user having to select the double-arrows, if they want to use all the prompt values to …

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 …

I had the unfortunate experience of having a root canal performed last week and it was not pleasant, but during the procedure I was totally fascinated by the way the Endodontist  spoke to his assistant.  He used terms and an entire language that I didn’t understand, but was second nature …

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 …

Having antivirus software is great to maintain the immunity of a system, but in certain cases these AV softwares can start to over work themselves and it can really take a toll on the machine and can also affect the overall performance of Business Objects. I have seen clients face issues …

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 …

Modern Business Intelligence (BI) platforms like SAP BusinessObjects, SQL Server Reporting Services and Yellowfin BI give organizations a wealth of reporting tools. Tools like Web Intelligence, Crystal Reports and SSRS make it easy to create attractive and valuable BI reports. Getting those reports into the hands of consumers and decision …