Proclarity Automation Question

[Kris]

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.

[f***@exologic.com]

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 :::

[Kris]

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 ..

Post by f***@exologic.com
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

[Joe H]

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.

Post by Kris
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.

[Kris]

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 ..

Post by Joe H
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.

Post by Kris
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.

[Joe H]

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.

Post by Kris
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 ..

Post by Joe H
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.

Post by Kris
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.

[Ivan Saavedra]

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

Post by Kris
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.

Post by Joe H
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.

Post by Kris
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 ..

Post by Kris
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 ..

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.

Post by f***@exologic.com
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-topic-area/Oracle-SQL-Developer/2/Oracle-SQL-Samples.aspx