Tuesday, April 21, 2009

Parsing different type of Column Delimited in SSIS FlatFile Data Source.

I followed this Article to achive my requirement. Very nice and Interesting.
Parsing the diferent type of Column Delimited(Comma, tab,Colon, SemiColon) in SSIS for the Flat File Source.
http://www.sql-server-performance.com/articles/dba/import_text_files_ssis_p1.aspx

Thursday, February 12, 2009

Create Named Set for Dimension Member in MDX.

WITH
MEMBER [Dim Project].[Project Type].[T&M & FixedBid] AS '[Dim Project].[Project Type].&[FIXED BID] + [Dim Project].[Project Type].&[T & M PROJECTS]'
MEMBER [Measures].[NonBillable Hours] AS
([Measures].[Duration In Hours] ,([Dim BillableType].[Billable Type].&[BILL]
,[DimBillable].[Billable].&[0],[T&M & FixedBid]))
SELECT {
[Measures].[NonBillable Hours]
}
ON ROWS,
[Dim Employee].[Employee Name] ON COLUMNS
FROM [Resource Utilization]