I want to break up one of my partitions of my measure group that has 450 million rows into sub partitions to make processing and querying faster. I currently split my measure group using attr1 of dimension1. Is it possible to split each partition further based on a different attr2 of the same dimension? I know that I can write a SQL query to do this but what I want to know is how to create the slice hint such that SSAS knows to look at the sub partitions. I tried something like this in slice expression for partition {dim1.Attr1&val1, dim1.Attr2&value2} but the processing failed with error saying tuple can't contain two different dimensions!?! What can I do here? Can multiple partitions have same slice hint ? Will that solve my problem if I give same slice hint for all related partitions ?
