Pixel Perfect Reports - repeating section issue

Q&A
, ,
1

Hi all,

I’m currently working on generating a pixel perfect report (PPR) and I’m trying to leverage the repeating section functionality.

The section I have created has a handful of tables and pivot tables, with no charts. The repeating section is based on a dimension which is a region, and there are 10 regions in total which the report should generate.

When bulding the section in the UI, the visuals display all of the relevant information with no issues, but when I attempt to generate the report I get an error message telling me “We can’t create your PDF right now. Please wait a few minutes and try again”.

Does anyone have any thoughts on why I’m seeing this?

The dataset is a direct query (to Athena) and has not been loaded into SPICE. Could this be the issue, where the report is timing out when trying to retrieve the data?

Any help here would be appreciated.

Q

2

Hi @QSCommUser

Is your dataset using direct query mode?

PDF generation errors in Pixel Perfect Reports (PPR) with repeating sections often stem from direct query mode timeouts from the source.

Change the dataset to SPICE import mode in the dataset editor, this caches the data for all 10 regions upfront and eliminates query timeouts during PDF generation. Also review tables and pivot tables for complex calculations or large row counts per region, and reduce aggregations or add filters to keep each section lightweight.

3

Hi @Xclipse

Yes - as mentioned above, my data is a direct query.

I will try loading the data to SPICE and see if I have the same issues.

As for the filtering, there in each table there is only about 20 rows of data, with 3-4 columns (all pre-aggregated) - so I wouldnt say there is a great deal of data needing to be loaded for each graphic.

Thanks.