Hi Michael, all is well here, have a new job which always brings change and excitement  

I think you're right that the member -full...

From memory, the where clause entry has to be a tuple, so you can't throw a set in there (which would make life easier), so I think if you create...

Honestly, I think ti was so that AS could be installed without SQL, but (for us anyway) the reality is that to manage an Enterprise installation of AS, we need...

getting back to your original question, the way to interrogate objects in AS is through the use of DSO (Decision Support OBjects).  This is very easy to do with VB6,...

A basic entry point is to use the YTD in conjunction with a SUM() function, but this may not produce correct results where your measures aren't summed (e.g. distinct counts).

If...

it's possibly a security problem with the catalog.  Does the catalog have a role defined and are you a member of it?

Which timeout value did you set?

It should be migrated to MSSQL to utilise the SQL engine as the repository DB engine, allow for it's inclusion in your backup routine of your SQL installation, and generally to...

I've not done it for this type of problem, but i can't think of any reasons why you couldn't use the LOOKUPCUBE function back to the same cube (i've done...

Is the aim to sum only the latest (most recent) cohortcount for each cohortid? 

When you say it includes duplicates across multiple periods, do you want the sum to be...

I'm not sure I fully understand why you wouldn't have the 'quantity associated' as a measure (which would obviosuly make the entire problem a lot easier to solve), but leaving...

Ok, so you are looking for members to add to your time dimension, rather than setting the default member.

To do the quarter, month and day, either look up the VBScript...

Hi Jared,

Forget the first way I said to do it - this works great for calculated members but not for setting the default member of a dimension.

Below is a script...

Apologies jared, this is what we use for a calc member (located in time dim) that allows users to see current month value for any given measure(watch out for distinct...

One of the ways we do it is to create a separate dimension that contains only the current period, hide it from users (visible = false) then use...