#happy2022workday day-041
Happy 2022 day-041! Today’s update…
My 2nd favorite confusing reporting topic is the “Optimized for Performance [x]” checkbox (OfPc). This somewhat recent “feature” might be your first clicks when creating a new custom report. Meaning, most of us click on it to *uncheck* the box (checked on by default.) Later, on the Advanced tab, you can consider checking the OfPc. But, once you know what it means, you might simply leave it unchecked.
Hint: Checking the OfPc does not make the report run faster. Try it. On a working report, run it both ways. No difference in the timing. But, if your report is running slowly and you don’t know why, maybe you cannot check the OfPc. This post is meant to help you learn why that’s the case.
In yesterday’s Sharing Café I asked if anybody knew exactly what the OfPc means. I’m expecting all my LinkedIn readers to have the same not-surprising incorrect answers.
Probably under 1% of all #Workday report writers in the world know what the OfPc means (counting a few dozen from yesterday’s Sharing Café, and now add those who are reading this entire #happy2022workday post, hooray, we are up to 1.1% of us.)
See pic for some hints. Guess with a comment (I will follow up with you directly upon request):
1-4) Four pics of the initial screen.
- The yellow highlighted RED “1” shows the hover-help on the Data Source field.
- The RED “2” shows the hover-help on the OfPc itself (matching the text just below it.)
- Uncheck and this text appears:
—
Alert: Clearing this check box enables you to select a non-indexed data source and non-indexed fields, which might cause your report to run slower.
—
If only a few words were added to the above, the answer would be clear. But, what’s the fun in that? - You could opt to uncheck the OfPc even after selecting one of the Indexed Data Sources such as “Workers for HCM Reporting”.
- Next screen shows a reminder that the Data Source you chose is Indexed.
- On the Filter tab, search for “full name”
- Click the twinkie (3-dots) on the “Full Name” field
- Expand the “Indexing Information” on the pop-up
- Notice you can click on the blue “4”, because it’s blue
- Four Data Sources are listed, including the one you chose for this report
- More hints: The [T] icon on the “Full Name” field in the Columns tab is not “golden” (it’s blue), but…
- On the Filter tab, the same field is indeed golden. It is indeed the same field, I promise, because I selected it via my tied-for-2nd-place favorite feature, the “Fields on Report” option.
- Going back to (4) to check the box, via the Advanced tab, we now search again for the word “name” and…
- There are only “(8)” fields to choose from, all golden in color.
- Our golden “Full Name” field is available, but this time much fewer other fields to choose from than in the pic (6) and also this time it appears as golden.
CHALLENGE: Did you figure it out? What does OfPc actually do?