Blog Syndication

Aggregating entries from other blogs.

SAP BusinessObjects and SAP Data Services Blogs

Altek Solutions

BI Happy

  • Embedding Tableau Dashboards
    September 1, 2014
    I delivered a webcast about embedding tableau dashboard in external facing apps, and embedded BI in general. You can view the webcast recording at the following …
  • Embedded Tableau Oscars Dashboard
    August 4, 2014
    A few months ago I published my Oscars dashboard (http://bihappyblog.com/2014/03/10/oscars-dashboard/). Recently, I decided to produce a new version of it, leve …
  • 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 …

The Crystal Reports® Underground

  • Updated comparison of Crystal Reports viewers (2014)
    September 22, 2014
    You use Crystal Reports to create, change and run reports. But what if you have users who just need to refresh/view/print/export? Do they need copies of Crystal …
  • Reporting on ‘multi-value’ fields
    September 14, 2014
    There were recently two different threads in LinkedIn that discussed reporting on ‘multi-select’ or ‘multi-value’ fields. A multi-value field allows the user to …
  • Finding fields in use outside of formulas
    September 8, 2014
    SAP created a suggestion box called the “Idea Place” in 2010. This month idea D661 from October 2010 was accepted by the developers at SAP. It is scheduled for …

Dallas Marks

Dave Rathbun

Data Scientist Insights

David Taylor

  • Upgrading to SAP BusinessObjects 4.1
    September 3, 2014
      Don’t Miss Out! There is an excellent Technical Webinar Series happening right now: Upgrading to the SAP BusinessObjects BI Platform 4.1 These sessions starte …
  • 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 …

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

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

  • Properties and Appearance for Background colour…
    September 18, 2014
    Amusing! For the last two years I have used the same plain background on the monthly report charts. However, today that all changes! The end results was:  Somet …
  • Dynamic Chart Labeling by Using Prompts
    September 17, 2014
    The starting situation is as follows. I've used multiple columns (universe -> odbc -> excel) for my organizational units (main department, department …
  • Dynamic Headers in WebI
    September 15, 2014
    Let me know i can show column values as Headers Names With multiple columns. For example  Item    Module_Name   Qty      CalculatedQty1         P1               …

Semantic Layer

  • Avoid Scheduling when no data in report
    September 8, 2014
     This post is about how to avoid scheduling when there is no data fetched from database. Sometime there is client requirement that they don’t want to receive re …
  • Adding Functional Module in Universe
    August 27, 2014
    In some cases we need to add function module in universe and need to join with tables to get certain results in webi report. Basically function modules will be …
  • Changing connection in the data foundation
    July 22, 2014
    Hi All I am explaining below step by step process for changing the connection in data foundation.Changing the connection in the data foundation, connection must …

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

  • Who likes whom in the Middle East? Key players & relationships
    September 11, 2014
    An interactive visualisation of key players & notable relationships in the Middle East created by David McCandless & Univers Lab. Part of the Knowledge …
  • ARRRRGHHWOOOOO!
    September 2, 2014
    That’s the sound of an author seeing their book for the first time… Just received the first physical copy of mine, Knowledge is Beautiful. Watch me ‘unbox’ it l …
  • Announcing the Information is Beautiful Awards 2014…
    August 21, 2014
    Get your dataviz entries into this year’s Information is Beautiful Awards by midnight EST September 8th. Enter here. Thanks to our beloved sponsors, Kantar, we’ …

Perceptual Edge

  • If Big Data Is Anything at All, This Is It
    August 18, 2014
    The first time that all but a few of us heard the term “Big Data,” we heard it in the context of a marketing campaign by information technology vendors to promo …
  • 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 …

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 …