COGNOiSe.com - The IBM Cognos Community

Hi All,

We are using PPES 7.1 MR2 on an AIX server.Ã, 

We have about 20 cubes (accessed via Upfront),
and each cube has Company Division as one
of the dimensions (about 20 categories).Ã, 
We have saved cube views of some popular reports from these
cubes, so the PPX's with non-mnemonic names are buried deep on the AIX server.Ã,  Ã, 
All the reports are grouped by Company Division.Ã,  When users
view these reports interactively, it's a simple matter
for them to filter a different Company Division.Ã, 

But we also have a requirement to save a historical snapshot (CSV format)
of each report after each month's data refresh.Ã,  (Sadly,
the data is not structured so that we can go back to re-create any point in history.)Ã, 
How can we automate this process?Ã, 

If I were using PP client for Windows, I think I could
write a Cognos Script macro to do it, looping through all the Company Divisions.Ã, 
But I'm drawing a blank on the remote cubes & cube views.Ã,  Ã, I know I can
access a remote cube from PP client, but what about the remote PPX's?Ã, 
And is there a better way?Ã,  Some keystroke capture program?

Any ideas?
Thanks, Kay

Hi Kay,

One solution could be to create a PP web viw of each of the cubes that you intend to snapshot (within Upfront).

You wil find a PPX for each of these Upfront newsitem IDs normally wihtin the "...cer3\ppserver\ppsroot\imported_reports\cubeName\" folder.

Your script could then scroll through each PPX, apply filters and save as required.

good luck,
DW