Hi Thanks for the response.

I want the last non-zero value for D1001 and D1002.. In the leg time device returns 0.

Vineet Dubey

My both the DBS are on same file filegroup e.g. PRIMARY.

key attribure of Week Of Month is collection : (Week Of Month,Month,Year)

[Dim Date].[Calendar Hierarchy].[Week Of Month]

WHERE (StrToMember('[Dim Date].[Date].&[2012-03-23T00:00:00]&[03]&[1]&[2012]') :

StrToMember( '[Dim Date].[Date].&[2012-03-31T00:00:00]&[03]&[1]&[2012]'))

Yes, i have full processed it , But No luck My Child Table is Not having HDR Record 4 ,5 ....

Am i missing something on relatioship ..?

Thanks Steve I am greatful to you !!!

For now i have below situation to poll the data from the cube...

(Fact)FactReadingTable ->(Parent)Project.ID->(Child)ProjectEquipment.ProjectID (ReferenceProjectID)

1 ) DimProject 2) DimProjectEquipment

IN the Dimension...

HI Steve

I have to use MDX Query Instead.

~Vineet

Thanks a lot ! It solved issue.

You Can Achive this by adding Computed Column also

CREATE TABLE [dbo].[tbl2](

[field1] [datetime] NULL,

[field2] [varchar](50) NULL,

[field3] AS ((((CONVERT([varchar],datepart(day,[field1]),0)+'.')+CONVERT([varchar],datepart(month,[field1]),0))+'.')+CONVERT([varchar],datepart(year,[field1]),0))

) ON [PRIMARY]

GO

SET ANSI_PADDING OFF

GO

Insert into [dbo].[tbl2] values ('2011-06-01 13:19:25.943',NULL)

GO

select * from [tbl2]

1) SELECT Measures.MEMBERS ON COLUMNS,

HEAD(ORDER({[Store].[Store City].MEMBERS},

Measures.[Sales Count], BDESC), 12) ON ROWS

FROM [Sales]

2) TAIL

3) SELECT Measures.MEMBERS ON COLUMNS,

TOPCOUNT({[Store].[Store City].MEMBERS}, 12,

Measures.[Sales Count]) ON ROWS

FROM [Sales]

4) TOPCOUNT

Are some of The functions can...

You can follow :

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/65473/

Another Way is to use OPENROWSET To Analysis Service

http://support.microsoft.com/kb/218592

Can we address above issue or Senario by using SSIS Packages ?

We are receiving CSVs files where order of column changed but is correct.

for e.g.

file1 columns0 columns1...

1-Please check your domain user is having access permission.

2-Please Try this by using Mozilla FireFox Browser

I have also faced user Prompt user/pwd.Even After suppling credentials this will not open...

Instead why can't you use Named Set ?

Plese read following link.

http://msdn.microsoft.com/en-us/library/ms144790.aspx

1st thanks to lookin.

-You are correct we can pass name and no all is required the function

is used by some IIIrd party component which can must be an

scaler function...