Skip to Content
0

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

Apr 04, 2017 at 12:16 PM

48

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Koen Hesters Apr 05, 2017 at 07:13 AM
0

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


Share
10 |10000 characters needed characters left characters exceeded
sanjay gajera Apr 08, 2017 at 07:54 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded