I've done both and found tables to be easier to get the info you need out such as timings of steps etc. However i have generally found that support/help...

Agree - I got bored writing the SQL.....

Create a view in SQL and base your dimension off that. You might want to write this to a table to give you some flexibility to name quarters or...

The syntax looks fine

It will be a problem with a member - best double check that the members of the tuple are correct e.g. is [Chargebacks].[CHB_Tree].[CHB Type].&[IRS VOID] correct?

Mack

Hi Bobby,

What version of SSAS are you using? Haven't used cell calcs in yearrrrrrrrrsssssssssss

If you are using 2005+ then you could try

SCOPE([Income_Statement].[Account List].&[464]); --not sure I included...

You are converting a set to a member which you can't do

Try

member [Measures].[VOID] As

(strToMember("[CHB Date].[Year - Month - Period - Date].[Date].&[" + Format(dateadd("d",now(),-1), "yyyy-MM-T00:00:00") +"]") , [Chargebacks].[CHB_Tree].[CHB Type].&[IRS VOID]...

If I have understood this correctly then its quite a tricky one but should be possible using the generate statement

I cannot test the below MDX but here is a stab...

You could create a set of dates using MDX

I believe in a previous post of yours DavosCollective suggested the following MDX for Yesterday

StrToMember("[Time].[Year - Month – Period - Date].[Date].&[" +...

If it works serially then maybe it's a problem with parallelisation as SSAS is sending multiple queries to SQL Server on a 2 CPU box

I've had issues with DTS where...

When we had issues with 32-bit SSAS it did a similar thing - it just seemed to flatline and hence it took so long to find the issue

I noticed that...

A member is one thing - one product or the sum/avg of a set of products

You need to define your set as a set as below - a set being...

It's probably how I would have done it

Alternatively you could do

MEMBER [Measures].[Yearly Adv Req] AS

(Descendants(Ancestor( [Date].[Calendar].CurrentMember, [Date].[Calendar].[Year] ),2).Item(0)

, [Measures].[Advertising Req] )

Mack

You could remove their OLAP admin access....(I sound like a DBA now :w00t:) and grant them admin access to each cube - this can be done by creating an admin...

Hi Astrid,

Your MDX is quite unusual and without access to your cubes I can't really say I've helped you but try the below MDX

I would say that:

If you want averages/max...

Use SSIS and loop through the databases running this MDX and feed the data into a table.

Then do the comparison in SQL Server

Mack