Smart View and Task Lists - all costs centres in a group

Summary: Smart View and Task Lists - all costs centres in a group

Content (required):

So, PBCS, Task Lists, Forms, opening same via Smart View.

Say a user is responsible for a group of cost centres, which will typically relate to a cost centre parent in the dimension hierarchy.

Q: Is there anyway to pre-populate a spreadsheet with numerous workbooks all of which (say) relate to the first node of the task list, but all pulling a different level zero cost centre via the POV control.

Cost Centres are currently in the POV of the form in question.

Cost Centre is in POV because form calls business rule to process that cost centre only, as part of a combination of other dimensions - for speed of processing and so as not to frustrate other users as business rule has downstream consequences.