Topic
1 reply Latest Post - ‏2010-02-05T03:45:24Z by yangling
atomictortoise
atomictortoise
2 Posts
ACCEPTED ANSWER

Pinned topic Saving Powerplay report as XLS file in macro script

‏2009-10-30T09:47:44Z |
Hi,

Can anyone give me an example of saving a .ppx file as a .csv or .xls in macro script. I am trying to automate this.

Regards
Updated on 2010-02-05T03:45:24Z at 2010-02-05T03:45:24Z by yangling
  • yangling
    yangling
    38 Posts
    ACCEPTED ANSWER

    Re: Saving Powerplay report as XLS file in macro script

    ‏2010-02-05T03:45:24Z  in response to atomictortoise
    Did you check online for PowerPlay Macro Reference at

    http://publib.boulder.ibm.com/infocenter/c8bi/v8r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.pp_mac.8.4.0.doc/pp_mac_id13710PublishToPortalMethod.html

    Sub Main()

    Dim objPPRep as Object

    Dim objPPRes as Object

    Set objPPRep = GetObject(, "CognosPowerPlay.Report")

    Set objPPRes = objPPRep.Columns.CumPercentOfBase _

    (objPPRep.Rows.Item("2008"))

    objPPRep.SaveAs "MyNewReport"

    Set objPPRep = Nothing

    End Sub