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

  • Field disappears during Verify Database
    October 30, 2014
    All reports pull their data from tables of some kind, and these tables do change over time. Fields are added or removed and sometimes field names or their data …
  • 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 …

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

  • Reporting & Analytics Interactive 2014
    October 27, 2014
    Originally posted on SAP BI BLOG:? ? Register for R&A Interactive 2014 Must register through link above to receive discount For More Information Join DFT at …
  • What’s new in SAP BusinessObjects 4.1 SP4
    June 23, 2014
    A few weeks ago SAP released SAP BusinessObjects 4.1 Support Pack 4 (SP4). This package introduced a few new features which are listed in the “What’s New guide” …
  • Is VMware ready for HANA production?
    June 6, 2014
    Originally posted on SAPonPower:Virtualizing SAP HANA with VMware in productive environments is not supported at this time, but according to Arne Arnold with SA …

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

  • Decline of women in computer science
    October 30, 2014
    NPR spent some time on the subject of the decline of women in computer science. Whereas the the percentage of …Tags: computer science, gender, NPR
  • Chess piece survival rates
    October 30, 2014
    On Quora, someone asked, "What are the chances of survival of individual chess pieces in average games?" Oliver Brennan answered …Tags: chess, surviva …
  • Statistically ignorant
    October 29, 2014
    Ipsos MORI, primarily a marketing research group I think, released results of their study on public perception of demographics versus …Tags: ignorance, world

Visual Complexity

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