Skip to main content

Notifications

Microsoft Dynamics NAV forum
Answered

Dimension Combinations in NAV and specifically Dimension Sets

Posted on by 98

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?

  • Verified answer
    Ron.McV Profile Picture
    Ron.McV 98 on at
    RE: Dimension Combinations in NAV and specifically Dimension Sets

    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

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Dimension Combinations in NAV and specifically Dimension Sets

    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/.../

    svirlan.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.

  • Ron.McV Profile Picture
    Ron.McV 98 on at
    RE: Dimension Combinations in NAV and specifically Dimension Sets

    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.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 32,744 Moderator on at
    RE: Dimension Combinations in NAV and specifically Dimension Sets

    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.

  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 11,423 User Group Leader on at
    RE: Dimension Combinations in NAV and specifically Dimension Sets

    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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Dynamics 365 Community Newsletter - September 2024

Check out the latest community news

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,524 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,469 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans