it is quite a task to decode the grid options (FORM_OPT)




So we got that 2^17 = 131072. Now the math gets involved 😀
Since all the form_opts are a toggle (0/1), we now need to eliminate anything greater than 17 and anything after 17.
The math that needs to be performed is
(mod(FORM_OPT,power(2,n+1))-mod(f.form_opt,power(2,n)))/power(2,n)
Let’s look at the SQL for generating a list of read-only forms now.
select o.object_name form_name, f.form_opt ,CASE (mod(f.form_opt,power(2,18))-mod(f.form_opt,power(2,17)))/power(2,17) when 0 then 'write' when 1 then 'read-only' end "Form ReadWrite Property" from hsp_form f left outer join hsp_object o on (f.form_id=o.object_id) where o.object_name like 'Actual vs Plan%';
You can run this for entire Planning application and find out which forms are read only
Let’s look “Operating Expenses – Forecast” form,
Now let’s find out which forms are hidden in the system.
FolDifference is 8388608 and exponent is 23
select o.object_name form_name, CASE (mod(f.form_opt,power(2,24))-mod(f.form_opt,power(2,23)))/power(2,23) when 0 then 'Visible' when 1 then 'Hidden' end "Form Hidden/Visible" from hsp_form f left outer join hsp_object o on (f.form_id=o.object_id) where o.object_name like 'Operating Expenses - Forecast%';
Let’s run the SQL and find out
Now let’s run it for all the forms
If you look at the SQL and the forms under Forecast folder (Vision application) you’ll see that the SQL results tie with the screen shot below.
Now that solves the decoding issue of FORM_OPT (now how that big of a number is generated is going to be a different blog post)
Thanks Celvin,
I need this to test the form if the form is open or not, and then only process the file via FDMEE form name and file name are same.
You saved at least a day of mine.
Thanks,
Shivendra
This is very nice information and excellent research work. The next step would be to find out what function has which number (the Exponent number). Then a user interface to check them on an off….
Maybe something to split up in a larger group as community work.
P.S. Attention Oracle, this is only possible on-premise !!!
That’s a great idea. We already know 2
Pingback: Essbase Down Under
Hi Celvin,
Hope you already know that many of your web pages are losing their formatting e.g. Groovy in PBCS and On-Premises Hyperion Planning – Part I, they are not displayed correctly.
Many thanks for putting up great stuff though.
Sandy, what’s wrong with that one? I tried to fix all formatting issues and I’m not aware of any. If you can please let me know what’s missing in that one, I’ll fix it right away. Thanks