An option to automatically flatten all hierarchy tables based on a give dimension (i.e. Account from G/L). Use case: a user defines 3 hierarchy tables based on Account table. Based on these 3 flattened views will be created; when adding the Account table as a dimension in OLAP user is prompted if all 3 hierarchies should be added to the dimension. Ideally dimension level relations would be automatically set also.
Option to flatten hierachy table