Which method should be used to include a newly added base account under a parent into the existing adhoc Smart View query's rows?

• A. Zoom out on the FCCS_Cash and Cash Equivalents parent account, then re-zoom in.
• B. Refresh the query
• C. Rebuild the query from scratch
• D. Modify the parent account structure

Answer: (A)

In an adhoc Smart View query, the list of members in a dimension is fetched from the server when you interact with the hierarchy. When a new base account is added under a parent, that new member isn’t visible in the existing query until you refresh the dimension metadata. Zooming out on the parent account and then zooming back in forces Smart View to re-fetch and rebuild the member list, making the newly added base account appear so you can include it in the rows.

This approach is preferred because it updates the dimension metadata without changing the data or rebuilding the entire query. Simply refreshing the query may not always pull in new hierarchy members, rebuilding from scratch would be unnecessary and disruptive, and altering the parent structure isn’t needed to view or add the new account.