I believe that the actual Dimension Set (Dimension Combination(s)) do not exist until a transaction exists. So from reporting matrix for Power BI or Workday Adaptive if you get a transaction for that combination is built you have an null. Is there a way across multiple companies to populate out these Dimension Sets upon the creation of a Dimension:
Department
Product Group
Business Class, etc.
I have taken a new job with an old NAV (long time) user company which has a lot of company and a lot of companies across countries. Do you know of a tool that helps catch when Dimension are created? And more specifically Dimension sets. And until used the set does not exist (like a template). We export GL data to Workday Adaptive and the disconnect causes a gap. Does not get cleaned up until the refresh happens when the Dimension set is available. Not sure if this is a job to run or some tool and or 3rd party?
Again thanks. No not trying to do this back to individual company’s but creat a master list or get the sets populated for sets on additions or new dimensions
I’ll look at links tomorrow Tks
It is important to understand that the dimension sets are and should be company specific. So any effort to try to sync the dimension sets between companies even though they may have the same dimension structure is more or less domed to fail.
When you work with dimension sets it is important that you do it through the correct way. Business Central and NAV have a specific codeunit called DimensionManagement that have pre made functions for maintaining the dimension sets.
I have AL code that does what you are looking for but i guess you need CAL code in your version. The best blog post i could find while typing is these two:
robertostefanettinavblog.com/.../
I hope they can help your developers get some idea about how this should be done. If you think the AL code would help as well, just send me a message.
But again - it is important that you do not even try to synch the dim sets between companies. Dimensions and dimension values can be synced. But trying to synch dim sets brings you on a path to certain failure.
Inge
thank you kindly. I thought I saw a post on a ArcherPoint.com blog about this or referenced to it wih some C\SIDE code examples. Get to find someone who has done this before. If do able I'll need to coach our developer team in this direction.
I guess the other way is to do a consolidation company which for the Dimension Sets would create the Dimension (SET) Combinations to be used as a mashup dataset against the company data.
Again thanks. If you remember or hear of a posting related to this or someone with a whitepaper, forward it please.
You can populate the dimension sets up front but you will have to do it in code. So in theory you can have the dimension set populated every time there is a change is one of the dimension values or a new dimension is added.
If you want a functionality like that you need to take help from a AL/CAL developer.
Not sure exactly what data you are wanting but you might consider a consolidated company. When you consolidate, the posting routine will create new dimension sets. Then you can export the consolidated company's data to Workday Adaptive.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,524 Super User 2024 Season 2
Martin Dráb 228,469 Most Valuable Professional
nmaenpaa 101,148