Sure, you only need to use the PivotTable object (for example with Excel). Menu -> Data -> PivotTable and PivotChart Report...

Just create the connection (Pivot Table wizard) and drag and...

Both servers use the same AD account to run SQL service, but I don't understand what do you mean by "integrated security for a domain user account"; could you explain...

I think the hard part on building the fact table you will find it with MOC2092 (Click here)

Cheers

I don't even knew that securing DBs with a password was a possibility!

I like QODs because them unveil some of the new capabilities of SQL2005

Got it.

Thank you all guys.

Woops, I was meaning to raid-stripe/ntfs-block relation.

This relation has any sense or... what is the reccomended stripe size for a SQL server?

Defrag isn't capable to deal with 64K blocks or why do you say this about the third party tool/win2003?

My tought is the block size and the NTFS allocation unit size...

Unfortunately I can't buy any more disks (budget), and the server is already here (I can't change the HW specs anymore). With such quantity of disks I think a RAID10+spare...

Thanks for the reply

The server has it's onw RAID controller (PERC4ei), this means the hotswap can be done for RAID1.. Right?

Could you explain me a bit how the RAID5 can...

I'm kind of embarrased. Your're totally right, dbo wasn't sa for the new database.

Thank you!

Congratulations Frank!!

It seems the shark's smile to be slightly bigger than other days.

Thanks Steve.

I couldn't try what you proposed, because in the end, the project leader decided to go back to NT because of the many problems (this is only one of...

Sensei Steve!

Is exactly what I needed... Thank you

Seems that this is finally done. I recived help to resolve it using Calculated Members (my MDX skills still sucks)

Sum(Descendants([Document Type].CurrentMember,,LEAVES),

Iif([Document type].CurrentMember is [Devolution], 0,

([Measures].[Invoiced]-[Measures].[Mfg Cost])

/[Measures].[Invoiced]))

Thank you both for your...

Sorry for my HUGE delay with this.

I've been looking to achieve this with Custom Members, but as far as I undestand, this is to dinamically change values for Dimension Members,...