Sorry upfront as this isn't a direct answer to the question posted. I would seriously consider changing the model yourself, creating new hierarchies within the one Period dimension.

you need to supply just a little more detail.....

are you looking to build a cube in code? or perhaps you have an xmla script that you'd like to deploy...

Like Valek said, the poll is meaningless (ie what are you expecting someone to vote on?)

Also, if you really are looking for some C# code, whether for use with Analysis...

Have you tried adding a .MEMBERS to the end of the column set specification?

so like { [Project Dim].[Project Manager Email].MEMBERS} ON COLUMNS

For testing only, you could try to add the Everyone (and maybe even Guest) accounts to your AS roles on your PC (not the virtual) - this *might* let your...

This page has the downloads for the OLE DB driver that you'll need. Note the requriement to install the XML Core Services 6 *BEFORE* you install this driver.

hth,

OT - Hey Michael, have you had a chance to test the upsert (update or insert --> the new MERGE statement) functionality in 08 yet? Be interested to...

Not sure exactly what you're looking to do, but you can add VB.Net code to any given report (go to the Report Properties and then Code tab). This code...

Personally, I'd still be tempted to use TSQL (ie have 2 colimns, one tha has the seconds and the other with the formated value) but, if you're insisting on doing...

Have you tried a four part qualified name for the external SMPT servername (e.g. someServer.somePlace.someCompany.com)? You may also want to ensure that the server will relay messages originating in...

guessing that you'd incorrectly named outboundhours and the number 4818 represents seconds (or possibly minutes) then some simple math, using modulo will let you pick out the hours, minutes and...

Do you have any data source that determines what the grouping members are? Not sure it'll work in your case, but assuming you *do* have that datasource, and you...

Glad you got it to work!

look at it this way, it's two days that you didn't spend doing something else 😛

Oh and the pointer i got was from...

Also, if you have deeper levels (eg sequence containers etc), the same syntax but 'slashed' paths to the object before you hit it's variables collection. so with a sequence...

Using a package level parameter, this works in SQLAgent --> \package.Variables[myVar].Value

HTH,

Steve.