I have a dynamic calc member that only needs to execute at the intersection queried. This can be at level 0, or upper levels or a combination across multiple dimensions. The formula only needs to run at whatever intersection is queried and the result will be correct.
In a regular BSO cube, this works naturally. In a Hybrid BSO cube, the formula runs at the leaf levels and, I assume, Hybrid BSO aggregates everything then discards the aggregated value in favor of the formula result at the queried intersection. I still get the correct answer but, when I'm querying root members, the process of executing the calc at the leaf levels takes forever.
How can I tell Hybrid BSO to just run the formula at the queried level?