Advanced

The Advanced pane contains the Secure structure when drilling down flag.

Caution: This flag can speed up list calculation but it must be used carefully. If used incorrectly, the flag can hide elements and make them inaccessible. It is False by default.

Lists can be calculated statically or dynamically. Static calculation loads all the elements of the list from the server at once. Dynamic calculation loads elements only as you expand the list.

Which method is used can affect performance, and various factors determine which calculation method is used in each situation. For example, static calculation is always used if the list is not hierarchized.

Dynamic calculation uses the .children property of lists. Often this is is the fastest method of calculating a list.

The Secure structure when drilling down option forces use of the .children property, regardless of the structure of the list.

If you use structure selection, filters, or custom MDX you can legitimately create a broken hierarchy. For example, you might exclude North/South America from this hierarchy: World>North/South America>North America.

In this example, if Secure structure when drilling down is True, no results are returned when you expand the World element.