Oracle Analytics Cloud and Server Idea Lab

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Enhanced Table/Pivot Alignment and Canvas Title Positioning in DV

18
Views
1
Comments

Executive Summary

This proposal outlines key user experience improvements for Oracle Analytics Cloud (OAC) Data Visualization's table, pivot, and canvas components to provide greater formatting flexibility and visual customization options within the DV workbook environment.

Current Limitations

Table/Pivot Alignment Issues in DV Workbooks

  • Table Visualizations: Limited alignment options for column headers and cell values in DV table charts.
  • Pivot Visualizations: Lack of comprehensive alignment controls for headers and data cells in DV pivot tables.
  • Inconsistent Formatting: No unified approach to text alignment across different visualization types within DV workbooks.

Canvas Layout Constraints in DV

  • Canvas Title Positioning: DV canvas titles are fixed to left alignment with no customization options in the Properties panel.
  • Limited Visual Hierarchy: Inability to create centered or right-aligned titles affects overall workbook presentation and dashboard aesthetics.

Pivot Visualization Movement Restrictions in DV

  • Directional Limitations: Pivot visualizations in DV can only be repositioned horizontally within the canvas.
  • Layout Flexibility: Vertical positioning constraints limit workbook design possibilities and optimal space utilization.

Proposed Enhancements

  1. Header Alignment Options in DV Properties PanelData Cell Alignment Options in DV VisualizationsImplementation Approach in DV Interface
    • Left alignment (default)
    • Center alignment
    • Right alignment
    • Justify alignment (where applicable)
    • Left alignment for text content
    • Center alignment for balanced presentation
    • Right alignment for numerical data
    • Custom alignment per column type
    • Add alignment dropdown in the Table/Pivot Properties panel under "General" or new "Alignment" section.
    • Provide column-specific alignment overrides in the Data panel.
    • Include bulk alignment options for multiple columns via right-click context menu.
  2. Title Alignment Options in DV Canvas PropertiesAdditional DV Title Enhancements
    • Left aligned (current default)
    • Center aligned for balanced workbook headers
    • Right aligned for specialized corporate layouts
    • Custom positioning with pixel-level control
    • Font size and weight customization in Canvas Properties.
    • Color and styling options consistent with DV theme capabilities.
    • Multi-line title support with individual line alignment.
  3. Bidirectional Movement in DV Canvas
    • Horizontal movement (current capability)
    • Vertical movement for improved workbook layout flexibility
    • Grid-snap functionality for precise positioning similar to other DV visualizations

DV Layout Benefits

  • Better space utilization in workbook design.
  • Improved visual flow and hierarchy across canvas pages.
  • Enhanced responsiveness across different screen sizes and presentation modes.

Business Value Proposition

User Experience Benefits in DV

  • Improved Readability: Proper alignment enhances data comprehension in DV workbooks.
  • Professional Presentation: Customizable formatting creates polished, enterprise-ready visualizations.
  • Design Flexibility: Greater control over visual layout and hierarchy within DV canvas environment.

Productivity Gains for DV Users

  • Reduced Manual Formatting: Built-in alignment options save time during workbook creation.
  • Consistent Branding: Standardized formatting across DV projects and organizational templates.
  • Faster Workbook Development: Enhanced positioning tools speed up DV visualization design process.

Competitive Advantage in BI Market

  • Feature Parity: Matches capabilities offered by leading BI platforms like Tableau and Power BI.
  • OAC User Retention: Improved user satisfaction through better DV customization capabilities.
  • Market Position: Strengthens Oracle's analytics offering in the self-service BI space.

Implementation Priority

High Priority (Phase 1)

  • DV Table/Pivot visualization header and cell alignment controls in Properties panel.
  • DV Canvas title positioning options with alignment dropdown.

Medium Priority (Phase 2)

  • Enhanced DV pivot visualization movement capabilities (vertical positioning).
  • Advanced DV formatting options and column-specific alignment controls.

Future Considerations for DV Platform

  • DV template-based alignment presets for organizational standards.
  • Role-based formatting permissions within DV projects.
  • REST API access for programmatic DV formatting and positioning.

Success Metrics

User Adoption in DV Environment

  • Percentage of DV users utilizing new alignment features in workbooks.
  • Reduction in OAC support tickets related to DV formatting limitations.
  • User satisfaction scores for DV workbook creation and presentation experience.

Technical Performance in OAC DV

  • No impact on existing DV workbook load times or canvas rendering.
  • Seamless backward compatibility with existing DV projects and visualizations.
  • Stable performance across different browsers and OAC deployment environments.

Conclusion

These enhancements address fundamental user interface limitations that currently restrict the professional presentation and design flexibility of OAC Data Visualization workbooks. By implementing comprehensive alignment controls and improved positioning capabilities within the DV environment, Oracle can significantly enhance user satisfaction while maintaining competitive positioning in the self-service business intelligence market.

The proposed features align with modern BI platform expectations and will contribute to improved OAC DV adoption and user retention rates, particularly among business users who require flexible formatting options for executive presentations and departmental reporting.

3
3 votes

Submitted · Last Updated

Comments

  • Hi Ajinkya! Your idea is well structured and excellent. We thank you for how much details you put in it. To better serve you and the community, I would request you to have one request for one idea. Currently your idea is a bundle of 3 or more requests and the community is not able to vote independently on each one. Thank you in advance!