If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Automate execution of PPES cube views

Started by Kay, 13 Dec 2005 05:52:03 PM

Previous topic - Next topic

Kay

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


dwood09

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