BusinessObjects Webinar

All posts tagged BusinessObjects Webinar

Key Takeaways from Dynamic Dates in Web Intelligence

by John S on February 3, 2022 No comments

Dynamic Dates in Web Intelligence Blog Feature Image
Did you miss our February 1st webinar Dynamic Dates in WebI? We have a quick summary of the webinar with the webinar presenters’ key takeaways from their session. This session had a lot of audience interaction with the presenter and we highly recommend checking it out if you use Web Intelligence!

Here is the webinar overview:

A common use case is to run a Web Intelligence report for a date range. That can be easily done with hard-coded date values, but that is not a very user-friendly approach always having to edit the query. Certainly prompts are more user-friendly. However, if you want to schedule a report for a dynamic, named date range such as yesterday, last month, last quarter, etc. you are at a dead-end.

This session will show how I built what I call a “Calendar Universe” a number of years ago that has stood the test of time. We will cover various ways to use dynamic dates talking about the pros and cons of each including the “Calendar Universe”.

Key takeaways from this session:

  • Set the prompt order in the Query Properties.
  • Use the format suggestion in the date prompt to convert the prompt value (always a string) to a date.
  • You cannot compare objects in a filter. Instead create a variable that does the comparison and filter on that.
  • Define a custom format for something other than the default or other available formats.
  • Copy the @Prompt function syntax details from the query script of a universe query and then paste it into a free-hand SQL query.
  • When using “Results from another query” cannot use “Between”; must use “Greater than” and “Less than”.
  • Add the pre-defined Query Summary cell to get an objective view of the queries such as execution time and number of rows returned.
  • Generate a date table dynamically with a common table expression (CTE) in a free-hand SQL query.
  • Add the pre-defined Query Summary cell to get an objective view of the queries such as execution time and number of rows returned.

Don’t forget you can stream this webinar in its entirety as well as ever other Let’s Speak BO webinar we’ve hosted when you are logged in on the site. It is completely free to join!

John SKey Takeaways from Dynamic Dates in Web Intelligence

Key Takeaways from Solving Business Problems with BusinessObjects

by John S on January 5, 2022 No comments

Solving Business Problems with BusinessObjects Webinar Summary Graphic

Did you miss our January 4th webinar Solving Business Problems with BusinessObjects? We have a quick summary of the webinar with the webinar presenters’ key takeaways from their session. Here is the webinar overview:

Using Business Objects for finance reporting has been around for decades, but have you considered using it for data analytics to look for fraud?

This session we’ll cover common data analytics scripts and how BusinessObjects could be utilized to help mitigate fraud. We will discuss ways to solve seemingly complex business issues with the tools we have while demonstrating technical solutions using Web Intelligence and IDT for being able to show data analytic to resolve specific business. So put on your Fraudster cap and hold on for the ride.

Key takeaways from this session:

  1. You don’t always have to buy new software to meet your company’s needs.
  2. Think outside of the box with Business Objects – it is more than just a reporting tool.
  3. Business Objects can be used for Data Analytics, Robotics and so much more.
  4. Searching with wildcards is easy once you learn the subtle differences between query vs report search

Don’t forget you can stream this webinar in its entirety as well as ever other webinar we’ve hosted on our Speak BO website when logged in.

If you have any questions about the session feel free to comment below and we will get back to you!

John SKey Takeaways from Solving Business Problems with BusinessObjects