Can the distribution wizard be configured to use properties dynamically?

[alexander_b_white]

I would like to create a distribution template using a dynamic list based on a dimension property.

One common use case for this would be to use the Owner property of the Entity dimension to regularly email a set of reports to the people responsible for each Entity.

When I attempt to create such a distribution template, first I select the Entity dimension as the Variable Members dimension. Next, I use the filter function within the member selector to define a list of Entities based on the Owner property – much like one could do within an EPM report. Upon clicking OK in the member selector, a warning pops up that "some members have been modified so that the template can be used." But for now, the member selection field still shows the selected list of Entities, which looks promising.

Unfortunately, upon reopening the template, it appears the list of Entities was saved as a static list rather than using a dynamic filter. So there ends up being a separate line for each Entity. Opening the .xltx template file directly confirms this.

Is there any other way to set up a distribution template to use a dynamic list rather than having to constantly maintain the static list of Variable Members?

[former_member186338 · Accepted solution]

Unfortunately only fixed list....

[former_member186338]

You can write in VBA the distribution wizard yourself. Not very complex...

[alexander_b_white]

Thanks Vadim. Are there any other tricks you can think of that might meet this requirement?

I thought about using the Worksheet Generation wizard as it appears to work with property filters; however this would still require manual action that could become tedious if there are a lot of different Owners.