Blog Syndication

Aggregating entries from other blogs.

SAP BusinessObjects and SAP Data Services Blogs

Altek Solutions

  • OpenSSL Heartbleed and SAP BusinessObjects
    April 11, 2014
    There has been a lot of media hype over the past few days about the recently discovered Heartbleed vulnerability in the OpenSSL libraries. Like our clients, we …
  • BI 4.1 Support Pack 3 Released
    March 31, 2014
    Support Pack 3 for SAP BusinessObjects BI 4.1 is now available on the SAP Service Marketplace. This release adds a long awaited feature for BI Administrators ev …
  • BusinessObjects BI4 vs Anti-Virus
    February 6, 2014
    On my current project, I installed a brand new Windows server with the latest release of SAP BusinessObjects BI 4.1. Following the install, I noticed that the a …

BI Happy

  • Nulls are evil (or at the very least mischievous)
    March 29, 2014
    If you have been involved in hands on database development for a while, or in any kind of BI / reporting initiative, you probably already know this. Nulls are e …
  • Oscars dashboard
    March 11, 2014
      I LOVE movies. I am fascinated by the craft of creating movies. It’s a field that combines technology and imagination in very unique ways and where science an …
  • Signal and Noise inspired dashboard
    February 27, 2014
    Reading Nate Silvers’ “The Signal and the Noise: Why So Many Predictions Fail — but Some Don’t” (amazon link to book) inspired me to create this dashboard to ar …

The Crystal Reports® Underground

  • Sage/PeachTree drops CR, adds a new BI tool.
    April 22, 2014
    PeachTree Accounting, now known as Sage Accounting, has a long history of using CR as a reporting engine for custom reports.  Sage currently comes with some sta …
  • Daily Appointment Calendar
    April 15, 2014
    One of my customers had adapted a report template that they found online to generate a calendar report.  But they weren’t happy with the reports performance.  W …
  • Options for displaying zero values
    April 10, 2014
    Hidden in the advanced formatting options for numbers are several ways of displaying zero values on your reports.  To find these options, right click on a numer …

Dallas Marks

Dave Rathbun

Data Scientist Insights

David Taylor

  • SAP Discusses Latest BI Roadmap
    August 15, 2013
    Yesterday, many SAP BusinessObjects customers, mentors, partners and even a few competitors listened in as Steve Lucas as he unveiled SAP’s bold, new analytics …
  • Migrating BEx-based Information Spaces to BusinessObjects 4.0
    August 8, 2013
    Sometimes in software it can feel that you take two steps forward and one step back. One example of this is with BEx-based Explorer Information Spaces when migr …
  • HANA continues momentum in Utilities…
    July 12, 2013
    I believe HANA represents the most significant innovation in SAP’s history.  A year ago I wrote  a quick summary of some of the key value points that HANA bring …

Perpendulum

  • Number of reports in a WebI document
    July 17, 2013
    An interesting question was asked today on the BOB forum. Let me rephrase it slightly: How can I count reports (some call them tabs) within a single WebI docume …
  • Optional prompts in a universe
    April 1, 2013
    I have been wondering for years why engineers at SAP have not incorporated optional prompts into Business Objects universes. They are possible only in Web Intel …
  • Calendar table script for Oracle
    June 8, 2012
    One of the necessities in a properly designed DWH is a calendar table (aka date dimension). Usually, it’s one of the very first tables created in a DWH and it’s …

All Things BOBJ BI

Tech Notes

  • Infostore Page Query
    October 24, 2013
    Here is some code for paged querying InfoStore (BO XI 3.1): String uri = "path://InfoObjects/**[si_kind='Webi' and si_instance=0]"; PagingQu …
  • Export Webi to MHTML
    October 13, 2013
    To export Webi report to MHTML, the function HTMLView.getContent(Writer,String,String) should be used. // widoc is an instance of DocumentInstance Reports repor …
  • SQL Anywhere iSQL
    October 12, 2013
    Starting from BusinessObjects XI SP5, SAP Sybase SQL Anywhere is used as default database for BusinessObjects system databases (CMS and Audit). This post descri …

Michael’s BI Safari

  • Optimizing Universe Lists of Values
    January 27, 2014
    Lately, I’ve seen a lot of heartache over universe Lists of Values (LOV). Lists of Values can be a great benefit to users, as well as your worst nightmare for d …
  • Simplified Date Prompts
    January 7, 2014
    I was recently on a project that involved a lot of work on existing universes. One thing that I noticed with these universes was that they incorporated a lot of …
  • Solving Aggregate Aggravation
    January 2, 2014
    The problem with Aggregate Awareness in a universe is that, when setting it up, you can’t skip any steps. Wouldn’t it be great if we could simplify it by skippi …

Dineshkumar’s BI Blog

  • T-SQL : Get count of all tables in a database
    April 16, 2013
    The following query will list the count of records in all tables of a database. These queries are based on CURSORS, Query 1: Query to get individual results, Qu …
  • T-SQL : List of scheduled reports in SSRS
    March 16, 2013
    The following query will list all the available report subscriptions in SSRS. The reportserver database basically holds all metadata information [reports, users …
  • T-SQL : How to get columns names of all tables
    February 12, 2013
    How to get columns names from all tables of a database ? The query should return all the columns of all tables in a particular database, in a order like how it …

SAP Community Network – Selected Blogs

BI General

  • SAP BI Roadmap Future Direction – ASUG Webcast Part 3
    April 21, 2014
    This is the future direction for SAP BI – future direction means after 6-18 months with no definite time frame given. Part 1 is here SAP BI Roadmap Planned Inno …
  • BI News: March Edition
    April 21, 2014
    March 2014 Business Intelligence NewsStrategies for creating an information-driven culturewww.sap.com/BInews Featured ContentCustomer StoriesUpcoming Events …
  • BI Roadmap Planned Innovations Part 2 ASUG Webcast
    April 20, 2014
    Part 1 is here SAP BI Roadmap Planned Innovations – ASUG Webcast Part 1The usual legal disclaimer applies that things are subject to change.  Planned innovation …

BI Platform

Web Intelligence

Semantic Layer

Crystal Reports

SAP Lumira

  • Share your SAP Lumira stories with us!
    April 17, 2014
    Are you already or do you have plans to go live with SAP Lumira for productive use?  SAP Lumira Product Management and Development team would love to learn more …
  • SAP Lumira 1.16 pre-requisites
    April 17, 2014
    Hi Everyone We are gearing up to get our release ready for SAP Lumira 1.16. As usual the official documentation, tutorials, and PAM will be made available as we …
  • Hockey Playoff Analysis with SAP Lumira
    April 16, 2014
    Who’s ready for some playoff hockey!?! The Quest for the Cup begins Wednesday April 16. Using SAP Lumira, the SAP data viz team has pulled the latest hockey sta …

SAP Predictive Analysis

  • Predictive Analytics Myths
    April 14, 2014
    How well will you do tomorrow? How can we be sure? Algorithmic and biomedical advances are now producing sports coaches, mangers and team owners the tools to pr …
  • Inconsistent Datatype DATE Type from Filtering
    March 21, 2014
    I thought I would post this quick blog to try and help anybody out who may come across the same issue as I did. When trying to do some data preparation via filt …
  • SAP PA and Twitter – Sentiment Analysis
    March 17, 2014
    Continuing from previous post we now explore Sentiment Analysis. First of all let’s talk about Sentiment Analysis and Text Mining and what exactly it means when …

Data Services

SAP Information Steward

SAP BusinessObjects SDK

Business Intelligence Solution Architecture

  • Data load failure to write optimized DSO after SP 13 upgrade
    February 6, 2014
    Hi All, I came across data load issue,while loading data from Datasource to write optimized DSO after service pack 13 upgrade.    Flag not set: get all new data …
  • SAP BOBJ on SAP BW – What tool do I choose as a developer?
    March 1, 2013
    With the release of Business Objects 4.0 (BI 4.0), the ability to leverage SAP BW data via the recommended BICS  connection makes it very easy to dive in and st …
  • SAP BusinessObjects Enterprise XI3.1排程到期時間
    October 2, 2012
              目前SAP BusinessObjects Enterprise (BOE)成熟穩定的版本是XI3.1,因此許多BO的老客都會將舊系統升級至XI3.1版,在升級後許多老客在大量處理帶有等待事件的排程時,部份排程會遭遇到一個失敗的狀況:無法在指定的時間間隔內將物件排程。但是個別處理這些排程時又不會遭遇 …

Other BI Blogs

Information is Beautiful

Perceptual Edge

  • Design for the Real World
    March 28, 2014
    All men are designers. All that we do, almost all the time, is design, for design is basic to all human activity. The planning and patterning of any act towards …
  • Data Insights: Deep Thinking About Data Visualization
    February 11, 2014
    I have an extensive library of books about data visualization. I purchase most of the books that are published on the subject, but only occasionally do I find o …
  • One of Bill Gates’ favorite graphs redesigned
    January 10, 2014
    This blog entry was written by Bryan Pierce of Perceptual Edge. The following 3-D treemap was brought to our attention by a participant in our discussion forum. …

FlowingData

Visual Complexity

  • Nuremberg Chronicle
    February 19, 2014
    As many readers might have noticed, from my first and most recent book, I’m slightly obsessed with medieval information design, and the remarkable work of many …
  • Cosmic Web
    January 28, 2014
    In the end of many of my talks, after going through a variety of compelling examples of network visualization, I wrap up with a bit of a quandary, asking the au …
  • The Book of Trees – available for pre-order
    January 8, 2014
    After many months of research, planning, and writing, I’m extremely happy to announce The Book of Trees: Visualizing Branches of Knowledge is now available for …