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

  • “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 …
  • Highlighting individual rows and columns in a cross-tab
    September 27, 2014
    I was reviewing a report for a customer that was based on a cross-tab. The cross-tab had several rows that had a different color font and background. Yet when I …

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

  • What's New in SAP Lumira 1.20 (summary)
    October 22, 2014
    And here it comes! SAP Lumira 1.20 is coming to you very shortly. Those of you who are attending SAP TechEd and D-Code in Las Vegas might already be having a ta …
  • Dunn Predicts Royals Win Series
    October 21, 2014
    How often do you get to mix work with fun? Well, if you work at Dunn Solutions with SAP products, all the time.  But when we got the opportunity to enter the “E …
  • Data Geek Challenge – SAP Lumira – Co2 emissions by country
    October 21, 2014
    Hello Everyone. I am writing this blog as part of the DataGeek III: How to Join challenge under the category House of Spirits – caring for the social good.  Hav …

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

  • F1 racing winners and age
    October 22, 2014
    So here's a sport I don't see or hear much about. F1 racing, which requires a different sort of strength …Tags: racing, sports, time series
  • Cynthia Brewer profile
    October 22, 2014
    Wired wrote a short profile for Cynthia Brewer, best known for Color Brewer, a tool that provides visually apt color …Tags: color, Cynthia Brewer, Wired
  • Your life on Earth
    October 21, 2014
    The BBC has a fun piece that shows changes over your lifetime. Enter your date of birth, gender, and height, …Tags: BBC, personalization, time series

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 …