Drilldown / Rollup Analysis
Customize and generate Group-level rollup analysis reports
Understanding Drilldown / Rollup Analysis
Utilizing Excel to manage and merge multiple data sets, including time series data, can get very complex and place a significant strain on system resources. The Drilldown/Rollup Analysis tool offers an alternative to replace the Sum, If, and various other functions used to compute group-level values. This tool provides the added functionality of supporting multiple data sets for a range of dates.
- Drilldown across multiple groups
- Multiple rollup options
- Supports Multi-Period Analysis
Drilldown / Rollup Analysis Pricing
Only add the modules you need with one affordable monthly price. Easily pause or cancel at any time.
Drilldown/Rollup Analysis – Standard
$ 302.50/month
+ $ 50.00 Setup fee
Features
- Generates Cascading Analysis Tree
- Ability to define multiple custom columns of data for Rollup Analysis
- Ability to define multiple groups for Rollup Analysis
- Point In time Analysis
- Period Analysis between any start and end date
- Support for multiple rollup operations including Weighted Average, Sum, Median, High and Low
- Support for multiple period operations including Cumulative, Sum, Begin/End of Period Value
- Multi-Currency Reporting
Drilldown/Rollup Analysis – Advanced
$ 385.00/month
+ $ 60.00 Setup fee
Features
- Generates Cascading Analysis Tree
- Ability to define multiple custom columns of data for Rollup Analysis
- Ability to define multiple groups for Rollup Analysis
- Point In time Analysis
- Period Analysis between any start and end date
- Support for multiple rollup operations including Weighted Average, Sum, Median, High and Low
- Support for multiple period operations including Cumulative, Sum, Begin/End of Period Value
- Multi-Currency Reporting
See all of the SAYS Platform™s great features
Discover SAYS Platform™Try before you buy.
Register for a free account today and you can try out the following reports and tools free of charge.
Ex-Post Return & Risk Data Report
Demo
Ex-Post Return & Risk PDF/Excel Report
Demo
Composite Analysis Data Report
Demo
Composite Analysis PDF/Excel Report
Demo
Union/vlookup
Data Management
Remove Duplicates/Unique List
Data Management
Ex-Post Return & Risk PDF Report
Analysis
IRR Calculation Engine with PE Analysis
Analysis
Return Correlation Matrix
Analysis
Annualization Return Calculator
Analysis
Explore More SAYS Platform™ Modules
As part of the SAYS Platform™ Drilldown / Rollup Analysis can add the following advantages to your systems for one simple monthly fee.
Composite Construction
Composite Construction & Management streamlines composite creation, membership, and reporting to meet GIPS® standards with speed...
Composite Reporting
Composite Management & Reporting (CMR) is a modular platform that streamlines composite construction, reporting, and GIPS®...
Performance / Attribution Analysis
Transaction-based performance. Accurate performance calculations using TWR at all levels of a portfolio at any time...
Performance Analysis / Return Generation
Portfolio level performance using market values and inflows/outflows may be calculated within the SAYS Platform™ using,...
Ex-Post Return / Risk Analytics
SAYS offers robust ex-post return and risk analytics for any frequency of portfolio and benchmark time...
NAV Return Analysis
Generate NAV returns across multiple periods and fund types
Blended Benchmark Generation
Benchmark Management lets users quickly build custom and blended benchmarks with flexible rebalancing, using any weighting...
Carve-out Allocation
Carve-out performance generator for GIPS 2020 compliance
Data Management / Normalization
Powerful cloud-based data management tool with data anonymization capability.
Drilldown / Rollup Analysis
Customize and generate Group-level rollup analysis reports
Equity Market Data Subscription
Flexible data downloads available through custom file and web service formats.
Net Transaction Cost
Net of Estimated Transaction Cost Calculator for GIPS 2020 compliance
Remove Duplicate / Unique List
Downloadable CSV Text File generated by performing a Remove Duplicates/Unique List operation on multiple uploaded data...
Return Correlation Matrix
Generate a Return Correlation Matrix from return streams
Union / Vlookup
Merge large data sets with ease. Downloadable CSV generated by performing an Union/vlookup operation with either...
