on 11-19-2014 6:32 AM
Hello Experts
I have come through one issue in which I want Load Bill of Material Master Data.
Regards
Bhagyesh Ravange
Hello All,
It has been achieved by making following changes.
1) Under EPM - User option -> Others -> Select Force Symmetric Refresh for Large Asymmetric Axis.
2) Under EPM - Sheet option -> General -> Select Remove Empty and Zero Values.
The problem with Remove Hide was that it first Expand the Template and was hitting maximum Limit of 150000 cells of BPC limit and Excel limit of 1048576. Hence, by selecting first option error of 150000 was not coming although error of 1048576 of Excel limit was coming. By selecting Remove empty and zero values it is now working fine.
Regards
Bhagyesh Ravange
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
ok, thanks for letting us know.
Andy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Andy,
Sorry my attachment didn't come.
We have more than 5000 finished goods along with more than 30000 (RM/SFG). Also same RM/SFG is being used for more than one Finished goods.
Requirement here is to load Bill of Material master data into BPC and also maintaining the relation between Product and Component. As the same RM/SFG is used for more than One Product I am not able to load directly Master data as it is not allowing to load duplicate ID. Hence, I planning to concatenate Product and Material (eg: 30000001_10000001) and load the same, also making Product (eg: 30000001 ) as parent of Component/Material (30000001_10000001).
In the below Table, Product is Finished Goods and Component is Raw material and Semi finished Goods.
Product | Quantity | UOM | Componenet | Quantity | UOM |
30000001 | 1 | KG | 10000001 | 2 | KG |
10000002 | 0.5 | KG | |||
20000001 | 1 | LTR |
Kindly let me know is this the correct methodology or is there any better way of doing it.
Regards
Bhagyesh Ravange
Hello Vadim,
In case If I create two separate Dimension then also I have to maintain the relationship between FG and RM either through Hierarchy or Properties, so that it appear as mentioned below. Also I need to Concatenate the Product and Material code because the same Component is used in more than One product.
Product | Component | Quantity |
30000001 | 10000001 | 2 |
10000002 | 0.5 | |
20000001 | 1 | |
30000002 | 10000001 | 2 |
10000003 | 0.25 | |
20000001 | 1 |
Regards
Bhagyesh Ravange
Hello Vadim
Thanks for your prompt reply,
I mean to say when I select particular plant (eg Plant 1000) then in the report for that particular Plant I should get 100 products along with the component used to manufacture that product.
In Plant 1000 there are 100 finished products and 2000 Raw material. Hence If I create 2 separate Dimension for Product and Raw material then in my report each product will have 2000 raw material as mentioned below.
Product Dimension | Raw Material Dimension |
30000001 | 10000001 |
10000002 | |
10000003 | |
…… | |
100002000 | |
30000002 | 10000001 |
10000002 | |
10000003 | |
…… | |
100002000 |
But I want m report as mentioned below
Product Dimension | Raw Material Dimension |
30000001 | 10000001 |
10000014 | |
10000023 | |
30000002 | 10000005 |
10000029 | |
10000125 |
Means I want only those Component which are used to manufacture that product
Regards
Bhagyesh Ravange
Just tested the following approach:
Cube dimensions/members
TIME: TMATRIX, normal time members
ENTITY: EMATRIX, normal entity members
CATEGORY: CMATRIX, normal category members
ACCOUNT: AMATRIX, normal account members
FG: FG1,FG2...
RM: RM1,RM2,...
Where TMATRIX,EMATRIX,CMATRIX,AMATRIX - base members created to store FG/RM matrix
FG/RM Matrix is loaded using input schedule:
Page axis (fixed members):
TIME: TMATRIX
ENTITY: EMATRIX
CATEGORY: CMATRIX
ACCOUNT: AMATRIX
Column axis:
FG: all members
Row axis:
RM: all members
"1" was entered on the intersections of FG and RM according to FG specifications.
Reporting:
2 reports were created with shared row axis:
First report:
Page axis (fixed members):
ENTITY: EMATRIX
CATEGORY: CMATRIX
ACCOUNT: AMATRIX
Column Axis (fixed member)
TIME: TMATRIX
Row axis (will be shared with second report):
FG: Context (Member and base members)
RM: ALL base members
In Edit Report -> Filtering was set with criteria TMATRIX=1
Second report:
Page axis
ENTITY: Context: some entity (real)
CATEGORY: Context: some category (real)
ACCOUNT: Context: some account (real)
Column Axis
TIME: Context (Member and base members)
Row axis - from first report!
Result:
First report is executed with suppression of rows by filter.
Then second report will be executed using row axis prepared by first report!
Vadim
User | Count |
---|---|
5 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.