Data can be taken from any database source - it's generally a good idea for it to be a data warehouse but it doesn't have to be. ROLAP is a storage mode for the cube once it's built - you wouldn't describe a data warehouse as "ROLAP" without this.