Amazon Redshift does not natively provide cube/slice/dice capabilities, this is normally provided by software products that sit "on top" of a database. For example Microsrategy allows you to build ROLAP cubes on top on data marts sourced from Redshift tables.
Can you specify what is "our Approach"? The best way to move data into an OLAP RDBMS is in "bulk" to maximize the parallel ingestion. Redshift providers the COPY command to perform bulk load ingestion. Data has to be moved into an S3 bucket previous to the execution of a COPY command. ETL tools may hide the process but in the back this process still happens.
Query performance in an MPP solution like Redshift depends mainly on how the tables containing the data are "distributed" across the cluster and how the data in them is sorted. Distributing and Sorting is a simple mechanism, but we have created some "automated features" that may allow the developers not to be so concerned about it.
AWS Glue load data from S3 to Redshiftasked 6 months ago
Distinguish Redshift Spectrum from Redshift CostsAccepted Answerasked 4 years ago
Redshift questions from AWS CustomerAccepted Answerasked 3 years ago
Redshift UNLOAD questionsAccepted Answerasked 6 years ago
Redshift data warehouse and Glue ETL design recommendationsAccepted Answerasked 2 years ago
use Redshift Spectrum to query both Redshift table and s3 fileAccepted Answerasked 2 years ago
Athena and Redshift Spectrum performance best practicesAccepted Answerasked 4 years ago
Transfer from S3 to Redshift and filter specific keyasked a year ago
DMS from Aurora to RedshiftAccepted Answerasked 5 years ago
How to offload historical data to Redshift or S3?Accepted Answerasked 2 years ago