cancel
Showing results for 
Search instead for 
Did you mean: 

How to define the Market Sales KF, in order to receive the desired result

Former Member
0 Kudos

Hi all,

I dont know how to define the Market Sales Kefigure, in order to get the following result. Any hint is more than welcome.

Prd_ID = Product ID

PS = Product Sales

M_ID = Market ID

MS = Market Sales

MS% = Market Share ( formula in BEX PS/MS)

<b>

Prd_ID;PS;M_ID;MS;MS%</b>

A00001;10;MRK1;100;10%

A00002;20;MRK1;100;20%

<b>SBTOT</b>;30;MRK1;100;30%

B00001;40;MRK2;200;20%

B00002;30;MRK2;200;15%

<b>SBTOT</b>;70;MRK2;200;35%

<b>GTOTL</b>;100;MRKX;300;33,3%

Products A00001 and A00002 compete in the same market. So the individual marketshares should be calculated against the market MRK1(200), e.g. 40/200 and 30/200.

The totals now, of the A00001 and A00002 products(3040) should be compared against <b>the same market</b> MRK1(200),</b> and <b>not against</b> the MRK1MRK1(200+200).

Thanks

Vasso Siagri<b></b><b></b><b></b>

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

ashwin,

thanks for your reply,

the issue here, is not how to calculate the market for each material. The problem is the sub_totals and totals.

The totals should be the sum(of unique records) based on Market_ID.

even if I have 10 products with MRK1 and 20 products with MRK2, the totalMarket should be MRK1+MRK2

and not 10MRK1 + 20MRK2.

P.S.

thanks for your info about rating. It is helpful since iam new comer in sdn.

Ashwin
Active Contributor
0 Kudos

Hi!

how are you calculating Market sales. why is it displayed as 200 instead of hundred. I think there is some mistake in the data model.

with regards

ashwin

Answers (5)

Answers (5)

Former Member
0 Kudos

ashwin hi,

thanks you for your advice.

Yes, I changed the modeling, and I created a restricted KF

with constant selection on product_Id and restriction on unassigned product.

This is working now.

Many thanks for your support

Vasso

Former Member
0 Kudos

Maik,

thank you for your answer, but I am afraid this is not giving the desired results.

What I want----


>What am getting

Prd_ID;PS;M_ID;MS;MS%

A00001;10;MRK1;100;10% ---> 10;MRK1;200;5%

A00002;20;MRK1;100;20% ---> 20;MRK1;200;10%

SBTOT;30;MRK1;100;30% ---> 30;MRK1;200;15%

B00001;40;MRK2;200;20% ---> 40;MRK2;400;10%

B00002;30;MRK2;200;15% ---> 30;MRK2;400;7,5%

SBTOT;70;MRK2;200;35% ---> 70;MRK2;400;17,5%

GTOTL;100;MRKX;300;33,3% ---> 1000;MRKX;600;16,7%

Neither resticted KF restricted on Market ID is working for many markets; it is working only if you analyze one market id.

Any idea? bw idea? What actually I need is aggregation of unique records in terms on market id.

Former Member
0 Kudos

I am really sorry about the confusing.

I am rewriting the example.

Prd_ID;PS;M_ID;MS;MS%

A00001;10;MRK1;100;10%

A00002;20;MRK1;100;20%

SBTOT;30;MRK1;100;30%

B00001;40;MRK2;200;20%

B00002;30;MRK2;200;15%

SBTOT;70;MRK2;200;35%

GTOTL;100;MRKX;300;33,3%

Products A00001 and A00002 compete in the same market. So the individual marketshares should be calculated against the market MRK1(100), e.g. 10/100 and 20/100.

The totals now, of the A00001 and A00002 products(1020) should be compared against the same market MRK1(100), and not against the MRK1MRK1(100+100).

Ashwin
Active Contributor
0 Kudos

Hi!

this is not a problem with the key figure modelling. you got to use a restricted keyfigure which will be restricted usiong MKA1 for sales of MS1 and then use this in this restricted keyfigure in your formula.

alternatively you can mainatin the totals for each market in the masterdata of the Market infoobject and then use that attribute in your calculation.this you can get through a variable

with regards

ashwin

<i>PS n: Assigning point to the helpful answers is the way of saying thanks in SDN. and you can assign points by clicking on the appropriate radio button displayed next to the answers for your question.yellow for 2, green for 6 points(2)and blue for 10 points and to close the question and marked as problem solved.closing the threads which has a solution will help the members to deal with open issues with out wasting time on problems which has a solution and also to the people who encounter the same porblem in future.</i>

Former Member
0 Kudos

You have to use a constant selection on Product ID for Market Sales. Define a restricted KF with Product ID and Market Sales and set constant selection on Product ID.

Ashwin
Active Contributor
0 Kudos

Hi!

Your question is a bit confusing. In the example you gave what does this MS means it is total sales for that particular product in the specified market or is it something else like total market sales for all products combined.

And where are you comparing… the results.

Can you portray the current bex results and the intended results with an example so that its clear.

And where are you youing your product B00001 and B00002. and where did you get the figure 40 for product I mean in your example you show A00001 has 10 and A00002 has 20 sales but in your calculation you arre yousing 40/200 and 30/200 ..how do you get this figure 40 and 30.

with regards

ashwin