Friday, May 18, 2012

[IBM][isereis Access ODBC] .. SQL query exceeds specified time limit or storage limit ..

I got this exception when I tried to execute a query using DB2 ODBC script. There fore I found that ODBC property has a time out option which we can used to omit this problem.

image

go to configuration section and then Performance section and click  Advanced button.

image

and clear the option “Allow Query Time out

Monday, May 14, 2012

Slowly Changing Dimension (SCD) in SSIS is slow (Taking long time)

I encountered a problem when using the slowly changing dimension (SCD) in large databases. SCD is easy and fast when it comes to less number of records. therefore I used following mechanism to  speed up the process using available SSIS components.

image

First record set is send through Lookup command. in there we are checking that item is already available with the table.

If yes we are redirecting to UPDARE Command and If not we are redirecting to Insert Command.

But make sure following redirect option (Redirect rows to no match output) is set in the lookup component.

image

Wednesday, May 9, 2012

How to convert String to Enum Type in C#

This is a common question that we need in most of the time in developing. .NET provides powerful function in Enum Class to do that.

enum DBType
{
SQLSERVER,
ACCESS,
SQLCE
}
private static DBType getDBType()
{
String dbType = "SQLCE";
return (DBType)Enum.Parse(typeof(DBType),dbType);
}

Tuesday, May 8, 2012

Extensions Methods in C#

C# extensions can be used to extended the  functionality of already written class. (Yes it is true that we can use it for our classes as well. But then we can add the method directly rather than having it as extension method)

Following example shows a extension method which I used for extend the functionality of the windows.form class.

public static class Extensions
{
public enum SpliterModes
{
PanelOne,PanelTwo
}

public static void Show(this Form frm, String name)
{
frm.TopLevel = false;
frm.Visible = true;
frm.FormBorderStyle = FormBorderStyle.FixedSingle;
frm.MaximizeBox = false;
frm.Text = name;
}
}
image

Wednesday, May 2, 2012

Use Member Properties, Filter and With keyword in MDX

This is not a complete post. I came across a situation that I needed to show [Date] dimension values which is not empty as report parameter.

image

But I need yeas that only have values in measure. there for I used following MDX to get that.

with
member yKey as [Date].[Year].currentmember.uniquename
member yValue as [Date].[Year].currentmember.MEMBER_CAPTION
select{yKey,yValue}on 0,
{
filter([Date].[Year].[Year],[Measures].[Total Amount]<>null)
} on 1
from [RetailigenceBI]

this code result in getting


image