cancel
Showing results for 
Search instead for 
Did you mean: 

Why is the attribute repeatinng for the same article no ?

Former Member
0 Kudos
32

Dear Experts,

In one of the queries that i've created, the requirement is to use this attribute Leadtime which is of Numc data type. This is an attribute of an Charateristic Article No. Anyway, when i executed the report, with this leadtime in columns, along with other KF's. The result set had too many columns that when i tried to export it to Excel, i got a msg that there are too many cells.

It looked something like this:

Leadtime 10--


10
10
--20---(so on)

KF1----


KF2

Article no: 123--


333--


444

Overrall Result--


333--


444

So i tried moving Leadtime to rows, the result set looked like this:

Article no-----Leadtime- KF1----


KF2

123--


10
333
--


444

123--


10
555
--


555

Overrall Result--


888--


999

However we want Leadtime to show up only once for each item, like for ex: for article 123 the leadtime is 10, I'm not sure why this is repeating. as Article 123 10 and then the next line for the same article 123, the leadtime is 10.

Can you please suggest how do i correct this, based on your suggestions, i'll approach our business.

Thank you.

Message was edited by:

NewYorker

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi

Plz check property of your lead time : if its been speficaly said "DO not display result"...

Try setting it to " dsiplay Result" and then sum of this..

hope it helps

Gaurav

Assign pts if it helps

Former Member
0 Kudos

Hi Gaurav,

Thank you for your suggestion. I've just found out that it's not a KF, it's an attribute of numeric data type. I'e rephrased my question, can you please help me with that. (As i said earlier, i'm relying on a BA's explanation, since they arew orking on my auth's, so i apologize for the wrong explanation)

Thank you...

Former Member
0 Kudos

H,

Not sure wht you mean by "attribute of numeric data type".

Did you mean to say tht its Replacement path on characteristics variable??

Anyways pl chk with my earlier suggestion.

Gaurav

Assign pts if it works

Answers (0)