Best Practices for Smart View

The users’ experience of Smart View is the result of performance on the application server, web server, LAN, and ultimately the Smart View client. Best results are obtained when you monitor performance across the system to identify the bottlenecks and address them first. Performance issues are most commonly associated with large workbooks that have many links to the database called HS.GetValue statements. Look at Figure 4-8 as an example of what these statements look like. Ad-hoc queries are much more efficient than functions, so you should use those when performance is an issue. But sometimes the functions are preferred, for a number of reasons. For example, they are much more familiar to former users of Hyperion ...

Get Oracle Hyperion Financial Management Tips And Techniques now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.