OBIEE Visual Analyzer不识别父子层级及与Analysis工具差异的技术咨询

Hey Andy, let's tackle your questions about OBIEE Visual Analyzer and hierarchies:

Yes, Visual Analyzer (VA) does support Parent Child Hierarchies, but there are specific configuration requirements that might be causing your issue. From my hands-on experience working with OBIEE:

• First, confirm your Parent Child Hierarchy is marked as "Enabled for Hierarchical Navigation" in the RPD's Business Model and Mapping layer. This setting is critical for VA to recognize and interact with the hierarchy.
• Double-check that the hierarchy’s parent-child relationship is correctly defined in the RPD, with valid key mappings and join conditions between the parent and child columns.
• Ensure the hierarchy is properly exposed in the Presentation layer subject area you’re using in VA—sometimes hierarchies get overlooked when publishing to the presentation layer, which prevents VA from picking them up.
• Also, note that older OBIEE versions (pre-12c) had limited support for Parent Child Hierarchies in VA. If you’re running an outdated release, upgrading to a newer 12c or 19c version might resolve the compatibility issue.

While they share some surface-level similarities, these tools are built for distinct user personas and use cases:

• Target Audience:
  • Visual Analyzer: Designed for business users who want self-service, no-fuss data exploration. It’s optimized for quick, intuitive drag-and-drop interactions, with a focus on visualizations that help users spot trends without needing deep BI technical skills.
  • Analysis/Interactive Reporting: Catered to power users and BI developers who need granular control over report creation. It’s ideal for building complex, production-ready reports that require precise calculations, custom logic, and standardized formatting.
• Core Capabilities:
  • VA prioritizes speed and simplicity—you can build charts, dashboards, and basic analyses in minutes, but it lacks advanced features like custom SQL overrides, dynamic parameterized prompts, or full support for all hierarchy types (as you encountered with Parent Child Hierarchies in older versions).
  • The Analysis tool offers robust control: you can define custom groups, set up detailed drilling behaviors, create calculated measures with advanced functions, and integrate with other OBIEE components like Agents or Scorecards. It’s also better suited for handling large, complex datasets with multiple filters and joins.
• Workflow Approach:
  • VA uses a visual-first workflow: you select data elements first, then VA suggests or lets you choose the best visualization to represent the data. It’s all about exploring data visually to uncover insights quickly.
  • The Analysis tool follows a structured, data-first workflow: you start by defining your dataset (columns, filters, calculations), then arrange the layout, and finally add visualizations. This makes it perfect for creating standardized reports that need to be shared and reused across teams.

内容的提问来源于stack exchange，提问作者Andy S