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

  • More efficient SQL for returning the last record
    November 21, 2015
    I wrote up a method I called the “wormhole” years ago. Normally when you calculate the maximum of a column you can refer to that maximum in any formula in the r …
  • Cross-tabs calculated before/after group selection
    November 14, 2015
    I just learned a neat trick for cross-tabs that allows you to decide if the cross-tab is calculated in the first pass or in the second pass. A cross-tab that us …
  • Another free viewer, RptView
    November 2, 2015
    RptView by Pursuit Technology was originally for sale. Then it was free with ads. Now it has now been released as a free viewer without ads. All that is require …

Dallas Marks

No items, feed is empty.

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

  • The Future of Autonomics
    October 9, 2015
    abstract: Digitization coupled to autonomic and cognitive services will have a profound impact. It is through this lens that there is a new way of looking at th …
  • FIELD NOTE: Your Math is All Wrong…
    October 7, 2015
    At the request of a friend, I recently reviewed the article “Your Math Is All Wrong: Flipping The 80/20 Rule For Analytics” by John Thuma. It is a good article, …
  • Cognitive Computing – It Emergent not Design
    July 20, 2015
    I recently read an article “Building Your Cognitive Technology” byTom Davenport. What I find of interest in articles like this a lack of an understandable discu …

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

  • 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 …
  • Returning After a Long Absence
    March 25, 2015
    It’s been a long time since I’ve posted anything on this blog, and for that, I apologize. For the last year, I’ve been involved in several projects that haven’t …

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

Web Intelligence

  • RelativeDate function enhancement, not yet
    November 25, 2015
    We recently upgraded our BusinessObjects environment from 4.1 SP02 Patch 2  to 4.1 SP06 Patch 2. One enhancement I was looking forward to is listed on Page 56 o …
  • How to implement a Running Count Distinct
    November 13, 2015
    UPDATE – Attached is a .wid file , renamed to .txt so I coulkd attach it, with the proposed solution. Is's on BO 4.1 SP5. In order to work, rename it back …
  • Web Intelligence Demo on SCN Metadata
    November 4, 2015
    If you were fortunate enough to attend this years Mastering Business Analytics event (Melbourne, Australia), you may have seen the Web Intelligence demo either …

Semantic Layer

  • 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 …
  • A plea to SAP
    May 19, 2015
    For many years, Business Objects has been at the leading edge of business intelligence software. There are two main reasons behind this; the software and its ev …

Crystal Reports

SAP Lumira

  • Visualization Multiples: Thinking With D3
    November 24, 2015
    Visualization Multiples: Thinking With D3This is a step-by-step example to build an alternative visualization to the “trellis” available in SAP Lumira or other …
  • Saving lumira documents without Data
    November 24, 2015
    Hope you have been enjoying your lumira journey so far, 1.29 release comes loaded with many features that have been awaited for quite some time now. One of them …
  • Connecting SAP Lumira 1.29 to SAP Hana Vora
    November 24, 2015
    Vora is showing the commitment that SAP is making in the new Big Data world, and has been very well received by our customers as evidenced by the numerous visit …

SAP Predictive Analysis

Data Services

  • SAP Application Advanced Configuration
    November 23, 2015
    HI All Anyone familiar with SAP documentation on SAP Application Datastore Advanced configuration. I have setup Load Balancing on Data Services v4.2 SP5, and us …
  • SAP Data Services File Handling Functions
    November 11, 2015
    Over the time, I have worked with various ways to read a file, check if file exists and so on. Here, I would like to share what I have learned thus far which so …
  • SAP Data Services Volume Testing
    November 10, 2015
    Recently I was playing around with Data Services to capture statistics by processing big volume of data. I know Data Services is very mature and capable of hand …

SAP Information Steward

SAP BusinessObjects SDK

Business Intelligence Solution Architecture

Other BI Blogs

Information is Beautiful

  • Vote for your Favourite Dataviz of the Year
    November 24, 2015
    Here’s the shortlist for the Kantar Information is Beautiful Awards. Some of the most striking, innovative and beautiful dataviz work of 2015. Browse the catego …
  • Who Old Are You?
    November 20, 2015
    Career highs. Creative Zeniths. Big life moments. Average ages. Compare yourself to the peaks and troughs of the talented and famous… » Who Old Are You?
  • Announcing the Information is Beautiful Awards Longlist
    November 12, 2015
    2015 looks like another vintage year in the world of data visualization and information design. We celebrate and exhibit this awesomeness every year in the Kant …

Perceptual Edge


  • Fast image classifications in real-time
    November 25, 2015
    NeuralTalk2 uses neural networks to caption images quickly. To demonstrate, the video below shows a webcam feed that continuously updates with new image caption …
  • Thanksgiving flight patterns
    November 25, 2015
    Millions of Americans will fly home this Thanksgiving weekend. (Based on my morning commute, the holiday already started a couple of days early.) Josh Katz and …
  • Metadata surveillance investigation
    November 24, 2015
    Metadata can tell you a lot, and most of us agree that it's not “just metadata” at this point. The Share Lab shows what one can find, just using everyday…T …

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 …