When a script means a xmla-script, you should use the DisplayFolder element.

Script the AdventureWorks-cube for an example.

I'm not quite sure what you mean by 'collapses nicely'.

However, AFAIK by default you can not get details for a calculated member when using a XL-pivot on a SSAS cube.

Hope...

If good old T-SQL is what you're looking for:

[font="System"]SELECT (CASE WHEN Age > 60

THEN 'Old'

ELSECASE WHEN Age > 40

THEN 'MiddleAge'

ELSECASE WHEN Age > 18

THEN'Young'

ELSE 'Baby'

END

END

END)...

As I read it, in Standard Edition it is not possible to have multiple SSRS instances use the same reporting database.

see for intance , that also points out other possible...

With some help of a colleague who is more familiar with asp.net and the security around that, we finally made this work.

I'm not quite sure how to describe it, but...

On my SQL 2005 Developer installation, sysprocesses is no table, but a view (master.sys.sysprocesses), which ruled out the first answer to me (as I did only check if the table...

In SSMS you can drag'n'drop elements from a list in a textual MDX query (when using the "New query" feature). However, you still got to make up the correct MDX...

I think this question doesn't provide the right answer with the 4 alternatives.

The answer should be BIDS, when developing a Reporting Services Project!

IMHO you can not do it in Reporting...

Actually, there is a 64 bit Oracle provider available from Oracle (OraOLEDB.Oracle.1, see the Connectivity whitepaper).

When implementing ETL packages at a customer however, we found that no performance benefit from...

OK, you could consider the following:

- use a simple table to hold the last successfull run of each job

- start each job by checking if the necessary jobs have run...

you might consider a "master package" in which you set the controlflow for the packages to be executed.

In its simplest form: two execute package tasks, with a "success" constraint between...

Have you checked the SSIS Connectivity whitepaper? They suggest using some ETI component for Bulk inserts to Oracle. See http://download.microsoft.com/download/2/7/c/27cd7357-2649-4035-84af-e9c47df4329c/ConnectivitySSIS.doc#_Toc158373716

If your solution/setup works for a smaller number of...

It might be that the error occurs in the code that is sent to SSAS, which is XAML if I'm correct. Maybe this code, generated by SSIS and send to...

Can anyone clarify why this questions is worth 2 points, where similar questions on other subjects are worth 1 point?

Is this because the editors think the subject of encryption is...

Jan;

You should use variables and expressions to achieve the task you mentioned.

I provided an example package (see attachment) that does the following:

- determine the startdate of the package and use...