Extract Column/Row/POV properties of Webforms


This is a follow up blog on the question that was posted on network54 (and partially answers OP’s question)

Here is how it is

 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;

I tried to look at the Grid properties and it is quite a task to decode the grid options. 😉 (it is getting stored in FORM_OPT column in HSP_FORM and is a 12 digit number)

Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase.

Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I’m an Independent Consultant with “Intekgrate Corporation” based out of Aurora office.

I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader.

I was awarded Oracle ACE Director for my contributions towards EPM community.

Leave a Reply