Ergin Ozturk's Professional Blog: March 2010

Tuesday, March 30, 2010

Types of Query Filters in Web Intelligence

Types of Query Filters in Web Intelligence: "The Web Intelligence Query Panel allows us to define a filter in the Query Filters area using the available dimensions,detail or measure object. The content explains the various combinations that are available to be utilized as a part of Query Filter in Web Intelligence.

BW Objects technical name changeability for SAP BO Planning & Consolidation, version for Netweaver

BW Objects technical name changeability for SAP BO Planning & Consolidation, version for Netweaver: "SAP Business Objects Planning & Consolidation, version for Netweaver, transports operate by transferring metadata about the existing source BPC configuration to a target system. Upon successful import into the target system, the metadata describing the new (or changed) BPC objects described in the transport is used to recreate/change BPC objects in the target system. BW users that wish to connect to these objects should be aware of which objects will retain their original (source system) technical name, and which should not be counted upon to remain static.

Monday, March 29, 2010

Socialization of Programs: It is alive!

Socialization of Programs: It is alive!: "Did you ever thought of an analytic application which visualize ABAP objects' relations to programs or humans? Opportunity to document your project in a way that which development is done by which developer.

Saturday, March 27, 2010

Social Network Analyzer

Social Network Analyzer:

NEW People Finder for iPhone version. Social Network Analyzer aggregates existing enterprise data, using business intelligence techniques, to help you find people/group/items based on multiple criteria, understand their relationships, connect with them and get up-to-date statistics on your organization. The purpose of this technology is to deliver an environment where people can easily and quickly analyze corporate network relationships and find the information they are looking for in their daily jobs.

Thursday, March 25, 2010

Walking Through SAP BusinessObjects Explorer

Walking Through SAP BusinessObjects Explorer:

Today I attended the GABOUG quarterly meeting and saw a really nice presentation of SAP BusinessObjects Explorer by Rob Fiorillo of RFP Consulting. He showed multiple demos.

During the first demo, he wanted to show how to use Explorer with data from Excel, so he used Live Office to take the data out of the EDW. He then imported the data into SAP BusinessObjects Explorer using the new plug-in from labs called, SAP BusinessObjects Explorer with Excel Navigation Prototype.

There are currently two versions of SAP BusinessObjects Explorer. There is:

SAP BusinessObjects Explorer Accelerated
SAP BusinessObjects Explorer

SAP BusinessObjects Explorer Accelerated – The Accelerated version provides unlimited scalability of in memory processing for data regardless of size and is really the way to go. It requires the use of SAP’s Netweaver BW 7, BWA Blades and SAP BusinessObjects Explorer Blades.

SAP BusinessObjects Explorer (non-Accelerated) – Organizations can use the non-accelerated version, but there are limitations to the amount of data SAP BusinessObjects Explorer non-Accelerated can handle. In 2010, SAP BusinessObjects will be bringing a “BWA Blades for non-SAP data” to the market, which will overcome the existing limitations.

SAP BusinessObjects Explorer breaks new ground with the way it brings together:

Fast Performance
Unlimited Data
Intuitive User Experience

SAP BusinessObjects Explorer Demo Site

A great example of the solution is represented my the http://microfinance.sap.com/ demo site. Click below and take it for a test run.

Incredible Data Volumes

The microfinance website does a great job of showing you the intuitive user interface while and the same time demonstrating the large data volumes that can be processes. This demo site is running a relatively small data sample of 27 million records, but look at the response time!

That’s fast! 0.016s to return a result set of 1,123,000 records. Also what I love about SAP BusinessObjects Explorer is that I am able to see the desired metric broken down by every dimension member. In the screenshot above you can see that of the selected sample, 498 are Existing Clients, 375 are New Clients and 250 are Former Clients.

I am fascinated by the growth of in memory solutions within the BI Marketplace. Qliktech’s QlikView is probably one of the better know solutions in the space. With Explorer, SAP BusinessObjects answers the call of the industry to provide in-memory solutions for organizations who have standardized on their platform. The good news is that you no longer have to deploy niche solutions to get the type of in-memory performance many of your end-users would love.

«Good BI»

Source: http://neverknewthat.wordpress.com

Overview of SAP BusinessObjects

Overview of SAP BusinessObjects:

Business Intelligence in business speak.

If you are new to Business Intelligence and want to get an overview of the solutions from SAP BusinessObjects from a business perspective, then I’ve got just the resource for you.

SAP BusinessObjects eBook

SAP’s new eBook provides you a 35,000 ft view of the world as we see it and how you can use Business Intelligence to impact it. Having solutions in place from SAP BusinessObjects helps organizations achieve the benefits of:

Strategic Alignment
Predictable Performance
Confident Decisions

We do this through the best practices we have heard from our customers which say you should:

Ensure Trusted Information
Proactively Manage Risk
Create enterprise visibility

If you want to understand what BI does without worrying about how BI does it. Check out this resource.

SAP BusinessObjects eBook

http://www.sap.com/community/ebook/2010_BOPO_eBook/en/index.html

Note that a number of the videos contained within the eBook are over 25 minutes each, so there is a lot of content here!

«Good BI»

Source: http://neverknewthat.wordpress.com/

SAP BusinessObjects Explorer for IPhone

SAP BUSINESSOBJECTS EXPLORER FOR IPHONE:

New in version 1.1: Upload you personal data on https://bi.ondemand.com - With the SAP BusinessObjects Explorer for iPhone prototype, insight into your business is never more than a few flicks away. Through simple and fast search, intuitive data exploration and visualization, and high performance and scalability, SAP BusinessObjects Explorer allows you to answer business questions 'on-the-fly' and regardless of where you are. Whether you are visiting a customer and need to see what orders they've placed, at a café dreaming up a new marketing program, or in the board room discussing this quarter's revenues, SAP BusinessObjects Explorer for iPhone puts immediate access to all quality-decision information on the go

Wednesday, March 24, 2010

Apple iPad? How about a little German innovation instead

Apple iPad? How about a little German innovation instead

Posted using ShareThis

Stunning BI Data Visualization -- From 1870

Stunning BI Data Visualization -- From 1870: "Data visualization has been around a long time -- here are some nice examples from the 1870 US census.

Evaluate Crystal Reports Server 2008 in the Cloud - No Need to Download or Install

Evaluate Crystal Reports Server 2008 in the Cloud - No Need to Download or Install: "Are you thinking of evaluating Crystal Reports Server 2008 but worried about downloading and installing the software? Try the free Crystal Reports Server 2008 evaluation online without downloading anything!

Tips on Xcelsius and SAP NetWeaver BW connection : #2032 error

Tips on Xcelsius and SAP NetWeaver BW connection : #2032 error: "Xcelsius and SAP NetWeaver BW connection: #2032 error.

Community Project ZAPP_INTEGRATOR

Community Project ZAPP_INTEGRATOR: "In the SAP Enterprise Portal there is the Application Integrator which allows to integrate different back-end systems in the Portal UI. This project tries to do the same based on the NetWeaver Web Application Server ABAP only. In the first release you can start transactions on the WebAS ABAP using the SAP GUI for Windows (WinGUI).

Monday, March 15, 2010

Copy and Paste for SAP BI Analysis Item (New Release)

// ------------------------------------------------------------------------------
// Copy and Paste for SAP BI Analysis Item
// ------------------------------------------------------------------------------
// Functionality: selecting a recangle in Analysis Item
// - mouse click and shift click to define
// - paste: select single cell and paste
// - paste: select multi cell and paste will fill all with identical content
// - paste: select multi and paste multi - message!
// - paste ignores table fields which are not input enabled (no tagName 'INPUT')
// ------------------------------------------------------------------------------

// ------------------------------------------------------------------------------
// Options (set to "true" to enable function or "false" to disable it)
// ------------------------------------------------------------------------------
// - sapbi_rig_plan_copy_paste_option = true / false
// -> enables or disables the copy & paste functionality
//
// - sapbi_rig_plan_paste_overwrite_option = true / false
// -> overwrite cell content during paste option if function is enabled
//
// - sapbi_rig_plan_select_on_click_option = true / false
// -> select all cell content on click if function is enabled
//
// - sapbi_rig_plan_next_cell_on_return_option = true / false
// -> press enter/return button to jump to the next row if function
// is enabled
//
// - sapbi_rig_plan_next_cell_row_first_option = true / false
// -> if "next cell on return" is enabled it will jump to the next column
// in the same row
// ------------------------------------------------------------------------------

var sapbi_rig_plan_copy_paste_option = true;
var sapbi_rig_plan_paste_overwrite_option = true;
var sapbi_rig_plan_select_on_click_option = true;
var sapbi_rig_plan_next_cell_on_return_option = true;
var sapbi_rig_plan_next_cell_row_first_option = true;

// List of global dependencies:
/*jslint browser: true */
/*global UR_SELECTION_STATE, sapUrMapi_SapTable_setCellSelection, sapUrMapi_Table_getClickedRowIndex,
sapUrMapi_Table_getClickedColIndex, ur_Table_create, sapUrMapi_SapTable_getClickedCellId */

var sapbi_rig_plan_inf = [];
sapbi_rig_plan_inf.top = -1;
sapbi_rig_plan_inf.left = -1;
sapbi_rig_plan_inf.bottom = -1;
sapbi_rig_plan_inf.right = -1;
sapbi_rig_plan_inf.activeSel = [];
sapbi_rig_plan_inf.activeTabId = '';
sapbi_rig_plan_inf.brwsType = '';

// Check if state is OK to perform copy or paste action
// ------------------------------------------------------------
function sapbi_rig_plan_isValidState(info){
if (info.top === -1 || info.bottom === -1 || info.left === -1 || info.right === -1){
return false;
}
if (info.activeTabID === '' || info.activeSel.length === 0){
return false;
}
}

// Set selection coordinates and activeItem based on src-element
// -------------------------------------------------------------
function sapbi_rig_plan_onclick(row, col,tabId, shiftKey, info){

if (shiftKey !== true || info.activeTabId !== tabId){
info.top = row;
info.left = col;
info.bottom = row;
info.right = col; 
info.activeTabId = tabId;
} else {
if (info.top === -1 || info.left === -1){
info.top = row;
info.left = col;
} else {
// sort coordinates 
if (info.top > row){
info.bottom = info.top;
info.top = row;
} else {
info.bottom = row;
}
if (info.left > col){
info.right = info.right;
info.left = col;
} else {
info.right = col;
} 
}
}
}
// Store IDs of selected cells and perform highlighting
// ----------------------------------------------------------
function sapbi_rig_plan_highlight(on, info){

// clear previous selection
var TDInfo = [];
if (info.activeSel !== undefined){
var cntDelMax = info.activeSel.length;
for (var cntDel = 0; cntDel<cntDelMax; cntDel++){
TDInfo = info.activeSel.pop();
var refTD = document.getElementById(TDInfo[0]);
if (refTD !== null){
if (sapbi_rig_plan_inf.brwsType === 'IE') {
sapUrMapi_SapTable_setCellSelection(refTD, UR_SELECTION_STATE.NOT_SELECTED);
} else {
sapUrMapi_SapTableSelectCell(refTD, false, false, true);
}
}
}
}
if (on === false){return;}

// set new selection
var refTbl = ur_Table_create(info.activeTabId);
if (refTbl === null){alert('ur model not found'); return;}

for (var cntRow = info.top; cntRow <= info.bottom; cntRow++){
for(var cntCol = info.left; cntCol <= info.right; cntCol++){
refTD = refTbl.rows[cntRow].cells[cntCol].ref;
if (refTD !== null){
if (sapbi_rig_plan_inf.brwsType === 'IE') {
sapUrMapi_SapTable_setCellSelection(refTD, UR_SELECTION_STATE.SECONDARY);
} else {
sapUrMapi_SapTableSelectCell(refTD, false, true, true);
}
TDInfo = [];
TDInfo[0] = refTD.id;
TDInfo[1] = cntRow;
TDInfo[2] = cntCol;
info.activeSel.push(TDInfo);
}
}
}
}
// Handler for OnClick Event
// -------------------------------------------------------------
function sapbi_rig_plan_onclickHandler(e){

var src;
var sid;
if (sapbi_rig_plan_inf.brwsType === 'IE'){
e = window.event;
src = e.srcElement;
} else{
src = e.target;
}
var shiftKey = e.shiftKey;

if (src === null || src.tagName === 'BODY' || src.tagName === 'HTML'){
sapbi_rig_plan_highlight(false, sapbi_rig_plan_inf);
return;
}
var row;
var col;
if (sapbi_rig_plan_inf.brwsType === 'IE'){
row = sapUrMapi_SapTable_getClickedRowIndex(e);
col = sapUrMapi_SapTable_getClickedColIndex(e); 
} else {
var cellRef = document.getElementById(sapUrMapi_Table_getClickedCellId('', e));
if (cellRef !== null) {
row = cellRef.getAttribute('rr');
col = cellRef.getAttribute('cc');
}
}
if (isNaN(row) || isNaN(col)){
return;
}
var tabId = sapbi_rig_plan_getTableId(e);

if (tabId.indexOf('_ia_pt_a') > 0) {
row--;
col--;
}

sapbi_rig_plan_onclick(row, col, tabId, shiftKey,sapbi_rig_plan_inf);
if (sapbi_rig_plan_select_on_click_option == true && shiftKey == false) {
sapbi_rig_plan_select_on_click(row, col, tabId);
}

if (sapbi_rig_plan_copy_paste_option == true) {
sapbi_rig_plan_highlight(true, sapbi_rig_plan_inf);
}
}

// Handler for OnKeyDown Event
// -------------------------------------------------------------
function sapbi_rig_plan_onkeydownHandler(e) {

var keynum;
var keyreturn = false;

if (window.event) // IE
{
keynum = e.keyCode;
if (keynum == 13)
keyreturn = true;
}
else if (e.which) // Netscape/Firefox/Opera
{
keynum = e.which;
if (keynum == 13)
keyreturn = true;
}

if (keyreturn == false) {
return true;
}

var src;
var sId;
if (sapbi_rig_plan_inf.brwsType === 'IE') {
e = window.event;
src = e.srcElement;
} else {
src = e.target;
}

if (src === null || src.tagName === 'BODY' || src.tagName === 'HTML') {
return;
}
var row;
var col;
if (sapbi_rig_plan_inf.brwsType === 'IE') {
row = sapUrMapi_SapTable_getClickedRowIndex(e);
col = sapUrMapi_SapTable_getClickedColIndex(e);
} else {
var cellRef = document.getElementById(sapUrMapi_Table_getClickedCellId('', e));
if (cellRef !== null) {
row = cellRef.getAttribute('rr');
col = cellRef.getAttribute('cc');
}
}
if (isNaN(row) || isNaN(col)) {
return;
}

var tabId = sapbi_rig_plan_getTableId(e);

if (tabId.indexOf('_ia_pt_a') > 0) {
row--;
col--;
}

if (sapbi_rig_plan_next_cell_on_return_option == true) {
sapbi_rig_plan_setFocusOnNextCell(row, col, tabId);
}

return false;
}

function sapbi_rig_plan_setFocusOnNextCell(row, col, tabId) {

var refTbl = ur_Table_create(tabId);
if (refTbl === null) { alert('ur model not found'); return; }

var maxRows = refTbl.rows.length;
var maxCols = refTbl.cols.length;
var colCnt;
var rowCnt;
var inputField;

if (sapbi_rig_plan_next_cell_row_first_option == false) {
// column first
row++; // next cell
for (colCnt = col; colCnt < maxCols; colCnt++) {
for (rowCnt = row; rowCnt < maxRows; rowCnt++) {
cellTD = refTbl.rows[rowCnt].cells[colCnt].ref;

if (cellTD != null) {
inputField = cellTD.getElementsByTagName('INPUT');
if (inputField != null && inputField.length > 0) { inputField[0].select(); return; }
}
}
row = 0;
}
} else {
// row first
col++; // next cell
for (rowCnt = row; rowCnt < maxRows; rowCnt++) {
for (colCnt = col; colCnt < maxCols; colCnt++) {
cellTD = refTbl.rows[rowCnt].cells[colCnt].ref;
if (cellTD != null) {
inputField = cellTD.getElementsByTagName('INPUT');
if (inputField != null && inputField.length > 0) { inputField[0].focus(); inputField[0].select(); return; }
}
}
col = 0;
}
}
}

// Global
// Register handler for events
// -------------------------------------------------------------
if (typeof (window.addEventListener) != 'undefined') {
sapbi_rig_plan_inf.brwsType = 'NN';

if (sapbi_rig_plan_select_on_click_option == true || sapbi_rig_plan_copy_paste_option == true) {
document.addEventListener('click',sapbi_rig_plan_onclickHandler,false);
}

if (sapbi_rig_plan_next_cell_on_return_option == true) {
document.addEventListener('onkeydown', sapbi_rig_plan_onkeydownHandler, false);
}
} else {
sapbi_rig_plan_inf.brwsType = 'IE';

if (sapbi_rig_plan_select_on_click_option == true || sapbi_rig_plan_copy_paste_option == true) {
document.body.attachEvent('onclick', sapbi_rig_plan_onclickHandler); 
}

if (sapbi_rig_plan_next_cell_on_return_option == true) {
document.body.attachEvent('onkeydown', sapbi_rig_plan_onkeydownHandler);
}
}
// -------------------------------------------------------------

function sapbi_rig_plan_select_on_click(row, col, tabId) {

var refTbl = ur_Table_create(tabId);
if (refTbl === null) { alert('ur model not found'); return; }

refTD = refTbl.rows[row].cells[col].ref;

if (refTD === null) { return; }
var inputField = refTD.getElementsByTagName('INPUT');
if (inputField != null && inputField.length > 0) { inputField[0].select(); }
}

// Copy data to clipboard (including input-field handling)
// -------------------------------------------------------
function sapbi_rig_plan_copy_clipboard(){
if (!window.clipboardData) {
alert('Access to clipboard not successful - potential reason: security does not allow access.');
return;
}

var info = sapbi_rig_plan_inf;
if (sapbi_rig_plan_isValidState(info) === false){
alert('Selection not defined properly.');
return;
}
var refTD;
var ClipBoardStr = '';
var refTbl = ur_Table_create(info.activeTabId);
if (refTbl === null){alert('ur model not found'); return;}

for (var cntRow = info.top; cntRow<=info.bottom; cntRow++){
for(var cntCol = info.left; cntCol<=info.right; cntCol++){
refTD = refTbl.rows[cntRow].cells[cntCol].ref;
ClipBoardStr = ClipBoardStr + sapbi_rig_plan_getContent(refTD);
if (cntCol < info.right){ 
ClipBoardStr = ClipBoardStr + '\t'; 
}
}
if (cntRow < info.bottom){ 
ClipBoardStr = ClipBoardStr + '\r\n';
}
}
if (ClipBoardStr.length > 0){
var retCode = window.clipboardData.setData('Text',ClipBoardStr);
if (retCode === false) {
alert('Access to clipboard not successful - potential reason: security does not allow access.');
}
}
}

function sapbi_rig_plan_paste_clipboard() { 
var info = sapbi_rig_plan_inf; 
if (sapbi_rig_plan_isValidState(info) === false) { 
alert('Selection not defined properly.'); 
return; 
}

if (!window.clipboardData) {
alert('Paste: Could not access clipboard.');
return;
}

var clipBoardData = window.clipboardData.getData('Text');
if (clipBoardData.length > 0 && clipBoardData.charAt(clipBoardData.length-1) == '\n') { // cut trailing return
clipBoardData = clipBoardData.substring(0, clipBoardData.length-1);
}

var selSingle = (info.activeSel.length === 1); 
var clpHasRows = (clipBoardData.indexOf('\n') !== -1); 
var clpHasCols = (clipBoardData.indexOf('\t') !== -1); 
var clpSingle = (clpHasRows === false && clpHasCols === false);

var cell; 
if (clpSingle === true) { 
for (var cntSel = 0; cntSel < info.activeSel.length; cntSel++) { 
cell = document.getElementById(info.activeSel[cntSel][0]); 
sapbi_rig_plan_setContent(cell, clipBoardData); 
} 
return; 
}

if (selSingle === false) { 
var clipCol; 
var cellTD; 
var clipRow = clipBoardData.split('\n'); 
var refTbl = ur_Table_create(info.activeTabId);

var maxRows = info.bottom - info.top + 1; 
if (maxRows > clipRow.length) { 
maxRows = clipRow.length; 
} 
var maxCols;

for (var rowCnt = 0; rowCnt < maxRows; rowCnt++) { 
clipCol = clipRow[rowCnt].split('\t'); 
maxCols = info.right - info.left + 1; 
if (maxCols > clipCol.length) { 
maxCols = clipCol.length; 
} 
for (var colCnt = 0; colCnt < maxCols; colCnt++) { 
cellTD = refTbl.rows[rowCnt + info.top].cells[colCnt + info.left].ref; 
sapbi_rig_plan_setContent(cellTD, clipCol[colCnt]); 
} 
} 
return; 
}

if (clpSingle === false && selSingle == true && sapbi_rig_plan_paste_overwrite_option == true) { 
var clipCol; 
var cellTD; 
var clipRow = clipBoardData.split('\n'); 
var refTbl = ur_Table_create(info.activeTabId);

var maxRows = clipRow.length; 
var maxCols;

for (var rowCnt = 0; rowCnt < maxRows; rowCnt++) { 
clipCol = clipRow[rowCnt].split('\t'); 
maxCols = clipCol.length; 
if (maxCols + info.left >= refTbl.rows[rowCnt + info.top].cells.length) {
maxCols = refTbl.rows[rowCnt + info.top].cells.length - info.left;
}

for (var colCnt = 0; colCnt < maxCols; colCnt++) { 
cellTD = refTbl.rows[rowCnt + info.top].cells[colCnt + info.left].ref; 
sapbi_rig_plan_setContent(cellTD, clipCol[colCnt]); 
} 
}
return; 
}

alert('Ranges from selection and clipboard does not fit'); 
return; 
}

function sapbi_rig_plan_clear(content){
if ('undefined' == typeof(content) ) content = '';
if (content == null) content = '';

var info = sapbi_rig_plan_inf;
if (sapbi_rig_plan_isValidState(info) === false){
alert('Selection not defined properly.');
return;
}

var cell;
for(var cntSel = 0; cntSel<info.activeSel.length; cntSel++){
cell = document.getElementById(info.activeSel[cntSel][0]);
sapbi_rig_plan_setContent(cell, content);
}
}

Thursday, March 11, 2010

1405865 - Get error "Object Variable Not Set" when sending data via Input Schedule -BPC 7.0 NW

Symptom
When sending data through an Input Schedule, in which there is a & character in the name, and get the below error:
Object Variable Not Set

Reproducing the Issue

Create an Input Schedule, and save it as a template, with & character in the name.
Open this Input Schedule, and send data.

Then will get above error.

Cause
Limitation in BPC 7.0 NW
Resolution
Avoid using & in Input Schedule name.
Keywords
Object, input schedule, name

Header Data

Released on	11.11.2009 06:54:24
Release Status	Released to Customer
Component	EPM-BPC-NW
Category	How To

Product		Product Version
SAP BusinessObjects Planning and Consolidation, version for SAP		SAP BPC 7.0 FOR SAP NETWEAVER