Extract Column/Row/POV properties of Webforms

 select b.object_name "Form Name", c.object_name "Dimension",  
 (CASE a.layout_type  
    WHEN 0 THEN 'POV'  
    WHEN 1 THEN 'Page'  
    WHEN 2 THEN 'Row'  
    WHEN 3 THEN 'Column'  
    ELSE 'Unknown'  
   END) "Layout",  
   (CASE a.STYLE  
    WHEN 0 THEN 'Start Expanded'  
    WHEN 2 THEN 'Member Name + Start Expanded'  
    WHEN 4 THEN 'Alias + Start Expanded'  
    WHEN 6 THEN 'Alias + Member Name + Start Expanded'  
    WHEN 8 THEN 'Member Name'  
    WHEN 10 THEN 'Member Name'  
    WHEN 12 THEN 'Alias'  
    WHEN 14 THEN 'Alias + Member Name'  
    WHEN 24 THEN 'Hide Dimension'  
    WHEN 32 THEN 'Member Name + Member Formula + Start Expanded'  
    WHEN 34 THEN 'Member Name + Member Formula + Start Expanded'  
    WHEN 36 THEN 'Alias + Member Formula + Start Expanded'  
    WHEN 38 THEN 'Alias + Member Name + Member Formula + Start Expanded'  
    WHEN 40 THEN 'Member Name + Member Formula'  
    WHEN 42 THEN 'Member Name + Member Formula'  
    WHEN 46 THEN 'Alias + Member Name + Member Formula'  
    WHEN 64 THEN 'Member Name + Show Consolidation + Start Expanded'  
    WHEN 66 THEN 'Member Name + Show Consolidation + Start Expanded'  
    WHEN 68 THEN 'Alias + Show Consolidation + Start Expanded'  
    WHEN 70 THEN 'Alias + Member Name + Show Consolidation + Start Expanded'  
    WHEN 72 THEN 'Member Name + Show Consolidation'  
    WHEN 74 THEN 'Member Name + Show Consolidation'  
    WHEN 76 THEN 'Alias + Show Consolidation'  
    WHEN 78 THEN 'Alias + Member Name + Show Consolidation'  
    WHEN 96 THEN 'Member Name + Member Formula + Show Consolidation + Start Expanded'  
    WHEN 100 THEN 'Alias + Member Formula + Show Consolidation + Start Expanded'  
    WHEN 102 THEN 'Alias + Member Name + Member Formula + Show Consolidation + Start Expanded'  
    WHEN 106 THEN 'Member Name + Member Formula + Show Consolidation'  
    WHEN 108 THEN 'Alias + Member Formula + Show Consolidation'  
    WHEN 110 THEN 'Member Name + Alias + Member Formula + Show Consolidation'  
    ELSE 'Unknown'  
   END) "Column/Row/POV Properties"  
 from  
 hsp_form_layout a,  
 hsp_object b,  
 hsp_object c  
 where  
 a.dim_id=c.object_id  
 and a.form_id=b.object_id order by 1;