tag:blogger.com,1999:blog-1492436440038408053.post2998133620068066757..comments2024-03-11T16:18:52.884+05:30Comments on Mohana's D365 Business Central & NAV Blog: How to include Dimensions in Conf. Package Table Fields while using Rapid Start Services in NAV2013Mohanahttp://www.blogger.com/profile/18444553810609906473noreply@blogger.comBlogger9125tag:blogger.com,1999:blog-1492436440038408053.post-58476435069142879662017-02-24T15:14:57.345+05:302017-02-24T15:14:57.345+05:30Exactly, that's the way to do it as Microsoft ...Exactly, that's the way to do it as Microsoft describes in the below link:<br />The suggested solution by Mohana does not work in Dynamics NAV2016.<br /><br />https://support.microsoft.com/en-us/help/2780200/dimensions-that-are-added-in-an-excel-worksheet-are-not-assigned-to-the-records-after-you-import-the-excel-worksheet-in-microsoft-dynamics-nav-2013<br /><br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1492436440038408053.post-60255010490201603722016-11-01T17:39:05.989+05:302016-11-01T17:39:05.989+05:30Instead of modifying the Page object, I just used ...Instead of modifying the Page object, I just used "Config. Worksheet" instead. <br />I added table 81 to a new row, then "Assign Package" and selected my rapidstart Configuration Package, then clicked the "Dimensions As Columns".<br />From now on shortcut dimensions can be exported and imported to/from Excel. Did this by action "Export to Template" (Excel) from Config. Worksheet.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-1492436440038408053.post-4601807760579217922016-08-30T03:27:54.117+05:302016-08-30T03:27:54.117+05:30Mohana,
Thanks for this post!
Mohana,<br />Thanks for this post!<br />Iaroslavnoreply@blogger.comtag:blogger.com,1999:blog-1492436440038408053.post-88464037226581245422015-12-02T12:16:20.796+05:302015-12-02T12:16:20.796+05:30Thanks for posting this Jakob--just what I needed!...Thanks for posting this Jakob--just what I needed!<br /><br />BradleyUnknownhttps://www.blogger.com/profile/14951842237413013767noreply@blogger.comtag:blogger.com,1999:blog-1492436440038408053.post-72179558617897679342014-04-19T03:47:32.282+05:302014-04-19T03:47:32.282+05:30Hi all,
Here is a work around.
1. Add the column...Hi all,<br /><br />Here is a work around.<br /><br />1. Add the columns that are missing to the table in the Excel template.<br />2. Select the column header on one of the missing dimensions.<br />3. Right click header of the table and choose the XML submenu -> XML source<br />4. You will see the dimensions but without a red star which means that it is not mapped to any data in the Excel table.<br />5. Right click the unmapped dimension and select which column it must be associated with.<br /><br />Best,<br /><br />JakobAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1492436440038408053.post-19853599556358653572014-04-19T03:29:07.382+05:302014-04-19T03:29:07.382+05:30Hi again,
I have got the problem. The dimensions ...Hi again,<br /><br />I have got the problem. The dimensions are not exported to Excel.<br /><br />Please advice,<br /><br />JakobAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1492436440038408053.post-55961257906732748702014-04-19T03:27:00.811+05:302014-04-19T03:27:00.811+05:30Hi Mohana,
Great tip.
I noticed that working wit...Hi Mohana,<br /><br />Great tip.<br /><br />I noticed that working with Rapid Start is fast on your machine. With me it is painfully slow. Are there any server options that needs to be configured for it to work faster?<br /><br />Thanks,<br /><br />JakobAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1492436440038408053.post-61531658035666722422014-04-02T19:46:04.678+05:302014-04-02T19:46:04.678+05:30Mohana,
I am also running into the same issue. I...Mohana,<br /><br />I am also running into the same issue. I added the "Dimensions as Columns" boolean and could see all the Dimensions when I went to Export the Template to Excel, the Dimensional fields to not flow to the template. I've noticed that there is no value in the Processing Order or Related Table ID fields when the Dimensions fields were added to the Table 81, but those fields seem to be non-editable so I can't put any values in there. I must be missing something simple but I cannot figure out what it is.<br /><br />Any advice would be appreciated.<br /><br />ThanksAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-1492436440038408053.post-47811648972685438852014-02-20T07:32:39.409+05:302014-02-20T07:32:39.409+05:30Hi Mohana,
Thanks for sharing.
however, i'm a...Hi Mohana,<br /><br />Thanks for sharing.<br />however, i'm able to see the dimension field on the field selection, but i still couldn't export it to excel. example, [Area (dimension), DEPARTMENT (dimension)] as column in excel.<br />please help and advise.<br /><br />Thank You.Anonymousnoreply@blogger.com