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 »
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 ...
Read More »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 »The checkbox is one of the most common UI elements that allow its users to have binary choices and it is available out-of-the-box in Xcelsius/SAP Dashboards. However, the Xcelsius component is limited due to the inability to control the selection or reset to its default state in run-time programmatically. In ...
Read More »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 »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 »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 »“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 »Reset is a built-in functionality provided in SAP Dashboards. The standard functionality is achieved by simply adding the Reset button which user can click to return the dashboard to its original state and reset the changes performed by user. This is typically used in dashboards with What-If-Analysis controls. There are ...
Read More »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 »