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
(
  {
   ([Payment Date].[Fiscal Year].[Fiscal Year].Members
   ,[Payment Date].[Is Current Fiscal Year].&[Y]
   ,[Payment Date].[Is Available For Finance].&[Y])
  ,
   ([Payment Date].[Fiscal Year].[Fiscal Year].Members
   ,[Payment Date].[Is Current Fiscal Year].Children
   ,[Payment Date].[Is Available For Finance].&[Y]
   )
  }
,[Payment Date].[Fiscal Year]
);
CREATE SET CURRENTCUBE.[Minority]
AS Extract
(
  {
     [Payee].[Is Minority].[All]
     +
      [Payee].[Is Minority].[Is Minority].Members

      [Payee].[Is Minority].&[N/AA]
   }
   , [Payee].[Is Minority]
) ;
CREATE SET CURRENTCUBE.[Active Entry Fiscal Years]
AS Extract
(
  {
   ([Fiscal Year Date].[Fiscal Year].[Fiscal Year].Members
   ,[Fiscal Year Date].[Is Current Fiscal Year].&[Y]
   ,[Fiscal Year Date].[Is Available For Finance].&[Y])
  ,
   ([Fiscal Year Date].[Fiscal Year].[Fiscal Year].Members
   ,[Fiscal Year Date].[Is Current Fiscal Year].Children
   ,[Fiscal Year Date].[Is Available For Finance].&[Y]
   )
  }
,[Fiscal Year Date].[Fiscal Year]
);