How can I create an OLAP data cube on AWS Aurora-postgresql

Question

Our database is in Aurora Postgres on AWS. I access it using psycopg2 in python. The data is such that each row represents an instance of an item being brought. There areI multiple columns such as the time_when_sold, item_name, item_category, customer_name. I want to create a multi-dimensional data cube so that the data can be better organized and pre-aggregated, which would make query results faster too. However, I cannot figure out how to create the data cube on postgres. The online resources I've gone through don't seem to talk about postgres. Any help will be greatly appreciated.