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: IIf(Measures.[Store Sales] > 50000, “Good”, IIf(Measures.[Store Sales] > 30000, “Average”, IIf(Measures.[Store Sales] > 10000, “Poor”, “No”))) Diditho.com manage by Gagas Lintas Media in partnerhsip with Netfit.id

If…Then..Else… in MultiDimensionalExpression

A logical script in MDX to perform an “If..Then.. Else..” block. 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) 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”) Example3: IIf(… 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]: (Measures.[Value] / (Measures.[Value], Time.[All Time], Products.[All Products],…) Sample 2:Measures.[Value Contribution to… Continue reading