Posts Tagged “olap”
Microsoft Analysis Service (OLAP) Front-End
by diditho on April 9, 2012
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. (…)
SAP BW : Prepare Large ETL (DSO and Cube)
by diditho on December 14, 2011
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) Related Posts:What is the secret recepies for making a good and reliable ERP system (…)
SSAS: Mastering MDX on SSAS
by diditho on July 21, 2011
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 (…)
SSAS: MDX Average Script On SSAS 2008
by diditho on June 7, 2011
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 (…)
What is the secret recepies for making a good and reliable ERP system ?
by diditho on January 27, 2011
What is the secret recepies for making a good and reliable ERP system ? and the answer is… Centralization of Master Data All you have to do is to have one Centralize ‘Master Data’ and the next steps, which is, (…)
