Ab initio description of collectivity for sd shell nuclei