Blog Syndication

Aggregating entries from other blogs.

SAP BusinessObjects and SAP Data Services Blogs

Altek Solutions

BI Happy

  • Don’t let the software migration cycle cripple your BI project
    September 30, 2014
    Software developers have been taught for decades that they must follow the Development/Integration/Staging/Production practice. This practice was instituted to …
  • 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 …

The Crystal Reports® Underground

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

  • Maconomy version
    September 25, 2014
    SELECT MAINVERSIONNUMBER, PATCHNUMBER FROM ( SELECT MAINVERSIONNUMBER, PATCHNUMBER, ROW_NUMBER() OVER (ORDER BY MAINVERSIONNUMBER DESC, PATCHNUMBER DESC) RN FRO …
  • Misc. Dates – SQL Server
    September 24, 2014
    SELECT DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()) – 1, 0) AS FIRST_DAY_PREVIOUS_YEAR, DATEADD(YEAR, DATEDIFF(YEAR, 0, GETDATE()), 0) AS FIRST_DAY_CURRENT_YEAR, …
  • Sum of Positive/Negative Values in Web Intelligence
    September 18, 2014
    =Sum((If [Value]>0 Then [Value]) ForEach([Service])) =Sum((If [Value]

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

  • 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

  • What if Blake Bortles Wins Fantasy Football For Me?
    September 30, 2014
    4 weeks is a good indicator of performance and I’m fairly satisfied with my fantasy football team despite my 1-2 record (at the time of writing).  RG III’s poor …
  • What's New in SAP Lumira 1.19 (summary)
    September 29, 2014
    Hi Everyone I know, I know, I am late on posting this and many of you are already getting up to speed with SAP Lumira 1.19 through tutorials, blogs, and your ow …
  • Investment Analysis by Using SAP Lumira Cloud
    September 29, 2014
    This blog post is for Data Geek III. Here i have created a Story board for Healthcare Financial data using SAP Lumira Desktop and published it on SAP Lumira clo …

SAP Predictive Analysis

Data Services

SAP Information Steward

SAP BusinessObjects SDK

Business Intelligence Solution Architecture

Other BI Blogs

Information is Beautiful

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

  • Open source mapping lab
    September 30, 2014
    Mapzen focuses on building open source mapping components for developers. We design things that can be provided as a service, …Tags: Mapzen, open-source
  • Fitbit obsessed
    September 30, 2014
    After you've collected data about yourself for a while, you tend to go one of two ways. You either quit …Tags: David Sedaris, Fitbit
  • Flooding risk cartogram
    September 29, 2014
    As you may or may not know, climate change could bring with it other effects besides our average days getting …Tags: cartogram, environment, New York Times

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 …