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"))) |
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
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
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; |
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
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
I always looking for free web gis server with dotnet framework capabilities. Mostly everything that related with dotnet came with a charge. Recently i found that autodesk start their web gis opensource project, the MapGuide Open Source Project (MGOS). Surely it can run on dotnet framework and it’s free. MapGuide Open Source is a web-based… Continue reading
One of my favorite geographic Information System (gis) web server is Sharpmap. It runs on dotnet 2.0 and using ASP.NET(C#) language. I like Sharmap, because it’s open source and free . The web server it self didn’t need any additional software/component to install. Just pure dotnetframework (v.2.0). So it can be easily deploy on common… Continue reading
This post is copy from http://gumper.com, a unique website coz it’s only have one item…. The basic script of Multi Dimensional Expression (MDX). It’s very usefull for developer to build some scenarios in a CUBE. thank you, hope it’s ok i copied all the page. MDX Expressions Function Requires Returns CurrentMember Dimension Member PrevMember Member… Continue reading
sql server 2000 one of most powerful and easy to use database application. It’s nicely handle giga size data. Unfortunately the growth of the log file can be very frustrating. Sometimes there’s a certain difficulty when we want to shrink the log file, mainly because the database still running a process. usually we can use… Continue reading