Thank you guys! Really helped a lot!

One thing I missed to tell is that Columns are measures (CurrentYearActual, CurrentYearBud and PreviousYearActual) are measures of the cube, I designed this on purpose to reduce MDX complexity at...

Ok, you are accesing file system files, right?

Are you running the package from the same workstation/server you created it? Check the connection managers for the filesystem files (flat files/excel workbooks/etc),...

Hello, I think that my question was not so easy to understand that's why anybody commented on it, ok, here is the solution I found, and works nicely!

it was taken...

Hello everybody, guess what! I got good and bad news, the good news first, I found what I was looking for, in this link (great!)

Many-to-many dimensions (by marcorusso)

Now the bad...

According to the "Create Indexed Views" link you sent, the first part says

"A view must meet the following requirements before you can create a clustered index on it:

...

The view...

Great article!!

For production environments it is recommended to do the most effort to accomplish a database moving without losing any of its settings (security, replication, backup profiles...) this means more...

Actually is not the big deal to get my 2 points... unless there are prizes for getting points... are there any prize for getting points?

Anyway Is a great way to...

Hello, stating that only Enterprise Edition of SQLServer 2008 allows automatic page repair is a mistake that Microsoft already updated,

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

"Updated content

Removed the incorrect statement that automatic page repair...