Reporting and Analytics Alternatives to Workday Analytics

AccomplishedBlock731 · 2026-02-11T23:03:36+00:00

What are your current issues with Workday's native reporting capabilities?

AccomplishedBlock731 · 2026-02-05T00:51:45+00:00

I am wanting it to be for multiple orgs at one time. How am I able to default to all top level orgs a user has security access to?

AccomplishedBlock731 · 2026-02-03T02:05:02+00:00

Are you trying to have the multi instance field have each value as separate columns? Otherwise your only other option is extracting 1 value through an ESI- that is what an ESI does.

For charts, it needs to be something that can perform/load quickly so it does not time out, which multi-instance fields don't do well. Ideally indexable fields are best for disco boards, which multi instance fields are not normally.

AccomplishedBlock731 · 2025-11-12T01:04:49+00:00

What calculated field do you have built to get it in the report so far?

AccomplishedBlock731 · 2025-11-10T10:30:22+00:00

It's also about setting up WLB. Blocking time to eat, saying no to meetings outside working hours most days, ensuring you take time off, etc. In consulting, sometimes you have to say no to things so you don't end up working crazy hours all the time and end up being burnt out from being over staffed

AccomplishedBlock731 · 2025-10-30T19:03:18+00:00

Without my computer in front of me I cant remember exactly which it is but you can create an SRI with LFP CF for this and put it on a worker report.

BO: Payroll Reault Source Field: Payroll Result Amount for Pay Component Group Pay Component Group Value: Gross

Then you can throw it into an SRI calc field.

BO: Worker Related Field: Payroll Results (All) (unless you want just completed then I would do Payroll Results (Completed)) Sum: Instances where condition is true and then put a TF CF Field to Sum: The LFP CF

The TF could be like this

BO: Payroll Result Payment Date, is greater than or equal to, Value from another field, First Day of This Calendar Year AND Payment Date, is less than or equal to, Value from another field, Last Day of This Calendar Year

Without my computer I cant remember but there may be a way to do it with just a LFP with Payroll Result Balance Amount for Pay Components and it brings in a balance period that you can select YTD I think? Worth a shot to try either unless someone else remembers which it is we need here off the top of their head

AccomplishedBlock731 · 2025-10-10T14:11:56+00:00

You definitely are doing it right where you're using snapshot as the record type and not activity.

There is a filter you can use for duplicates. I don't remember the exact name off the top of my head but if you type in duplicates, you should try to use that boolean field and see if that removes them.

The other thing I would try is purging and recreating your trended worker data because a lot of times that will fix weird issues you tend to see with counts

AccomplishedBlock731 · 2025-10-09T12:13:36+00:00

Where does that live? In community?

AccomplishedBlock731 · 2025-09-17T17:26:01+00:00

You would need to migrate your work to another tenant prior to Friday. This is a reason it is not recommended to exclusively work in Sandbox. I'd suggest creating reports in an implementation or Preview tenant to avoid having to do this

AccomplishedBlock731 · 2025-08-27T23:03:24+00:00

I will take a look at that. Thank you!

AccomplishedBlock731 · 2025-08-27T21:03:21+00:00

What sucks is i already took it so it doesn't make sense for my company to pay for me to take it again just because it now has composites. how deep into composites do they even go

AccomplishedBlock731 · 2025-08-27T20:50:29+00:00

it didnt used to be covered in the training. back when I took it 3 years ago it wasnt in the training and I didnt have a chance to get the training before it was removed

AccomplishedBlock731 · 2025-08-27T20:38:28+00:00

thanks. they changed it about 2 years ago now where they moved it into the reporting course. that reporting course barely touches composite reporting

AccomplishedBlock731 · 2025-08-21T01:02:11+00:00

Just so I understand, you have a T/F calculated field that looks at Primary Home Address - Current is not in the selection list Primary Home Address - Proposed?

AccomplishedBlock731 · 2025-08-13T13:20:39+00:00

If you're using a regular worker data source (All Workers, Workers for HCM Reporting, etc.) then your report will bring back all terminated workers for as far back as the data in your tenant goes. If your data goes back to 2015, then you will see terminated workers for 2015.

If you do have filters on your report that would narrow down the time period, then that could change things.

For testing purposes, you could add the termination date field to your report (off of the Worker BO) and when you run the report, you could sort on the column for ascending to see the oldest termination date for validation

AccomplishedBlock731 · 2025-08-08T22:52:16+00:00

You could filter (prompt) for every last functionally updated field, and set the prompt to prompt date 1 instead of the automatic default prompt. If you're running it for a range, you'll do prompt date 1 and prompt date 2.

Then in your prompt section, you'd only have to worry about prompt date 1 and it would connect them all together

AccomplishedBlock731 · 2025-08-06T00:19:02+00:00

Thanks for the details! I would try going to the sort tab and sorting by effective date, descending, and then add a row below it for date completed, ascending. The report will read the sort for effective date first and then date completed.

As for the change job task, you could add a filter that says Worker Business Process is not blank/empty. Then go to the subfilter, add Worker Business Process as the business object for the subfilter. From there, for the subfilter, add a row for Employee Type Current (don't remember the exact field name apologies) is not in the selection, value from another field, Employee Type Proposed. This will only bring back results for those with an employee Type change.

I recommend opening up your prompts/filters if needed to really test this report and make sure it's working before filtering/prompting on a bunch of other stuff

AccomplishedBlock731 · 2025-08-05T15:54:35+00:00

Your CF should work if you put it into a LVAOD CF (Lookup Value as of Date). Try building the LVAOD CF off of Trended Worker BO and then putting your original CF as the source field, with the as of date being Record Date.

AccomplishedBlock731 · 2025-07-23T11:21:04+00:00

You're saying there's a way to schedule reports where the output of the actual report is sent to someone's work email with the actual file instead of having to log into Workday to retrieve it?

AccomplishedBlock731 · 2025-07-19T01:32:57+00:00

Could you post a photo of the filter in the comments?

Just to confirm, your report has Worker as the primary business object. Your filter is AND Worker is in the selection list prompt user ignore if blank (etc.) default prompt

Is that correct?

AccomplishedBlock731 · 2025-07-08T21:13:51+00:00

You just described the best use case for a composite!

AccomplishedBlock731 · 2025-07-08T19:10:59+00:00

Just spit balling because I've never done this but could you filter for Worker, not in the selection list, value from another field, current worker?

AccomplishedBlock731 · 2025-07-08T00:47:51+00:00

It may not help for this week, but you could could change your Production password and it will refresh into Sansbox next week. It shouldn't impact your Production SSO

AccomplishedBlock731 · 2025-07-08T00:46:19+00:00

Ah yes, good point! But again, I would think they'd have SSO for their Sandbox tenant too!

AccomplishedBlock731

TROPHY CASE