obiee - Hierarchy level based on Flag - Stack Overflow

admin管理员组

文章数量:1331091

In OBIEE Hierarchical development, we have a specific requirement where we need to implement a hierarchy based on a single dimension table. The hierarchy levels are defined as follows: account_group_name --> sub_account_group_name --> account_code. We also have a drill_down_flag column, which holds values 'Y' or 'N'. The hierarchy should only drill down to the next level if the drill_down_flag is 'Y'; otherwise, it should not drill down. How can this scenario be implemented in RPD development?

Nothing worked i tried so many

In OBIEE Hierarchical development, we have a specific requirement where we need to implement a hierarchy based on a single dimension table. The hierarchy levels are defined as follows: account_group_name --> sub_account_group_name --> account_code. We also have a drill_down_flag column, which holds values 'Y' or 'N'. The hierarchy should only drill down to the next level if the drill_down_flag is 'Y'; otherwise, it should not drill down. How can this scenario be implemented in RPD development?

Nothing worked i tried so many

• obiee

Share Follow edited Nov 28, 2024 at 10:51 DarkBee 15.6k88 gold badges7272 silver badges117117 bronze badges asked Nov 28, 2024 at 10:51 Mohamed ismail AbdullahMohamed ismail Abdullah 1 2

• 1 "Nothing worked i tried so many" - Please edit your question to include a minimal reproducible example so that readers can run your code to answer your question. – DarkBee Commented Nov 28, 2024 at 10:52
• 1 Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. – melvio Commented Nov 29, 2024 at 8:42

Add a comment  | 

1 Answer 1

Sorted by: Reset to default -1

As mentioned by DarkBee and melvio, the question is very vague and needs clearer specification.

That said, what you are talking about is either a so-called ragged hierarchy or an unbalanced one, or both. It's impossible to say from the description provided. If a hierarchy has no children the drilldown will not be rendered by default. If you do have children the drill-down will be rendered. Having children but stopping the drilldown is non-sensical with regards to how hierarchies work.

本文标签： obieeHierarchy level based on FlagStack Overflow