Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.6K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 295 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 993 SQL General
- 384 SQL Performance
- 34 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
fields in an active key may not exceed...
Boom-Box
Member Posts: 27
Hello all!
I am currently facing a width restriction in the key in the Item Analysis View Entry table.
Since this kind og problems have already been posted, though I can't find none with a solution, I will try to give you some more detail through all the problem.
1.In the Inventory analysis views, I had the need to make my views filtered by Gen. Bus. Posting Group and Gen. Prod. Posting Group.
2. Fields and filters were created in analysis Columns and analysis view entry tables.
3. CodeUnit 7110 was modified in order to filter the results to item analysis view entry properly.
4 opening analysis "Analysis Report" in "Inventory"->A&R, if we have 2 columns eactly the same, but one has a posting group filter we get the exact same value on both. When we drill down, we get the correct entries for each. Passing both for Excel, we get the correct (different) sums on each column. Naturally, the column which is filtered has less values than the other.
Now I was trying to add this fields to the key in analysis view entry but i get the classic error:
"The fields in an active key may not exceed 252 bytes. The size of the Analysis Area,Analysis View Code,Item No.,Item Ledger Entry Type,Entry Type,Source Type,Source No.,Dimension 1 Value Code,Dimension 2 Value Code,Dimension 3 Value Code,Location Code,Posting Date,Entry No.,Gen. Bus. Posting Group,Gen. Prod. Posting Group key fields in the Item Analysis View Entry table is 276 bytes."
Any help will be highly apreciated!
Thanks In Advance,
Miguel Andrade
I am currently facing a width restriction in the key in the Item Analysis View Entry table.
Since this kind og problems have already been posted, though I can't find none with a solution, I will try to give you some more detail through all the problem.
1.In the Inventory analysis views, I had the need to make my views filtered by Gen. Bus. Posting Group and Gen. Prod. Posting Group.
2. Fields and filters were created in analysis Columns and analysis view entry tables.
3. CodeUnit 7110 was modified in order to filter the results to item analysis view entry properly.
4 opening analysis "Analysis Report" in "Inventory"->A&R, if we have 2 columns eactly the same, but one has a posting group filter we get the exact same value on both. When we drill down, we get the correct entries for each. Passing both for Excel, we get the correct (different) sums on each column. Naturally, the column which is filtered has less values than the other.
Now I was trying to add this fields to the key in analysis view entry but i get the classic error:
"The fields in an active key may not exceed 252 bytes. The size of the Analysis Area,Analysis View Code,Item No.,Item Ledger Entry Type,Entry Type,Source Type,Source No.,Dimension 1 Value Code,Dimension 2 Value Code,Dimension 3 Value Code,Location Code,Posting Date,Entry No.,Gen. Bus. Posting Group,Gen. Prod. Posting Group key fields in the Item Analysis View Entry table is 276 bytes."
Any help will be highly apreciated!
Thanks In Advance,
Miguel Andrade
0
Answers
RIS Plus, LLC
MVP - Business Apps
I know what this mistake means, I was triing to figure out if there's a workaround we can use in such a case...
any ideas?...
RIS Plus, LLC
MVP - Business Apps
Well I agree that's a very funny joke, but the danger is that someone might think you were serious, so you should put a
Thank you for your replies,
I had to solve this the other way around... where we had a "calcsums", I had to create local records vars and make the sum "manually" through a "repeat..until" cycle.
Thanks again,
Miguel Andrade
P.S.: About that fileds' names length, it's not that related with the key size...it is related with the amount of bytes each type (decimal, text, boolean) requires.