Tech Tips

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 person prior to distribution is critical …

Tip: Error found at 00 Trick: Truncating datetime to seconds We recently worked with a customer to provide a solution to a datetime field in their PI SQL database (OSI) that was returning a SQL parsing error when using it in a query filter.  Specifically, the error stated “Error found at 00”. Looking into the datetime field we can see …

Tip: How to stop Windows 10 Update from breaking Xcelsius (SAP Dashboards) Trick: Easy install of a patch or Service Pack Has a recent windows update caused your SAP Dashboards to stop working?  It may well be a recent Windows update for Windows 10 which includes some security updates for Adobe Flash Player.   This update may cause you to get …

One of the often overlooked additions given to us in the 4.2 SP3 release was the ability to merge data on variables, not just dimensions.  For many years we have lived with these restrictions in Web Intelligence: 1.) You could only merge on dimensions, not on variables. 2.) The data format between the two data sets had to match – …

Tip: How to pick up User Token or ID from HTTP Headers for use in a Dashboard. Trick: Use InfoBurst to inject the value into the dashboard. Figuring out security in your dashboards can often be one of the more difficult pieces to solve. Often times, we’re able to make use of InfoBurst users, Windows NT users, or even a …

Tip: How to Skip Dataflows for Testing or Restarting a Job for Recovery Trick: Use Bypass One of the greatest features of SAP Data Services is the ability to divert dataflows/workflows in a large workflow or job with multiple steps. This becomes very important when performing system testing or an even more critical situation- recovering an overnight job from failure! …

Tip: How to Document IDT Universe information Trick: Use Save as One of the features of IDT is to document all available setups that were performed on the business layer and data foundation of a .unx universe. In our example, we are going to document E-fashion Universe’s Business Layer. Prerequisites: You need to have a PDF reader Basic skills and …

Same Level Break is a new feature added in the Web Intelligence 4.2 service pack – SP05.  With this type of break, the aggregate is displayed at the same level whenever multiple objects are selected for a break. The breaks depend on the layout of the table, meaning that the first break happens whenever a value of the first object …

We are living in the age of data revolution and more corporations are realizing the fact that to lead or in some cases to survive, they need to harness their data wealth effectively. The data warehouse, due to its unique proposition as the integrated enterprise repository of data, is playing an even more important role in this situation. There are …

In a previous post, Overcoming Checkbox Shortcomings Part 1 , I wrote about a technique I devised to overcome the limitation of the Xcelsius checkbox where it will not programmatically switch to the value in the cell. I needed 10 yes-no checkboxes – one for each row of a tabular display and to be reset to yes/no depending on user interaction. …