Steps to create PowerPlay reports from Impromptu reports.

[cogjai]

Hi
I am pretty new to Transformer and Powerplay. I need some information regarding these! What are all the different approaches to convert impromptu reports into powerplay reports. We have created few hundred impromptu reports which are getting data from views on Oracle 9i DB. Now we need to convert these impromptu reports into powerplay reports. I have few questions regarding this.
1. What are all the different approaches to do this?
2. What are the steps involved in these approaches?
3. What are the advantages and disadvantages in these approaches?

thanks in advance

 

[sln007]

cogjai,
This is a loaded question and has many aspects.
Remember that a "CUBE" is more effective as an analytical
tool for viewing a more basic and summarized view of your
data for analysis. You then, "drill-thru" into more
detailed Impromptu reports.
Many of your Impromptu reports may be able to 'convert' into
a cube but there are alot of formatting, grouping, conditions, etc. that you can do for an Impromptu report
that will not work well for a cube.
In general we look at it this way:
CUBEs are for general -to- multi viewed summarized analysis
that can be twisted & turned
REPORTs are for a fairly specific view of information
with little or no alternative angles to view the data.