Ok, we got a disaster in SAP BW NW 7 machine, part of the physical memory just suddenly break! Yeah! and The ‘fun’ part , the malfunction occures on heavy extraction of data from SAP R3 / IS-M Production Server. It break on pararel processing , although we can identify the malfunction Object, the team… 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
Here’s are steps that need to execute before start executing Data Transformation 1. Delete Data and SID On Cube (Destination) 2.Delete Index (Destination) 3.Delete Aggregate (Destination) Terimakasih!
The Next step on using SQL Server Analysis Service (SSAS) as Business Intelligence (BI) / Warehouse (BW) platform is to master Multi Dimensional Expression (MDX), it’s like Query on T-SQL. Question, how to master MDX script language on SSAS (SQL Server Analysis Service) ? or where to start ? Firts thing first, you have to… 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)
Old one, SSAS 2000, How to calculate Net Value By Date (NetValue… Continue reading