MDX Script - MdxScript Commands Index

Calculations Command Script

/*
The CALCULATE command controls the aggregation of leaf cells in the cube.
If the CALCULATE command is deleted or modified, the data within the cube is affected.
You should edit this command only if you manually specify how the cube is aggregated.
*/
CALCULATE;
CREATE SET CURRENTCUBE.[Active Fiscal Years]
AS Extract
(
  {
   ([Date].[Fiscal Year].[Fiscal Year].Members
   ,[Date].[Is Current Fiscal Year].&[Y]
   ,[Date].[Is Available For Finance].&[Y])
  ,
   ([Date].[Fiscal Year].[Fiscal Year].Members
   ,[Date].[Is Current Fiscal Year].Children
   ,[Date].[Is Available For Finance].&[Y]
   )
  }
,[Date].[Fiscal Year]
);
CREATE SET CURRENTCUBE.[Active Terms]
AS Extract
(
  {
   ([Term].[Term Title].[Term Title].Members
   ,[Term].[Default Term].&[Yes]
   ,[Term].[Active Term].&[Yes])
  ,
   ([Term].[Term Title].[Term Title].Members
   ,[Term].[Default Term].Children
   ,[Term].[Active Term].&[Yes]
   )
  }
,[Term].[Term Title]
);
CREATE SET CURRENTCUBE.[Available Terms]
AS Extract
(
  {
    NONEMPTY
    (
        {
        ORDER([Term].[Term Title].[Term Title].Members
        ,[Term].[Term Title].CURRENTMEMBER.MEMBER_KEY, BDESC)
        }
        ,[Measures].[Fact Student Total Fees Count]
    )
  }
  ,[Term].[Term Title]
);
CREATE MEMBER CURRENTCUBE.[Measures].[ReceiptPaymentsToPeriod]
AS (
  Aggregate
  (
     PeriodsToDate
     (
        [Date].[FiscalCalendar].[Fiscal Year]
        ,[Date].[FiscalCalendar].currentmember
      )
      ,[Measures].[Receipt Payment Amount]
  )
),
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Receipt Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Receipt Payments';
CREATE MEMBER CURRENTCUBE.[Measures].[Prior Year Term Student Total Fee Count]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],1,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[Fact Student Total Fees Count]
),
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Fee Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Total Fees';
CREATE MEMBER CURRENTCUBE.[Measures].[Prior Year Class Fees Assessed]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],1,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[Class Total Fees Assessed]
),
FORMAT_STRING = "Currency",
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Fee Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Total Fees For Class'  ;
CREATE MEMBER CURRENTCUBE.[Measures].[Prior 2Year Class Fees Assessed]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],2,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[Class Total Fees Assessed]
),
FORMAT_STRING = "Currency",
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Fee Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Total Fees For Class'  ;
CREATE MEMBER CURRENTCUBE.[Measures].[Prior Year Class Fees Paid]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],1,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[Class Total Fees Paid]
),
FORMAT_STRING = "Currency",
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Fee Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Total Fees For Class'  ;
CREATE MEMBER CURRENTCUBE.[Measures].[Prior 2Year Class Fees Paid]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],2,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[Class Total Fees Paid]
),
FORMAT_STRING = "Currency",
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Fee Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Total Fees For Class'  ;
CREATE MEMBER CURRENTCUBE.[Measures].[Prior Year Class Fees Not Paid]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],1,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[Class Total Fees Not Paid]
),
FORMAT_STRING = "Currency",
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Fee Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Total Fees For Class'  ;
CREATE MEMBER CURRENTCUBE.[Measures].[Prior 2Year Class Fees Not Paid]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],2,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[Class Total Fees Not Paid]
),
FORMAT_STRING = "Currency",
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Fee Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Total Fees For Class'  ;
CREATE MEMBER CURRENTCUBE.[Measures].[Prior Year Fee Paid Amount]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],1,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[Fee Paid Amount]
),
FORMAT_STRING = "Currency",
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Fee Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Fees Paid'  ;
CREATE MEMBER CURRENTCUBE.[Measures].[Prior 2Year Fee Paid Amount]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],2,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[Fee Paid Amount]
),
FORMAT_STRING = "Currency",
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Fee Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Fees Paid'  ;
CREATE MEMBER CURRENTCUBE.[Measures].[Prior 2Year Term Student Total Fee Count]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],2,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[Fact Student Total Fees Count]
),
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Fee Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact Student Total Fees';
CREATE MEMBER CURRENTCUBE.[Measures].[Prior Year HeadCount]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],1,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[EOT Headcount]
),
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Headcount Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact EOT Enrollment Snapshot';
CREATE MEMBER CURRENTCUBE.[Measures].[Prior 2Year HeadCount]
AS (
ParallelPeriod([Term].[TermYearTypeTerm].[Term Year],2,[Term].[TermYearTypeTerm].currentmember)
,[Measures].[EOT Headcount]
),
VISIBLE = 1 ,  DISPLAY_FOLDER = 'Headcount Calculations' ,  ASSOCIATED_MEASURE_GROUP = 'Fact EOT Enrollment Snapshot';