Blog Syndication

Aggregating entries from other blogs.

SAP BusinessObjects and SAP Data Services Blogs

Altek Solutions

  • BI4 Content Promotion Options
    January 13, 2015
    One of the first things that an SAP BusinessObjects administrator will notice after an upgrade to BI4 is that the Import Wizard, the best option for moving BI c …
  • Altek’s BI Wishlist for 2015
    January 6, 2015
    With the new year, we here at Altek are looking ahead to the future of SAP BusinessObjects.  I asked around the office and we came up with the list below.  We h …
  • SAP BusinessObjects and Poodlebleed
    October 31, 2014
    Following the infamous Heartbleed bug earlier this year comes another security issue with SSL known as Poodlebleed. Unfortunately, this one can affect out of th …

BI Happy

The Crystal Reports® Underground

  • Document from SAP on Excel exports
    February 5, 2016
    I have written several times over the years about exporting reports to Excel. My first post was in 2005 and follow-ups in 2008, 2012 and 2015. It took much tria …
  • Web based deployment options compared (2016)
    January 27, 2016
    There are many ways to deploy Crystal Reports to users. I normally lean toward the simpler and less expensive options, like locally installed viewers, or schedu …
  • SAP “Idea Place”
    January 16, 2016
    I haven’t mentioned SAP’s “Idea Place” in a couple of years. This is a site where you can suggest product features or improvements. Once an idea is submitted, p …

Dallas Marks

Error: Feed has an error or is not valid

Dave Rathbun

  • Downgrading from Multi-Source to Single Source
    November 5, 2015
    I mentioned a few weeks ago that I had found a way to “downgrade” a multi-sourced universe to a single-source. I wanted to create a beautiful blog post with scr …
  • Yes, Virginia, You Can Switch a Multi-Source Universe Back to Single Source
    October 13, 2015
    What’s the first decision you have to make when creating a new universe with the Information Design Tool (IDT)? You have to specify if you want a single-source …
  • It’s Alive!
    September 16, 2015
    Wait… what’s this? Yes, my blog has a heart beat again. It has been a long time since I’ve been here, and I hope to fix that. I started this morning by reviewin …

Data Scientist Insights

David Taylor


  • 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

  • Webi – Validate value in Webi report
    July 7, 2015
    We want to validate values of the dimension [Job No.] from Query 1 against values of [Job No.] from query Valid within Webi report. We can create a detail objec …
  • Image with Hyperlink in Webi report
    April 10, 2015
    We want to add hyperlink to an image in Webi document. Here I am using an image with name UserLogo1.png that has size 165 x 25. Copy your image to the server to …
  • Format date in Batch yyyyMMdd
    February 26, 2015
    The usual approach to build a timestamp for a log files in a batch is to use standard Windows utilities date and time. However the format of the output depends …

Michael’s BI Safari

  • Universe Design Best Practices
    February 2, 2016
    I’ve always avoided writing a blog on universe best practices, primarily because there have been many others who have written some excellent blogs on the topic. …
  • Review of Information Design Tool 4.1
    November 5, 2015
    It’s been a while since I wrote my initial review on Information Design Tool (IDT) in SAP BusinessObjects 4.0. If you’ve read that post, you know that I was fru …
  • Impact of a Database Migration
    April 29, 2015
    For the past few years I’ve been involved in quite a few “forklift” projects. What is a forklift project? I’m glad you asked. When a company decides to move the …

Dineshkumar’s BI Blog

  • SSRS : Multivalued Parameters
    October 26, 2013
    I am creating a simple SSRS report to demonstrate the workarounds available to pass multivalue parameter to Stored Procedures. Stored procedures are capable of …
  • SSAS : Cube Metadata – Documentation
    September 20, 2013
    We all are seeing a continuous importance for documentation in any project work that we do. I can see a common factor in developers that they all hate to do doc …
  • T-SQL : Gaps and Islands Problem – 2
    August 2, 2013
    There are lot of ways to find the gaps in a sequential numbers, and some of them are listed below. I have posted some 3 methods to achieve the expected. The goa …

SAP Community Network – Selected Blogs

BI General

BI Platform

  • BusinessObjects BI Licensing Updates
    February 3, 2016
    It's a new year, and that means licensing updates! We have simplified our license model to make it easier to understand, while still keeping the core compo …
  • Submit your Crystal Reports review, get a reward!
    January 29, 2016
    Hi everyone,I wanted to make our Crystal Reports customers on the SCN community aware of some great promotions we’ve got running right now with a few listing/re …
  • Exporting Results from CMC to Excel
    January 15, 2016
    Quite often, I had always wondered if there was an easy out to export the results from a CMC to excel. There is of course, the tool that can be found online, th …

Web Intelligence

Semantic Layer

  • Universe Context design and Neutral Joins
    December 21, 2015
    I've seen some questions about the usage of the "Neutral" joins in universe's Data Foundation. This blog is reviewing the differences betwee …
  • Multi-joins on table in universe cardinality error
    November 12, 2015
    I was getting errors when trying to join two fields in one table to two fields in another table… "Invalid expression. Parsing of expression for the busin …
  • The case against the Where clause
    September 29, 2015
    Note that the post uses examples from Oracle but equally applies to SQL Server, Teradata, HANA, etc with the relevant DBMS date syntax When creating objects, it …

Crystal Reports

SAP Lumira

  • Histograms in Lumira
    February 9, 2016
    Histograms may not be available in Lumira as one of the default chart types. However, it is easy to create one – Lets consider I have Quantity Sold data against …
  • "Passionate on Analytics" is now available
    February 7, 2016
    I am proud to present my first book on analytics called "Passionate On Analytics" Driven by a deep belief of the value that analytics can have in the …
  • SAP Lumira Expert Series Webinars – Kicking-off for 2016 !
    February 6, 2016
    Greetings Lumira Enthusiasts ! In case you haven't heard of them already – the SAP Lumira Expert Series Webinars (run by the Product Management, SAP Analyt …

SAP Predictive Analysis

Data Services

SAP Information Steward

SAP BusinessObjects SDK

Business Intelligence Solution Architecture

Other BI Blogs

Information is Beautiful

Perceptual Edge


  • Sponsor: Metis Data Science Training →
    February 12, 2016
    Introduces common data science theory and techniques to help programmers, mathematicians, and other technical professionals expand their data science expertise. …
  • Who marries who, by profession
    February 12, 2016
    People with certain professions tend to marry others with a given profession. Adam Pearce and Dorothy Gambrell for Bloomberg Business were curious. When it come …
  • International impact of China’s economic slowdown
    February 11, 2016
    China's economic slowdown means a major decline in imports from other countries, which leads to significant effects in these areas. The Guardian takes a lo …

Visual Complexity

  • Visual Complexity: Alive and Kicking
    November 26, 2014
    As some attentive users of Visual Complexity might have noticed, the number of projects featured on the website has slowly come to a halt, with the perpetual gr …
  • The Book of Trees – Structure & Timeline of Characters
    October 30, 2014
    The Book of Trees: Visualizing Branches of Knowledge has been out for six months and during this time it has received a great number of positive reviews from pu …
  • The Book of Trees in Japanese
    October 22, 2014
    During a sumptuous dinner last February in Shibuya, Tokyo, following a long visualization workshop, my welcoming hosts presented me with a gift: an exceptional …