Inventory Valuation: Material Prices and Inventory Values Query
I have been asked to install the cube 0COPC_C04 in BI. The datasource that is recommened for this cube is 0CO_PC_ACT_04, but in R3 that datasource is not populated.
What is wanted is to have the price and value of inventory material in one report. I can get the price from one datasource and the value from another, but the datasource that has the value information (from what I can find) 0CO_PC_ACT_02 only allows full loads and there are millions of records.
I am fairly new at setting up extractors for use in BI and need to know if there is another datasource to use or a trick to getting the needed information into BI.