Hi,
In FA model in the video guide it shown – add the dimension as a string. In mapping we binded our created asset book – calculated feild with rollforwardtmp.
Then in excel mapping how is BU field binded in FixedAssetgrouptotal ??
1. We add BU dimension field in Asset roll forward in Data model.
2. Then we added asset book table , add BU as calculated filed. we give a relation of Fin dim BU with dimension set.
3. We link Asset book table with Assetrollforward tmp table by using where, and formula.
—– Till this is its’s very clear to me ——–
When we added BU in excel template and our trying to map.
Your BU created field shows under Assetrollforward(totalsbygroup) recold list – but in step 1 we create in assetrollforward and in step 3 we link to tmp not tmp totals by group , then how is it binding and showing data ?
Hi,
I don’t know where exactly the problem lies. Will try to export the sample that I setup and used in this demo and send it to you so that you can have a look. Hope this will help.
Best regards,
Ludwig
Dynamics 365FO/AX Finance & Controlling 
Pingback: DO YOU KNOW … The right way to add monetary dimensions to the fastened asset rollforward report? – Ahosti – Latest IT News Trends
Hi,
In FA model in the video guide it shown – add the dimension as a string. In mapping we binded our created asset book – calculated feild with rollforwardtmp.
Then in excel mapping how is BU field binded in FixedAssetgrouptotal ??
LikeLike
Can you elaborate because I dont understand the question. Thanks
LikeLike
Hey Ludwig,
As per the video,
1. We add BU dimension field in Asset roll forward in Data model.
2. Then we added asset book table , add BU as calculated filed. we give a relation of Fin dim BU with dimension set.
3. We link Asset book table with Assetrollforward tmp table by using where, and formula.
—– Till this is its’s very clear to me ——–
When we added BU in excel template and our trying to map.
Your BU created field shows under Assetrollforward(totalsbygroup) recold list – but in step 1 we create in assetrollforward and in step 3 we link to tmp not tmp totals by group , then how is it binding and showing data ?
LikeLike
Hi,
I don’t know where exactly the problem lies. Will try to export the sample that I setup and used in this demo and send it to you so that you can have a look. Hope this will help.
Best regards,
Ludwig
LikeLike