Transcript Brio 6 to Hyperion 8.3

Brio 6 to Hyperion 8.3
USDA – Forest Service
Experience
Brio 6.6
•
•
•
•
Started in 2000
Grew slowly till 2004
Very little financial data online
User community grew from a few to a few
hundred
Brio 6 Queries
• Initially simple
– Results and 1 or 2 pivots
– Variable limits
• Build your own query
– Query section with meta data model
– Results section and maybe a pivot
• Eventually more complex queries
– Sub-queries and preformatted reports.
Build Your Own Query
• Query section with meta data model
• Do not save results. Set in startup
–
–
–
–
var SecCount = ActiveDocument.Sections.Count
for (j = 1; j <= SecCount ; j++)
{ if (ActiveDocument.Sections[j].Type == bqQuery)
ActiveDocument.Sections[j].SaveResults = true }
• Auto logon-users can save query to PC.
–
–
–
name = "fs_public"
ActiveDocument.ODSUsername= name
ActiveDocument.SetODSPassword(name)
• Auto process of queries
Hyperion Intelligence 8
•
•
•
•
•
New financial data warehouse coming
Number of users to multiply
Number of queries to multiply
Need to use SQR
Need to publish other than .bqy
Installation
• First install on test server (8.2.1)
– Repository in Oracle
– Oracle user id HISERVER
• Test queries and administration
• IRM setup Tomcat 4
– Tomcat 5 had errors
• Thin-client queries did double process
• Tried services set to auto
Installation of 8.3
• Production server
– W2K, IIS
• Install SQR first
• Standard 8.3 install including JRun
• Problems
– Oracle userid HISERVER same as test
• Need to completely clean out old tables
– JRUN default parameters too small.
– Still can’t set services to auto
Posting Queries
• All users logon as one user id.
–
http://sv68wo.wo.fs.fed.us:8100/Hyperion/browse/Main?user=fs_public&pass=fs_public
• Turn off personal pages
– Hyperion has special version of launchApp.jsp
• Hyperion fixed thin-client process
– Process queries in startup script
• Some build-your-own queries but
– User has to logon to run in plug-in
Lessons so far
• Don’t do standard install
• Separate Foundation, Java server and
Oracle
• Plan your folder structure
• Publish end-user documentation
• Don’t be afraid. It’s not difficult.
Our Look
User Instructions