Steps on configuration the Audit dataabse

[Prerna Chaudhary]

Hi All,

I need to configure Audit database n Cognos 10.2.1.

Can somebody please guide me on what are the steps for setting up the audit database on SQL Server 2008 and Cognos version 10.2.1.

Also would like to know what do we mean by "parameter settings " in Cognos installation.

Any help is appreciated.

Thanks and regards
Prrena

[cognostechie]

Prerna -

The installation guide of audit has all the steps. I did it few years ago so don't remember all the steps but this is what it should be:

1> Create a new DB in SQL Server 2008
2> Configure that DB in Cognos Configuration in the audit DB section
3> Create a Data Source with the same name as suggested in the installation guide. Alternatively, open the FM Model
     that comes with the audit package and check the Data Source name there.
4> This should make the FM Model work

There is a setting somewhere to specify how detailed audit you want . It's audit level setting somewhere
There is also an xml file that comes with the package which you have to install. The FM model needs that xml file
for one of the query subjects.