This website is not affiliated with, sponsored by, or approved by SAP AG.

Distribution variable factor (Fox Performance Issue)

All postings related to SEM only

Moderators: Snowy, thx4allthefish

Distribution variable factor (Fox Performance Issue)

Postby Yolanda » Thu Aug 25, 2011 3:44 pm

Hi guys and gals

I have to distribute an annual budget to each month of the year with variable distribution factors according to a combination of characteristics

AREA ORG_UNIT DIST_FACT
AAA XXX DF1
AAA YYY DF2
BBB ZZZ DF3
…



JAN FEB MAR APR MAY JUN JULY AGUS SEPT OCTB NOV DIC
DF1 : 1/12 1/12 1/12 1/12 1/12 1/12 1/12 1/12 1/12 1/12 1/12 1/12
DF2 : ¼ ¼ ¼ ¼
DF3 : 1/2 1/2

Now I have a FOX Formula that does the job but the performance is terrible for a huge AREA (I am reading 200 k registers so the formula creates 200000 * 12 = 2400000 aprox)

Can I pull this out with standard distribution functions?
Any other recommendations?

Thanks in advance Yolanda
Yolanda
 
Posts: 62
Joined: Mon Jul 21, 2003 4:35 pm

Return to SEM

Who is online

Users browsing this forum: No registered users and 2 guests





This website is not affiliated with, sponsored by, or approved by SAP AG.