Author Topic: Automate execution of PPES cube views  (Read 3188 times)

Offline Kay

  • Associate
  • **
  • Join Date: Jul 2005
  • Posts: 1
  • Forum Citizenship: +0/-0
Automate execution of PPES cube views
« on: 13 Dec 2005 05:52:03 pm »
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

Offline dwood09

  • Global Moderator
  • Senior Member
  • *****
  • Join Date: Jul 2005
  • Posts: 60
  • Forum Citizenship: +9/-0
Re: Automate execution of PPES cube views
« Reply #1 on: 13 Dec 2005 06:04:45 pm »
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,