Query with dimensions (no global)

zutzu
Member Posts: 86
I want to create a query with information about sales line table and dimensions. The global dimensions are in the same table. But i want to add the value of the third dimension area.
I add the 480 (dimensión set entry) table and i link it with the field dimension set ID (dataitemlink)
DataItemLink: Use Default Values if No Match
Like a want only the third dimension (area) in dataitemtablefilter, i filter: dimensión code=CONST(AREA).
When it has value in area, it shows ok.
But when there is no value in área, the register is not shown.
I think that the problema is that if i filter, "Use Default Values if No Match" does not work as usual (if there is no value in table 480, register may be shown, but area value will be 0).
Is there any solution?
SALES LINE
Dimension set ID
10 10000 100
10 20000 101
11 10000 102
11 20000 103
DIMENSION SET ENTRY
Id Dim code Dim value code
100 Area A10
100 Code C
101 Area A11
103 Area A12
And the query:
Nº Line Area
10 10000 A10
10 20000 A11
11 20000 A12
Nº 11and line10000 is not shown. I want all the values of sales line and the value of tha área (or 0 if it has no value)
Thanks!
I add the 480 (dimensión set entry) table and i link it with the field dimension set ID (dataitemlink)
DataItemLink: Use Default Values if No Match
Like a want only the third dimension (area) in dataitemtablefilter, i filter: dimensión code=CONST(AREA).
When it has value in area, it shows ok.
But when there is no value in área, the register is not shown.
I think that the problema is that if i filter, "Use Default Values if No Match" does not work as usual (if there is no value in table 480, register may be shown, but area value will be 0).
Is there any solution?
SALES LINE
Dimension set ID
10 10000 100
10 20000 101
11 10000 102
11 20000 103
DIMENSION SET ENTRY
Id Dim code Dim value code
100 Area A10
100 Code C
101 Area A11
103 Area A12
And the query:
Nº Line Area
10 10000 A10
10 20000 A11
11 20000 A12
Nº 11and line10000 is not shown. I want all the values of sales line and the value of tha área (or 0 if it has no value)
Thanks!
0
Answers
-
Hi, did you solve it? I have the same problem.0
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