Let Legal Entity dimension drive Local Currency output in Currency dimension

Joined
Feb 27, 2020
Messages
34
Likes
21
Points
8
#1
If you have a dimension like Legal Entity that has a one to one for Currency, and a separate currency dim, in a workview you can drive the Local currency to be automatically referenced by what is selected in the Legal Entity dim selector. This only works when both dims are in the selector area (not in rows or columns)

  1. Create a 2 dimension mapping cube 1 to 1 eg LE to Currency measure : TIP: you want the parent consolidations mapped where possible
  2. In workview on Currency dim Insert using Formula (reporting currency AUD in this example) eg
    Code:
    IF(LINK("MapLE", ["Currency"]) = "", "AUD",LINK("MapLE", ["Currency"]) )
 
Last edited: