上記のように３かつBのディメンションに入力される値のみを取得する方法はありますか？
※3-B(ラインアイテム)全てに100が入る形でも問題ありません
リストラインアイテムを使用したLOOKUPは試したのですが、Source module.valueが全項目それぞれ出てきました。
上記の他にSummaryなどの設定が必要でしょうか？
【追記】ディメンションを削除したところ、臨む値のみを取得することができました
TristanS ありがとうございました
Yes there is a way.
Step 1: Create a constants module with the following line items
SYS001 Constants
Line Item
Format
Formula
B Constant
List for B
finditem('List for B', "B")
3 Constant
List for 3
finditem('List for 3', "3")
Step 2:
Target module to have dimension specified in the rows of your example.
Value will be
Target module.target line item = Source module.value[Lookup: 'SYS001 Constants'.'B Constant', Lookup: 'SYS001 Constants'.'3 Constant']
Dear Hive Mind, Do we have a way to get the history of a particular List Item, from its creation into a model up until its removal ? I am trying to chase when / how an item has been added into a model and how / when it would have been deleted and then recreated with the same code. Is there a pattern (manual or API) to get…
I have an action in a process which is getting failed since 2 days when run via CloudWorks with below error . No issues when run manually . Same error occurs when run manually but as a warning "Import complete but with failures" This action is running since almost a year without any issue . No change has been made to…
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
