Skip to Content
avatar image
Former Member

calendar wise Opening / closing stock restricts repeatation for all feilds by month year

Hi All,

I have created one BEx query on 0IC_C03 info cube . Query is fetching the data for

1. Opening stock

2. Closing stock

3. safety stock

4. Material consumption

The report will give the output Material & Plant wise for the mentioned key figures in Columns and Materiel and Plant in Rows view.

I am facing issue is that , i want Opening and Closing stock value to be shows calendar year wise , and Safety stock and Material consumption values normally without calendar year wise .

So that should not be repeated for all the month and years .

Please suggest how i can do the same.

Waiting for your positive response.


Regards.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 05, 2017 at 07:13 AM

    Hi,

    Set the keyfigures in the columns

    Set the calendar year month underneath the keyfigures in your columns

    you can set columns --> properties --> set as hierarchy and by default to level of Keyfigures.

    Result:

    The user can choose to see the spread over time by drilling down on the key figure

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 08, 2017 at 07:54 AM

    Hi Koen,

    Can you please show me the Rows and columns structure ?

    I have done the same way you have shown , but it is not providing the calmonth wise data in column.

    Regards,
    Sanjay

    Add comment
    10|10000 characters needed characters exceeded