Great stuff!

Does your SQL Server Agent service account have administrator rights? Try adding your account in there and restart the service and see if it runs then...

Check the REPLACE function in BOL:

REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3' )

SELECT REPLACE ( 'text1, text2, text3' , ',' , '-' )

Change the database name under your configuration deployment properties to a different name and deploy it... A new database will be created on your Analysis Server which you can use...

Create a Report Server project and add a data source connecting to your cube.

You will need to use expressions to update the variable and properties of your package. Read up on Expressions in SSIS.

Try this:

select

c1.company,

(

select

c.dept + ', ' as [text()]

from

comp c

where

c.company = c1.company

order by

dept

for xml path ('')

) as Department

from

(select distinct company from comp) c1

Just change the query...

SSIS could be used for this type of extraction.

Try adding the user to the Analysis Server Properties Security page...