I remeber having read, that ROLAP stores source data and metadata in relational format that permits to use SQL, except of only MDX for SSAS storage.
Can SQL be used in HOLAP storage mode?
I understand that ROLAP storage mode can be set for a separate dimension.
Can SQL be used in this case?
How is such storage, when everything is stored in MOLAP (i.e. in SSAS) but one dimension in relational source (OLTP) database, is called?
View Complete Post