Skip to Content

How to display Fat/Medium/Slow moving materials in Query

Hi All,

i have a requirement like this:

we have no of issues 0NO_VAL_ISS (KF).Now i need to display fast moving(F),slow moving (S) and non moving (N)materials in the report.

F:If a material is issued to prod at least one in each month over a period of last 12 months

S:If a material is issued to prod only on six different months over a period of past 12 months

N:if a material is not issued to prod as all over a period of past 12 months.

how can get this? any ideas?


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2005 at 04:43 AM


    Adding to what Anil has already stated.

    I am really not sure why you would need a Multiprovider, as I understand the 0NO_VAL_ISS (KF) must be with reference to Material, so I guess 0Material should be available in the Cube. Correct me if I am wrong.

    From the reporting aspect

    Instead of restricting each column of the 12 columns by a period you could use a variable for Period and use offsetting in the rest of the 11 columns to make it more flexible. (for sure you would need 12 columns as Anil stated, and you can make them hidden)

    You could have a formula column(hidden) in the report which count the number of issues

    Formula = COUNT ( column1 ) + COUNT ( column2 ) + COUNT ( column3 ).....and so for the 12 periods

    At the end you can have a three status column like

    F represented by

    (Formula >= 12 )

    S represented by

    (Formula >= 6 AND Formula <12)

    N represented by

    (Formula = 0 )

    The above will again give you a status of 1 if the condition is satisfied, not sure how you can see F, N or S as the value.

    If you do the above you can get all the Fast/slow/medium moving items in the same report.

    Hope it helps.



    Message was edited by: Anurag Khungar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2005 at 04:14 AM


    1) Define a Multi provider on 0MATERIAL and the cube ( which has 0NO_VAL_ISS (KF).).

    2)Drag and drop 0MAterial in to the rows area. (there should be only one cahracterstic in the rows, and that is material).

    3) Drag and drop the KF 0NO_VAL_ISS 12 times to columns area and restrict each one with separate Period.And hide them all.

    say column1,column2,...column12.

    4) Create a formula like this, and hide it :

    (column1> 0 AND column2 > 0 AND column3 > 0 AND column4 > 0 ....column12 >0 )

    5) Create a condition for the report as Formula = 1.

    So this report display the all Fast moving materials .

    Similarly we need to 2 more reports for displaying slow moving (S) and non moving (N)materials seperately.

    I will Let you Know , if all are possible in a single report.

    With rgds,

    Anil Kumar Sharma .P

    Message was edited by: Anil Kumar Sharma

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.