I've become a firm believer in SSD for Essbase. Especially with Intel's recent entry into the PCI SSD market. You can also take a look at my KSCOPE presentation which you can find at: http://www.emergenow.com/images/files/file/KSCOPE12_Planning_for_and_Managing_Hyperion_Infrastructure_JBooth.pdf
Thank you for helping me here. I wonder, where is the suitable area for Essbase? FYI, we have about 1TB data (using ASO cube). If we put SSD in data file (*.dat), it will be very expensive investments. What do you think John? Do we need to put SSD for other purpose? Kindly need your advice. Thanks.
You have to consider the expense of SSD in relation to memory as well as what level of investment you have to provide better performance.
You can arrive at 1 TB of SSD in several different ways whether that be 2 of Intels PCI cards, internal drives, Fusion IO, ... so it sounds like your real question is about the price. This can run from $8,000 for a pair of the Intel cards to the mid tens of thousands of dollars for Fusion IO.
I would suggest you try to prototype something using more consumer level hardware to confirm you will get the performance boost you may be hoping for by taking advantage of SSD and/or partner with someone who can assist you with benchmarking.