Pyramid's Calculation Engine Explained
Pyramid includes a sophisticated, multi-tiered calculation engine designed to handle the full spectrum of calculations often required in solving analytic questions and problems.
Using the Pyramid Query Language ("PQL") as the mechanism, the calculation engine resolves:
- Granular Calculations: logic driven at the transactional level - typically in the database
- Semantic Calculations: logic driven at the aggregated level, in the data model
- Context Calculations: logic driven at the reporting level, in the visualizations
Although, it’s not entirely obvious why an analytic application would need all three types, very often there is a strong need for each capability. What makes the Pyramid engine more powerful than most, is that it can resolve all three classes of calculation in the same application in a consistent, integrated fashion and use it on any of the data stacks it operates with.
Surprisingly, few other platforms offer users all three capabilities. Some offer granular and semantic options. Others just semantic calculations. Real context calculations are offered by very few vendors. And it’s very rare to find an application that does all three.
The video above explains what the three calculation types are with examples. Click here to view other videos demonstrating context calculations.
You can also read the full blog article here.