I then started the SQL Profiler connected to the SSAS Server to watch what the system would do when I ran a query across vertical partitions, for instance analyzing sales across all years.

Send the prompt to OpenAI’s GPT-3.5-turbo API and request an SQL query to answer your question. Run the SQL that comes back on your data set to calculate your answer.