Curso Avançado:
CorVu Administration
Duração: 2
dias
Objetivo: O usuário
será habilitado a criar fórmulas
usando as funções avançadas
do CorVu, manipular e criar gráficos
avançados, e organizar melhor os
aplicativos desenvolvidos em CorVu, de modo
a obter maior produtividade e agilidade
no uso da ferramenta.
Pré-requisitos: Ter
experiência com a ferramenta CorVu
ou ter completado o Curso Básico/Introdutório
(CorVu Introduction) e o Report Writer Course,
ter conhecimento prévio das funções
básicas do Windows e de bancos de
dados relacionais.
Currículo:
Chapter 1:
Specialty Graphing Functions Compare Values,
Graphing Percentages,
Creating Combination Graphs,
Graphing Subgroups,
Dual Axis Graphs, Time Trend Charts,
Parent-Child Graphs.
Chapter 2:
Writing Your Own Formulas CorVu Formula
Language, Truncating,
If-Then-Else Logic,
Referencing Other Rows Creating Running
Totals,
Using Logical Operators (AND and OR), Using
Substrings.
Chapter 3:
Advanced Report Features Working with Sections,
Complex Conditions,
Filtering,
Specialty Formatting,
Adding New Lines,
Wrapping Text in Columns.
Chapter 4:
Complex Query Conditions & Filters Complex
Query Conditions, Complex Compound Filters,
Freestyle Compound Filters.
Chapter 5:
Using Date Functions and Conditional Crosstabs
Using the now() function,
Conditional Crosstabs.
Chapter 6:
Other Functions and Prompts Working with
nulls,
Using the Calendar Wizard,
Populating a Column with Extra Prompts.
Chapter 7:
Controlling Ranking Adding a Unique Column,
Adding a Ranking Column,
Using Set Summarization Level Prompting
for a Filter, Developing Top N and Bottom
N reports.
Chapter 8:
Determining Percent of Total Using the sum
function in a dynamart,
Calculating One Row as a Percent of the
Total,
Creating Share Reports.
Chapter 9:
Editing SQL in Queries Forcing Sort Order
with SQL,
Using SQL to Display Multiples of a Column,
Using Subqueries.
Chapter 10:
Appending Dynamarts Creating Appended Queries,
Building Historic Data.
Chapter 11
Outer Joins Types of Joins,
One-Way Outer Joins,
Full Outer Joins,
Merging for True Full Outer Joins
Appendices:
Calendar Files,
Formulas and Functions
WEB DEPLOYMENT
Chapter 1: Web Deployment - Introduction
Chapter 2: Setting up the Environment
Chapter 3: Developing a Web Page Template
Chapter 4: Generating the Web Pages
Appendices
|
 |
