CASE Member Expression Optimization
Expressions performing large numbers of Member checks using CASE or IF statements generate large amounts of out-bound SQL, selecting from unnecessary Fact Tables and taking too long to plan.
Now, if Member checks are specific to Hierarchy Levels, static Level Checks will short-cut the work needed to fulfill the query, especially when terminal conditions select from a single fact table.
Check out our demo to see how this new capability
- Reduces the size of outbound queries for expressions that check Member values
- Reduces table scales if logic is enclosed by Level checks which select from different fact tables
- Reduces planning time
- Query size and planning time reduction by anywhere from 30% to 90%