Akhirnya Microsoft SQL Server 2008 mendukung tipe data spatial (keruangan). Sebelum memulai masuk ke bagian teknis ada baiknya kita sedikit berkenalan dahulu dengan data spatial. Data spatial (keruangan) dasarnya di bagi menjadi 2 bagian yaitu jenis data vektor dan satunya lagi jenis data raster. Jenis data vektor adalah “hasil” dari koordinat X,Y, Z untuk menggambarkan… Continue reading
Posts in "dev"
Part 3: Data Loading,Methods dan Sample GEOMETRY di SQL Server 2008
Pada tipe data GEOMETRY (lupakan dahulu GEOGRAPHY, agar tidak bingung), SQL Server 2008 memiliki 3 opsi loading data (membentuk data) : OGC Well Known Text (WKT), Well Known Binary (WKB) dan Geography Markup Language (GML). Sedangkan untuk mempresentasikan data, SQL Server memiliki beberapa Methods sesuai standart OGC dan beberapa yang sifatnya extended. Contoh Syntax WKT:… Continue reading
Step 4: Extraction, Loading SPATIAL Data Type
Pada tiga penjelasan sebelumnya, kita sudah berkenalan dengan jenis data spatial di SQL Server 2008. Topik berikunya mengenai load data spatial jenis shapefile(shp) ke dalam table SQL Server 2008. Mengapa saya memilih menyimpannya di SQL Server 2008 dibandingkan dengan penyimpanan format flat file macam shapefile (shp,idx,dbf) ? Berdasar pengalaman, data dalam bentuk tabular lebih mudah… Continue reading
Kill a lock process
The last method (workaround) to solve a lock status is by killing the process. Write this line to Kill a process in sql server:
1 2 3 4 |
--This example shows how to terminate SPID 55. KILL 55 --This example generates a status of the rollback process for the specific spid. KILL 55 WITH STATUSONLY |
–This is the progress report.spid 55: Transaction rollback in progress. Estimated rollback completion: 70% Estimated time left: 15 seconds.
Multiple IIf Logic Block
IIf function often used in MultiDimensionalExpression (MDX), It’s quiet simple to implement single block of IIf block. This an example of Multiple IIf logic block. Example1:
1 2 3 4 |
IIf(Measures.[Store Sales] > 50000, "Good", IIf(Measures.[Store Sales] > 30000, "Average", IIf(Measures.[Store Sales] > 10000, "Poor", "No"))) |
If…Then..Else… in MultiDimensionalExpression
A logical script in MDX to perform an “If..Then.. Else..” block.
1 |
IIf(«Logical Expression», «Numeric/String Expression1», «Numeric/String Expression2») |
Example1:The following example returns 0 if Measures.CurrentMember is an empty cell, 1 otherwise:
1 |
IIf(IsEmpty(Measures.CurrentMember), 0, 1) |
Example2:The following string returns the string “Yes” if Measures.CurrentMember is an empty cell, the string, “No” otherwise:
1 |
IIf(IsEmpty(Measures.CurrentMember), "Yes", "No") |
Example3:
1 2 3 4 5 |
IIf( [Scenario].CurrentMember IS [Scenario].[Budget], [Measures].[Budget Unit Sold], [Measures].[ActualUnit Sold] ) |
Example4:Average Sales (Measure) By Time Day (Dimension)
1 2 3 4 5 6 7 |
IIf ( ([Time].currentmember.level.name = "(All)" OR [Time].currentmember.level.name = "Year" OR [Time].currentmember.level.name = "Quarter" OR [Time].currentmember.level.name = "Month" OR [Time].currentmember.level.name = "Day" ),AVG(Descendants(Time.CurrentMember,[Time].[Day]),Measures.[Sales]),0) |
Source:… Continue reading
Relative Contribution to Total Value (Percentage)
There’s a few scenario to calculate a percentage of a measure in OLAP CUBE (Analysis Service 2000). A Percentage is common calculation in MDX , and it can be solved by divide a measure to total value (Grand Total). Sample 1:Measures.[Value Contribution to Total]:
1 |
(Measures.[Value] / (Measures.[Value], Time.[All Time], Products.[All Products],…) |
Sample 2:Measures.[Value Contribution to Total]:
1 |
(Measures.[Value] / (Measures.[Value], Products.[All Products],Warehouses.[All Warehouses]) |
Sample 3:Measures.[Product Contribution to… Continue reading
Encrypt and Decrypt Web.Config (Connection Strings, etc) from ASP Page
Example: How to encrypt/decrypt connectionStrings and SessionState section on Web.Config file? This is a codebehid sample script written on C# to perform Encrypt and Decrypt procedure against few items on Web.Config file. Single ASP.NET page can perform this task easily, so you don’t have to write any code in command prompt. Declare this namespace:
1 2 3 |
using System.Web; using System.Web.Configuration; using System.Web.Security; |
Web GIS with MapGuide Opensource 1.2
I found that the simple and low cost way to setup, produce, run and maintain a Web Geographic Information System (GIS) is by using MapGuide Opensource (server) and Autodesk MapGuide Studio (Author). Screen shot Note: The spatial data is based on esri shape file (shp) and automatically transform into sdf (autodesk spatial data file) for… Continue reading
Sharepoint Service 2.0 and SharePoint Portal 2003 BUG!
In my opinion, Sharepoint Portal Server 2003 (SPS 2003) is a superb! Content Management System (CMS) and Collaboration Portal for Intranet. It’s build (runs) on top of Windows Sharepoint Service 2.0 (WSS 2.0). It’s very suitable for Knowledge Management. You can throw almost any kind of document, collaborate and find it again just a second…. Continue reading