Options

Query with dimensions (no global)

zutzuzutzu Member Posts: 86
edited 2016-03-23 in NAV Three Tier
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!

Answers

  • Options
    Hugo4711Hugo4711 Member Posts: 6
    Hi, did you solve it? I have the same problem.
Sign In or Register to comment.