Monday, December 1, 2014

Discoverer - Viewer , Plus and Desktop differences

These differences are for 10g versions, but they are pretty handy for making a general decision about the product type to use.
Reference: http://proudman.homestead.com

FunctionDesktopPlusViewer
Create / Edit QueryYesYesNo
View Query With Dynamic DataYesYesYes
BI Beans Based ChartingNoYesYes
Export To Microsoft ExcelYesYesYes
Integrated With Oracle Single Sign-OnNoYesYes
Create Worksheet ParametersYesYesNo
Apply Parameters To WorksheetYesYesYes
Create / Edit ConditionsYesYesNo
Create / Edit CalculationsYesYesNo
Save The WorkbookYesYesYes
Schedule WorkbooksYesYesNo
Export To XML?YesYes
Export To PDFNoYesYes
Drill To LinkYesYesYes
Cascading ParametersYesYesYes
OLAP SupportNoYesYes
Command Line InterfaceYesNoNo
Text AreaNoYesYes
Graphs created in DesktopYesNoNo
EmailYesNoYes
Drilling to external programYesNoNo
Hyperdrill to URLNoYesDisplay
Cascading ParametersDisplayYesDisplay
Optional ParametersDisplayYesDisplay
Conditional Formatting - (exceptions in Desktop)YesYesYes
Stoplight FormattingDisplayYesDisplay
Editing Stoplight colorsNoYesNo
Edit worksheet dialogMandatoryOptionalNo
Interactive PivotingNoYesYes
Save to File systemYesNoNo
Able to pick workbooks by userDisplayYesDisplay
Scheduling workbooksYesYesNo
Sharing workbooksYesYesNo
Sharing results of scheduled workbooksNoYesNo
Discoverer ConnectionsNoYesYes
Corporate logoNoYesYes
Workbook logoYesNoNo
Customized screenNoNoYes(1)1 - performed via Admin interface in OEM
Customized look and feelNoYes(2)No2 - Plus with Sun Java - 1 of 4 types (Browser, Oracle, Plastic and System). Plus with Jinitiator - Plastic defaults to Browser
Bitmaps in titleYesNoNo
Resize column headings by sliding column separatorYesYesNo
Create new worksheet by dragging out of current workbookYesNoNo
Rename worksheetsYesYesNo
Interaction with SSONoYesYes
Interaction with PortalNo(3)No(3)Yes3 - workbooks created in Plus and Desktop can be made to display in Portal
Preferences stored in registryYesNoNo
Preferences stored centrallyNoYesYes
Choose EUL on log inNo(4)YesYes4 - set internally and must reconnect after changing
Analytic function templatesNoYesNo
Graph templates - only in PlusNoYesNo
Count of all rowsYesNoNo
Uncouple Discoverer from database while creating worksheetsNoYesNo
Ability to create parameters that use indexes and valuesNoYesNo(6)6 - cannot create in Viewer but can use if created in Plus
3D heading gridlinesNoYesNo(6)
InterfaceClientJavaHTML
Change PasswordNoYesYes
Able to open multiple workbooks at same timeYesNoNo
Able to copy worksheets between workbooksYesNoNo
Discoverer TimeoutNoYesNo
Assiging user defined helpNoNoYes(7)7 - only but done via OEM
Automatically execute a worksheetNoNoYes(8)8 - performed by passing in URL
Ability to schedule and export in one step - only in Desktop using command line interface and a third-party schedulerYes(9)NoNo9 - using command line interface and third-party scheduler
Export to Excel iQuery - only available in ViewerNoNoYes
Export Crosstab to Excel pivot tableNoYesYes
Subqueries - can only be created in Desktop but will work in Plus and ViewerYesNo(10)No(10)10 - subqueries created in Desktop will work in Plus or Viewer
Calendar style date pickerNoYesNo

No comments :

Post a Comment