Apa itu Business Intelligence ?

Business Intelligence (BI) merupakan topik atau istilah yang cukup hangat diperbincangkan di dunia bisnis maupun teknologi informasi. Seringkali kita mendengarkan istilah ini diucapkan pada seminar maupun tertera pada artikel ilmiah. Sialnya pengertian business intelligence pada bidang bisnis dan teknologi informasi sangatlah berbeda.

BI in Business != BI in Information Technology. Business Intelligence pada dunia bisnis tidak sama dengan business intelligence pada dunia teknologi informasi.

Pada tulisan kali ini akhirnya saya dapat memberikan contoh perbedaan istilah business intelligence pada dunia bisnis dan teknologi. Hal ini berkat salah satu sesi pada salah satu acara kantor yang menghadirkan pembicara dari dunia perbankan, mantan Marketing Director Citibank Indonesia  yang secara jenaka dapat mendeskripsikan pengertian business intelligence di dunia bisnis.

Pengertian business intelligence di dunia teknologi sangat mudah dideskripsikan, lihat saja halaman wikipedia berikut .

Sedangkan untuk pengertian business intelligence di dunia bisnis, simaklah cerita humor berikut… (saya sedikit modifikasi agar bisa ditulis)

Suatu hari di sebuah hutan yang rindang dan luas, seorang anak menantu (sebut saja anak menantu satu) berjalan bersama dengan ibu mertuanya. Tiba-tiba sang ibu mertua terperosok ke dalam sebuah danau yang dalam. Seketika itu juga sang anak menantu pertama menolong sang ibu mertua.

Hari berikutnya, sang ibu mertua memberikan sebuah sedan BMW kepada sang anak menantu pertama.

Beberapa minggu kemudian, sang ibu mertua kembali berjalan menikmati keindahan hutan dengan anak menantu lainnya (sebut saja anak menantu dua). Tiba-tiba sang ibu mertua kembali terperosok ke dalam sebuah danau yang dalam, danau yang sama. Seketika itu juga sang anak menantu kedua menolong sang ibu mertua.

Hari berikutnya, sang ibu mertua memberikan sebuah SUV BMW kepada sang anak menantu kedua.

Beberapa minggu kemudian, sang ibu mertua kembali berjalan menikmati keindahan hutan dengan anak menantu lainnya (sebut saja anak menantu ketiga). Tiba-tiba sang ibu mertua kembali terperosok ke dalam sebuah danau yang dalam, danau yang sama…

Saat itu, sang anak menantu ketiga hanya melihat saja (tidak memberi bantuan) kepada sang ibu mertua tersebut. Akhirnya sang ibu mertua tenggelam dan pergi meninggalkan dunia untuk selama-lamanya.

Hari berikutnya,  sang anak menantu ketiga mendapatkan sebuah mobil sedan sport LAMBORGHINI AVENTADOR terparkir rapi di garasi rumahnya. Pada kaca depannya terdapat sebuah kertas dengan tulisan

“Mobil ini untukmu” tertanda bapak mertua.

Business Intelligence dalam dunia bisnis ? semoga anda bisa menggambarkan dengan versi anda sendiri ..#hahaha

Microsoft Analysis Service (OLAP) Front-End

Visual Business Intelligence - Tables and Graphs 1

Option for MSSQL Analysis Service (OLAP) Front-End

1.Microsoft SQL Reporting Service

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. It is administered via a web interface

2.Microsoft PerformancePoint Service

PerformancePoint Services in Microsoft SharePoint Server 2010 is a performance management service that you can use to monitor and analyze your business. By providing flexible, easy-to-use tools for building dashboards, scorecards, reports, and key performance indicators (KPIs), PerformancePoint Services can help everyone across an organization make informed business decisions that align with companywide objectives and strategy. Scorecards, dashboards, and KPIs help drive accountability. Integrated analytics help employees move quickly from monitoring information to analyzing it and, when appropriate, sharing it throughout the organization.

3.Tantalum

4.Analyzer

Analyzer allows even non-technical users to become productive and self-sufficient quickly, performing powerful analysis and building visually compelling dashboards and flexible reports. A wide variety of components, including pivot tables, charts, Key Performance Indicator (KPI) scorecards, dashboards, web pages, Reporting Services® reports, geographic maps, heat maps, and more — lets users create custom reports and dashboards just by dragging and dropping.

5.Visifire

Visifire is a set of data visualization controls – powered by Microsoft®Silverlight & WPF. Visifire is a multi-targeting control which can be used in both WPF & Silverlight applications. Use the same API to create charts & gauges in Mobile, Web & Desktop environments. Visifire Silverlight Controls can also be embedded in any webpage as a standalone Silverlight App. Don’t take our word for it! Visit Visifire Gallery or design your own chart or gauge using Chart/Gauge Designer.

6.XlCubed

XLCubed’s product set empowers the business user. Bringing the power and flexibility of OLAP reporting to Excel, XLCubed leverages Excel’s strengths but mitigates the risks. Users have a rich Reporting, Analytics and Dashboard environment in Excel, and the ability to deploy the reports to XLCubed Web Edition with ease

7.Tableau

Flat files, databases, warehouses, or cubes: Access your data wherever it lives. Analyze it. Fast.The reality of business today is that no organization has data in a single place. Heterogeneous environments are the rule; exceptions to it are hard to find. You need the ability to analyze data wherever it lives to get the answers you need. Make sure your business intelligence solution can handle your data, everywhere.

8.Report Portal

Report Portal is an advanced web client reporting solution that lets you build, publish and view the following types of reports

9.ranet-uilibrary-olap

It provides parsing, generating and visualization of MDX language and MDX query results. Moreover it provides data input and Writeback to OLAP cube. It works under .NET and Silverlight.

10. DevExpress  –  Business Intelligence Suite

DevExpress Analytics controls allow you to deliver highly interactive data-centric applications to your end-users with minimal effort. From OLAP data mining with integrated charting to data export and analysis via our award winning gauge and reporting options, DevExpress allows you to deliver your very best and offer your customers a way in which to intuitively analyze data.

11. Viblend

VIBlend DataGridView for WinForms is a top of the line data grid control loaded with hundreds of powerful features. It provides a solid and highly extensive data visualization foundation ideal for a broad spectrum of data driven applications. You can build in-house Business Intelligence applications as easily as loading a set of records from a database.

12.Syncfusion – ASP.NET – For BI Edition

We offer more than 60 AJAX-enabled controls/frameworks with complete documentation and samples for the ASP.NET platform. Our unique wrappers for jQuery UI controls allow you to easily add advanced jQuery UI features to your Web Forms applications.

anything else..??

SAP BW: COPY, DELETE Query and WorkBook

sap logo

Managing Query in SAP BW NW7 can be done with theese tools and t-code:

  • Query Designer, an application from SAP NW7 Business Explorer installation.
  • t-code: RSZC : to Copy Query between InfoCube or MultiProvider
  • t-code: RSZDELETE : to Delete Quer between InfoCube or MultiProvider
  • t-code: SA38 , program: RSAQ_DELETE_QUERY : Reorganization of WorkBook and Role Storage , this t-code and program can seek query dependency with workbook. Query with workbook cannot be deleted directly, the workbook should be deleted.

Note for Deleting Query

Deleting Query can be easily done by using this t-code: RSZDELETE or using Query Designer, but sometimes problem just happen.

Problem / Symptom that migght happen when Deleting query with RSZDELETE:

The Query Cannot be deleted from Query Designer or SAP GUI (with RSZDELETE). It just keep showing error / warning message  “ Query Block” on SAP GUI interface. If we delete the Query from Query Designer, the query seems deleted but if logoff and log on BEX again the query magically appear.

So, what we have to do then? Both RSZDELETE and Query Designer cannot delete the Query.

Log on to SAP GUI > RSA1 > Transport Connection Menu.We have to set the query to the Bex Transport Request. Note that there are two kind of transport (Transport and Bex Transport). Build a new Bex Requset transport, by clicking the icon with pictures of a ‘car’ and ‘BEx’. Then Click ‘Assingn / Delete ‘, create ‘new request’ …. done!

and the query should be deleted easily. Good Luck

SAP BW, Documentation (1)

sap logoAfter getting to  know and familiar with SAP BW basic T-CODES. I found another website to help mastering SAP BW is http://sap.seo-gym.com/.

Lots of goodies relating  SAP BW, such as tutorials, learning guides and help files containing PDF or Microsoft Documents (Doc) .

Interesting, I thought the page/sub domain is a technic for Search Engine Optimation(SEO), and it works!

Theese are the list of tutorial that i copy paste from sap.seo-gym.com

  • SAP BW Authorizations docs in detail
  • SAP BW BPS Planning Folders and Layouts
  • How to integrate SAP BI with XI PDF
  • How to install SAP BW
  • SAP BW Netweaver Installation MEDIA_LIST_NETWEAVER
  • Online Analytical Processing(OLAP)
  • SAP BW Sizing Help for estimating the hardware resources needed
  • SAP BW Business Explorer(BEX) a detail learning document
  • ABAP Required in SAP BW for ABAP routines,Functional modules in detail
  • SAP BI Accelerator for high performance in queries
  • SAP BW Cell editing in BEX
  • Control and profitability Analysis in SAP BW
  • Exit Function in SAP BW
  • SAP BW Front End Designing
  • How to handle inventory in SAP BW
  • SAP BW Transaction Codes (t-codes)
  • SAP BW Performance Tuning for queries
  • SAP BW BPS WEB Based Planning

SAP BW : Cannot delete DTP

sap logoProblem:

Cannot delete Data Transfer Process (DTP) from DSO/CUBE to DSO/CUBE. Despite all the pre-conditions have been met, such as deleting data and requests in the target and source.

Error Message:

Delta DTP cannot currently be deleted (see long text)
Message no. RSBK037

Diagnosis
You want to delete a delta DTP that has been successfully used to load requests from the source into the target. If you delete the DTP, you will also delete the information on the source data that was successfully transferred. As a result the source data would be transferred again, if you create a new delta DTP that links the same source with the same target.

Procedure
You have two options:
1. Delete all the requests loaded with this DTP from the target and then delete the DTP.
2. Do not delete the DTP and continue to load deltas using this DTP.

Solution:

Go To Transaction RSBKDTP to delete DTP directly.

Source: http://forums.sdn.sap.com/thread.jspa?threadID=1568522&messageID=8581401

Additional Note:

Data Transfer Process (DTP) is related to various object such as Target, Source and Transformation. Here’s an extra table check for transformation. After deleting DTP, Cube or DSO  than the transformation should be deleted too.

RSTRAN Transformation
RSTRANFIELD Mapping of Rule Parameters – Structure Fields
RSTRANRULE Transformation Rule
RSTRANSTEPROUT Rule Type: Routine
RSTRANRULESTEP Rule Steps for a Transformation Rule
RSTRANSTEPMAP Mapping for Rule Step Within a Rule

Source:http://www.sapks.com/2010/01/dtp-tables.html

SAP BW UD Connect and SQL Server Unicode Setting

sap logoWith UD Connect you can now integrate the data for the source object into SAP BW. You can either extract the data, load it into SAP BW and physically store it there, or, as long as the prerequisites for this are fulfilled, you can read the data directly in the source using a SAP RemoteCube. Example SQL Server 2008…

But, when we tries to extract data from SQL Server 2008 x64 database to SAP BW NW7 with UD Connect , we get an error message.

The error message when executing an  Info Package to load/transfer data from SQL Server 2008 x64 to SAP BW NW7.

S:RSSDK:400 Cannot convert field DECIMALS of type NUM to int

to solve the problem you have to check the SQl Server “UnicodeSetting

Steps:

1.) Go to SAP BW > RSA1 > Source System > UD Connect > ….

Right Clik on the UD connection name and Click on  Connection Param.
sap udconnect menu

3.)  Go to MDMP & Unicode Tab and Run Unicode Test you must have access to TCODE SM59

4.) If your target system is Unicode, then you have to tick Unicode for Communication Type for Target System.
sap udconnect unicode

5.) Save and Close the Source System Dialog

6. )re Run the Execution of Info package.

Good Luck

SAP NW7 Deleting Bex Web Analyzer Bookmark (Bex Portfolio / KMBookmark)

sap logoSAP Net Weaver 7 (SAP NW7) has a capability to store query bookmark on web application (Bex Web Analyzer). If we execute query from Query Designer, than it will launch a query in web application. The other way running a query is from Excel Ad In (Query Analyzer).

I like to run query from web application  compare to Excel Ad In, it has great presentation look and it can run anywhere with in browser.

The Problem is the “Save As” menu to My Favorites“,”Bex Portfolio“,”My Portfolio” on web app query is visible and easily use , but there’s no “delete” button on web application query for “Bex Portfolio” item .  User can easily save layout but cannot delete them. Whoott……..!!

To delete a Bex Web Analyzer Bookmark – Bex Portfolio , follow this steps:

1.) Go To:

http://<servername>:<port>/irj/servlet/prt/portal/prtroot/com.sap.km.cm.navigation

or

http://<servername>:<port>/irj/go/km/navigation/

note:don’t forget to add ‘slash’ (/) at the end of the url

2.) Fill User Name and Password , then click  Documents > Public Documents (see picture below) Or Entry Points> Public Documents

public documents my portfolio

3.) Click the icon at the right corner of the Bex Web Application Item (see picture below)
public documents my portfolio delete

and it is DONE! for Bex Portfolio” item

4.) To delete another  Bex Web Analyzer Bookmark – My Favorites or Personal Folder :

Go To: http://<servername>:<port>/irj/go/km/navigation/

and explore the navigation menu. I can’t describe in detail because i’m not testing it on non admin user, yet.

Reference:

  1. SDN Forum – Bex Web Favorites

SAP BW , Repairing BW Objects

sap logoFirst, if there is an error on the activation of a DataSource Object (DSO) or the Transfer Rule Object.

Run this transaction code:

RSRV: Analysis and Repair of BW Objects

Second, If an SAP BW InfoObject get an enhancement then it should be repaired too. Apply these steps:

Run this transaction code:

RSA1  :

Goto Top Menu and follow these steps:

Tools Apply Hierarchy / Attribute Changes

SAP BW NW7 Transaction

sap logoSAP BW Client

SBIW : SAP Business Information Warehouse IMG (Implementation Guide)

RSA1 : Modelling DW Workbench. This is Main Transaction

SCC4 : Client Administration (BASIS Area)

RSECADMIN : Authorization, Replacing Obselete RSSM

SE10 : Transport Organizer

RSPC : Process Chain Maintenance

SE37 : ABAP Function Modules

RSZC : Copy Query Between InfoCube

RSRV : Analysis and Repair of BW Objects

RSORBCT : BI Business Content Transfer

SM37 : Overview Of Job Selection

LISTCUBE: To display content of Info Providers

SAP R3 Client (Origin, Dev, or Quality Control)

RSA9 : Content Application Transfer Component Hierarchy (One Time Setting)

RSA2 : OLTP Metadata Repository, For Checking DELTA Capable

RSA3 : Extractor Checker

RSA 5 : Install Business Content

RSA6 : Maintain DataSource

RSA7 : BW Delta Queue Monitor

LBWQ : Logistic Queue Overview

LBWE : LO data Extraction : Customizing Cockpit

LBWG : Deletion of Setup Data

SBIW : SAP Business Information Warehouse IMG (Implementation Guide)

OLI7BW : Statistical Setup for Old Documents : Order

SE16 : Data Brrowser

SE10 : Transport Organizer

SE11 : ABAP Dictionary Maintenance

RSO2 : OLTP Metadata Repository