hi,

Could you please give me the expression for the conversion.

Thanks

vijay

hi,

You can use the given below query to acheive your task

Select Measures.columnname from Cubename

You can use the columns which are all you want to display.

Regards

vijay

hi,

You have to use Unicode String[Dt_WStr] datatype for solve this error 🙂

cheers

vijay

hi rootman,

I am also a newbie in Datawarehousing .we are using SSAS and SSIS for backend,proclarity as frontend.I had two years of experience in developing...

hi Rajesh,

Cube is nothingbut a mere representation of blocks of data which has several dimension associated with it , by which we can slice and dice the cube.We cant...

hi friends,

No body has faced this error..:unsure:

hi Mic,

As per you suggested i have used the derived column for splitting up the date (08/27/1982) into three columns day,month and the year.The package executed successfully...

hi,

For sending mails, we have to use SSIS packages.We can connect an analysis service cube using analysis server connection manager in the SSIS.After that drag and drop two send mail...

hi,

You have to add your windows login name to the analysis server and in the impersonation tab of the datasource in Business Intelligence studio you have to give your...

hi,

I got the problem solved friends...Thanks for all of you...

cheers

vijay

hi mates,

Suggest me something so that i can try something....

Regards

vijay

hi sindhu,

You can use the Execute sql Task of SSIS to execute the stored procedure...For triggering the sored procedure on changing dimension..I have no idea .:)

Regards

vijay

hi,

You can use the preetha script in the Script task or the file system task.Nice script preetha:)

cheers mate

vijay

hi mate,

Thanks a lot yaar for those links and for sorted out my query.

Thanks & regards

Vijay:)

hi,

Thanks a lot for those links mate:)...Now am going in for devloping cube ..Any particular book for developing cubes using SQL Server Analysis server 2005.

Regards

vijay