Home / Tech Tips (page 2)

Tech Tips

Crystal Reports with Top N Based on a Date Dimension

InfoSol Blog Tech Tip

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

Read More »

Crystal Reports with Dynamic Report Field Selection – Part 1

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 ...

Read More »

Antivirus Software: Good or Bad for BO 4.1?

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 ...

Read More »

Creating a Performance Optimized Dashboard Leveraging Derived Tables in IDT

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 ...

Read More »

Why won’t my Xcelsius Dashboard USA Map show alerts?

Using the maps provided in Xcelsius/Dashboards 4.x is not difficult, but I have often seen developers forget how to set them up properly to get them to display the data and alerts because it is not the most obvious/intuitive component and also not frequently used. I finally made this cheat sheet ...

Read More »

5 Easy Steps in Designing a Dynamic Y-Axis Web Intelligence Report Leveraging Derived Tables in IDT

“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 ...

Read More »

Customizing Selection & De-selection in Dashboard Data Hierarchies

Being able to “bind” the selected item in a Selector has really allowed Dashboard designers to do more with the magic of moving data behind the scenes.  However, there are times when we want more control … like when we want to “unselect” a selection that has been made. An ...

Read More »