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 were not displayed. The key to this solution is …
Read More »Tech Tips
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 following fields: A user who wants to see only the …
Read More »Xcelsius Tech Tip: Overcoming Checkbox Shortcomings
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 this article, I will describe how I altered my design …
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 such as long waiting time after opening a report, log …
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 an employee dashboard with 4 different tabs “City”, “Employee”, “Region” …
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 to help them remember how to set it up. …
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 create one report with separate tabs. What If your end …
Read More »Tech Tip: Customize the Reset Functionality in SAP Dashboards/Xcelsius
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 situations though when the functionality needs customization. (Fig. 1) I …
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 example of this might be where we have 3 Combo …
Read More »Creating Infographics with Standard Xcelsius Components
There is constant evolution in technology, and how things look and feel is part of that evolution. What looked new and exciting last year is now the norm, and something else is wowing people. The first time I saw an Xcelsius model (now called SAP Dashboards) I was very impressed with how it looked. The next time I saw a …
Read More »