Books

Langganan National Geographic Internasional

August 29, 2008 22 Comments diditho read

Sudah sejak lama saya ingin berlangganan National Geographic. Harga langganan National Geographic Indonesia yang mahal membuat saya mengurungkan niat tersebut. Ketika saya dan istri membutuhkan bacaan berkualitas, pilihannya lagi-lagi jatuh ke majalah NGI. Iseng-iseng browsing ke situs National Geographic International Subscription, saya menemukan sesuatu yang menggembirakan. Harga langganan (subscription) plus pengiriman ternyata lebih murah dari… Continue reading →

Kuliner Travel

Kerja,oleh-oleh dan kuliner Banjarmasin

August 15, 2008 30 Comments diditho read

Bulan Agustus 2008 ini saya mendapat dinas ke Kota Banjarmasin. Bila tugas ke luar kota/pulau, sebenarnya saya tidak begitu bersemangat untuk jalan-jalan. Berbeda dengan di Banjarmasin, saya sempatkan untuk jalan – jalan mencari oleh – oleh, kuliner dan berburu pernak-pernik (cinderamata). Niat ini muncul karena kali ini saya beruntung mendapat pinjaman sepeda motor. 1.Kuliner Bila… Continue reading →

Unique

Acara 17 Agustus

July 31, 2008 7 Comments diditho read

Menjelang tanggal 17 agustus 2008, tinggal di Komplek perumahan baru memang sangat menyenangkan. Selain pemandangan orang tua mendorong kereta bayi dan anak-anak bermain sepeda, pastinya acara 17 annya juga sangat meriah. Atmosfer ini tidak saya temukan ketika tinggal bersama orangtua di komplek perumahan pulo asem, rawamangun, Jakarta. Lomba 17 an tahun 2008 ini, di komplek… Continue reading →

Personal

Constantine Barindra Nugroho

July 27, 2008 10 Comments diditho read

Hot momma and cool poppa production Presents: “Constantine Barindra Nugroho” born on July 25th, 2008, 10:35 a.m, 2,9 kg, 51 cm, at Family Medical Center (FMC) Hospital, Bogor, Indonesia, with C-section. Constantine at Flickr!

dev

Kill a lock process

July 18, 2008 0 Comment diditho read

The last method (workaround) to solve a lock status is by killing the process. Write this line to Kill a process in sql server:

--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 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.

Tech Unique

3 e-Newspaper

July 3, 2008 0 Comment diditho read

Dalam sehari , inbox dan feedreader saya menampilkan informasi mengenai e-newspaper (koran digital) dari tiga pernebit koran cetak. Koran Kontan, Koran Tempo dan Koran KOMPAS. Ketiganya dapat diakses dengan bebas (tanpa biaya), paling tidak sampai hari ini (3 Juli 2008). Koran Tempo membutuhkan registrasi untuk beberapa fiturnya, sedangkan dua lainnya tidak membutuhkan registrasi. Koran Kontan… Continue reading →

Enlighten Tech Travel

Tips Aman membawa Laptop / Notebook di Bandara dan Mal

June 26, 2008 3 Comments diditho read

Berita basi banget (basbang) sebenarnya, tapi masih sering muncul di beberapa milis dan masih menimbulkan banyak keraguan dan ketakutan. Untuk memberi ‘sedikit’ ketenangan, posting email dari salah satu milis yang saya ikuti mungkin bisa membantu. Konfirmasi ke pihak BSA Indonesia sebaiknya dilakukan, just to make sure. Pesan forward yang saya baca di milis netzaga beberapa… Continue reading →

dev

Multiple IIf Logic Block

June 25, 2008 0 Comment diditho read

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:

IIf(Measures.[Store Sales] > 50000, "Good",
IIf(Measures.[Store Sales] > 30000, "Average",
IIf(Measures.[Store Sales] > 10000, "Poor",
"No")))

IIf(Measures.[Store Sales] > 50000, "Good",

IIf(Measures.[Store Sales] > 30000, "Average",

IIf(Measures.[Store Sales] > 10000, "Poor",

"No")))

dev

If…Then..Else… in MultiDimensionalExpression

June 25, 2008 0 Comment diditho read

A logical script in MDX to perform an “If..Then.. Else..” block.

IIf(«Logical Expression», «Numeric/String Expression1», «Numeric/String Expression2»)

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:

IIf(IsEmpty(Measures.CurrentMember), 0, 1)

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:

IIf(IsEmpty(Measures.CurrentMember), "Yes", "No")

1	IIf(IsEmpty(Measures.CurrentMember), "Yes", "No")

Example3:

IIf(
[Scenario].CurrentMember IS [Scenario].[Budget],
     [Measures].[Budget Unit Sold],
     [Measures].[ActualUnit Sold]
)

IIf(

[Scenario].CurrentMember IS [Scenario].[Budget],

[Measures].[Budget Unit Sold],

[Measures].[ActualUnit Sold]

)

Example4:Average Sales (Measure) By Time Day (Dimension)

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)

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 →

dev

Relative Contribution to Total Value (Percentage)

June 24, 2008 0 Comment diditho read

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]:

(Measures.[Value] / (Measures.[Value], Time.[All Time], Products.[All Products],…)

1	(Measures.[Value] / (Measures.[Value], Time.[All Time], Products.[All Products],…)

Sample 2:Measures.[Value Contribution to Total]:

(Measures.[Value] / (Measures.[Value], Products.[All Products],Warehouses.[All Warehouses])

1	(Measures.[Value] / (Measures.[Value], Products.[All Products],Warehouses.[All Warehouses])

Sample 3:Measures.[Product Contribution to… Continue reading →

First
«
18
19
20
21
22
23
24
»
Last

diditho.com

Posts by "diditho"