One thing that is missing from your analysis is the type of Aggregation of the data in the data warehouse. Column Store indexes are mimicking the behavior of Key...
This is the same problem SQL Server has with having Materialized Views on tables. I am haven't tried it yet, but I am hoping a true Column Store physical...