bw_list_afo_workbooks
Lists Analysis for Office workbooks stored in BW with where-used details, so you can find which workbooks use a query or planning function, or sit in a role menu, without downloading files.
Instructions
List the Analysis for Office workbooks stored in BW, with the where-used list BW keeps for them: per workbook its text, document and file type, last change (user and time), its data sources (alias → query name, or an aggregation level or provider used directly), its planning functions and sequences, and the role menus and folders it is placed in. Answers "which workbooks use query X / planning function Y?" (used_object) and "which workbooks are in the menu of role Z?" (role) without downloading a workbook. Newest first. Workbooks kept only on a file share are not stored in BW and do not appear here.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | Workbook technical name or pattern with * (e.g. "WORKBOOK_*"). | |
| role | No | Only workbooks placed in the menu of a matching role: the role name, or a pattern with *, matched in full, or a term found in the role description (e.g. "ROLE_NAME" or "*APPLICATION*"). Not the workbooks a role is authorized for. | |
| user | No | Only workbooks last changed by this user. | |
| changed_to | No | Only workbooks last changed on or before this date or timestamp (ISO, UTC). | |
| max_results | No | How many workbooks to show (default 100, at most 1000); the total is always reported. | |
| used_object | No | Only workbooks that use this object: a query name, planning function, planning sequence, aggregation level or provider (e.g. "QUERY_NAME"). | |
| changed_from | No | Only workbooks last changed on or after this date or timestamp (ISO, UTC). |