Queries based on dimensions

I have been looking at the type of queries that are available and trying to compare them with our workflows. We generate a ton of time series data from engine testing and development but usually its the metadata or in OLAP terms the dimensions that are used as the filter to select data by. A typical engineer is interested in a run number or a series of runs rather than a specific time window ( the time window is usually used to narrow down when tests were run). Will type of queries could I use that would give the best performance and also return raw data without aggregates etc.