Top FAQs for Data Model Editor (Pixel-Perfect Reports)

The top FAQs for creating and managing data models for pixel-perfect reports are identified in this topic.

How do I check if the data model generates data correctly?

Open the data model, click Data, and then click View to view a maximum of 200 rows of data. If you want to view the complete data, create a report, and then view the report online or schedule the report.

How do I chunk XML data for processing large datasets?

For processing large datasets, enable XML data chunking at the instance level or at the data model level.

What's the SQL query size limit for bursting?

The output of an SQL query is limited to 200,000 rows.

How do I optimize the SQL queries?

Use the Skip Unused Dataset Query, Optimize Query Execution, and Multithread Query Execution data model properties to optimize SQL queries.