Query Studio :
is a very user–friendly adhoc query tool that allows users to easily access information. With Query Studio, the user drags and drops fields to execute queries, and with multiple available options at a touch of the mouse, it can group data, create summaries, display charts, filter information and export data. An Author who has access to Querv Studio is referred to as a Business Author.
Metrics Studio :
is a powerful scorecard tool that allows for the creation and monitoring of goals through an organization. An Author who has access to Metrics Studio is a Business Manager.
Analysis Studio :
is the user-friendly tool used to quickly analyze summarized information with powerful dimension and variable crossing for complex analysis, discovery of trends and forecasting. An Author who has access to Analysis Studio is a Business Analyst.
Report Studio :
is the professional report-authoring tool. The tool allows for the development of pixel-perfect reports, such as invoices and statements, as well as very complex layouts, such as those required for enterprise dashboards. An Author who has access to Report Studio is a Professional Author.
Cascading prompts :
Cascading Prompts allows a user to use values selected from one prompt to filter values in another prompt.
Difference between view and materialized view
Views contains query whenever execute views it has read from base table Where as M views loading or replicated takes place only once which gives you better query performance
No comments:
Post a Comment