Setup PM repository in another schema other than Unive schem

other Performance Management
1

Can i Setup the Performance manager repository in a different schema other than the schema of the universe tables.

What i mean is that I have created a GL universe which connects to GL user which has the necessary GL facts and dimension.

In order to create the metrics in PM Can I Create a seperate users in which the PM tables are created. so that extra tables are not populated in my existing GL user.

Please let me know weather this is possible.

Thanks & Regards

Ishaq

ishaqbaig (BOB member since 2009-03-28)

2

Your PM Repository should be created completely separate from the Production DB (i.e the connection being used in the Universe to the Production DB). You need to create a different connection to a DB that will contain the PM tables. You have to ensure the connection has read/write permissions to create the required PM tables.

Zulfiqar_Taj (BOB member since 2002-09-16)