Audit Reports development for multi environments

[pvs.kalyan]

Hi guys,
There is a requirement come up for me to create audit reports for multi environments.for example, i need to display audit report for c83,c84 environments in a single report.any suggestions on approach??

thanks
satya

[cognostechie]

If you mean c83 and c84 are different versions then they have different Content Stores and differemt Audit schemas.

You could set up one FM Model that could connect to both the schemas using different Data Sources , then create a Union of Query Subjects and publish a package. Performance degradation is expected.

Can't think of any other way..

[Shailaja0520]

Hi ,
I have a similar question--
I have 2 different  versions of databases oracle 10G and oracle 11G and their respective content store tables.
So  can I use the same method of  creating package using  datasources for the respective databases ?

or--
though use of tabular sql  in the report-- can i call the 2  different content store tables of different databases though user defined sql? is that possible?

Appreciate your help

[pvs.kalyan]

Thanks for reply..
I would like to add more content to my question--

We have 3 different environments 1)cognos 8.3 prod 2)cognos 8.4 prod 3)cognos 8.4 stage

these 3 environmnets have existing audit reports in each environment respectively.Now there is a requirement came up to develop the consolidated audit reports which shows data for these 3 environments at one higher version of environment.

So iam looking for a better approach like 'building a FM model from 3 different content stores will be simpler ' or using tabular sql to pull the data across the 3 environments is simpler

Awaiting for suggestions--

satya