Blog Syndication

Aggregating entries from other blogs.

SAP BusinessObjects and SAP Data Services Blogs

Altek Solutions

  • Batch Promotions with LCMCLI
    October 13, 2014
    Anyone that has used the Promotion Management tool included in BusinessObjects Lifecycle Management knows that promoting large amounts of content can be an extr …
  • Element Linking in Web Intelligence – Prt 9
    September 18, 2014
    Continuing our previous post on Input Controls, let’s now look into Element Linking in Web Intelligence Reporting. The combination of Element Linking with Input …
  • Input Controls in Web Intelligence – Prt 8
    August 28, 2014
    One of the Features in Web Intelligence 3.x and 4.x version for filtering and interacting on report data elements in the report is Input Controls. In this sessi …

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

  • ReCrystallize Light
    October 24, 2014
    ReCrystallize has just released a simplified edition called ReCrystallize Light. Like ReCrystallize Pro, it generates a web page for each of your reports. These …
  • “Instant” Data Dictionary
    October 14, 2014
    I have a previous post that shows simple ways to report on the structure of a database.   This month one of my readers sent me a report that gives you more deta …
  • Two new report management tools
    October 7, 2014
    The developers at R-Tag have released two new tools for managing reports. The first, R-Tag Crystal Reports Documentation and Search, is for searching and docume …

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

  • 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

  • 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 …
  • Safety belt for SAP BW as data source
    July 6, 2014
    Hi All,I am explaining about safety belt and it's importance. Safety belt is used to restrict and protects against large result-set of data retrieval from …

Crystal Reports

SAP Lumira

SAP Predictive Analysis

  • SAP InfiniteInsight – Modeler
    October 19, 2014
    Hi In my previous blog SAP InfiniteInsight – Explorer , I demonstrated how you can create a data set for further analysis.  In this blog I will focus on the SAP …
  • Adding Predictive Analytics Coolness Into Applications
    October 16, 2014
    Developers are rarely shy about sharing their views on new tools and technology. I appreciate their passion and healthy scepticism, in fact I seem to have devel …
  • SAP InfiniteInsight – Explorer
    October 16, 2014
    Hi I have not seen much posted regarding InfiniteInsight. I thought I would take some time to demonstrate parts of this product. InfiniteInsight is predictive a …

Data Services

SAP Information Steward

SAP BusinessObjects SDK

Business Intelligence Solution Architecture

Other BI Blogs

Information is Beautiful

Perceptual Edge

  • This is your Brain on Big Data: A Review of “The Organized Mind”
    October 21, 2014
    In the past few years, several fine books have been written by neuroscientists. In this blog I’ve reviewed those that are most useful and placed Daniel Kahneman …
  • Performance Measurement
    October 3, 2014
    In my dashboard design course, which I taught most recently last week in Portland, Oregon, it is inevitable that participants ask for help in gathering requirem …
  • New Arrivals
    October 1, 2014
    During the last few months, I’ve been hit with a double barrel of distraction. Life sometimes gets in the way, but the path forward is opening up and I’m anxiou …

FlowingData

  • Job Board, October 2014
    October 24, 2014
    Looking for a job in data science, visualization, or statistics? There are openings on the board. Business Intelligence Analyst for …
  • New York Times mapmakers
    October 24, 2014
    When news breaks, maps often accompany stories (or the maps are the story), and cartographers and graphics people have to …Tags: New York Times, Wired
  • Visual summary of skateboarding tournament
    October 24, 2014
    George Murphy visualized the results of this year's skateboarding tournament Battle at the Berrics 7. Even if you don't like …Tags: skateboard, sports …

Visual Complexity

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