You can put this into the Where condition in a query for a simple solution. For example in AdventureWorks this:

SELECT

NON EMPTY [Measures].[Reseller Sales Amount] ON 0,

[Geography].[State-Province].[State-Province] ON 1

FROM

[Adventure Works]

WHERE

{[Geography].[Geography].[State-Province].&[NY]&[US],

[Geography].[Geography].[State-Province].&[SD]&[US]}

...would give...

They only have information on when a partition/dimension was last processed and don't record any sort of history. Your best bet is using msdb.dbo.sysjobhistory and running a query on that.

According to the Analysis Services Operations guide (http://msdn.microsoft.com/library/hh226085.aspx) CoordinatorExecutionMode is to do with processing and querying only. It mentions nothing of backup operations.

According to a quick google search if you...

There isn't a way of seeing how long a cube took to process within the cube itself. However if the processing is done via an agent job you can look...

I'm not sure what you are trying to achieve by simply merging two fact...

Hi,

Sorry for the late reply I was busy yesterday!

I honestly can't see anything obvious but I'm still pretty sure it has something to do with the use of currentmember in...

Convert to XML then use one of two methods.

You can do it with an XML task in SSIS:

http://microsoft-ssis.blogspot.co.uk/2012/08/validating-xml-file-against-xsd-with.html

Or a script task in SSIS using C#:

http://microsoft-ssis.blogspot.co.uk/2012/08/validating-xml-file-against-xsd-with_6.html

I've done this in the...

For any connection manager you can set different aspects of it when you configure your project/package in SSMS. So you can set the initial catalog, password, servername and username independantly...

I have had some (quite brief) dealings with Dundas and I know that if you write manual mdx then you lose some functionality in regards to drilldown but I'm not...

Why do you need separate UserTypeMapping and UserTeamMapping intermediate facts.

Why not structure your data to have (going back a few steps to dimension modelling) one User table that has foreign...

Jake Shelton (2/5/2014)

---

Cheers guys!!

Another question, I have a LOT of these to build, typically I'll only need 2-3 tasks and a couple of connections...

Is it possible/worthwhile using the Wizard to...

I might be wrong here, but do you just need to create a set from what is in your select statement that can be used at any time with the...

Can you not just install the Excel assembly on the server and then you can call the Mode function using Excel!Mode ?

FirstChild and LastChild are used for hierarchy navigation so wouldn't be that relevant in your query.

Have a read of the following:

http://mdxpert.com/Functions/MDXFunction.aspx?f=40

http://mdxpert.com/Functions/MDXFunction.aspx?f=36

This'll do it:

WITH MEMBER Aft AS

MAX({([Trans].[TRA].CURRENTMEMBER, [Trans].[Seq].[Seq].MEMBERS)},[Measures].[Num Val])

MEMBER Change AS

Aft - [Measures].[Num Val]

SELECT

{

[Measures].[Num Val], Aft, change

} ON COLUMNS ,

(

[Trans].[Tax Year].[Tax Year].members, [Trans].[TRA].[TRA].members

) ON ROWS

from...