• Report node options can now be controlled by a range within the workbook. There is a new entry in the report editor for Report Options range name. This range must contain 2 columns with column 1 contain the option name and column 2 containing the value for the option. The following option names are supported:

    • Dimension – name of the dimension

    • ExpandLevels – number of levels to expand

    • SuppressIfZero – 0 = no suppress, 1 = suppress if zero

    • ExcludeCurrentMember – 0 = include current member, 1 = exclude current member

    • OnlyBaseMembers – 0 = include all members, 1 = only include base level members

    • ParentsAfterChildren – 0 = parents before children, 1 = parents after children

    • PropertyDisplayForAll – 0 = no Property Display For All, 1 = Property Display For All

    • PropertyDisplayAsHeading – 0 = no Property Display As Heading, 1 = Property Display As Heading

    • PropertyRowColOffset – a number for the Property Row or Column Offset

    • TimeOffset – a number for the Time Offset

    • TimeOffsetLevel – valid entries are blank, Period, Year, Quarter, Month

    • DrillReport – name of the Drill Report

  • Property filters can now be controlled by a range within the workbook. There is a new entry in the property filter page for a Property Filters range name. This range must contain 4 columns as follows. Each row in the range is one filter.

    • AndOr – valid entries are blank, And, Or. This entry should be blank for first row.

    • Property – valid property name for the node dimension

    • Like – valid entries are Like, NotLike

    • Value – filter value for the property