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

  • The function to nowhere.
    August 22, 2015
    A customer recently asked me how to use the vertical alignment formula functions in Crystal reports. He had found them on-line and was surprised that there were …
  • Comparing Crystal to other reporting tools
    August 15, 2015
    Three months ago I mentioned plans for a new comparison matrix. The goal of this new matrix is to compare the features of Crystal Reports to the featurs of othe …
  • Suppress trailing zeros in decimal values
    August 7, 2015
    Formula #15 on my formulas page has always allowed you to convert a number into text and have it not display zero decimals on the right end.  So if you had the …

Dallas Marks

Dave Rathbun

Data Scientist Insights

David Taylor

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

  • 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

  • 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 …
  • 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 …

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

Semantic Layer

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

  • A Taxonomy of Hipster Coffee Shop Names
    July 8, 2015
    The hidden taxonomy of hipster coffee shop names. LDN edition. » See the graphic » The new book Knowledge is Beautiful out now  
  • Oil Well
    July 2, 2015
    Almond? Olive? Sunflower? Which is the ultimate cooking oil? Our graphic visualizes every single cooking oil and grades each for health, smoke point, flavour an …
  • Workshops are Beautiful San Francisco
    June 12, 2015
    Information is Beautiful founder David McCandless shares his method & process for great dataviz in San Francisco on Monday July 27th. Following sell-out ses …

Perceptual Edge

FlowingData

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 …