try this:

SELECT MEASURES.DEFAULTMEMBER ON 0,

NON EMPTY

{

GENERATE([Geography].[Country].[Country],[Product].[Category].ALLMEMBERS)

*[Geography].[Country].[Country] } ON 1

FROM [Adventure Works]

SELECT {<<some measures>>} ON 0,

[Customer Dimension].[Customer Status].[Customer Status] on 1

FROM <<your_cube>>

WHERE (NULL:[Dim Date].[Date].&[26062013])

This code will effectively give you the customer status from Start of Date in the dimension till 26th...

Create a new dataset which will query the server such as using @@SERVERNAME and use parameters in the report body

CAST & REPLACE are SQL functions and the keyword AS not understood by Analysis Engine. This DMV will not work.

MERGE JOIN transformation?

If you are executing the cube process logic via a SSIS package, you can design an audit mechanism to track package start time and package end time for every cube...

What kind of testing are you planning? Is the agenda for the testing related to data correctness or performance related?

For the #2 approach which you have mentioned, the design must have a dedicated staging area tables to perform an OUTER JOIN with destinations to load only new data.

You can create two tablix regions in the report body with distinct data sets and group the report datasets by Agent Name.

Yes you are correct. But its just the way the query is built. You can always fine tune the MDX yourself 🙂

There are two parts to your question, if I understand it correctly

1. You can always use the the standard DMV's to see the formula and the MDX used to define...

To begin with, Profile the SQL and check whether the SQL is syntactically correct for the multi value parameters

See this:

http://stackoverflow.com/questions/11263538/powershell-display-table-in-html-email

and

http://lukieb.wordpress.com/2011/03/03/powershell-script-to-send-sql-server-query-results-via-e-mail/%5B/url%5D

What you should note here is that these blog links shared here have defined their own mail snippet to send the result, alternatively, you can also use the...

Paste your complete PS code here. Also, is there a specific reason not to use sysjobshistory and sysjobs tables for reporting needs?

What is the version of powershell you are using?