So ever wanted to know where the Period values iN SPM are actually stored?

Well as long as you aren’t trying to do some dodgy updates to the SPM schema, as you know that is against the rules…

The first trick is that Periods are stored in the SAS Solution Data Mart layer not in SPM itself.

They are stored as a master details record with:

• the master being in SASSDM.sas_member where INTERNAL_DIM_TYPE_ID = -9
• there are three children records in SASSDM.sas_member_property (joined on member_id) whihc cover:
  • Start Date
  • End Date
  • Period Type

Of course as I have said don’t touch these manually and you should really use the prebuilt SAS Time view to look at them