Page History

Ability to analyse user needs

The view administrator must have the skills to conduct user needs analyses to create categories and fields that are relevant to the user vocabulary, and to develop views that meet the needs of the user community.

Database knowledge

A View administrator needs to have a good working knowledge of the company’s database management system (DBMS), how the databases are deployed, the logical database structure, and the type of data stored in company databases.

Structured Query Language (SQL)

A working knowledge of SQL is necessary.

Dimension fields retrieve the data that will provide the basis for analysis in a report. Dimensions typically retrieve character-type data (employee names, company names, etc.), or dates (years, quarters, etc.)

Metric fields retrieve numeric data that is the result of calculations on data in the database. Metrics tend to be dynamic: the values they return depend on the dimensions they are used with. For example, if you include Person and Age in a query, Age per person is calculated.

View Geography Fields are fields linked to a GeoPack.

Pre-Defined Filters are fields where a set of conditions have been set up when the view was created. This assists users to limit the data returned in a query to only the expected results. For example if the filter is called ‘United States’ then only data from the united states would be included in the results.

Parameters are fields which are used to capture user defined values and pass them into calculated fields or filters. These parameters can assist in conducting what if analysis.

View Filter Groups are sets fields to be used as filters, reused multiple times. Filter Groups can contain filter dependency hierarchies, as well as cached values. These only have to be set up once, rather than for each report.