Generic DataSource for Hierarchy

Hi All,

I need to create a generic datasource for Hierarchy using Extraction from Table .Before starting the development, I would like to know what are the steps do I need to consider for creating a hierarchy strucuture. Base table will contain only 2 fields (Product hierarchy and Group).

Strucuture of the hierarchh should be same like 0PROD_HIER_TEXT.

Kindly let me know if anyone has done this before.

Thanks for your time.

Thanks & Regards,

Raja