Best Practices

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

The Best and Worst Branding of 2018 – Business Article

Design can be powerful. Thriving businesses know this and regularly rely on good design to create influential and impressive brand identities and brands. As we recently wrote, No successful company has ever left its brand and branding to chance. Instead, smart companies are intentional and public about their mission and values, among other things. There’s a good reason for this. 87% of consumers will purchase a product solely because of brand values. In 2018, we saw some terrific examples of…

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

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

The Resilience of Master Data Management – Business Intelligence Article

Final article in a six-part series on the “New Age of Master Data Management” by Julie Hunt For years, there have been industry professionals and analysts who seemingly find pleasure in declaring some type of technology “dead”. This compulsion has been a constant in the software industry. Master data management (MDM) is no exception. Some have been convinced that MDM was DOA practically from the day it emerged as a distinct form of data management and data governance. Making such…

Read More

MDM – Speaking the “Language” of Business – Business Intelligence Article

Part 5 of a six-part series on the “New Age of Master Data Management” by Julie Hunt Data management continues to take on an ever-growing range of activities as the role of data has evolved and expanded for many organizations. Business agility and real-time insight are inherent requirements for many organizations. To meet such requirements, organizations need right-time data on a continuous basis, where master data management initiatives are integral to processing business-ready data. MDM software solutions are evolving as well,…

Read More

Business People are Drivers of the New Age of MDM – Business Intelligence Article

Part 4 of a six-part series on the “New Age of Master Data Management” by Julie Hunt Master data management and data governance have always been about business. However, there has been a history of MDM implementations putting too much emphasis on technology, and less time into over-arching business aspects. For successful outcomes and continuous improvement, the ongoing participation of various business roles is an essential element of MDM strategies and activities. It takes ‘everybody’ to ensure optimal data management processes…

Read More

How Does Technology Enable Effective MDM? – Business Intelligence Article

Part 3 of a six-part series on the “New Age of Master Data Management” by Julie Hunt No Room for “Tech for Tech’s Sake” Many organizations have routinely made technology purchases based solely on the predilections of IT groups. This approach to technology decisions has often proven to be a limited path in terms of providing the technology infrastructure imperative for business needs in today’s world, one that has become faster and more complex for many organizations. More organizations are now…

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

MDM for Business Value: New Approaches – Business Intelligence Article

Part 2 of a six-part series on the “New Age of Master Data Management” by Julie Hunt Master data management is entering an ‘evolutionary’ era where MDM implementations better mirror how businesses use data for numerous purposes, and where people, practices and processes come to the forefront as essential elements. MDM functioned as yet another solution space that was harmed by disproportionate attention to its underlying technologies. But MDM has always been far more about business objectives and needs, as well…

Read More

Master Data Management Rebooted (Part 1) – Business Intelligence Article

Part 1 of a multi-part series on the “New Age of Master Data Management” by Julie Hunt The ‘New Age’ of Master Data Management It’s about time that master data management (MDM) enjoyed a ‘new age’. The creation and use of master data for business purposes has always been a good idea. The goal has been to make sense of all data that touches the organization: clean it up, add context, enrich it, and put it to work strategically as…

Read More

Latest White Paper with Information Builders: “Five Things to Focus On for Faster MDM Results” – Business Intelligence Article

The latest Hub Designs white paper, sponsored by Information Builders Hub Designs’ latest white paper on master data management (MDM) was published recently by Information Builders. The paper is titled Five Things to Focus On for Faster MDM Results, and it talks about the importance of getting the “soft stuff” right and improving the alignment between business and IT. It also covers how to achieve a business-oriented, balanced, holistic approach that addresses: People / corporate culture (through organization design and change management)…

Read More