Our users are using Oracle smartview for financial reporting and are looking for an excel based tool to have similar capabilities in BigQuery. I wanted to know if CData plugin for excel can do the below:
- Slice and dice data based on BigQuery data models
- Consume hierarchies maintained in bigquery. For example a legal entity hierarchy that would be maintained centrally in BQ and consumed in financial reports
- Schedule reports
- Do cell based formulas. So for example, I want to create a forumla that goes into a cube and returns net earnings for the year input by the user in one of the cells.