Installing Essbase 11.1.2.3.500 with MS SQL server 2008 database
Hi,
I would like to know how to setup the MS SQL Database in order to install Essbase ?
I have found some information that recommends to install each product on a different Schema, but the meaning of Schema in Oracle and MS SQL are different, so my questions is:
Should I create different DBs with different users in MS SQL Server ?
Please give your comments for the following configuration:
| Products | Schema or DB ??? in MS SQL Server 2008 | Space allocated | 
|---|---|---|
| Shared Services | EPMSS | 200 MB | 
| IAS | EPMAS | 32M x 20 users = 640 MB | 
| EPM Workspace | EPMWS | 500 MB | 
| Report & Analysis | EPMRA | 500 MB | 
| Essbase Studio | HYPSTD | 
