Hi all,
We are starting to experiment with RDB cubes, based on the ODBC connector to Snowflake.
One use of these cubes would be to store specific detailed versions of some large cubes (currently cubes more than 30 or 40Gb, soon to reach 50Gb).
However, since RDB cubes cannot have versions, there is no simple way to design reports that would use aggregated versions while keeping the possibility to drill down until the most granular level (level stored in the external SQL table).
Idea: allow MDB versions for RDB cubes.
Benefits :
- Load data directly through a simple "Align" operation, using the ongoing selections
- Single entry point to access the data when building the front-end, allowing easy drill down / drill anywhere without the need for a drill-through setup
- Ability to use the external SQL engine to aggregate the data to load at the expected versions level
It seems that such a thing was possible in past versions, maybe some people will remember ?
Thanks for considering the idea.
Etienne