Deleting Global Dimensions

Savatage
Member Posts: 7,142
We have had global dim 1 & 2 set for 4 years and I'd like to delete them all. We simply don't use them as I thought we would way back when. And since it eating space I'd like to kill them.
Is simply changing them back to "Blank" enuf to get the job done.
And any estimate on time that it would take would be nice.
(We're problably talking about getting rid of 30 million records)
thanks
Is simply changing them back to "Blank" enuf to get the job done.
And any estimate on time that it would take would be nice.
(We're problably talking about getting rid of 30 million records)
thanks
0
Comments
-
Under general ledger function menu button, you should see the option to change them to blank. This step will remove them from all the tables.
This step will take a long time. I would run the client on server.
This will take a couple of hours.
The next step would be to delete the following tables. a couple of hours.
Dimension
Dimension Value
Dimension Combination
Dimension Value Combination
Default Dimension
Ledger Entry Dimension
Journal Line Dimension
Document Dimension
Production Document Dimension
Posted Document Dimension
G/L Budget Dimension
Dimension Translation
IC Dimension
IC Dimension Value
IC Document Dimension
Document Dimension Archive
FA Allocation Dimension
Item Budget Dimension
Bank Rec. Line Dimension
You have rebuild the analysis views if you are setup any dimension.
a couple of hours0 -
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions