I have an existing hierarchy in a dimension and I want to insert a level in the middle of the hierarchy. An analogy would be that I have a Fiscal Year-Fiscal Month hierarchy and I want to insert a Fiscal Quarter level in the middle.
I'm trying to analyze the impact on the database from a size and speed perspective.
If no aggregations are saved in the database then will the insertion of a level in the hierarchy take up more disk space?
What will be the effect on query speed with this extra level? Will a Fiscal Year aggregated value take longer to retrieve from a measure group with the additional child in the hierarchy?
What factors should I consider to estimate the effect (number of distinct values in the new level, size of the dimension table, etc.)?
P.S. First time on the site so I'm not sure how many points to attach to this.