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… Continue reading
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… Continue reading
The MDX script on Microsoft Analysis Service (SSAS) 2008 and 2005 are different from SQL 2000. Here’s an example how to calculate average using MDX script on Analysis Service 2008. SSAS 2008, How to calculate Net Value By Date (NetValue / Date)
|
1 2 3 4 5 6 7 |
AVG( Descendants( [Time].[Calendar].CurrentMember, [Time].[Calendar].[Date] ), [Measures].[NetValue] ) |
Old one, SSAS 2000, How to calculate Net Value By Date (NetValue… Continue reading
After 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… Continue reading
SAP 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… Continue reading
Bagi penggiat Knowledge Management, mesin pencari Google seringkali dirasa belum cukup untuk memenuhi kebutuhan data yang diinginkan. English Query yang digunakan mesin pencari google dan sejenisnya seringkali menimbulkan kekacauan bila dikaitkan dengan pencarian data yang membutuhkan output numerical atau perhitungannya, apalagi dikaitkan dengan aktifitas slice and dice ala Business Intelligence (BI) . Google and other… Continue reading
In many Business Intelligence implementation cases, there’s a certain difficulty for IT Pro to explain or describe the difference between OLTP (OnLine Transactional Process) and OLAP (OnLine Analytical Process). I hope the table below might help a little. source: 360decisions