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 |