Posts by "diditho"

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 →

Cycling Travel

Pondok Pemburu – Gunung Pancar, Nyasar!

May 21, 2008 12 Comments diditho read

Seperti biasanya, pada hari sabtu 17 Mei 2008 saya dan teman-teman (fami doang) KGC bersepeda di jalur offroad.Kali ini sasarannya adalah jalur Pondok Pemburu sampai Gunung Pancar. Kami benar-benar “buta”dengan jalur ini, bisa dibilang agak nekat juga, karena kami berdua belum pernah sama sekali mencicipi jalur ini.

Cycling

MTB Heroes

May 13, 2008 5 Comments diditho read

Sama seperti cabang olahraga lainnya, Mountain Bike (MTB) juga memiliki icon atau “pahlawan” tersendiri. Tennis punya Maria Sharapova dan Roger Federer. Balap motor punya Valentino Rossi. dll… Jadi, siapa saja para icon atau pahlawan di dunia sepeda gunung ? Dimana mulai mencari ? Tiap tahun Union Cycliste Internationale (UCI) mengadakan perlombaan sepeda gunung bersklala besar… Continue reading →

dev

Encrypt and Decrypt Web.Config (Connection Strings, etc) from ASP Page

May 13, 2008 0 Comment diditho read

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:

using System.Web;
using System.Web.Configuration;
using System.Web.Security;

using System.Web;

using System.Web.Configuration;

using System.Web.Security;

… Continue reading →

dev Geography

Web GIS with MapGuide Opensource 1.2