+ Reply to Thread
Results 1 to 7 of 7

Proclarity Automation Question

  1. Proclarity Automation Question

    Hi,

    I am using Proclarity 6.3 as Cube browser. We publish the cube to AS and
    Proclairty connects to AS and we can see all the available cubes to browse.

    Now in Proclairty, we have many ready views saves within ProClarity library.
    Now we have to convert the saved view into PDF for auditors as proof of
    reports.

    Is there any way, we can automate Proclarity’s view into PDF ?

    Thank you,
    Kris.



  2. Re: Proclarity Automation Question

    Kris,

    I thought one of the print options in ProClarity has a "print all
    slices" checkbox, so you may want to use that.
    But that only resolves one set of slices for a given "report" and not
    all possible cells of a cube, but you may not need that.

    Depending on robust you want to make it, you could just do some
    SendKey calls from either a simple
    VB app or Excel and have that provide the scripting.

    For a more robust approach, use ADOMD library in another VS.Net app to
    pass various sets of MDX queries, and take that resultset and print
    those. (you'd probaly just cut & paste the current MDX queries out of
    the ProClarity books and use those).

    You could also use Office 12 and the Pivot Tables to get what you
    want. Just iteratively populate the property that is populated for
    the MDX queries (.Command something or other) and then hash each
    report to a new sheet and loop through
    each sheet and print.

    -exologic

    ::: Pain with Essbase? Use CubePort, The BI Porting App :::
    ::: Go from Essbase to Microsoft Analysis Services :::
    ::: web: exologic.com/products.htm :::


  3. Re: Proclarity Automation Question

    Not related to your queston - but how happy are you with Proclarity and I'm
    gussing Perf Point?

    We managed to get some stuff out the door but have a list of about 50 real
    issues with the products. One of the most frustrating things is lack of
    better conrol for the legends. Once they get too big - they just start
    dropping rows. So when you allow drilldowns across other dimensions - it
    creates a problem if there are more members than can display.

    "Kris" wrote in message
    news:2FB7C8F5-A4DC-4DDE-B58E-0AE3E72ADECDatmicrosoftdotcom...
    > Hi,
    >
    > I am using Proclarity 6.3 as Cube browser. We publish the cube to AS and
    > Proclairty connects to AS and we can see all the available cubes to
    > browse.
    >
    > Now in Proclairty, we have many ready views saves within ProClarity
    > library.
    > Now we have to convert the saved view into PDF for auditors as proof of
    > reports.
    >
    > Is there any way, we can automate Proclarity's view into PDF ?
    >
    > Thank you,
    > Kris.
    >
    >




  4. Re: Proclarity Automation Question


    Not very impressive tool, i will go with Cognos, if i have to choose. One of
    major issue with Proclarity is performance, as Proclarity submits query in
    Proclarity MDX format and doesnot use the prebuilt Aggregation, Very less
    help is available to automate some my requriments ..


    "Joe H" wrote:

    > Not related to your queston - but how happy are you with Proclarity and I'm
    > gussing Perf Point?
    >
    > We managed to get some stuff out the door but have a list of about 50 real
    > issues with the products. One of the most frustrating things is lack of
    > better conrol for the legends. Once they get too big - they just start
    > dropping rows. So when you allow drilldowns across other dimensions - it
    > creates a problem if there are more members than can display.
    >
    > "Kris" wrote in message
    > news:2FB7C8F5-A4DC-4DDE-B58E-0AE3E72ADECDatmicrosoftdotcom...
    > > Hi,
    > >
    > > I am using Proclarity 6.3 as Cube browser. We publish the cube to AS and
    > > Proclairty connects to AS and we can see all the available cubes to
    > > browse.
    > >
    > > Now in Proclairty, we have many ready views saves within ProClarity
    > > library.
    > > Now we have to convert the saved view into PDF for auditors as proof of
    > > reports.
    > >
    > > Is there any way, we can automate Proclarity's view into PDF ?
    > >
    > > Thank you,
    > > Kris.
    > >
    > >

    >
    >
    >


  5. Re: Proclarity Automation Question


    Thank you for reply, Yea there is Print option. But I am trying to automate
    the Job and convert the existing views within Briefing Book. Any help pls ..


    "fimianiatexologicdotcom" wrote:

    > Kris,
    >
    > I thought one of the print options in ProClarity has a "print all
    > slices" checkbox, so you may want to use that.
    > But that only resolves one set of slices for a given "report" and not
    > all possible cells of a cube, but you may not need that.
    >
    > Depending on robust you want to make it, you could just do some
    > SendKey calls from either a simple
    > VB app or Excel and have that provide the scripting.
    >
    > For a more robust approach, use ADOMD library in another VS.Net app to
    > pass various sets of MDX queries, and take that resultset and print
    > those. (you'd probaly just cut & paste the current MDX queries out of
    > the ProClarity books and use those).
    >
    > You could also use Office 12 and the Pivot Tables to get what you
    > want. Just iteratively populate the property that is populated for
    > the MDX queries (.Command something or other) and then hash each
    > report to a new sheet and loop through
    > each sheet and print.
    >
    > -exologic
    >
    > ::: Pain with Essbase? Use CubePort, The BI Porting App :::
    > ::: Go from Essbase to Microsoft Analysis Services :::
    > ::: web: exologic.com/products.htm :::
    >
    >


  6. Re: Proclarity Automation Question

    Have you used Performance Point? It's actually pretty cool - but it's like
    1.0 and has a long way to go. I haven't looked at Cognos as we are a M$
    shop.

    "Kris" wrote in message
    news:5234507C-2CDC-492F-8AD1-D9E7768647B4atmicrosoftdotcom...
    >
    > Not very impressive tool, i will go with Cognos, if i have to choose. One
    > of
    > major issue with Proclarity is performance, as Proclarity submits query in
    > Proclarity MDX format and doesnot use the prebuilt Aggregation, Very less
    > help is available to automate some my requriments ..
    >
    >
    > "Joe H" wrote:
    >
    >> Not related to your queston - but how happy are you with Proclarity and
    >> I'm
    >> gussing Perf Point?
    >>
    >> We managed to get some stuff out the door but have a list of about 50
    >> real
    >> issues with the products. One of the most frustrating things is lack of
    >> better conrol for the legends. Once they get too big - they just start
    >> dropping rows. So when you allow drilldowns across other dimensions - it
    >> creates a problem if there are more members than can display.
    >>
    >> "Kris" wrote in message
    >> news:2FB7C8F5-A4DC-4DDE-B58E-0AE3E72ADECDatmicrosoftdotcom...
    >> > Hi,
    >> >
    >> > I am using Proclarity 6.3 as Cube browser. We publish the cube to AS
    >> > and
    >> > Proclairty connects to AS and we can see all the available cubes to
    >> > browse.
    >> >
    >> > Now in Proclairty, we have many ready views saves within ProClarity
    >> > library.
    >> > Now we have to convert the saved view into PDF for auditors as proof of
    >> > reports.
    >> >
    >> > Is there any way, we can automate Proclarity's view into PDF ?
    >> >
    >> > Thank you,
    >> > Kris.
    >> >
    >> >

    >>
    >>
    >>




  7. Re: Proclarity Automation Question

    Hi,

    Open the book in proclarity professional. Then you print , but before you have to change to pdf printer. So you print to pdf file and with a code you send the file to anyone by mail.

    Adolph

    > On Monday, December 15, 2008 4:47 PM Kri wrote:


    > Hi,
    >
    > I am using Proclarity 6.3 as Cube browser. We publish the cube to AS and
    > Proclairty connects to AS and we can see all the available cubes to browse.
    >
    > Now in Proclairty, we have many ready views saves within ProClarity library.
    > Now we have to convert the saved view into PDF for auditors as proof of
    > reports.
    >
    > Is there any way, we can automate Proclarity???s view into PDF ?
    >
    > Thank you,
    > Kris.



    >> On Tuesday, December 16, 2008 1:46 PM Joe H wrote:


    >> Not related to your queston - but how happy are you with Proclarity and I'm
    >> gussing Perf Point?
    >>
    >> We managed to get some stuff out the door but have a list of about 50 real
    >> issues with the products. One of the most frustrating things is lack of
    >> better conrol for the legends. Once they get too big - they just start
    >> dropping rows. So when you allow drilldowns across other dimensions - it
    >> creates a problem if there are more members than can display.
    >>
    >> "Kris" wrote in message
    >> news:2FB7C8F5-A4DC-4DDE-B58E-0AE3E72ADECDatmicrosoftdotcom...



    >>> On Tuesday, December 16, 2008 2:32 PM Kri wrote:


    >>> Not very impressive tool, i will go with Cognos, if i have to choose. One of
    >>> major issue with Proclarity is performance, as Proclarity submits query in
    >>> Proclarity MDX format and doesnot use the prebuilt Aggregation, Very less
    >>> help is available to automate some my requriments ..
    >>>
    >>>
    >>> "Joe H" wrote:



    >>>> On Tuesday, December 16, 2008 2:34 PM Kri wrote:


    >>>> Thank you for reply, Yea there is Print option. But I am trying to automate
    >>>> the Job and convert the existing views within Briefing Book. Any help pls ..



    >>>>> On Tuesday, December 16, 2008 6:36 PM Joe H wrote:


    >>>>> Have you used Performance Point? it is actually pretty cool - but it is like
    >>>>> 1.0 and has a long way to go. I have not looked at Cognos as we are a M$
    >>>>> shop.



    >>>>>> On Wednesday, December 17, 2008 5:06 AM fimian wrote:


    >>>>>> Kris,
    >>>>>>
    >>>>>> I thought one of the print options in ProClarity has a "print all
    >>>>>> slices" checkbox, so you may want to use that.
    >>>>>> But that only resolves one set of slices for a given "report" and not
    >>>>>> all possible cells of a cube, but you may not need that.
    >>>>>>
    >>>>>> Depending on robust you want to make it, you could just do some
    >>>>>> SendKey calls from either a simple
    >>>>>> VB app or Excel and have that provide the scripting.
    >>>>>>
    >>>>>> For a more robust approach, use ADOMD library in another VS.Net app to
    >>>>>> pass various sets of MDX queries, and take that resultset and print
    >>>>>> those. (you'd probaly just cut & paste the current MDX queries out of
    >>>>>> the ProClarity books and use those).
    >>>>>>
    >>>>>> You could also use Office 12 and the Pivot Tables to get what you
    >>>>>> want. Just iteratively populate the property that is populated for
    >>>>>> the MDX queries (.Command something or other) and then hash each
    >>>>>> report to a new sheet and loop through
    >>>>>> each sheet and print.
    >>>>>>
    >>>>>> -exologic



    >>>>>> Submitted via EggHeadCafe
    >>>>>> Oracle Developer For Beginners
    >>>>>> http://www.eggheadcafe.com/training-...L-Samples.aspx


+ Reply to Thread