on 05-14-2009 8:20 AM
Good day
I have searched SDN already, but could not find an anser for my issue.
I have created a Structure in columns which include the characteristic "Model Key" as follows:
BUS = Model Keys (BUS and CVLA)
FUSO = Model Keys (MCTR and MFUS)
In the query results the user would like to see the key figure results per the structure = BUS and FUSO, but still wants to see the detail of the characteristic "Model Key". Thus the results should be:
STRUCTURE: MODEL KEY: Keyfigure 1:
BUS : BUS : 20
BUS : CVLA : 1
FUSO : MCTR : 10
FUSO : MFUS : 4
But what the query is returning is:
STRUCTURE: MODEL KEY: Keyfigure 1:
BUS : BUS : 20
BUS : CVLA : 1
BUS : MCTR :
BUS : MFUS :
FUSO : MCTR : 10
FUSO : MFUS : 4
FUSO : BUS :
FUSO : CVLA :
Why is it returning the extra lines (line 3,4 and 7 and 8)?
Thanks for your time.
Have a nice day
Cj
Thanks, answered
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
That is the standard operation with structures. If you have a structure and add a drill down by a characterisitic, all values are displayed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.