This content has been marked as final. Show 3 replies
Use Index col() functionality
Im not sure but I think it is not possible with indexcol function. It works with level based security to select appropriate column for a report.
What I need is to show a brunch of tree according to a session variable.
Have you ever tried to build a parent-child hierarch using indexcol function? If so, Ill appriciate if you provide a simple sample. thanks ...
According to searches I made in support.oracle and google, it seems that it is not possible to view just a branch of a parent-child tree. Because the closure table is static. Therefore, you can not change the distances of objects dynamically.
This parent-child ability is very frustrating for me. As I understand, parent-child dimension ability can only be used in read-only sources. Any filtering or dynamic changes does not seem possible in this structure. Any changes on parent-child table requires parent-child relation table to be rebuilt.
I couldnt find any functionality of indexcol or choose functions in parent-child dimensions. I think they can only be used in level based dimensions.
Any comments appriciated..