Budgeted Expense Report

[AVHuntley]

Added 'hide' formula to formatting rows so that they didn't have to be pasted down the sheet. This should improve performance by making the size of each sheet smaller.

Altered the Page script on the Report tab (the one that gets cascaded) so that it doesn't create empty sheets (for MngID members with no data). This should also speed things up, especially on a 'client-side' build. The old script was:

SELECT
    { DESCENDANTS([Expense MngID],, LEAVES) } ON COLUMNS
FROM
    [@cube]

The new script is:

SELECT
    NON EMPTY DESCENDANTS([Expense MngID],, leaves) ON COLUMNS,
    (
        [FY],
        [Budget],
        [NA Division],
        [Expense Data],
        [Fully Adjusted],
        [${Year}]
    ) ON ROWS
FROM
    [@cube]

Finally - I was checking Insert functionality, and I noticed that, in the production (old) system, there is an insert script, but it does not function.

The question is: should you be able to Insert new rows in this model?