Hi Felipe,

With the custom rollup at the 'level' level (ie every member within the level), if you know that the submarket is always going to be the first child of...

If your submarket "1" is always the first child of each Zone then you could use a custom rollup formual for the level within the dimension (ie set the rollup...

check your personal messages.

Not saying I'm proud of it, but the following is a single pass query that will produc the running total for you.  It's not "perfect" in that you'll need to...

If you've built your own front end then you write your own MDX too?  (ie the front end generates MDX to query the cube).  If so, then to nest items,...

Just out of interest, if you're looking for a quick and easy way to write the DTSRun command string, g to a cmd (command/dos) window and type dtsrunui (this assume...

wonder if thats a record for most un-intentional smilies in a single post??

Have you tried using the SQL retrieval method but still using ADOMD?  In BOL there is a section on using a recorset (instead of cellset) for data retrieval.  This will...

You should be able to do this using the ParallelPeriod function.  Something like the following should work

SUM(LastPeriods(3, ParallelPeriod(Year, 1, [Time].CurrentMember), [Measures].[Sales Grossval])

One thing to check is the Directory Security setting on the virtual dir for "/Reports", if this is set to anonymous (regardless of whether you have basic or integrated also...

It's not clear from your ealier post(s), so I'll ask anyway - have you followed the steps outlined in section 1.8 of the readme.htm (comes with the CD/installer) re: "Reporting...

(i hate it when the window times out and you loose an entire post)

Can you post the working and not working url's?

Also, have you tried escaping the ampersands ? ie...

Can you post one of the links that isn't working?  (use dummy data for url bits if these are public and you don't want them viewed by all

You could try using the datetime information supplied and passing the appropriate parts to each of your fields.  e.g.

SELECT <some_stuff> FROM <my_Table> WHERE CONVERT(CHAR(8), <my_Date_Field>, 112)  = CONVERT(CHAR(*), @The_Param, 112)...

If you want to rename just the catalog/DB, can't you copy and paste to the same server and it will prompt you for a new (different) name?

If you want to...