A possibility to set consolidation factors depending of several dimensions would dramatically increase the slowly changing dimensions (SCD, see Kimball's bibles) management possibility of Jedox OLAP server.
Example:
in 2014 is my Regions hierarchy as follows:
West
=> France
=> Germany
=> Belgium
East
=> Poland
in 2015 Germany will be moved in East:
West
=> France
=> Belgium
East
=> Poland
=> Germany
To manage that I must have 2 different element "West" and "West-2015". That's ok for such a trivial example but when dealing with P&L hierarchy for instance that can really become very complex, especially for the users and also when using YTD agregations.
A consolidation factor that would be dependent of other dimensions would be awesome. This would allow following:
West
=> France Conso. fact 2014 : 1 ; conso factor 2015 : 1
=> Germany Conso. fact 2014 : 1 ; conso factor 2015 : 0
=> Belgium Conso. fact 2014 : 1 ; conso factor 2015 : 1
East
=> Poland Conso. fact 2014 : 1 ; conso factor 2015 : 1
=> Germany Conso. fact 2014 : 0 ; conso factor 2015 : 1
