Don't forget if you are doing a Process Incrimental/Update to do a Process Index on the whole cube afterwards to rebuild aggregations.

This is quite a good article on using...

Processing is different depending on the state of whatever object you are processing (a cube, the whole db, a dimension)

Have a look here: http://msdn.microsoft.com/en-us/library/ms175634.aspx

My guess is that in your case...

Here's something on using VB.net in SSRS:

http://www.codemag.com/Article/0701061

As for a generic VB.net guide just google "VB.net tutorial" or something similar.

Good luck 🙂

According to your image, if you have dimensions that correspond to the foreign keys in your fact table and you have them properly related to your relevant measure group on...

Are you sure the folders are actually deleted or is it that the permissions have changed?

Have a look in the ReportServer database and look at the catalog table. Check...

The way I have handled this in the past is to do a process update to the dimensions followed by processing the latest partition in the facts. Then the final...

Try using a derived column transformation in conjunction with the TOKEN expression.

For example, for what you are calling "Column4" the expression would be something like:

[Prefix]+TOKEN([Prefix 1],",",1)

"Column5" would be:

[Prefix]+TOKEN([Prefix 1],",",2)

....and so...

From personal experience it depends but generally I would recommend that it is separate. What else is happening on the box? If you have all of your SQL databases on...

Give MDX Studio a try:

http://www.sqlbi.com/tools/mdx-studio

Depends on which aspect of SSAS you mean.

SSAS in Multi Dimensional Mode is a fairly mature and well established product. Whilst it's unlikely to undergo any drastic changes it is...

Have a go with the guide on this very site[/url] 🙂

Have you tried using OPENQUERY?

SELECT *

FROM

OPENQUERY (SSAS, 'Select * from [$SYSTEM].DBSCHEMA_TABLES')

You shouldn't need to specify the catalog (which I'm assuming is [Self Service Reporting]) as you define that in...

I think you'd have to do this in a script task and then pass the value into a variable to use later on in a data flow task excel source.

You...

I believe so, if this thread is anything to go by.

Have a look into the SCOPE statement it should give you the ability to do what you need:

http://technet.microsoft.com/en-us/library/ms145989.aspx