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)
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 [...]
A linked server configuration enables Microsoft SQL Server (MSSQL) to execute commands against OLE DB data sources on remote servers. Linked servers offer the following advantages: Remote server access ; The ability to issue distributed queries, updates, commands, and transactions on heterogeneous data sources across the enterprise [...]
Arrghh!! need to manage an old version of MySQL database. Turnout the vary of MySQL version is a serious problem to lot of free MySQL Graphic User Interface (GUI). Most of it, cannot manage old version of MySQL database, only the new one *DOH!!*. Finally found… The only free GUI that [...]
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] ), [...]
Search
Meta

