Business Objects

Business Intelligence to Inspire Us All – InfoSol Blog – Business Intelligence Article

As I look back on 2018 and all the amazing BI solutions I saw created, there was one that really stood out in terms of its impact on the world that left me both awestruck and humbled. It was a solution created for the International Humanitarian City (IHC) based in Dubai, UAE that provides international relief for human disasters around the world. I had the privilege to tour their facilities last November and it is a vast expanse of warehouses…

Read More

Merging on Variables in Web Intelligence – InfoSol Blog – Business Intelligence Article

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 – for example, February 7 2019 would not merge with a 2/7/2019 and Joe Smith would not merge with JOE SMITH.…

Read More

How to perform data masking – Business Intelligence Article

One of the cool features with Information Design Tool and UNX universes is the ability to point to different table views depending on your security profile. Because of this, we can easily perform data masking, which allows us to mask restricted data. For example, I have 2 different types of users. Group FULL who can see all revenue/cost measures, and Group PUBLIC who can see revenue measures but 0 for any cost measures. A question one might ask is, “Why…

Read More

How to pick up User Token or ID from HTTP Headers for use in a Dashboard – InfoSol Blog – Business Intelligence Article

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 manual login. In some cases though, a company might have their own portal security in place that they would like…

Read More

Let’s Speak BO Together– Highlights of 2018 – InfoSol Blog – Business Intelligence Article

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…

Read More

Applying an SAP BusinessObjects patch or service pack upgrade – Business Intelligence Article

Every time I apply a service pack upgrade or patch at a client site, I’m always excited about the features or fixes. However it is very annoying that any customizations get overwritten. This includes items such as: Branding, Single Sign-On, Modifications to the login page The following is a checklist of items that I backup beforehand when applying a service pack or patch upgrade Branding If you have made logo changes to replace the SAP logo with your company logo,…

Read More

How to Skip Dataflows for Testing or Restarting a Job for Recovery – InfoSol Blog – Business Intelligence Article

Tyler Koitka December 3, 2018 Business Intelligence, BusinessObjects, Highlights, InfoSol, Products, SAP Business Objects, Tech Tips 513 Views 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! There is…

Read More

The Dashboard Salsa Dance – InfoSol Blog – Business Intelligence Article

On a recent vacation in Mexico, I attended a class to learn how to dance salsa. Now, I have two left feet when it comes to learning any structured dances. I can do the count in my head and I can do the steps with my feet, but I can never get them synchronized which usually results in either stepping on my partner’s feet or freezing in fear of stepping on my partner’s feet! The instructor taught the basic salsa…

Read More

How to Document IDT Universe Information – InfoSol Blog – Business Intelligence Article

Minith Patel is an Enterprise Architect with InfoSol Inc. He is experienced in all phases of the creation, installation, optimization and deployment of Business Intelligence, Enterprise Performance Management and Data Warehouse applications. His passion for building data-driven solutions has allowed him to successfully work on many global design, implementation and development projects. This self-proclaimed Japanophile is also well versed in all things BusinessObjects and excels at programming, analysis, project management, client/customer relationship management, system integration, data warehousing and enterprise architecture.…

Read More

The BusinessObjects Upgrade Dilemma – InfoSol Blog – Business Intelligence Article

Buying a car has always been a challenging experience for me. I never know what to buy, when to buy, what features to include, and I definitely don’t enjoy the inevitable frustrating bartering with the sales and finance people. I also still haven’t figured out why I always end up with this invisible ZakTek protection coat despite stating right up front that I don’t want it. In fact, my last vehicle also had something called the “invisible bra” in addition…

Read More

How to bypass opendocument login screen – Business Intelligence Article

In this article I’d like to show you a simple example of how to bypass the opendocument login. This is especially useful if you are trying to use an opendocument call to open up a web intelligence document from a 3rd party application. It’s quite simple, and you can expand the example to use trusted authentication if desired. Download the custom.jsp here Step 1 First you will need to edit the custom.jsp file to fit your environment. Set the CMS…

Read More

Fiori BI Launchpad | David Lai’s Business Intelligence Blog – Business Intelligence Article

After seeing the Fiori BI Launchpad previews, I was so excited to finally get SAP BI 4.2 SP4 installed on our sandbox.It was literally like opening presents during Christmas as I couldn’t wait to try out the fresh new interface that would be similar to SAP ONE Support Launchpad . After the installation was complete, it was time to log in to the new BI Launchpad. So I typed in the url http://server:8080/BOE/BI, logged in, and long and behold… It…

Read More

Handling many-to-many joins using a bridge table (Part 1) – Business Intelligence Article

As a data warehouse architect, star schemas are great until we encounter the dreaded many-to-many fact to dimension scenario. For example, we have a Ticket Fact table and a Tag Dimension table. The cost metric is calculated at the ticket level, so tickets have the lowest granularity and hence the ticket fact table.   However tickets can be tagged with multiple describers. A ticket can be interesting, excellent, and complicated. If we flatten the tags into the fact table, you’ll notice…

Read More

CurrentDate() in WEBI | David Lai’s Business Intelligence Blog – Business Intelligence Article

In Web Intelligence there are a variety of helpful date functions that you can use. 2 in particular are CurrentDate() and CurrentTime(). You would think that CurrentDate() returns just the current date and CurrentTime() returns the current datetime. However both return the exact same result which makes it confusing, especially if you are using date dimensions where the time is stripped off. The funny thing is that most people don’t even catch this issue when they are using CurrentDate() !…

Read More