Network Reporting FAQs
Review the following frequently asked questions (FAQs) for Network Reporting.
General
What is Network Reporting in Veeva Network MDM?
It's a feature that allows users to create and run reports on the data within Veeva Network MDM.
What is the difference between a Basic Report and an Aggregate Report?
A Basic Report generates a flat list of individual records (e.g., HCPs by state). An Aggregate Report groups data to perform calculations like counts, sums, or averages (e.g., total HCOs per city) for trend analysis and metrics.
Are there pre-built reports available to help me get started?
Yes. Network MDM provides Network MDM Samples, which are pre-configured report templates covering common use cases like data coverage, quality, and stewardship activity. You can run these samples immediately or use Save As to create a customizable copy.
Basic reports
What are the basic types of reports I can build?
Basic reports that display detailed records based on selected criteria.
What kind of criteria can I use to filter data in a basic report?
You can filter by object type, fields, and specific values.
Can I customize the columns displayed in a basic report?
Yes, you can select which fields to include as columns in your report.
Aggregate reports
What are aggregate reports used for?
To summarize data by grouping records and performing calculations like counts, sums, and averages.
How do I create an aggregate report?
Similar to basic reports, start by creating a new report and then configure grouping and aggregation functions.
What is grouping in an aggregate report?
Grouping allows you to categorize records based on the values of specific fields before applying aggregate functions.
What functions can I use in aggregate reports?
Functions like COUNT, SUM, AVG, MIN, and MAX.
Advanced SQL reporting
Can I use SQL to create custom reports in Network MDM?
Yes. The SQL Query Editor allows advanced users to write custom queries using standard syntax. This is useful for joining multiple objects, applying complex filters, or querying lookup tables unavailable in the basic report builder.
Where can I write and execute SQL queries for reports?
In the SQL Report Builder within the Network Reporting section.
What knowledge is required to build SQL reports?
Familiarity with SQL query syntax and the Network MDM data model.
Are there any limitations to using SQL queries for reports?
The SQL Reference in the help details specific limitations or considerations.
Security and permissions
How does data security affect report results?
Reporting in Network MDM is data-permission aware. This means users can only see records and fields in their report results that they are authorized to see based on their assigned Data Visibility Profiles (DVPs). If a user doesn't have access to a specific country or object, those records will be excluded from their report output.