How can we improve Jedox Software?

Historize consolidation factors

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

14 votes
Vote
Sign in Sign in with Jedox AG
Signed in as (Sign out)
You have left! (?) (thinking…)
P. Lorentz shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

0 comments

Sign in Sign in with Jedox AG
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base