I2024.2.2 BI Features and Improvements

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%