We switched to the Custom Segments introduced by NetSuite from a couple of custom fields to keep track of what Industries are customers are in.  For example one Parent Industry is Aerospace and the subsegments under Aerospace we have the following:
ID     Value                                          Parent
  2    Aerospace               
10    Air Cargo                                     Aerospace          
11    Aircraft Manufacturers                  Aerospace          
12    Aircraft Repair and Maintenance    Aerospace          
13    Space                                         Aerospace          
14    Airlines                                        Aerospace
If I run a saved search I can set in the Criteria to either the “Parent” or the “Value” field which is shown as “Name”.  So if I want to run a search for those customers who are in the Aerospace industry I would just set the criteria for Parent = “Aerospace”.
However, in using the Report Builder or using Suite Analytics via ODBC you can not access the “Parent” field just the “Name” field.  This is a major drawback to using Custom Segments and I can’t understand why NetSuite does not give us access to the “Parent” field in either the Report Builder nor via ODBC.
Pete
This is a cached copy. Click here to see the original post.