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
Posts in "dev"
SAP BW : Prepare Large ETL (DSO and Cube)
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)
SSAS: Mastering MDX on SSAS
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
Linked Servers, How To Read MySQL On SSMS 2008
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 ; and The ability to address diverse data… Continue reading
HeidiSQL Rock!
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 work best and flawlessly… Continue reading
SSAS: MDX Average Script On SSAS 2008
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
What is the secret recepies for making a good and reliable ERP system ?
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, how you have to build ERP system is becoming less important (critical). Any implementation model, In-House,… Continue reading
SAP BW: DTP, Extract Very Large Data from PSA to DSO
The next step in SAP BW after Initial (INIT) and Full of Logistic (LIS) Data Extaction (with InfoPackage) from SAP R/3 to Persistance Storage Area (PSA), is to load very large data (2LIS_11_VAKON) from PSA to DataSource Object (DSO). This data source is one of the biggest Datasource we have on our SAP BW 7… Continue reading
SAP BW: ABAP dump on Read Master Data
Read Master Data (Master Data Derivation) in SAP BW NW 7 is one of popular Transformation method to fill an InfoObject on a Cube or DSO. I think 99 percent of SAP BW architecture use this method. Recently we have problem , an ABAP dump (error) occurs just after we finished a modification to a… Continue reading
Get UserName on ASP.NET Membership Provider
If you are using ASP.NET Membership Provider for a website, one simple and practical way how to get ‘username’ for logging activities on CRUD (Create Read Update Delete) implementation is by storing the “username” on a session. Put this little code on Default page, or first landing page after succesfull user login.
1 |
using System.Web.Security; |
…
1 2 3 4 5 6 7 8 9 |
protected void Page_Load(object sender, EventArgs e) { //check user login if (User.Identity.IsAuthenticated) { //get username and put into session Session["UserName"] = Membership.GetUser().UserName.ToString(); } } |