Blog Syndication

Aggregating entries from other blogs.

SAP BusinessObjects and SAP Data Services Blogs

Altek Solutions

BI Happy

  • Tableau connected Medicare enrollment dashboard
    July 22, 2014
    Our medicare enrollment database continues to grow and now contains over 9M enrollment records from across the country. I began collecting this information almo …
  • Using Webi 4.1 SDK to get Report SQL
    June 2, 2014
    When SAP introduced BusinessObjects 4.0, clients who were invested in the Webi REBEAN SDK got worried. The Webi SDK had been mostly deprecated and it was not cl …
  • 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 …

The Crystal Reports® Underground

  • RPT management utilities for 2014
    July 16, 2014
    I have just updated my comparison of RPT management utilities for 2014. These are tools that allow you to scan, document, compare and update RPT files. One vend …
  • Automatically fill in “Overridden Qualified Table Names”
    July 8, 2014
    This post will only be useful for developers who create reports that need to be launched from an application. I have written before about property called “Overr …
  • Formula failures without error messages
    June 28, 2014
    I cleared up a mystery today, one that I thought was just a Crystal glitch. It explains why Crystal formulas sometimes fail without an error message to describe …

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

BI Platform

Web Intelligence

Semantic Layer

  • Safety belt for SAP BW as data source
    July 6, 2014
    Hi All,I am explaining about safety belt and it's importance. Safety belt is used to restrict and protects against large result-set of data retrieval from …
  • Mapping of InfoProvider objects in a universe
    June 26, 2014
    Hi All, I am explaining how the BW objects are mapped in a universe. To build a universe on SAP NetWeaver BW, We must create a multisource-enabled data foundati …
  • Cartesian Product
    June 24, 2014
    Hi All,  I am explaining to understand basics of Cartesian product.  Once we include tables in the data foundation, we need to link tables using different joins …

Crystal Reports

SAP Lumira

SAP Predictive Analysis

Data Services

SAP Information Steward

SAP BusinessObjects SDK

Business Intelligence Solution Architecture

Other BI Blogs

Information is Beautiful

  • Islamic Sects, Schools, Branches & Movements
    July 10, 2014
    Sunni? Shia? Hanbali? Ismali? Deobandi? Taliban? ISIS? A visual guide to the major & notable sects, schools & movements within Islam. Much confusion and …
  • Antibiotic Resistance
    July 8, 2014
    A lot of fear and furore around the increasing resistance of bacteria to antibiotics. We took a look at the numbers. See our visualisation. The datasheet has mo …
  • $5000 Dataviz Challenge: Design a Page of My New Book
    March 11, 2014
    I got stuck visualising a dataset for my new book, Knowledge is Beautiful (US & UK). I wondered if you could help? It’s a dataset on the price of a human li …

Perceptual Edge

  • A Sure Path to Learning
    July 8, 2014
    Even though we all claim to value education, teaching and learning is rarely done well. To achieve good outcomes, teachers and students must understand how the …
  • Design vs. Art
    May 12, 2014
    I am writing these words in Amsterdam. Yesterday, when I arrived here, I visited the Stedelijk Museum of contemporary art and design. The featured exhibition wa …
  • The Three Vs and the Big O
    May 6, 2014
    It’s often useful to take a fresh look at things through the eyes of an outsider. My friend Leanne recently provided me with an outsider’s perspective after rea …

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 …