SAC subtotal challenges

[mikehoekstra1]

We've run into a couple of challenges with the SUBTOTAL function.

For context, we are using an SAC analytic model.   

1. We're using the SUBTOTAL function to get percents of totals but there is a 10 dimension limit.  Does anyone  know of an alternative that does not have that limit? 
2. We've tried to use SUBTOTAL on an aggregated measure (we aggregated it in the Model), but it failed.  Is this expected?  

Thanks for your help!

[RajuRao]

Yes, this behavior is expected in SAP Analytics Cloud.The SUBTOTAL function has a hard limit of 10 dimensions, and there is no alternative function that removes this limit. SUBTOTAL also works only on base measures, not on aggregated or calculated measures created in the model. When used on aggregated measures, it fails by design due to calculation order restrictions. The recommended workaround is to reduce dimensions, or calculate percent of total in the source query or model instead of using SUBTOTAL.