I have this case in teradata, where in the certain set of child members (which are eventually parent members later) should be eliminated (along with their level 0 members ) and rest of the members alone should be fetched.
and so on.
If i omit the member '100' all the members under that should also be eliminated.
is recursive function helpful to solve this ? Please help.
Please provide the DDL and DML
Also please help me understanding your issue. So if you omit 100 then your output would be:
It would be nice if you provide your input and the desired output.