Time-dependent Nav-attr type CHAR in BEx
I detected the following problem: my cube has a characteristic (Colective Partner nr.) which has master data and navigation attributes, namely the one called Colective Partner nr._Name (CHAR 50). The characteristic is most times empty, only some lines have this information. When a query is made in the cube, if I don't include the attribute Colective Partner nr._Name I get 100% of the lines in the cube. When I had the attribute Colective Partner nr._Name to the query I get only 15% of the lines, only the ones which have information in this field.
I was expecting to see all the lines, of course 15% would show the Name filled and the rest would have it blank. Why doesn't this work? Am I missing something, or is it "the way it works"?
Thanks in advance.