web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Dimension Combinations...
Small and medium business | Business Central, N...
Answered

Dimension Combinations in NAV and specifically Dimension Sets

(0) ShareShare
ReportReport
Posted on by Ron.McV 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?

I have the same question (0)
  • Suggested answer
    Dallefeld Profile Picture
    Dallefeld 211 User Group Leader on at

    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.

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,111 Moderator on at

    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.

  • Ron.McV Profile Picture
    Ron.McV 98 on at

    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 1,111 Moderator on at

    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.

  • Verified answer
    Ron.McV Profile Picture
    Ron.McV 98 on at

    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

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,606

#2
YUN ZHU Profile Picture

YUN ZHU 931 Super User 2025 Season 2

#3
Jainam M. Kothari Profile Picture

Jainam M. Kothari 773 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans