cancel
Showing results for 
Search instead for 
Did you mean: 

Structuring Bill of Material in BPC

bhagyesh_ravange
Active Participant
0 Kudos

Hello Experts

I have come through one issue in which I want Load Bill of Material Master Data.

Regards

Bhagyesh Ravange

Accepted Solutions (1)

Accepted Solutions (1)

bhagyesh_ravange
Active Participant
0 Kudos

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

former_member186338
Active Contributor
0 Kudos

Interesting!

It means that with Remove Empty or Zero Values it's done on the server side? Opposite to filter - on the client side...

The effect is the same!

Vadim

former_member186338
Active Contributor
0 Kudos

Yes, tested!

I have replaced in my sample filter with the option "Remove Empty or Zero Values" and the report works much faster!

Vadim

Answers (1)

Answers (1)

Former Member
0 Kudos

ok, thanks for letting us know.

Andy

bhagyesh_ravange
Active Participant
0 Kudos

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.

ProductQuantityUOMComponenetQuantityUOM
300000011KG100000012KG
100000020.5KG
200000011

LTR

Kindly let me know is this the correct methodology or is there any better way of doing it.


Regards

Bhagyesh Ravange

Former Member
0 Kudos

Hi,

I've worked on a project and we decided to load the top 20 products, as the amount of combinations are too high, you have to take 5000 times the number of components each product have.

yes, you have to concatenate the product with the components if you want to load into BPC.

Andy

former_member186338
Active Contributor
0 Kudos

Hi Bhagyesh,

First - why not to have 2 dimensions for FG and RM?

Second - you will have real performance issues...

Vadim

bhagyesh_ravange
Active Participant
0 Kudos

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.

ProductComponentQuantity
30000001100000012
100000020.5
200000011
30000002100000012
100000030.25
200000011

Regards

Bhagyesh Ravange

Former Member
0 Kudos

Hi,

There is no way to maintain the relationship if you have it in 2 dimension.

Andy

former_member212095
Participant
0 Kudos

Hello Bhagyesh

You can create 2 dimension & while loading master data for FINISHED GOODS use ID=0RM+*STR(_)+ID.

Where 0RM is Infoobject for Raw material.

Regards

former_member186338
Active Contributor
0 Kudos

What do you exactly mean by "I have to maintain the relationship between FG and RM"? What for?

You can have some dummy members of other dimensions to fill relationship matrix between FG and RM for FG (1-yes,empty - no)

Vadim

bhagyesh_ravange
Active Participant
0 Kudos

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 DimensionRaw Material Dimension
3000000110000001
10000002
10000003
……
100002000
3000000210000001
10000002
10000003
……
100002000

But I want m report as mentioned below

Product DimensionRaw Material Dimension
3000000110000001
10000014
10000023
3000000210000005
10000029
10000125

Means I want only those Component which are used to manufacture that product

Regards

Bhagyesh Ravange

former_member186338
Active Contributor
0 Kudos

Empty line suppression?

former_member186338
Active Contributor
0 Kudos

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

bhagyesh_ravange
Active Participant
0 Kudos

Hello Vadim,

Thanks for your reply,

I have 2 questions:

1) I need to create 2 separate Dimension for Product and Raw Material respectively, correct?

2) In Edit Report -> Filtering, I need to give filtering based on Columns, correct?

Thanks & Regards

Bhagyesh Ravange

Former Member
0 Kudos

Do you know how much work is needed to create the matrix?

The suggested solution is not gonna work for your 5000 products.

Do you have semi-products? ie a finished product used as a material for another product?

Andy

former_member186338
Active Contributor
0 Kudos

1. Yes

2. Yes

You will also have to load matrix by input schedule!

Test the performance, I can't warranty that filtering will work very fast (but for the reasonable number of FG will be OK - just single column report...)

Vadim

former_member186338
Active Contributor
0 Kudos

It depends... the matrix creation can be done automatically using source data...

The question is how fast the filtering will work...

bhagyesh_ravange
Active Participant
0 Kudos

Hello Vadim,

I am facing the following issues. I think combination of Product and Raw material is exceeding 150000.  But the combination of Product and Raw Material with Value 1 is 10.

Thanks and Regards

Bhagyesh Ravange

former_member186338
Active Contributor
0 Kudos

Ups, then no luck

Vadim