Skip to Content
1
Former Member
Oct 29, 2018 at 12:09 PM

Why is Key Figure "Requested Quantity" displayed in each column on Excel Data View?

176 Views Last edit Oct 29, 2018 at 12:11 PM 2 rev

Hi IBP Expert,

I have loaded the through template in keyfigures "Requested Quantity" and "Sales Order(Confirmed Quantity)" from a excel file to IBP manually (through data integration job).

Example:

Sales Order (101500) has 16 Requested Quantity on 01.01.2016

When I create a new Data View in Excel, then i see, that KeyFigure "Requested Quantity" was not displayed only on column 01.01.2016 but also on other column whole row.

How should I configure the Excel or IBP settings, so that, a Keyfigure is displayed only on a column, when this sales order has been created?

Thanks and Regards

Attachments

ibp-1.png (43.8 kB)
ibp-2.png (37.4 kB)