Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Option In Data Form To Set Ancestor Position

Description
I have requirement to set Parent member in top and child member should come after that in data forms. I can do the same in smart view ad-hoc in Option->General->"Ancestor Position" and selecting the option Top/Bottom as per need. The same option is not available in Data Forms.
In the form definition, when I give parent name first and then use @DESCENDANTS(Parent) or @CHILDREN(Parent), instead of @IDESCENDANTS(Parent). then also I can not see parent member first and then child. It always show parent in bottom.
I have attached the screen shot for the reference. In that the highlighted member should come first then it's child should appear.
Use Case and Business Need
The business want to see the data form in Top down hierarchy which show parent member should come first then it's child.
Original Idea Number: bcf9adb775
Comments
-
Will be helpful idea.
1 -
This is actually available… I know this comment has been out here for a while. I'm not sure if this functionality has always been available because I haven't had the use case before, but in the row you're trying to present with the Ancestor on top, you can enter "Gross Sales,Children(Gross Sales)", using Gross Sales shown above as an example. This presents the Parent first, and allows for expansion of the Children (or starts expanded if you have that setting checked). The Descendants formula will work also, but may cause issues if there's Children that are also Parents.
0 -
@Jeff Rich-Terillium it is not dynamic,and only works for one level.
If the client wants to see a hierarchy expanded with the parents at the top, there is no solution
0