Let's Speak BO

Key Takeaways from BusinessObjects as Part of BI Strategy for the Next Decade Feature Image

by John S on March 1, 2022 No comments

BusinessObjects as Part of BI Strategy for the Next Decade Feature Image

Did you miss our March 1st webinar BusinessObjects as Part of BI Strategy for the Next Decade? 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:

As the world continues to navigate a global pandemic that started well over a year ago, the importance and significance of Business Intelligence has never been more critical.

Yet, at the same time, most organizations find themselves in a situation where time, resources and budget have never been tighter. As a result, making better and more use of the BI applications in place makes a lot of sense. For many, that means leveraging BusinessObjects as it remains the most widely used BI suite in the world today.

In addition, between Web Intelligence and Crystal Reports, it offers the best BI reporting platform available.

While tools like Tableau and PowerBI are gaining larger market share in the BI space, they are used for data discovery and data visualization and not designed for BI reporting.
It is for this reason, that most organizations who have adopted these tools, retain BusinessObjects for BI reporting.

This session will both discuss and show real customer case studies of how existing BusinessObjects are adapting to the new co-existence norm and how companies, new to BI, are adopting BusinessObjects as part of their new BI strategy for the next decade.

Key takeaways from this session:

  • BusinessObjects Remains the Number 1 BI Reporting Platform in Use Today
  • BusinessObjects co-existence  with Tableau and PowerBI is the new normal
  • Moving to BusinessObjects BI 4.3 in the next 18 months makes sense
  • Only move BusinessObjects to the Cloud when the majority of data sources it accesses are also in the Cloud

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 BusinessObjects as Part of BI Strategy for the Next Decade Feature Image

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

Let’s Speak BO Together– Highlights of 2018

by Bree-Anna Mustad on December 19, 2018 No comments

The Let’s Speak BO Webinar series that began in the winter of 2015 just recently concluded its third straight year of bi-weekly Business Intelligence Webinars with a fantastic close. Adam Lange, with A. Lange Consulting, lead a jam packed session dedicated to all of the new things our BusinessObjects community can expect when upgrading to BI 4.2 SP6. From Administrative enhancements to reporting feature releases, our SpeakBO listeners received a wealth of information to consider with their BusinessObjects investment moving forward into the New Year.

For me, it has been a privilege not only hosting the Let’s Speak BO webinar series for three years, but also forming relationships with the vast BusinessObjects community worldwide. Some of my favorite emails and calls have been with devoted listeners expressing gratitude and excitement for the free educational offering, which seems to be quite unique these days in the space of SAP BusinessObjects information sharing when it comes to the original core BusinessObjects toolset.

Here’s a look at some of the topics hosted in 2018 that viewers found very helpful to not only improve their personal work with the tools, but also inspire decision making when it comes to upgrades, looking into third party solutions, leveraging the existing platform and all of its features, assisting group training within organizations, and more.

BusinessObjects Administration:

This year we hosted a variety of topics for BusinessObjects Administrators. The topics include:

...and of course the latest and greatest with the recent release of BI 4.2 SP6.

Inspired by our listeners, the Let’s Speak BO webinar series has put together a new lineup of Administrative topics for 2019.

Topics like:

  • Customizing your BI Launchpad for Global Branding and Organization Synchronization
  • Discovering the Administrative Management Tool in Web Intelligence
  • A Migration look at Converting Desktop Intelligence Reports to Web Intelligence

…and much more!

The World of Web Intelligence in 2018:

One of the most requested, well attended, and popular topics among the BusinessObjects community seems to remain that of the well-regarded reporting tool- Web Intelligence. This year on Let’s Speak BO, we put together more topics on Web Intelligence for our listeners than ever before. And still, they cannot seem to get enough.

In a single hour, our viewers received fantastic deep-dives into topics like:

…and so much more!

The topics didn’t end there.

This year we had fascinating case studies and new topics on:

As a listener myself to these amazing sessions, I have learned a lot about where the community of BusinessObjects is in regards to educating themselves and wanting to improve upon their usage of these fantastic tools. It inspires me to further my relationships with individuals and organizations, large or small, out there who are inspired to grow within their investment by continuing to learn about these tools, and more importantly, help others within their organization expand their reaches by learning and educating themselves as well.

To conclude the year, I would like to thank a special few of our listeners who shared countless calls and emails with me chatting about their experiences with BusinessObjects and sharing their story on how they lead educational sessions and webinars of their own, inspired by our bi-weekly webinar series. Or how a professor of a prestigious university has his students not only listen live to our webinars, but then write papers or conduct group projects on what they learned, to better prepare them for the real world.

These stories, I personally get to leave the year with, have truly inspired what’s to come:

  • 2019’s Line up of Webinar Topics
  • Open Format Discussions
  • Live Q&A’s

…and brand new customer case studies that I hope you all continue to enjoy and benefit from.

Bree-Anna MustadLet’s Speak BO Together– Highlights of 2018

Key Features in SAP BusinessObjects Promotion Manager for Administrators

by Bree-Anna Mustad on July 27, 2018 No comments

Key Features in SAP BusinessObjects Promotion Manager for Administrators Feature Image

This webinar explores some of the key best practices in utilizing the Promotion Manager tool within the LCM options inside of SAP BusinessObjects. Promotion Manager, an Administrators side-kick, contains a wide range of features and actions that allow administrators of BusinessObjects to save on time as well as space when running reports or day to day jobs.

VIEW WEBINAR RECORDING

This is an important tool to be aware of when considering major upgrades or large migrations in BusinessObjects. By understanding much of the tools capabilities, Administrators can save time and interruptions by working through some of these key best practices.

Bree-Anna MustadKey Features in SAP BusinessObjects Promotion Manager for Administrators

SAP BusinessObjects Administration Can Be Self-Serving?

by Bree-Anna Mustad on July 23, 2018 No comments

Self-Service BusinessObjects Administration Feature Image

An hour didn’t seem long enough in the Let’s Speak BO webinar hosted on July 10th 2018 as Minith Patel, Senior Consultant and SAP BO Administrative expert, took our listeners through a case by case adventure of how to become a fully sufficient, self-service BO Administration organization.

>>VIEW THE WEBINAR

This was a fascinating and creative look at what it means to think through the array of situations that might arise with employee requests when it comes to making necessary adjustments to their environment while maintaining the integrity of an organization’s administrative security.

Here are just a hand-full of the topics explored:

  • CMC restricted features
  • User Group Assignments
  • Customizing your CMC Tab Configuration
  • Why team delegation to a helpdesk alleviates the administrators
  • Creating certain windows AD self-service groups based upon departments
  • The LCM toolset and how they can best be used
  • Setting up tasks, events and assignments
  • A sneak peek at the automation framework tool

Far too often the SAP BO Administration for an organization neglects to evolve itself in terms of alleviating workload by consolidating the common requests into a new map on how to expand towards self-service concepts. This webinar allows administrators to imagine creative ways on how others can assist themselves within the CMC and BI Launchpad while maintaining user restrictions in order to improve work productivity and reduce redundancy of day to day tasks for the BI Administrator.

For those looking to learn more about the LCM tool, Promotion Manager, check out our webinar on The 12 Best Practices for using Promotion Manager happening July 24th at 10am PST. You can find it on our upcoming webinars page.

 

Bree-Anna MustadSAP BusinessObjects Administration Can Be Self-Serving?

SAP BusinessObjects Cloud Migration – A Case Study to Take Notes On

by Bree-Anna Mustad on June 27, 2018 No comments

BusinessObjects Cloud Migration – A Case Study to Take Notes On

Senior Consultant and BusinessObjects Expert, Rajesh Ponnurangam hosted a webinar this week that to our audience, was well worth taking notes on. The case study webinar focused on a large migration from XI 3.1 to BI 4.2 with Crystal Reports to Crystal Reports Server 10 hosted in the cloud.

This story, although highlighting key steps and methods that ultimately landed this organization at their desired goal to conclude the migration with a success, also came with many lessons learned. Rajesh shares an intimate look at each of the steps that were involved in such an arduous task.

To begin, Rajesh took the audience through a look at the plan form the initial stages after assessing both the environment and timeframe allocated to migrating, updating and testing the soon to be cloud based environment from the old. The stages were as follows:

  1. What is takes to prepare for an upgrade
  2. Installing the BI Platform using a third party cloud hosting provider (in this case AWS; Amazon Web Services)
  3. The migration of reports using the Upgrade Management Tool within SAP BusinessObjects
  4. Configuring and testing the environment (which was explained to have taken 70% of the entire project’s time).

VIEW WEBINAR RECORDING NOW >

Whether you are an SAP BusinessObjects Crystal user, or an SAP BusinessObjects user to the entire suite, this webinar is a fantastic case study for the sheer in-depth process and planning details, the lessons learned, as well as the value of migrating testing. For those considering in moving to the cloud with their SAP Platforms, this recording will provide guidance and shine a light on all aspects to consider when it comes to the array of options in cloud hosting providers. The important pieces I extracted from this webinar was how, in the end, the majority of issues and time constraints in finalizing the project wound up to be on the cloud server side rather than any issues in regards to the migration of BusinessObjects reports.

Bree-Anna MustadSAP BusinessObjects Cloud Migration – A Case Study to Take Notes On

Platform Optimization: Harmonizing Processes at a Nationwide Supermarket Chain

by Bree-Anna Mustad on June 14, 2018 No comments

Platform Optimization: Harmonizing Processes at a Nationwide Supermarket Chain

This case study is a fascinating one for any organization, supermarket or not, that is looking for a holistic Business Intelligence approach to multiple platform synchronization in order to improve upon data governance and the consolidation of reports. Albertsons/ Safeway, a recently merged Nation-wide supermarket chain has for many years heavily relied upon SAP BusinessObjects Crystal Reports and Crystal Enterprise as their primary reporting software. Coupled with SAP BI4 and InfoSol’s InfoBurst Enterprise Platform, this webinar takes an in-depth approach to looking at how a Business Intelligence team created an effective management strategy in order to join data generated from SAP BI4 and the InfoBurst Platform into a single analysis and reporting platform.

VIEW WEBINAR RECORDING NOW >

Case Studies hosted on our Let’s Speak BO webinar series seem to gather the most attendance, primarily because all of us within the BusinessObjects community are continuing to look for way to leverage our existing environments in better, more efficient ways. Rather than the unfortunate approach these days, to moving off of our investments into something new.

Crystal Reports and Crystal for Enterprise have both been around since the beginning of SAP’s BusinessObjects adoption. Over 37,000 Companies in the United States today still rely upon Crystal as their primary reporting tool. These records, considering the advancements in tools like SAP BusinessObjects Web Intelligence, are still quite high considering the majority of our high-tech age in the business world seem to still prefer viewing their reports in PDF or Excel outputs, regardless of the reporting tool used. Crystal is fantastic for this. From generating invoices, creating neat and customizable reports, to pushing data out on a scheduled bases with InfoBurst to large subsets of customers, emails, FTP sites, in formats like PDF, Excel and more… Albertsons/ Safeway succeeded in a fascinating Business Intelligence use case of what it means to consolidate, leverage, automate, and ultimately “optimize” their multi-platform investment.

Bree-Anna MustadPlatform Optimization: Harmonizing Processes at a Nationwide Supermarket Chain

Smoothing Out the Inevitable: Excelling Data into Web Intelligence

by Bree-Anna Mustad on May 30, 2018 No comments

Smoothing out the inevitable: Excelling Data into Web Intelligence

One would imagine in our ever advancing world of data access in BusinessObjects that no longer would companies so heavily rely upon one of the oldest reporting tools and data sources out there; Microsoft Excel. However, time and time again through webinar presentations or our annual BusinessObjects User Groups, conversations still manage to come down to talking about this one, irreplaceable (it seems) and not going anywhere- data storage/ reporting solution.

In a recent study to global business software systems, about 81% of business and organizations today still heavily rely upon Excel. This percentage is quite high considering each year more and more database management tools are being introduced, or version enhancements to existing systems like SAP BusinessObjects Universe Design Tool, or Information Design Tool, are advancing to heightened levels of usability.

VIEW WEBINAR RECORDING >

Still Excel remains a large demographic in business data storage. Not only as an easy to use, not quite so pretty, reporting solution; but also as a method of hard-copy databases floating amidst endless company folders and portals for storing historical, valuable information.

Due to such a large toolset as the SAP BusinessObjects suite, users of reporting solutions like Web Intelligence, also find limitations in accessing the Universe or IDT, in order to extract the data they need in a timely manner. These limitations, although common, due to the construct of a Universe and Administrative permissions, cause an inevitable need to work around the Universe data and simply load straight from Microsoft Excel.

Michael Ward from Creative Technologies Training & Solutions (CTTS), a fantastic expert, instructor and advocate of the beloved reporting tool within BusinessObjects, Web Intelligence, put together a fantastic webinar loaded with tips and tricks on how to best leverage your Excel data into SAP BusinessObjects Web Intelligence. This webinar is well worth attending and having a notepad. For such a straight forward topic on Excel into Web Intelligence, our viewers we surprised with the variety of methods one can not only import their Excel Spreadsheets, but also refresh, reload, and reconstruct the data within Web Intelligence.

Bree-Anna MustadSmoothing Out the Inevitable: Excelling Data into Web Intelligence

Getting the Most out of Experts in the SAP BusinessObjects Web Intelligence Community

by Bree-Anna Mustad on May 17, 2018 No comments

This week the Let’s Speak BO webinar series hosted a panel of three Web Intelligence experts who participated in a live question and answer series for our webinar community. Participants to the webinar were able to submit an unlimited number of questions that pertained to their business and ask them directly to the panel of experts.

Each expert on the Let’s Speak BO took the time to not only discuss the question but also, for some, demonstrate the answers right there for the audience to see. Topics for this series ranged from Universe and data security in Web Intelligence, to report formatting how-to tips and tricks, what’s coming in future versions, comparative questions on features between different builds, and more.

While each of our three panelists took the time to work through our list of pre-submitted questions, we also received live questions throughout the webinar. This provided our audience with a plethora of information, drilling into the details of each question and beyond.

VIEW WEBINAR RECORDING NOW >

From my seat, it was such an informative experience to not only hear the related questions from customers in the SAP BusinessObjects space based upon their work within Web Intelligence, but to also get a better understanding from our participants on how Web Intelligence is truly being used today. It continues to be a reporting solution for many that cannot be replaced; jam-packed with features that are continuing to be explored and unveiled, as well as the ability to connect to a variety of data sources in a variety of way – SAP BusinessObjects Web Intelligence continues to push all boundaries of a reporting solution and is a topic we always enjoy discussing on Let’s Speak BO.

Due to the success of such an open, Q&A-format, webinar for our BusinessObjects Community InfoSol plans to host a follow up to Ask the Experts sometime in July.

Stay tuned for up-coming webinars here.

Bree-Anna MustadGetting the Most out of Experts in the SAP BusinessObjects Web Intelligence Community