Date archives "June 2008"

Tips Aman membawa Laptop / Notebook di Bandara dan Mal

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

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:

If…Then..Else… in MultiDimensionalExpression

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

Example1:The following example returns 0 if Measures.CurrentMember is an empty cell, 1 otherwise:

Example2:The following string returns the string “Yes” if Measures.CurrentMember is an empty cell, the string, “No” otherwise:

Example3:

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

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

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

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