Block Creation Issue...

@Descendants("All_Departments"

 Hello,

The issue is that the blocks don’t exist after running this script, and I thought it would after adding these 2 commands:

 

SET CREATEBLOCKONEQ ON;

And…

{Scenarios_Select} = 0;

 

It’s not creating the blocks. I've used them separately and at the same time but it still does not create the blocks.

 

FYI : The dimensions are as follows:

 

The dense dimensions are “L600” (Measure), “Periods” and “HSP_Rates” – the rest are sparse.

 

SET CREATEBLOCKONEQ ON;

 

FIX ("GBP","L600",{Years_Select},{Scenarios_Select},@Descendants("All_Departments" , 0),"No_Employee",{VersionTo})

 

FIX

(@DESCENDANTS("Legal Entities", 0),@DESCENDANTS("Legal & Professional  Related",0),@REMOVE(@DESCENDANTS("All_Cost_Centers"