Actuals Balance Sheet Reporting - LBC CASCADE

[afs1jes]

Here's a sample note.

[AVHuntley]

This page script runs faster than the original:

SELECT 
  NonEmpty
  (
    {
      [LBC] + Descendants([Outlet]) - [100 Corporate] + [601 King of Prussia]
    }
   ,{
      (
        [Current]
       ,[${Year}]
       ,[Balance Sheet]
       ,[All Brands]
       ,[All Departments]
       ,[All SubAccounts]
       ,[Actuals]
       ,[Fully Adjusted]
       ,[Full Year]
      )
    }
  ) ON COLUMNS
 ,{} ON 1
FROM [@cube];