---
title: "Custom report, Gemini: the full transcript — Kiweely"
description: "Every turn of Gemini on the custom report task in Kiweely’s Workday tenant test, word for word with its times."
url: https://kiweely.com/tenant-test/transcripts/t2-ge
---

# T2 · GE · Gemini: Google Gemini 4 Neon (High) via Antigravity CLI

## Turn 1: prompt (sent 2026-11-20T04:49:09.217Z)

Please create a custom report in our Workday tenant called “Org Roster TT-GEM”. When someone runs it, it should ask them to pick a supervisory organization and then list the active workers in that organization and all of its subordinate organizations. Columns: Worker, Employee ID, Supervisory Organization, Job Profile, Location, Hire Date, Manager. Sort it by Hire Date, earliest first. Our main test organization is “HCM1119 Outfitters”. Please give me what I need to build it.

## Turn 1: answer (2026-11-20T04:51:28.016Z, 138.8 s)

I don’t have direct access to your Workday tenant to create the report for you, so here is the complete configuration specification and step-by-step build guide to create **`Org Roster TT-GEM`** in Workday Report Writer.

* * *

### 1\. Create the Report Definition

Search for and open the **`Create Custom Report`** task, then enter:

| Setting | Value |
| --- | --- |
|  **Report Name** | `Org Roster TT-GEM` |
|  **Report Type** | `Advanced` *(required to configure Prompts, Filters, and Sort)* |
|  **Optimized for Performance** | Checked |
|  **Temporary Report** | Unchecked |
|  **Data Source** | `Workers for HCM Reporting` *(indexed; Primary Business Object = `Worker`)* |
|  **Data Source Filter** | `Active Workers by Organization` *(or `Workers by Organization` — see note below)* |

> **Data Source Filter check:** Click the related actions (`...`) next to the Data Source Filter → **Data Source Filter > View** to confirm:
> 
> 1.  It restricts to **Active** workers (if your tenant’s org filter includes terminated workers, add the active filter in Step 4 below).
> 2.  It exposes built-in prompts for **Organizations** and **Include Subordinate Organizations**.
> 
> *Why use this filter instead of a manual Filter tab rule?* A standard Filter tab rule (`Supervisory Organization in the selection list`) only matches the exact org picked and **does not** recurse down child organizations. Using a Data Source Filter with the built-in `Include Subordinate Organizations` prompt handles arbitrary hierarchy depth natively and performs much faster.

* * *

### 2\. Configure Columns (**Columns** tab)

Keep **Business Object** set to `Worker` for all 7 rows and add them in this exact order:

| # | Business Object | Field | Column Heading Override | Notes |
| --- | --- | --- | --- | --- |
| 1 | `Worker` | `Worker` | `Worker` | Full name (links to worker profile) |
| 2 | `Worker` | `Employee ID` | `Employee ID` |  *Note: Blank for Contingent Workers. If you want IDs for both employees and contingent workers, use `Worker ID` instead.* |
| 3 | `Worker` | `Supervisory Organization` | `Supervisory Organization` | Worker’s assigned supervisory org |
| 4 | `Worker` | `Job Profile` | `Job Profile` | Primary job profile |
| 5 | `Worker` | `Location` | `Location` | Primary work location |
| 6 | `Worker` | `Hire Date` | `Hire Date` | Most recent hire date *(use `Original Hire Date` only if you want initial hire date for rehires)* |
| 7 | `Worker` | `Worker's Manager` | `Manager` | Override heading to `Manager` |

* * *

### 3\. Configure Sorting (**Sort** tab)

| # | Field | Direction |
| --- | --- | --- |
| 1 | `Hire Date` | `Ascending` *(earliest hire date first)* |
| 2 *(optional tie-breaker)* | `Worker` | `Ascending` *(alphabetical for same-day hires)* |

* * *

### 4\. Configure Filtering (**Filter** tab)

-   **If your Data Source Filter already limits to Active workers:** Leave the Filter tab empty.
-   **If your Data Source Filter includes terminated workers:** Add:
    -   **Field:** `Active Status` | **Operator:** `equal to` | **Comparison Type:** `Value specified in this filter` | **Comparison Value:** `Yes`
-   **Optional scope refinements:**
    -   *Employees only (exclude Contingent Workers):* Add `Worker Type` | `in the selection list` | `Employee`.
    -   *Exclude workers on Leave of Absence:* Add `On Leave` | `equal to` | `No` (in Workday, workers on leave still have `Active Status = Yes`).

* * *

### 5\. Configure Runtime Prompts (**Prompts** tab)

First, check **`Populate Undefined Prompt Defaults`** so Workday loads the prompts from your Data Source Filter. Then configure:

1.  **`Organizations`** *(or `Supervisory Organizations`)*
    -   **Label for Prompt:** `Supervisory Organization`
    -   **Required:** **Checked** *(prevents users from accidentally running an unfiltered tenant-wide query)*
    -   **Do Not Prompt at Runtime:** **Unchecked**
    -   **Default Type:** Leave blank so users must choose an org each time *(or set `Specify Default Value` → `HCM1119 Outfitters` if you want it pre-populated while remaining editable)*.
    -   *(Tip: If the delivered prompt allows any Organization type rather than only Supervisory Organizations, restrict it to Supervisory Organizations via the prompt’s valid-value/type configuration if available in your Data Source Filter, or select a Supervisory-Organization-specific filter.)*
2.  **`Include Subordinate Organizations`**
    -   **Default Type:** `Specify Default Value`
    -   **Default Value:** **Checked** (`Yes`)
    -   **Do Not Prompt at Runtime:** **Checked** *(locks subordinates ON automatically so runners only have to pick the supervisory org and don’t have to remember to check the box)*

* * *

### 6\. Share & Security (**Share** tab)

-   Leave as **Do not share report definition** while testing.
-   Once verified, switch to **Share with specific authorized groups and users** and add the target security groups (e.g., `HR Partner`, `Manager`, `Report Viewer`).
-   Workday will automatically enforce each runner’s existing row-level and field-level security (e.g., `Worker Data: Public Worker Reports`, `Worker Data: Current Staffing Information`), so users only see workers they are authorized to view.

* * *

### 7\. Save and Test with `HCM1119 Outfitters`

1.  Click **OK** to save the report, then click **Run**.
2.  At the prompt screen, select **`HCM1119 Outfitters`** for **Supervisory Organization** and click **OK**.
3.  Verify the output against these checks:
    -   **Subordinate roll-up:** Confirm the `Supervisory Organization` column contains workers from both `HCM1119 Outfitters` and its child/subordinate supervisory orgs.
    -   **Active only:** Confirm no terminated workers appear in the results.
    -   **Columns & order:** Confirm the 7 columns appear as `Worker`, `Employee ID`, `Supervisory Organization`, `Job Profile`, `Location`, `Hire Date`, `Manager`.
    -   **Sort order:** Confirm rows start with the oldest/earliest `Hire Date` at the top and progress chronologically downward.
    -   **Contingent workers (if applicable):** Check whether any contingent workers under `HCM1119 Outfitters` have blank `Employee ID` or `Hire Date` values and adjust per Steps 2 & 4 if needed.

## Turn 2: follow-up (sent 2026-11-20T05:31:17.654Z)

Step 1 says set the Data Source Filter to “Active Workers by Organization” (or “Workers by Organization”). Searching the Data Source Filter prompt for “Active Workers by Organization” shows “No matches found”. The Data Source Filter list shows: All Active Impacted Workers, All Active Workers, All Active Workers (All Types), All Employees, All Terminated Workers, All Workers, All Workers for Manage Work Schedule Assignments, All Workers for Mass Submit Time, All Workers with In Progress Calibration Event, and more. Searching for “Organization” returns 3 results: Workers by Learning Organization, Workers for all Organizations, Workers in Organizations - Employee Reviews. There is no filter named “Workers by Organization”. The field is required and currently shows “All Active Workers” by default.

## Turn 2: answer (2026-11-20T05:33:45.892Z, 148.2 s)

Good catch — `Active Workers by Organization` / `Workers by Organization` is not a Data Source Filter on **`Workers for HCM Reporting`**. Use **`Workers for all Organizations`** from the 3 results you found.

### What to select in Step 1

-   **Data Source:** `Workers for HCM Reporting`
-   **Data Source Filter:** **`Workers for all Organizations`**

> *(Quick check before clicking OK: click the related actions `...` on `Workers for all Organizations` → **Data Source Filter > View** to confirm what prompts it brings in and whether it includes terminated workers.)*

### Adjustments for Steps 4 & 5 with `Workers for all Organizations`

1.  **Filter tab (ensure Active workers only):** Unlike `All Active Workers`, `Workers for all Organizations` can return terminated/inactive workers. Unless it has a built-in prompt that excludes them, add this row on the **Filter** tab:
    
    -   **Field:** `Active Status`
    -   **Operator:** `equal to`
    -   **Comparison Type:** `Value specified in this filter`
    -   **Comparison Value:** `Yes` *(if your tenant uses a status list instead, use `Worker Status` `in the selection list` `Active`)*
2.  **Prompts tab:** Check **`Populate Undefined Prompt Defaults`** to reveal the filter’s built-in prompts, then configure:
    
    -   **Organization prompt** (e.g., `Organizations`):
        -   **Label for Prompt:** `Supervisory Organization`
        -   **Required:** Checked
        -   **Do Not Prompt at Runtime:** Unchecked
    -   **`Include Subordinate Organizations`** (if exposed):
        -   **Default Type:** `Specify Default Value`
        -   **Default Value:** Checked (`Yes`)
        -   **Do Not Prompt at Runtime:** Checked *(so subordinates are always included automatically)*
    -   *(If an **`Include Terminated Workers`** or similar status prompt appears, default it to unchecked/`No` and check **Do Not Prompt at Runtime**.)*

* * *

### If `Workers for all Organizations` does *not* include an `Include Subordinate Organizations` prompt

Let me know what prompts appear after clicking **Populate Undefined Prompt Defaults**, and we can either:

1.  Keep **`All Active Workers`** as the Data Source Filter and filter on the **Filter** tab using `Worker`‘s hierarchy/all-organizations field (so it captures the selected supervisory org and every subordinate org below it), **or**
2.  Switch the **Data Source** itself (not the filter) to a delivered org-prompted Data Source like **`Workers by Organization`** or **`Employees by Organization`** (if present in your tenant).

## Turn 3: follow-up (sent 2026-11-20T05:58:18.325Z)

Applied “Workers for all Organizations” as the Data Source Filter, the Active Status filter row, and the prompt settings. Populate Undefined Prompt Defaults filled 8 prompt rows: Organizations by Type, Contingent Worker Type, Employee Type, Worker Types, Active, Include Subordinate Organizations, Include Terminated Workers, Remove Exclude From Headcount. I set Organizations by Type to label “Supervisory Organization” (Required checked, Do Not Prompt unchecked), and Include Subordinate Organizations to Specify default value with the Default Value box checked and Do Not Prompt at Runtime checked. For Include Terminated Workers I chose Default Type “Specify default value”, left the Default Value box unchecked, and checked Do Not Prompt at Runtime. On OK, Workday does not save and shows: “Default Value (Row 7 Column 7) - The field Default Value is required and must have a value.” The Default Value for that row is a single checkbox, and it is unchecked as the answer says. Nothing is saved until this error is resolved.

## Turn 3: answer (2026-11-20T05:59:08.610Z, 50.3 s)

That’s a classic Workday checkbox-prompt quirk: for a single-checkbox (Boolean) prompt, Workday treats an **unchecked** box in **Default Value** as *blank*, so choosing **`Specify default value`** only validates when the checkbox is **checked** (`True`).

### How to fix Row 7 (`Include Terminated Workers`)

Because `Include Terminated Workers` is an optional (non-required) checkbox prompt, leave its default blank to make it evaluate as **unchecked (`False`)** at runtime:

1.  Change **Default Type** from `Specify default value` to **blank / `No default value`** (clear the field).
2.  Leave **Default Value** unchecked/blank.
3.  Keep **`Do Not Prompt at Runtime`** **checked**.

* * *

### Recommended settings for all 8 prompt rows

To ensure the report **only** asks the user to pick a Supervisory Organization (and hides the other 7 prompts cleanly), configure all 8 rows like this:

| Row | Prompt | Label for Prompt | Default Type | Default Value | Required | Do Not Prompt at Runtime |
| --- | --- | --- | --- | --- | --- | --- |
| 1 | `Organizations by Type` | `Supervisory Organization` |  *(blank)* |  *(blank)* |  **Checked** | Unchecked |
| 2 | `Contingent Worker Type` |  *(default)* |  *(blank)* |  *(blank)* | Unchecked |  **Checked** |
| 3 | `Employee Type` |  *(default)* |  *(blank)* |  *(blank)* | Unchecked |  **Checked** |
| 4 | `Worker Types` |  *(default)* |  *(blank)* |  *(blank)* | Unchecked |  **Checked** |
| 5 | `Active` |  *(default)* | `Specify default value` |  **Checked** *(or `Yes`)* | Unchecked |  **Checked** |
| 6 | `Include Subordinate Organizations` |  *(default)* | `Specify default value` |  **Checked** | Unchecked |  **Checked** |
| 7 | `Include Terminated Workers` |  *(default)* |  *(blank / No default value)* |  *(blank)* | Unchecked |  **Checked** |
| 8 | `Remove Exclude From Headcount` |  *(default)* |  *(blank / No default value)* |  *(blank)* | Unchecked |  **Checked** |

**Two quick notes on Rows 5 & 8:**

-   **Row 5 (`Active`):** Setting this to checked + hidden filters to active workers right at the Data Source Filter level (you can keep your `Active Status = Yes` row on the **Filter** tab as a safeguard, or remove it after verifying).
-   **Row 8 (`Remove Exclude From Headcount`):** Leaving this unchecked/blank excludes any positions flagged *Exclude from Headcount* (Workday’s standard roster/headcount behavior). If you want those workers included too, switch Row 8 to `Specify default value` + **Checked**.

Click **OK** after clearing **Default Type** on Row 7 — the report should save cleanly, and running it will prompt only for **Supervisory Organization**.
