разработка приложений в системе Hyperion planning часть 2

  • Published on
    27-Jun-2015

  • View
    261

  • Download
    3

Embed Size (px)

Transcript

  • 1. Hyperion Planning 2http://www..com.ua

2. Jan Feb Mar Qtr1 15201045Jan+Feb+Mar15201015Jan15201010Mar 15201015(Jan+Feb+Mar) / 3 15151515 15201014,8901 (Jan * 31 + Feb * 29 + Dec * 31) /Actual_Actual 91 100 110 120 14,6703 (Jan * 31 + Feb * 28 + Dec * 31) /Actual_Actual_365 91 3. Jan Feb Mar Qtr1 0 202515 (Jan+Feb+Mar) / 3- 202520 (Feb+Mar) / 2 0 202520 (Feb+Mar) / 2 0 - 2525 (Mar) / 1 4. :1. 2. 3. 4. 12 5. Account Jan Feb Mar Qtr1Profit7550100 225Sales 150 200 250 600Profit% () 50% 25% 40% 115% (Jan+Feb+Mar)Account Jan Feb Mar Qtr1Profit7550100 225Sales 150 200 250 600Profit%()50% 25% 40%38,3333%(Jan+Feb+Mar)/3Account Jan Feb Mar Qtr1Profit7550100 225Sales 150 200 250 600Profit% () 50% 25% 40%37,5% (Profit->Q1 %Sales->Q1) 6. AccountJan Feb Mar Qtr1Profit 7550100 225 (5)Sales150 200 250 600 (6) 0% (4)Profit%50% (1) 25% (2) 50% (3) 125% (7) AccountJan Feb Mar Qtr1Profit 7550100 225 (5)Sales150 200 250 600 (6) 0% (4)Profit% ( ) 50% (1) 25% (2) 50% (3) 125% (7) 37,5% (8) 7. . 8. 1. > 150 2. (Java) 9. 1.@VAR(Actual, Budget)2.@VARPER(Actual, Budget)Variance Actual Budget Variance% Sales100120 -20 -16.67% COGS100120 20 16.67% () 10. - - - - 11. , .. , .. 12. 13. . IF(@ISUDA(Product, No VAT")) Revenue = Sales * 1.2; ELSE Revenue = Sales; ENDIF 14. Account Period Year Scenari Version Entity o

Recommended

View more >