Home

User Manual - Anadolu EFES Financial Consolidation and Reporting

1. Other cash and cash equivalent Cash and cash equivalents Invalid 3 Is Drillable Tool bar Arche This toolbar contains options to use HFM data entry form Purposes of these options as follows This options contains a menu which has the same options in the toolbar E Create a new data entry form this option is only available for admin users Save data input form design changes this option is available when an admin user changes the screen design Save data input form design changes as a different form this option is available when an admin user changes the screen design Execute the screen design and show end user view of the form this option is available for admin users and it is activated E when the admin switch to design view Switch to visual design view of the form this option is available for admin users LJ Switch to script design view of the form this option is available for admin users 3 Save data changes to HFM server Ti Refresh financial data from HFM server Calculate data form this option executes HFM rules on the server these calculations are necessary to create BS and PL tables and check validations Calculate command runs intelligent calculation It means if you did not any change any data from the last calculation and click on calculate button HFM automatically understand nothing has changed on server and the results should be s
2. smn s a S E Documents Manage Journals x HQCP_3_02 Capital parent currency movement i Scenario IFRS Year 2013 d Period December d i Value lt Entity Curr Adjs gt Oracle Hyperion Reporting Use Reports e Login to EE EPM EE ane lias on DOE button Oracle En terprise Per en E sc https efesconstest anadoluefes tits ge index jsp _ ORACLE Enterprise Performance Management System SSES Fusion Edition we View Favorites Tools Help Explore iB EFESCONS l HEADCOUNT Operating Report E FT_3_Konsolide Di er Kapsaml Gelir Tablosu E 10 11 E 20 Income Taxes Deferred Tax Assets and Liabilities E 15 16 E 12 Goodwill E FS_3_Consolidated Statement of Comprehensive Income E Consolidated Interim Income Statement Open Workspace Pages Favorites er GE Ze HomePage ial My Personal Page Applications Consolidation i EFESCONS Oracle En erprise P DEEN a e 3 pg oe w EE bere eeben index jsp ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Sistem A Navigate File Edit View Le Be Explore Type Modified Descripti Financial Reporting 11 8 13 4 43 PM Financial Reporting 11 8 13 5 52 PM Financial Reporting 11 11 13 9 12 AM Financial Reporting Financial Reporting 11 1 13 1 38 PM 11 8 13 6 09 PM Financial Reporting 10 30 13
3. Type Security Clas Balanced Regular gt zl Defaut Adionsy Viewy PX HER OY iont Description Manual journals can be created both on groups and entities When the Entity is selected Currency appears as the defined currency which is local currency for the entities and reporting currency for the groups Journal information requires Account Description and Debit or Credit amount When it is double clicked on account part Member Selection screen appears From that window it is required to define applicable account number ICP and customs 1 6 information for the selected line Please ensure that the selected information matches with HFM screens for the selected scenario After completion of all steps aforementioned the journal should be saved Also the screen allows users to scan print delete and reset the entered data 36 When the journal is saved it will appear on Manage Journals screen and the status is Working In order to see the results system requires a submission process Submit gt Approve gt Post Journals not posted do not appear on financials or any disclosures W When it is clicked on Reports tab journal reporting screen appears Requested journals can be reported in HTML pdf or excel format with sorts of information such as account info custom info submission approval post date and responsible etc W HomePage
4. Year dimensions After ensuring the scenario and year selection desired period can be opened for journal creation by right clicking on period and click Open button Important Note If the period is unopened user cannot create any journals for the period If the period which is opened before is closed the existing journals are still valid but changing the journals is not allowed 2 Manage Journals After opening the period you will be able to create journals In order to create journals please follow the steps below Click Consolidation gt Journals gt Manage Oracle Enterprise Performance Management System Workspace Fusion Edition Wi ORACLE Enterprise Performance Management System Workspace Fusion E View Favontes Tools ri lidation Help De Explore Manage m Templates a Periods Groups DO Documents x Cee L Load j Reports E o Fi GARY By clicking Manage tab initial POV options automatically appears Scenario Year Period and Value These POVs should be correctly set because one step forward changing POVs will not allowed HomePage ij Documents Sa Manage Journals EER Scenario IFRS ZG Year 2011 wt Period December d LG Value lt Entity Curr Adjs gt vers QZX ena WW BS E see A A av status y amp Short Description 7a Gro Scenario Value e k EE ma 0 IRRS IR5S OO IFRS Contribution Adjs MNG_ACTUAL Management Parent Adjs MNG_BUDGET
5. r Sp E ed Extract Equity Pickup e Onthe manage ownership screen you should select right POV at first place You need to select a parent entity to manage ownership information After you select a parent entity the children of this entity will be listed on screen By entering data to child entity rows you can manage parent child entity GEI ORACLE Enterprise Performance ER System Workspace Fusion Edition Logged in as Ko Sistem A Help Log Off O Navigate File View Favorites Tools Consolidation Help L Be Explore Documents gt B Manage Ownership x Application Tasks A d a e Bo Documents E Actions View w 5 W HI ES E Display Options journals EER Scenario IFRS GI Year 2012 g Period December ah Entity G20 e V Show Entity Description i Intercompany 8 E F a PMIN PCTRL DOWN Consol Data El Calculate Ownershi E ZAO Moscow Efes Brewery Efes Moscow 100 0000 99 9962 0 0038 100 0000 91 2341 o S D aintenance j E _ CISC SABMiller RUS SABM RUS 100 0000 100 0000 0 0000 100 0000 89 0015 D Calculations Load Consolidation Method OAO Knyaz Rurik az Rurik 100 0000 100 0000 0 0000 100 0000 100 0000 0 e J sy Percent Consolidation E Task Lists S ZAO Mutena Maltery beleet
6. Budget lt Parent Curr Adjs gt MAG FORECAST 1 11 Forecast 1 11 lt Entity Curr Adjs gt MNG FORECAST 2 10 Forecast 2 10 Elimination MG FORECAST _3 9 Forecast 3 9 Proportion FORECAST 4 8 Forecast 4 8 FORECAST 5 7 Forecast 5 7 a FORECAST 6_6 Forecast 6 6 5 PORECAST_ 5 Forecast 7 5 MNG FORECAST 8 4 Forecast 8 4 complicated dimension HHG FORECAST 9 3 Forecast 9 3 Please refer to Consolidation Admin Manual for details of MAG FORECAST 10 2 Forecast 10 2 VALUE dimension Scenario and Value POVs are important in order to manage manual journals Scenario POV clearly defines the journal posting into which scenario Value is more MAG FORECAST 11 1 Forecast 11 1 ICP Matching ICP matching 3 Journals creation Step 1 Click Actions gt Journal HomePage EFESCONS E Documents D Manage Journals x SS Scenario IFRS Year 2011 A Period December ie DR eeng ea Status IER EFESCONS Search Le Advanced Documents TC Manage Journals GC New Journal LG Scan New 9 Delete E Print S Reset Hl Save l Entity 20 d Value lt Entity Curr Adjs gt j ICP ICP None d Custom1 None d Custom2 None d Custom3 None de Custom4 None di Custom5 None d Custom6 None CC Scenario IFRS Ei Year 2011 bgy Period December iil 4 Curren Status USD Working Balance Type
7. December 2012 522 181 3 804 283 781 13 184 268 242 164 509 cSistem A Help Log Off CH Logged in as Koc Excel Interface Smartview Excel Interface Basic Actions 40 Start Excel and open Smartview ribbon Iepgeoa Ge le Booki Microsoft Excel im tS Undo Ey Copy S 2 Help 7 e kb E Redo Paste CJ Sheet Info Panel Connections Refresh Submit Options Functions 7 Data Z More Start Edit Data General File Home Insert Page Layout Formulas Data Rewiew View Smart View RO o Ei gi 8 Sheet Sheet Sheet3 First you need to connect HFM server Select Panel item on the Smartview ribbon and select Shared Connection at the window opened right side of Excel CERERE Start Edit Data General Booki Microsoft Excel o B amp File Home Insert Page Layout Formulas Data Review View Smart View a 3 CO ER s amp s Ss ax 5 Undo E Copy A S a Help Redo Paste Ka U e heet Info Panel Connections Refresh Submit Options S Functions Data More 7 Sheet1 Sheet2 Sheet3 a Smart View x ft gt Smart View Home e Shared Connections Connections from shared repository E Private Connections Locally defined connections and shortcuts to shared connections Recently Used E Form 01_04 Cash and cash equivalents Interest rate H PERIONTEST EFESCONS Form FrmTest
8. BS00103 Current trade receivables J 8500105 Other receivables 3 BS00106 Current biological assets BS00107 Inventories Ch BS00108 Current deferred tax assets Calibri 11 A A S BIE QA WS March ESCH A Cut Ba Copy DS Paste Options POV Training Plan xlsx Sheet5_1 v j 3 IFRS IFRS x Paste Special Insert E e lt Entity Curr Adjs gt lt Entity Curr Adjs gt e Clear Contents e ICP Entities ICP Entities e Format Cells 3 None No detail X Row Height None No detail Y Hide No detail X Unhide None None No detail X 26 None No detail Y It is highly recommended click on Smartview Refresh button after every change on the Ad Hoc grid Excel Interface Smartview Excel Formulas e Login to Hyperion Server Using Smart View gt Panel button Home Insert Page Layout Formulas 53 54 Select Shared Connections on SmartView Panel window Smart View Input your username and password if they are asked Connect to Data Source User Authentication Needed Enter comect usemame and password to sign on kocsistem 55 Expand the EFESCONS application and right click on the EFESCONS application name Select Build Function menu item Smart View Select function that you want to use For example HSSetValue This function is used for to send data to HFM application Select Function
9. The meanings of the calculation statuses as follows Status OK OK ND OK SC CH CH ND TR ND CN CN ND Locked NoData NoAccess Description None of the data for the specified Scenario Year Period Entity and Value dimensions has changed OK No Data The calculation was run but calculations were not run for no data OK System Changed A change has occurred that may affect the data for the specified Scenario Year Period Entity and Value dimensions For example a new rules file metadata file or member list file has been loaded or the currency rate has changed The data itself such as a value of 10 000 has not changed Rather some change has taken place perhaps in a dimension member attribute For example the number of decimals associated with the account was set to two requiring the value to be changed to 10 000 00 Needs Calculation At least one data cell for the specified Scenario Year Period Entity and Value dimensions changed or metadata parameters or rules have changed As a result because calculation was not run other data cells in this dimension may not be current For base level entities you may have entered the data cell through data entry or by a data file load For any entity the data cell may have been entered by a journal posting Needs Calculation No Data This indicates the first time that calculation will be performed on the cell Needs Translation The selected Value dimens
10. change to the server you need to click on save button on the tool bar which is highlighted below Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Sistem A S Help Log Off D Navigate File View Favorites Tools Consolidation Help a Se Explore Lele EFESCONS See rr LH Application Tasks D ooume E ICP001 Balance sheet accounts ICP x Documents ICP001 Balance sheet accounts ICP Balance sheet accounts ICP information journals Currency RUR Sn dione EEG AJ Ba DP BBs BG ZS o CG Si Data Point of View maintenance EZ Scenario ICP_Matching Zi Year 2012 d Period December A View lt Scenario View gt st Entity G20 E100 Er Load dx Value lt Entity Currency gt v E115 Anadolu Efes Birac l k E118 Anadol ve Malt Sanayii A 5 Ticaret A S Aefe E Extract HFM allows more than one user can work on same screen and same point of view area Some times when you work on a HFM data forms another user may change data values on same screen If you want to see the changes you need to refresh data form You must click on refresh button on the toolbar Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer OF x ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Si
11. H PERIONTEST SIMPLE Form 320 Ticari Bor lar HYPERIONTEST UFRSDEMO ES Farm Y Iv Display on Startup 41 Enter HFM password Connect to Data Source User Name User Suthentication Needed Password i Ed Enter corect username and password to sign on kocsistem Cancel Details lt lt URL Provider wksp https SFEFSEPMTOSZ anadolu corp 19000 Wworkspace Select Oracle Hyperion Financial Management item from the right side of the window a H Os z File f Home SS e oe Q D Paste Panel Connections Refresh Submit Functions Data Edit Insert Page Layout Formulas Data Start Review Om o Cs Options Lo Booki Microsoft Excel View Smart view Help ET Sheet Info A More v o E amp a cof E Data D Al eneral O all m Ti MO IO BENER NL IP iw irs ka ka ka k ka ka ka mele o sl DO P O bal 19 20 HAH Sheeti Sheet Sheet SZ IKI Ready Ill LZ Smart iew T ki Shared Connections Select Server to proceed Oracle Hyperion Financial Management Fusion Edition Reporting and Analysis Framework Bom 1w g Expand HYPERIONTEST gt EFESCONS gt Root Booki Microsoft Excel Home Insert Formulas Review View Smart View ES amp Panel Connections Page Layout wow i Paste Refresh Submit El Functions D
12. ICP Custom1 Custom 2 Custom 3 Custom 4 Custom 5 Custom 6 in that order View section shows the member name for the View dimention Process Unit IFRS 2013 March G20 E100 lt Entity Currency gt POV Detail BS001010201 NONGROUP None None None None None EEUR View YTO Status Calculation Status OK Process Level First Pass Cell Status No data Cell Security Access All Data Scale 0 Num Decimals 0 e When you click OK and look at the formula cell you will see a Excel formula like below You can manipulate the formula according to your needs For example if you want to use the year information from a Excel cell you can change Year 2013 Section as Year amp D6 By this way formula always retrieves year info from cell D6 HsSetValue B2 WSFN HFM HYPERIONTEST EFESCONS EFESCONS Scenario IFRS Year 2013 P eriod March View YTD Entity G40 Value lt Entity Curr Adjs gt Account ACQO1 ICP ICP Entities Custom1 None Custom2 None Custom3 None Custom4 None Custom5 N one Custom6 ECUR 56 Excel Interface Smartview in MS Word and PowerPoint e You can import Financial Reporting reports like in Excel Details are described in Excel Interface Report Import section mals Dec F E 2 EES BE CC EIERE eg en SNE EE KA d ge Smar View BALANTT SHEET erte ett ve Mah e Anouk rb Deve F T P Eng
13. nancial Rep 3 8 13 22 08 aM ass o prm sen 13 33 25 aM ars o oiae 5 23 3 25 P as a mewe isen 20 income Tares Deferred Tax Assets and Liabiities Financial Reporti 10 22 133 36 PM 25 1 Related Party Balances and Transactions Financial Report 11715713 11 18AM _ 2 04 2 Segment Information Financial Reporti 11 14 13 3 20 PM Financial Reporting Menu Items New Open Open In Close Import b Properties Alt Enter Subscribe E mail Link Preferentes Log Off Exit Le a a Import New Creates new Hyperion Workspace content Open Open Oracle Hyperion Application or Report Open In Open selected report in selected format Close Close opened content Export Export selected report to special formatted file Import exported files into Financial Reporting Properties Displays selected report s properties Excel Interface fan WI DN ls rie Omg g G I Undo BR Help Redo A Paste EN Sheet Info Panel Connections Refresh Submit Options S Zl Functions gt Data Z More Start Edit Data General Booki Microsoft Excel o E CS el Jas e Shared Connections Connections from shared repository E Private Connections Locally defined connections and shortcuts to shared connections Recently Used 01_04 Cash and cash equivalents Interest rate H PERIONTEST EFESCONS J Form FrmTest H PERIONTEST SIMPLE 2 Fo
14. reports using this box 5 Logged in as Ko Sistem A Help Log Off O D we Favorites fR My Personal Page Applications Consolidation A EFESCONS This section dynamically changes for each user This section displays applications and reports which are used We do not have any content in this section This section displays special designed Oracle EPM Workspace pages They should be designed using Oracle EPM Workspace API This section contains your Oracle EPM Applications In our environment it only contains EFESCONS HFM This menu bar contains commands you need to use Oracle EPM products Content of these menus will be explained in next sections of this document The menu items are dynamic and they changes depending on the active application in Oracle EPM Workspace This section contains information of logged in user In addition to that there is a Log Off link which provides user to exit from system properly This section contains shortcut buttons of specific menu item commands Content of the menu bar changes according to active application in Oracle EPM Workspace The functions of the tool bar icons as follows LI A Explore Open Home Page O Create new workspace document CH Open report Open report repository window Home Page Menu Items Navigate Menu Applications fei Applications F 5 Explore You can start Oracle EPM Applications with the help of this menu item 7 Workspa
15. tr ANADOL O Favorites E CHECK_AEFES_BS Statement of financial position November 8 2013 3 14PM _ Default baris dinc efespilsen com tr ANADOLI E CHECK_EBI_BS Statement of financial position November 8 2013 3 04PM _ Default baris dinc efespilsen com tr ANADOL E CHECK_IC_AEFES Income statement November 8 2013 3 57 PM Default baris dinc efespilsen com tr ANADO E CHECK_IC_EBI Income statement October 11 2013 8 05 PM Default kocsistem Native Directory R E Cons_scope Shareholders equity Movement November 13 2013 9 37 AN SC_HOL baris dinc efespilsen com tr ANADO E G01 Currency Rates Rates September 2 2013 7 00 AM Default baris dinc efespilsen com tr ANADOL T G02 Consolidate Translate Calculate Consolidate Translate Calculate October 3 2013 1 12 PM Default kocsistem Native Directory E ICP matching process ICP matching process July 25 2013 1 06 PM Default kocsistem Native Directory ei IFRS reporting process IFRS reporting process July 25 2013 1 02 PM Default kocsistem Native Directory E IFRS validations All Entities IFRS validations all entities September 16 2013 1 50PM Default selman Native Directory vi IFRS_CONFO1_01 Current trade receivables Current trade receivables and payables from related parties c September 20 2013 2 46PM Default kocsistem Native Directory i IFRS_CONFO1_02 Non current trade receiva Non current trade receivables and payables from related parti September 20
16. w a wm e e 3 _ ae r a Ce a j i SOCUMEN Ji f Enterprise Perfor Anadotu EFES Fin j Fidder Web Debu wi Document Mix K Anadoty EFES Fin ES Microsoft Exce Pred T a E at d e You can copy any data cell reference from Excel Ad Hoc grids and paste them into Word or PowerPoint documents Create an Ad Hoc grid in Excel and select desired data cell Click on Copy button in the Smartview Ribbon Home Insert Fage Layout Formulas Data Copy the selected Smart View content Content includes data points Smart Query definitions and Oracle BI EE objects SS Oracle Hyperion Smart View for Office Fusion Edition Press Fl for add in help B5001 Current assets BSO00101 Cash and cash equivalents BSO0102 Current financial investments BSOO1L03 Current trade receivables Open the Word or PowerPoint document and click on the Paste button on the Smartview ribbon Cell reference automatically created in the document You can view data of this reference by click on Smartview Refresh button You can use this references as in line word in sentences 57 Mailings Review NEED_REFRESH Excel Interface Smartview VBA Script You can write VBA codes to automate some functions of Smartview You can find information about this topic in the Oracle Smartview Manual which is accessible at https efescons anadoluefes com 58 Process flows IFRS consolidation and reporting process START In
17. 0000 eae 0000 0 0000 100 0000 100 0000 o j m iicp matching process 000 Vostok Solod p e 0000 besi 0000 0 0000 100 0000 100 0000 0 _ Percent Control Jini i E Ann Era PAN Foree Percent Ome ee ZAO Moskovski Torgovyi Dom E 0 0000 190 0000 190 0000 o SE teney J 5 C Efes Kazakhstan Brewery Efes Kazakhstan Yes None 100 0000 Ges 0000 100 0000 72 0000 o Gini 4 Efes Vitanta Moldova Brewery S A Efes Moldova Yes a 100 0000 96 8298 3 1702 100 0000 96 8298 0 All Entities JSC Lomisi Efes Georgia 100 0000 100 0000 0 0000 100 0000 100 0000 D Periods Efes Ukraine Brewery Efes Ukraine SC 100 0000 99 9321 0 0679 100 0000 99 9321 o CA 111 Efes Breweries International N V EBI be Yes None 100 0000 100 0000 0 0000 100 0000 100 0000 D d 112 Central Asian Beverages B V Central Asian EUR Yes None 100 0000 100 0000 0 0000 100 0000 100 0000 D March 113 Efes Trade BY FLLC Efes Belarus BYR Yes None 100 0000 100 0000 0 0000 100 0000 90 0000 0 F April E114 Euro Asian Brauerein Holding GmbH Euro Asian EUR Yes None 100 0000 100 0000 0 0000 100 0000 100 0000 0 w Se August F September October November J December Calculate e Every column on the ownership management screen has a special purpose o ACTIVE This column defines weather this entity will be included into consolidation or not If you select
18. 2 55 PM Financial Reporting 11 11 13 10 25 AM Financial Reporting 11 8 13 6 11PM Financial Reporting 11 11 13 3 21PM 11 11 13 3 06 PM ET INCOME STATEMENT MTD 11 8 13 6 46 PM Financial Reporting Financial Reporting 10 30 13 11 52 AM E MARGINAL CONTRIBUTION ANALYSIS BY BRAND Financial Reporting Financial Reporting 11 1 13 5 23 PM 11 12 13 10 19 AM i MEBITDA VARIANCE ANALYSIS VS BUDGET Financial Reporting 11 8 13 4 10 PM j MEBITDA VARIANCE ANALYSIS VS PRIOR YEAR Financial Reporting 11 8 13 4 39 PM Operating Report Financial Reporting 11 12 13 10 25 AM 2 OTHER INC EXP E prodvoulme Financial Reporting Finandal R ting 10 30 13 3 01 PM 10 9 13 3 01 PM IS rate sellin Financial Reporting 11 8 13 11 13 AM 10 9 13 9 03 AM E SELL IN amp SELL OUT PERFORMANCE ech Reporting nen 5 11PM variance j VOLUME BY BRAND amp PACKAGING SELL IN SELL OUT PERFORMANCE DS PM 41 PM VOLUME BY CHANNEL 37 Financial Reporting 10 30 13 3 07 PM 38 Select report POV This report book runs for the members on the user Point of View listed below lt Entity Curr Total gt Oracl Enterprise Pe formance Manager System space e Tee hitps efesconstest anadoluefes com workspace index jsp ORACLE Enterprise Performance Management Sy
19. 2013 2 47 PM Default kocsistem Native Directory vi IFRS_CONF01_03 Other receivables and pa Other receivables and payables from related parties confirmat September 23 2013 11 43 AM Default kocsistem Native Directory B IFRS_CONFO1_04 Non current other receiv Non current other receivables and payables from related parti September 23 2013 11 17 AM Default kocsistem Native Directory IVs Report October 23 2013 9 39 AM Default E Management reporting process Management reporting process September 12 2013 12 58 PM Default ecto amp fest ul October 24 2013 7 14 PM Default selman Native Directory 100 e Application tasks This section contains shortcuts to data input screens and HFM process management screens These screens are grouped in task lists A task list contains all necessary screens for a specific reporting period Favorites You can add frequently used HFM forms in this area by right click and add to favorite command Documents This section contains all HFM data entry forms in folder structure These screens are the same screens listed under task lists The content of this section may change depending on user rights Filters This section contains filter options which controls Documents section Document section lists contents according to filter settings in this area HFM Application Menu Items 8 Documents D al This option opens HFM Documents dialog Journal
20. ANADOLU EFE EFESCONS Anadolu Efes Financial Consolidation and Reporting Project User Manual 2013 Last Update 26 November 2013 Table of Contents Ietd eraf ler e EE 3 Prepare your eine E EE 4 AO GUE WO KIN E CNV OMIM INE e eege 5 NEIER 5 LOC IN TE 5 HOME GE 6 HomePage E E ln EE 7 RFMApplication Document WING OW EE 8 AEM ADDIICATION Menu em Sreser E A ETE 9 HEM Application DdatavEntty eg EE 10 HFM Application Data Entry Form Right Click Menu 11 HFM Application Data Entry Form Member Selection Dialog 13 HFM Application Process Control 14 Financial Reporting REDON leg 15 Financial RE DOM Ee UN EE 16 Ey Cel Ree Ee 17 How to Use Oracle Hyperion ele e EE 18 NEE UE 18 Oracle e Se e EE 18 Oracle HFM Run Consolidation Egide ee Eileen 27 Oracle FEM Manage e e el EE 30 Excell ett Eleng EN A0 Excel Menge Ce eg ed e LEE 40 Excel IMPS aCe REPO IMPDO EE 44 Excel Interface Ad HOC ANAIS Seenen a dacs a TAE ATA AEE a AE T eee 49 Excel Interface Smal VIEW Extel Form la Seesen aneia a a a EA ERE aaia 53 Excel Interface Smartview in MS Word and Bowerboint 57 Excel Interface Smar view VBA d le GE 58 eege dE 59 IFRS consolidation and reporting Drorcess 59 Management consolidation and reporting procesS s sssseeesssseeersssreeesssrteosssrerosserersssreresssreresssreresssreresseree 59 Introduction This document is the main reference guide for EFESCONS Anadolu EFES Fi
21. CONS application and right click on the EFESCONS application name Select Ad hoc analysis menu item Smart View Ad hoc analysis After this section Smartviews creates a simple Ad Hoc screen in the Excel Sheet Ad Hoc screens are most likely Excel Pivot Tables They also have columns rows and POV selection windows Smartview puts Period dimention on column and Account dimention on Rows by default All other dimentions are 51 listed in POV selection window You can put any dimension to column or row area by selecting in POV window and drag drop on row or column with left mouse button ACQ01 Total consideration value POV Training Plan xlsx Sheet5_1 e 2013 2015 YTD Year to date lt Entity Curr Adjs gt lt Entity Curr Adjs gt ICP Entities ICP Entities None No detail None No detail None No detail None No detail None No detail ECUR Entity Currency i 4 S i 52 If you want to remove any dimention from row or column You should drag drop it back to POV window using right mouse button G40 Anadolu Efes Birac l k ve Malt Sanz March ACQO1 Total consideration value POV Training Plan xlsx Sheet5_1 None No detail None No detail None No detail You can type account or period codes if you know them into column or row headers directly After you click on Smartview refresh button Smartview will automaticly recognizes your input an
22. Custom None Custom None Custom None Custom None Custome None 2011 A 2011 YE 2012 B 2012 A Cash and cash equivalents 522 181 522 181 1 884 589 Current financial investments 3 804 3 804 279 514 Current trade receivables 283 781 283 78 1 005 446 Other receivables 13 184 13 184 R 13 908 Current biological assets Inventories 268 243 268 2 870 452 Other current assets 164 509 153 796 Current derivative financial instruments asset Asset held for sale and discontinued operations Receivables from continuing construction contracts 279 1 an as all E All Pages Split Pages across worksheets E Refresh Using Workspace Point of View Help e Although the imported reports are seen as static reports they are actually still connected with Hyperion Reporting server If the values on the server changes you can easily refresh your imported report by click on Refresh button on the SmartView ribbon d Gainian emm sisi Microsoft E BALANCE SHEET ay Anadolu Efes Biracalikve Malt Sanayii Anonim irketi 4 Dee KAN mstr its asset a set KS e erations Bell Receivables from contirmume construction contracts jp Assets related to current penod mcome tax e contumans construction contracts ged come e Ifyou weant to change selected POV of the imported report you can click on Smartview Ribbon gt Connections gt Reporting and Analysis Document gt
23. E 12 Goodwill E FS 3 Consohdated Statement of Comprehensive Income E Consolidated Interim Income Statement 3 Open _ i EFESCONS e On the left side of the windows there is a small box tiled as Task Lists This section contains all options you need to use HFM In this section currently there are three task list ICP Matching process IFRS reporting process and Management reporting process These task lists contains options you need to use during ICP matching IFRS reporting and Management reporting steps https efesconstest anadoluefes com workspace index jsp ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Sistem A S Navigate File View Favorites Tools Consolidation Help L Be Explore e Ce F Ar anced Application Tasks Task Lists j 5 G SS isl ICP matching process e n Document Type All E IFRS reporting process July 12 2013 2 27 PN Default Document File Type E Management reporting process E ICP matching reports July 12 2013 3 04 ER Default P Al ef IFRS reporting process July 23 2013 4 06 PN Default j ive Di Document Category July 30 2013 9 11 Af Default September 23 2013 SC_HOL October 31 2013 10 Default es Borrovings Entry Test Debug October 31 2013 3 0 Default amp Borrowing information entry November 7 2013 9 SC_HOL E CHECK_AEFES_BS Statement of financial
24. Edit menu item After that the POV selection 47 48 window appears again and you can change POV of the imported report Home Insert a Unda Copy Redo M Paste Active Connections d Reset to Default Connection Recently Used Fage Layout Formulas Review You can also I mport repors into Microsoft Word or Microsoft Powerpoint documents The directions are same as in the Excel but you can import reports as image into Word or Powerpoint documents Import Workspace Document Prez reenter erence ve eect O Oh BALANCE SHEET Anadolu Efes Biraciaik ve Malt Sanavii Anonim irketi December 2012 ICP ICF None Customi None Custom None Custom None Custom4 None Custom None Custome None 2011 A 2011 YE 1012 B 2012 A 522 181 1 884 589 Cash and cash equivalents Current financial investments Current trade receivables Other receivables Current biological assets Inventories Current deferred tax assets Other current assets Current derivative financial instruments asset E All Pages E Refresh Using Workspace Point of View Help 522 1 81 3 804 283 781 13 184 268 242 164 509 3 804 283 781 13 184 279 514 1 005 446 13 905 870 452 253 796 279 e You can apply image crop function in Ms Word on imported reports Smartview still can refresh cropped reports when you click on Refresh button BALANTT S
25. HEET December 2012 Ach and can equivalents ament financial investments werent tude recervaltes Mher receivables ugeet biological assets m Surrent derivative financial imtruments asset ssel held for sale and descoutinmed operations Recervables from continuing comsirechos contracts setts related to current penod imoome tax vest prepaid cxpemece urrent assets ivestmems m associates jot curros financial investments Non current trade recenabies Mer non current peceivubles current biological assets operty plant and equipment vom current deferred tax assem Mher non current assets Intangite asswis iimvestmen ponpertic me current derivative financs iairuments asset ioe current prepaid e e 6506 EE Total acts HEET 5 787188 unrest porton of kag tenm borrow ings terms barrowinga Other financial bafsbe en Current trade payables Mier curren payables Kaz ae This function may also provide you to change data Data input and update is not recommended on Ad Hoc screens e Login to Hyperion Server Using Smart View gt Panel button Home Insert Page Layout Formulas KE Je Krea TZ Fu 49 50 Input your username and password if they are asked Connect to Data Source User Authentication Needed Enter comect usemame and password to sign on User Name kocsistem Password wese http stefsepmt082 anadolu corp 19000 workspace Sn Expand the EFES
26. HsSetValue DataValue ConnectionName Memberlist Sends values to the source Input a cell referans for Data Text field Data in the field will be sending to the HFM application Leave the Connection field as it is Then select Members in the Member List field These members defined the coordinates that the data will be sending to You must define a specific member for all HFM dimensions Member Selection Function Arguments HsSetValue SN Connection m ACQO1 Total consideration value WSFN HFMIHYPERIONTEST EFESCC S EE S WE None No detail aoe CS None No detail None No detail None No detail 1 Forecast 1 11 Forecast 2 10 Forecast 3 9 Forecast 4 8 Forecast 5 7 Forecast 6 6 Forecast 7 5 Forecast 8 4 Forecast 9 3 2 Forecast 10 2 1 Forecast 11 1 tching ECUR Entity Currency G40 Anadolu Efes Biraalik ve Malt Sanz ICP Entities March IFRS lt Entity Curr Adjs gt YTD Year to date 2013 You can learn the correct members for a specific area by opening the HFM data form which contains the data cell that you want to send data Right click on the data cell and select Cell Information Process Unit section contains necessary member names for Scenario Year Period Entity Value dimensions in that order POV Detail section contains necessary member names for Account
27. Prepare your computer section of this document Web interface Login Page Te A http sfefsepmt082 anadolu corp 19000 Oracle Enterprise Performance Management System Works Windows Internet Explorer gt Cle ORACLE Enterprise Performance Management System Workspace Fusion Edition User Name yYOur_Username ORACLE ENTERPRISE PERFORMANCE MANAGEMENT SYSTEM Copyright 2005 2013 Oracle and or its affiliates All rights reserved Login Dialog HFM asks username and password to protect your financial data You need to use login dialog to enter your username and password Internet Explorer Zoom Level Internet Explorer zoom level should always be 100 Home Page SG Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer gt ORACLE Enterprise Performance Management System File Explore QQ Recently Opened E HEADCOUNT A EFESCONS Operating Report ta FT_3_Konsolide Di er Kapsaml Gelir Tablosu E Note 10 11 ES Note 20 Income Taxes Deferred Tax Assets and Liabilities iia Note 15 16 l Note 12 Goodwill E FS_3_Consolidated Statement of Comprehensive Income g Consolidated Interim Income Statement sace Fusion Edition Recently opened documents by you recently Workspace pages Quick links application Menu bar Information bar Search box Tool bar You can search
28. Yes the entity will include the consolidation If you select No HFM will ignore this entity o Method This column is for defining consolidation type There is only one type consolidation method in the system and it is EQP If you select EQP in the Method column that entity will be consolidated according to Equity Pickup method If you select None the consolidation will be done according to the values in the PCON column o PCON You can enter consolidation rate in this column o POWN You can enter direct indirect ownership rate in this column In fact this column value can be calculated automatically according to entities capital structure values o PMIN This column shows minority rate and it is calculated by PCON POWN o PCTRL This column value displays control rate on the entities This column values does not have any functionality on this application o DOWM You can enter direct ownership values in this column but this column actually can be calculated automatically by HFM using capital structure values o The rest of the columns do not have any functionality POWN and DOWN column values should be calculated automatically In order to that first open HQ Consolidation Process gt HQCP_1 Capital Structure gt HQCP_1 02 Capital structure for consolidation purpose HFM data form and run Force Calculate By this way you will copy user entered capital structure values to HFM System Account
29. ame and does not run calculation twice Force calculate This option does not take into account the intelligent calculation It always runs calculations whether data has changed or not Intelligent calculation always checks current year period entity and value members for data changes If previous period s data has changed you may need to recalculate this period values because of movement tables In this case intelligent calculation does not understand previous period has changed and there is a movement effect this period so need to calculate this period also You need to use Force calculate in such cases EEH open row suppression options EH open column suppression options EH open both row di and column suppression options i open cell text comment entry dialog Ga open data form instructions the current data form to create link to this data form in HFM enable disable one click data entry in normal settings you need to click twice on data cells for data entry You can change this setting as one click data entry with this option dialog print data form Du open this data form in Excel as Smartview screen E you can copy URL of POV Point of View This section contains point of view selection links HFM stores financial data in multi dimensional format But HFM data forms have two dimensions rows and columns HFM creates virtual data pages to display multi dimensional data on two dimension data forms POV secti
30. an Celtiker Help Log Off O WW Name a Type Modified a e igen od ature T l Financial Reporti 11 13 13 5 26 PM Financial Reporti 11 13 13 5 28 PM L25 22 Related Party Balances and Transactions Financial Repor 1 35 33 11 17 AM A25 a3 Related Party Balances and Transactions Financial Report 11 15 13 13 19AM A25 b Related Party Balances and Transactions Financial Repor 11 15 13 11 22AM Bl Nature and Level of Risks Arising from Financial Instruments Financial Reporti 11 15 13 11 45AM r Consolidated Statement of Financial Postion Financial Report 1 33 33 4 50PM_ r Consolidated Statement of Financial Postion Financial Reporti 11 13 135 22PM_ LA FS 2 Consolidated Income Statement nancial Repor 1 7 13 1 55PM Ea FS 3 Concoidted Statement of Comprehensive Income Financial Reporti 11 7 13332PM Ea FS 4 Consolidated Statement of Changes in Equty Financial Reporti 11 7 133 42PM_ mmm We oM U U 7 BEEN RES EN Report Folders This section contains Financial Reporting folder structure These folders contains Oracle Financial Reporting Reports such as IFRS notes Report Folder Content This section displays the content of the reporting folders m _ i 03 Business Combination Financial Reporti 11 14 13 2 54 PM ni Segment Information Financial Reporti 10 22 13 3 38 PM ren prend 10 22 43 3 99PM Arean i
31. an Native Directory Default kocsistem Native Directory November 7 2013 9 25 AM Statement of financial position November 8 2013 3 14PM Statement of financial position November 8 2013 3 04PM Income statement November 8 2013 3 57PM Income statement October 11 2013 8 05 PM ee a ee T S Dei ICP matching process ICP matching process E IFRS reporting process IFRS reporting process IFRS validations All Entities IFRS validations all entities di IFRS_CONFO1_01 Current trade receivable Current trade receivables and payables from related parties di IFRS_CONFO1_02 Non current trade receiv di IFRS_CONFO1_03 Other receivables and p Other receivables and payables from related parties coni GB IFRS_CONFO1_04 Non current other receiv el Management reporting process Management reporting process You can select more than one period or entity cell on this screen After that if you right click and select Concolidate All The consolidation process will start for all of selected periods and entities Noe o O NODATA NODATA NODATA NODATA NODATA NODATA NODATA NODATA NODATA NODATA NODA Manage Process ee ATA NODATA NODATA NODA _NODATA NODATA NODATA NODATA NODA _NODATA NODATA NODATA NODATA NODA e This screen also displays the calculation status of the entities For example CN means Consolidation needed
32. ata a Undo EN Help 7 E Sheet Info e More v General Redo Options E E HYPERIONTEST 7 vg EFESCONS om H 0 EN SON S L NEN e EI ICP confirmation process e EI IFRS reporting process i EI Management reporting process E Eis PO E FIX_Pove E G01 Currency Rates E G02 Consolidate Translate Calcula EI Task Lists IFRS4DIM SIMPLE UFRSDEMO E Open Forms e You can open data input screens to Excel by double click These screens are the same screens which are on web interface Yellow cells are for data input and green screens are for calculated cells as in web interface Data POY 01_01 Cash and cash equivalents ICP vs FC HYPERIONTEST_EFESCONS_1 December D YTD Year to date D G31 E123 Coca Cola ecek Anonim irketi D lt Entity Currency gt lt Entity Currency gt D IFRS IFRS f G EA Ne G le Booki Microsoft Excel o0 File Home Insert Page Layout Formulas Data Review View Smart View HFM a 3 o EN 8 i A Cell Commentz Drill through E o a o vg Add Member G3 Adjust Refresh Submit D RB Calculate 2 Instructions Data Cash on hand Demand deposits Time deposits Bank accounts Reverse repurchase agreements Interest income accrual Cheques received Other cash and cash equivalent Cash and cash equivalents Non Group Non Group Alternatifbank A Abank ICP total Non Group Alternatifbank 4 5 Abank ICP Total Non Group A
33. ce e Open any HFM Data Form data input screen Select a Parent Entity Ex G40 on Entity POV area Select lt Entity Currency gt on Value POV area Select other POV members according to you needs SC Scenario MNG_ACTUAL Si Year 2013 fs Period December A7 View YTD of Entity G40 d Value lt Entity Currency gt e Right click on any data cell and select one of Consolidate Consolidate All Consolidate with Data options December UG Cell Information Pe Cell Text P Linked Form ZE Consolidate Calculate Contribution e Running Tasks window automatically appears and you can view the status of the consolidation on this screen Consolidation may take a while Actions vew D H Activity Description Progress Consolidation MNG_ACTUAL 20 13 December December G40 Calcula EEN Status Result det Updated Time Running Nov 20 2013 7 54 22 PM e With this technic you can run consolidation only for one period year and entity If you want to run consolidation for more than one period year or entity you can use G02 Consolidate Translate Calculate data grid This Time Stamp September 26 2013 9 54 AM July 12 2013 2 27 PM July 12 2013 3 04 PM July 30 2013 9 11 AM September 23 2013 1 03PM October 31 2013 10 44 AM October 31 2013 3 08 PM Default kocsistem Native Directory SC HOL selm
34. ce Pages i Administer b Explorer AN Schedule b This item opens report repository which you can open reports by selecting from it Open Items File Menu New b Preferences Op d You can change your user specific settings with this option For example decimal separator Close character in the HFM Preferences Log Off Eyit This option is used to exit all system properly Exit You can close active application in the Oracle EPM by selecting this option Favorites Menu DEER Add to Favorites Se You can add the active content to your favorite list Your favorites will be listed in Quick AEEA Links section of Home Page Manage Personal Pages is HomePage 3 My Personal Page Manage Favorites This option is used to change your favorite items HomePage This option opens your home page in the workspace Tools Menu Install Launch Financial Reporting Studio Install You can download Oracle EPM client tools with this option but we recommend you to use the instructions in the user manual always Help Menu cial Te F1 This menu contains hyper links to Oracle Product Documentation Contents Technical Support P O rt d EPM Documentation About Oracle Enterprise Performance Management System Workspace Fusion Edition HFM Application Document Window Oracle Enterprise Performance System Workspace Edition Wir ORACLE Enterprise Performance Management System Workspace Fusion Edition Na
35. cess Oo IFRS reporting process E Rates E gt process Control o Process control Manage Journals 4 Manage Journal Templates Load Data EN ER II p S El Favorites Step 2 Check POV and make regarding updates e Period a Se REECH Efes Trade BY FLLC Efes Belarus C OK 3 Ki First Pass C a Step 3 Calculation status Step 4 Validation and pass fail status check e Should be OK e Both should be e If not right click and e If not please check your data input and calculate validation screen Step 5 Review level e Right click on review level cell e Manage process gt Submit Step 6 Submission e After click submit as mentioned above e OK button should be selected Point Of View IFRS 2012 December lt Entity Curr Total gt Comment Step 7 Final While review level is submitted process will be finalized Actons 5B e ees av Scenario IFRS 3 Year 2012 s Period December 5 Entity Efes Trade BY FLLC Efes Belarus car cist ts d Journal Status Review Level Pass Fail Efes Trade BY FLLC Efes Belarus Please note that submitted data forms are not changed by operation Any update need raised the operation should inform the HQ team and system admin will reject regarding data form and operation can update it Oracle HFM Run Consolidation You can run consolidation on any data input screen But you have to use HFM web interfa
36. counts ICP Balance sheet accounts ICP information journals Currency TRY h aa Actions w Le a ie AO gw D SSES A G al Sp EI Data Point of View maintenance EZ Scenario ICP_Matching Year 2012 y Period December A View lt Scenario View gt st Entity G31 E123 SS e Er Load dx Value lt Entity Currency gt v a D n M tract E115 Anadolu Efes Birac l k E118 Anad El Task Lists ve Malt Sanayii A S Ticaret A S Ae GIen SON S L NEN _ Total TT TTT Current trade receivables from related parties _ _ _ _7 Other receivables from related parties e Non current trade receivables from related parties i i i El 9 ICP matching process E A ICP confirmation process C 1CP001 Balance sheet Other non current receivables from related parties Current trade payables to related parties E 1oP002 PL accounts ICP Other current payables to related parties E Cell Information a ICP003 PPE accounts ICP Non current trade payables to related parties Ge Cell Text se e ICP004 Intangible accoun Force Calculate ort Force Calculate Contribution Lock Ta Unlock 3 Manage Process E 1cP999 ICP matching proc A ICP matching reports o Rates E Process Control iC Source Transactions eee Bottles and cases O O d o amp Load Data Supplies and spare parts Ch Destination Transactions D Lg fil D P Sl IFRS rep
37. d displays input account value 1 March tag B5001 Current assets Lo 5 e lf the account in the row or column is a parent account which has detailed accounts under it You can display the children values by simply left double click on the account code BS001 Current assets BS00101 Cash and cash equivalents BS00102 Current financial investments BS00103 Current trade receivables J 8800105 Other receivables BS00106 Current biological assets BS00107 Inventories BS00108 Current deferred tax assets BS00109 Other current assets BS00110 Current derivative financial instruments asset BS00111 Asset held for sale and discontinued operations BS00112 Receivables from continuing construction contracts BS00113 Assets related to current period income tax BS00114 Current prepaid expenses POV Training Plan xlsx Sheet5_1 4 2013 2013 YTD Year to date G40 Anadolu Efes Biraalik ve Malt Sanayii Anonim irketi v lt Entity Curr Adjs gt lt Entity Curr Adjs gt ICP Entities ICP Entities None No detail None No detail None No detail None No detail None No detail ECUR Entity Currency f e You can use Excel s row and column delete function to remove unwanted rows and colums After this action you have to click on refresh button al BS001 Current assets CN BS00101 Cash and cash equivalents BS00102 Current financial investments
38. df faces hfm jspx _afrLoop 1349581659079203 amp _afrWindowMode 0 amp accessibilityMode false amp themeSelection BpmTadpole amp _adf ctrl state ayb1lhaio_167 Tool bar This section contains function shortcuts for process control window The function of the buttons as follows opens detailed process control menu opens currency rate form this is unavailable in this system ES this option opens Ownership Management screen which is used by consolidation admin w refreshes process management grid te displays the options to change process status start promote Dez submit approve publish sign off reject displays options to run consolidation displays options to run calculations display options to run translations POV You should select the POV section which you want to manage process status Process Control Grid This section lists all selected members for all POV dimensions Display Options These sections has options to change view of the process control grid Financial Reporting Report Explorer Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer ORACLE Enterprise Performance Management System Workspace Fusion Edition Navigate File Edt View Fa F 2 Explore ES HomePage f EI Y l sonu Format EI Sample Content EI Shared Workspace Pages EI UFRSDEMO Users vorites ools Help Logged in as Selm
39. ear to date BE S H L Member Selection Ea w Year iu Vv A Y Y Enter a member name and click Find You can save your data to server by clicking Submit Data item on the ribbon Formulas Data Review Whew Smart wiew HF fei rough tions Inse cell go Add H Calc Refresh r DOMM Di Di ach and rach e You can run calculation by clicking on Calculate gt Force Calculate Home Insert Page Layout Formulas Cell Comments Sa Drill through S YE Add Member 89 Adjust W Sub Calculate DON DI 01 Cash a Force Calculate ws FC HYPER 201i 2011 December e You can use Excel formulas or links in data input cells Results of these formulas and links will be submitted to server if you click on Submit Data button amp Sheet B14 Sheet2 K1 ee Mon Group Refresh T E e If you want you can save this Excel workbook to save your linked cells and formulas and you can use same document to upload data to HFM later If you want to use previously saved Excel documents which has HFM input screens in it You need to reconnect HFM server after open this document Click on Refresh button on the Smart View ribbon is enough to reconnect HFM server Excel Interface Report Import e Login to Hyperion Server Using Smart View gt Panel button Home Insert Page Layout Formulas ata Review e Select Shared Connecti
40. ion member is not the entity s default currency and its translated values may not be current Needs Translation No Data This indicates the first time that translation will be performed on the cell Needs Consolidation The data for the specified Scenario Year Period Entity and Value dimensions may not be current because any of the following items changed e Data for a child entity e Data for the entity s default currency e Metadata parameters or rules Needs Consolidation No Data The parent has no data but data for a child entity changed This indicates the first time that consolidation will be performed on the cell The data for the specified Scenario Year Period Entity and Value dimensions has been locked by an administrator The data can no longer be modified manually or through calculations Note You can use the Allocation function to modify data in a locked destination POV No data exists for the specified Scenario Year Period Entity and Value dimensions The user does not have rights for the specified dimension member Oracle HFM Manage Ownership This function is only available for Consolidation Users Other users cannot see necessary menu items to open manage ownership screen e You can open manage ownership screen using Consolidation gt Data gt Manage Ownership menu item Consolidation Help i Data EL Manage Maintenance i E Process Control Load ES Manage Ownership l
41. ll be listed under it Each type of ES HFM item has different icon image is for folders and folders contains other folders or HFM items HH icon is for data input screens in other words HFM Data Forms All other kind of HFM items have their unique icons CJ LAT OLL Task Lists SS LJ EN SON S L NEN a El ICP matching process Rn confirmation process ICP matching reports Rates E Process Control E Extract Data i Load Data Sl ters reporting process e You can open a data input screen HFM Data Form by double click or right click and select Open ee Se El FEIS FL El Task Lists Z J FIX_PC eu SON S L NEN G01 CH E 9 ICP matching process ES G02 Cc fie ICP me E icp confirmation process tg pe EH 1cp999 1CP matching pr oe e Data input screen will be opened at right side of the page Data input screens has different sections toolbar section point of view section and grid section Grid section has different colored cells You can input data to light yellow cells Greens cells are calculated values and you cannot change them Orange colored cells mean invalid cells and logically these cells cannot contain any data Grey cells for section separations Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Sistem A S Help Log Off O Navigate File View Favo
42. lternatifbank 4 5 Abank ICP total Non Group Non Group Total Turkish Lira US Dollar Euro Russian Ruble Kazakh Tenge Moldovan Leu Alternatifbank AS Abank ICP total Non Group Non Group ICP total Sheet Sheet2 Sheet3 Georgian Lari vx fh gt Oracle Hyperion Financial Management gt e EI IFRS reporting process B P O1_Cash and cash equivalents Shared Connections EI 02_Financial assets 6 7 O3_Investment in associates EI D Trade receivables and pay H gI 05_Due from to related partie esi 06_Other receivables payab 1 EI O7_Inventories 1 EI 08_Other assets liabilities 7 09_Tangible and intangible as H I 10_Derivative Financial instrun e EI 11_Borrowings D E 12_Taxation 13_Provisions e EI 14_Shareholders equity EI 20_Income Stament E F501_Statement of financial p E F502_Income statement EJ RISKO1_Foreign currency posi E RISKOZ_Maturity position E RISKOS_Credit Risk LG Mananement remnrtina nracess e You can change point of view by clicking option under the point of view items drop down lists Point of view selection dialog is similer to the web dialog 42 43 z Le Insert Pag out Formulas Dat Cell Comments Drill through o Add Member 88 Adjust Submit E Calculate LZ Instructions Data Data Refresh T PO OI DI Cash and cash equivalents ICP ws FC HYPERIONTEST 2011 2011 e December December e YTD Y
43. mation process E icpo01 Balance sheet a ICP002 PL accounts ICP E ICP003 PPE accounts IC E ICP004 Intangible accot E 1CP999 ICP matching pr a ICP matching reports CONFO1_01 Current KR CONFO01_02 Non curren K i CONF01_03 Other recei K i CONFO01_04 Non curren eh CONFO2_01 Income sta eh CONF02_02 Volume trai K i CONF02_03 Financial in eh ONFO2 04 Fixed ass System Running Tasks 100 E Current trade receivables and payables from related parties confirmation and trade Windows Internet Explorer Current trade receivables and payables from related parties confirmation and trade Scenario ICP_Matching Year 2011 Period December View YTD Value USD Entity G40 Base get kocsistem Native Suppress Details No Suppress Reversed No Partner G40 Base Directory Suppress Reversed No Decimal Override 0 Scale Factor 0 Date 8 25 2013 Matching Tolerance 15 000000 Decimal Override 0 Time 5 55 10 PM Matching Tolerance Plug Percent Account Entity Account Entity Amount Partner Amount Difference Grand Total Oracle HFM Submit Data Deliver Data to HQ and Lock Data Input Screens To lock data forms data inputs are completed and properly validated please follow below listed steps Consolidation E Data E di Maintenance E EP oad IES extract Task Lists KE Zi E ICP matching process i Gi IFRS reporting process Consolidation Step 1 In task lists e IFRS reporting pro
44. mber Selection section You can use left blue arrow to remove selected member HFM Application Process Control Oracle Enterprise Performance Management System Workspace Fusion Edition Win ORACLE Enterprise Performance Management System Workspace Fusion Edition Navigate File ew Favorites Tools Consolidation Help LS Se Explore E EFESCONS Application Tasks Task Lists A Display Options fl ICP matching process g Grid Settings D ICP confirmation process D ICP matching reports dl fe E Anadolu Efes Biracilik ve Malt Sanayii Anonim irketi x d E Process Control X wi Extract Data y P SS age E Load Data e Entity View S 5 Coca Cola i ecek Anonim Sirketi RS H i n iew EE Anadolu Efes Dig Ticaret A S Aefes Dig Ticaret nape eg preces mmm Ltd Anadolu Efes Technical and Management Consultancy N V AETMC Period View d Efes Holland Technical Management Consultancy B V EHTMC Period View x Efes Deutschland GmbH Efes Germany x all _ Column Settings Review Level Review Level Columns pas Fail Validation E Favorites Calc Status Journal Status Review Level Summary Calculation Status Summary http sfefsepmt082 anadolu corp 19000 hfma
45. n Logged in as KocSistem A S Help Log Off D Navigate File View Favorites Tools Consolidation Help F Explore rw search DEE Avance l CONF01_01 Current trade receivables and payables from related parties confirmation Select the values you wish to override when printing the selected reports I Override Report Definition EE Scenario ICP_Matching SZ Year 2011 Period December A View YTD d Value USD V Override Report Definition V Override Report Definition Entity G40 Base Wd ICP Partner G40 Base a V Override Report Definition Report format Report template IV Override Report Definition Suppress Matches V Matching Tolerance Matching Tolerance percent e I Override Report Definition I Override Report Definition Suppress Reversed E Suppress Details E A precoess status window will be displayed You sould click on the icon at the Result column to display report Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Sistem AS Help Log Off Ka Navigate File View Favorites Tools Consolidation Help L Se Explore P Teneo EFESCONS search ooo Advanced 7 Application Tasks ij Documents _ ICP001 Balance sheet accounts ICP gt 3 Running Tasks x E Bim eee GI ve LE matcning process H O ICP confir
46. n hierarchies You can expand this hierarchies by clicking on the plus signs Some items does not have plus sign on their left these items are base items You can only input data to this base items So need to select E123 Coca Cola ecek item on the left and click on the blue arrow which directed to right and click OK You can change other point of view items with same steps Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Sistem AS Help Log Off O Navigate File View Favorites Tools Consolidation Help L i Explore z cn crescons search NE vance mel big None o E G40 Anadolu Efes Consolidated G30 Efes Beer Group E G31 Coca Cola ecek Anonim irketi C E123 Coca Cola Icecek Anonim Sirketi ICP confirmation pr G10 Efes Rus E G11 Efes Commonwelth of Independent States and Ea en ae z ICP003 PPE acc E ICP004 Intangib Selection List E 10P999 ICP mat O ICP matching repo Si Rates E Process Control E Extract Data oad Data E IFRS reporting process lt Entity Currency gt R10 5 If you change a cell value the color of this cell turns to dark yellow This means you have changed the cell value but you did not save it to the server You will lose this data if you close the window If you want to save this
47. nancial Consolidation and Reporting Project users It contains all information to use HFM Oracle Hyperion Financial Management tool which is selected as a main consolidation tool The content is written considering all type of users so you may see some sections in this document actually you do not authorized to use them If you want to get more information about the Oracle s consolidation tool you can download Oracle s user documents with the links below Oracle Hyperion Financial Management User Guide https efescons anadoluefes com docs hfm_user pdf Oracle Smartview Microsoft Office Add in User Guide https efescons anadoluefes com docs smart view User pdf Prepare your computer The link below contains the instructions to prepare your computer to use HFM https efescons anadoluefes com docs Anadolu EFES Financial Consolidation and Reporting Project Guide for pre paring a User computer pdf About working environment As a user you will use two kinds of environment The first one is web interface You need to use Internet Explorer or Firefox to use this web interface Oracle calls it as Oracle Enterprise Performance Management System Workspace or Oracle Hyperion Workspace The second one is Microsoft Excel interface You need to install a small Add In to use Microsoft Interface All users should do some settings on their computer to use these environments You can find information about these settings at the
48. ntes Tools Consolidation Help H Se Explore IS e EE scorch RE 2 200 7 Application Tasks Ei Documents gt 1cP001 Balance sheet accounts ICP x De Documents a ICP001 Balance sheet accounts ICP Balance sheet accounts ICP information Sick Currency RUR m Gh eromnpaw iine Ei E ei j HU ie Cl CO 3 D G 8 ae L S Data Point of View maintenance EE Scenario ICP_Matching Year 2012 d Period December View lt Scenario View gt st Entity G20 E100 y d Value lt Entity Currency gt v CH Current trade receivables from related parties Glen SON S L NEN 1 Other receivables from related parties g iE icp matching process Non current trade receivables from related parties E ln confirmation process Other non current receivables from related parties a Current trade payables to related parties ICP001 Balance shee Other current payables to related parties E 1cp002 P accounts ICP Non current trade payables to related parties E 1CP003 PPE accounts IC Other non current payables to related parties E115 Anadolu Efes Biracilik E118 Anadolu Ef ve Malt Sanayii AS Ticaret A S Aefes Di Total e e EE ES S ICP004 Intangible accor Finished goods E Cragg Cp matching pr Trade goods Bi icp matchina renorts Work in progress gt Raw materials 2 100 Data input screens are designed by considering reporting footnotes and relation between the accounts Users will use same screen even they input m
49. on helps user switch between different data pages Number of dimensions listed on POV section depends on form design If you click on a dimension name on the POV section A member selection dialog will be open Data Form Grid This section contains data cell grids You can input and view financial data here Color of the data cells has a special meaning You can learn this meaning from legend section Legend This section contains color code meanings of the data cells HFM Application Data Entry Form Right Click Menu Content of this menu changes according to selected Entity and Value dimension members A Cell Information Y Cell Information Gives detailed information about selected data cell Unlock locked data Cell Text Eip Force Calculate Cell Text G t Force Calculate Contribution Opens cell text comment entry dialog fy Lock Ta Unlock Force Calculate 3 Manage Process This option is the same option on the tool bar Allocate Be Source Transactions Lock a DEE Lock data cell for further data entry This option may prevent some calculation so only i Entity Details specific type of users can lock data cells Cell History d B Run EPU Unlock kp Force EPU Crm Manage Process Opens manage process dialog Entity Details Gives detailed information about selected entity Cell History Gives detailed log about data changes on current data cell Consolidate Cell Information Run consolidation for pa
50. ons on SmartView Panel window 44 45 Input your username and password if they are asked Connect to Data Source User Authentication Needed Enter corect usemame and password to sign on kocsistem http sfefsepmt082 anadolu corp 19000 workspace Sn wksp Select Reporting and Analysis Framework on drop down list Smart View Select Server to proceed Orade Hyperion Fnandal Management Fusion Edition 46 Reports in the system will be listed in Folder Tree structure Select and double click on desired report Smart View ID UO CH LONNHECCUONS B H bim sfefsepmt082 anadolu corp 19000 rafra 4 EI Administration EL EI AEFESMNG A pop up window will be appear in order to provide you the ability to select POV of the report Select desired POV members In the Import Document As section you can select input format of the report Import Workspace Document Preview User Point of View This report book runs for the members on the user Point of View listed E All Pages Split Pages across worksheets Refresh Using Workspace Point of View Back Next EWEN Cancel e After POV selection preview of the report will be displayed in the window You can click on Finish button to complete report import action Import Workspace Document BALANCE SHEET Anadolu Efes Biraciaik ve Malt Sanavii Anonim irketi December 2012 ICP ICP None Customi None
51. ore than one company or reporting period values We define point of view section of the input screens in order to five users the ability to change the company or period they are working on You can see the point of view section below Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Sistem A S Help Log Off ECH Navigate File View Favorites Tools Consolidation Help L Se Explore Sr e DEET ie search REN Avance Application Tasks Ta Documents gt ICP001 Balance sheet accounts ICP x Documents ICP001 Balance sheet accounts ICP Balance sheet accounts ICP information dournals Currency RUR e Wh intercon l B g owu OB e a al Ej Ga amp a L E Data P Maintenance Year 2012 Sg Period December y View lt Scenario View gt v ate Entity G20 E100 EP Load E115 Anadolu Efes Birac l k E118 Anadol ve Malt Sanayii A S Ticaret A S Aefe Total i E Extract Before input any data you must sure you are on right point of view section If not you need to change your point of view properly For example I want to input data for Coca Cola ecek A Si so need to click on Entity G20 E100 After that need to find Coca Cola ecek A on the left side of the window At the left side of the window you see the items listed i
52. orting process GIT Trade goods Entity Details GIT Raw materials Cell History GIT Packaging materials other than bottles and cases hg Run EPU 7 4 100 2 f re 3 s After calculate your data you need to check your intercompany related values are consisted with your partner values You can use ICP Matching reports for this puspose You can find ICP matching reports under ICP matching process task list If you double click on a report a parameter screen appears In this parameter screen first you should select point of view for the report Select Override Report Definition option at the top of point of view section and select Point of view items You should always select ICP_Matching for scenario YTD for View and USD for Value Second you should select your entity group You need to select Override Report definition options at the top of Entity and ICP Partner sections You can select aspecific entity group or simply keep them as G40 Base Third you should select Override report definition at the top of Report Format Select HEM FORMAT as report format and HFM_IntercompnatDefault_new xsl for Report template And last define matcihng suppression values and select OK to run report Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer Ale E gw O ORACLE Enterprise Performance Management System Workspace Fusion Editio
53. position November 8 2013 3 Default E CHECK_EBI_BS Statement of financial position November 8 2013 3 Default E CHECK_IC_AEFES Income statement November 8 2013 3 Default E CHECK_IC_EBI Income statement October 11 2013 8 0 Default E Cons_scope Shareholders equity Movement November 13 2013 SC_HOL G01 Currency Rates Rates September 2 2013 7 Default LO G02 Consolidate Translate Calcula Consolidate Translate Caloulat October 3 2013 iid ofa ei ICP matching process ICP matching process July 25 2013 1 06 PN Default el IFRS reporting process IFRS reporting process July 25 2013 1 02 PN Default EJ IFRS validations All Entities IFRS validations all entities September 16 2013 Default d IFRS_CONFO1_01 Current trade rect Current trade receivables and pa September 20 2013 Default GR IFRS_CONFO1_02 Non current trade Non current trade receivables am September 20 2013 Default Ga IFRS_CONFO1_03 Other receivables Other receivables and payables f September 23 2013 Default di IFRS_CONF01_04 Non current other Non current other receivables ani September 23 2013 Default ei Management reporting process Management reporting SE 12 2013 Default October 24 2013 7 1 Default E Show other users private docs Favorites e If you click on the plus sign left of the task lists Different type of HFM items wi
54. put Currency and Consolidation Rates Start Period for Data Input Approve ICT Data APPROVE Vv Start IFRS Data Input Print Reports SE KG APPROVE Approve IFRS Data q END D Tasks for consolidation admins 59 Management consolidation and reporting process START Input Currency and Consolidation Rates Start Period for Data Input Approve ICT Data APPROVE Vv Start IFRS Data Input Print Reports Run Consolidation and Lock Dala KGAPPROVE Approve IFRS Data Tasks for consolidation admins 60
55. rent entities This option runs intelligent calculation during Cell Text consolidation If no data changes this option does not run consolidation This option is Consolidate only available for consolidation users art Calculate Contribution FE Consolidate all With Data Consolidate All With Data SI Consolidate All Run consolidation only for entities which has data This option is only available for GE Translate consolidation users Lock l a Unlock Consolidate All eg Run consolidation for all entities This option is only available for consolidation users GA Manage Process CB wane TS Translate B a E Run currency translation 3 Entity Details FE Cell History K HFM Application Data Entry Form Member Selection Dialog E119 Cypex Co Lid Cypex E120 Anadolu Efes Technical and Management Co G G Dimension Selection If HFM data form has more than one dimension on POV section you can change selected dimension from this option to change selected member for it Dimension Content You can view all member content of the selected dimension and select any member to add Member Selection section Member Selection This section lists all selected members for all POV dimensions Selection Buttons In order to select a member for a POV you need to find a member from the Dimension Content section and select it After that you need to click on right blue arrow to add this member to Me
56. rm 320 Ticari Bor lar HYPERIONTEST UFRSDEMO Sheet2 Sheet3 Ready Smart View ribbon This section contains buttons to manage Smart View functions Connection Panel You can connect to Hyperion server with this panel In addition to that you can open HFM Forms or Reports into Excel with the help of this window How to Use Oracle Hyperion Products WEB Interface Oracle HFM Basic Actions e Open the URL http efescons anadoluefes com workspace on Internet Explorer and ligin to system by entering your HFM username and password ORACLE Enterprise Performance Management System Workspace Fusion Edition File Log On User Name kocsistem Password ORACLE ENTERPRISE PERFORMANCE MANAGEMENT SYSTEM Copyright 2005 2013 Oracle and or its affiliates All rights reserved zl 100 5 e Click on EFESCONS under the Quick Links gt Applications gt Consolidation section in order to start HFM application ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Sistem A S Help Log Off Navigate File View Favorites Tools Help F Be Explore WS CG S ah Links i EFESCONS Favorites i HEADCOUNT Zen HomePage O ting R t PA ii My Personal Page E FT_3_Konsolide Di er Kapsaml Gelir Tablosu a 10 11 7 5 20 Income Taxes Deferred Tax Assets and Liabilities Consolidation a 15 16
57. s ei intercompany Data d Journals This item contains options to manage and create journal entries These options are necessary for consolidation users so they may not be seen by other type of a users a Maintenance EF Load Data E Extract This section contains functions to manage financial data directly You can bulk copy or delete your data with these options These options may cause data lost Load You can load your financial data to a specific formatted text file with this option Extract You can extract your financial data to a specific formatted text file with this option HFM Application Data Entry Form S Oracle Enterprise Performance Manage ion Edition Wir t Explore e ia X ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Sistem A S Help Log Off avorites Tools Consolidation Help i o amp Application Tasks Ui Documents 01_01 Cash and cash equivalents ICP vs FC x 01_01 Cash and cash equivalents ICP vs FC Cash and cash equivalents ICP vs FC Task Lists Ki USI icp matching process Les Agl wm Ep eracoa Do A me GG B a US TFRs reporting process ti 9 Management reporting process T Favorites Alternatifbank A Abank ICP Total
58. s After that open HFM Manage Ownership screen and select Percent Ownership and Direct Percent Ownership options under the Calculate Ownership section Then select All Entities and select necessary periods At last click on Calculate button HFM will automatically calculated direct ownership rates and put it in DOWN column and calculate direct indirect ownership and put it in POWN column Oracle HFM Manual Journal creation process 1 Open period for journal creation Before creating journals it should be ensured that period is opened for journal entry Please do not confuse about period open for data entry and period open for journals They have different process management screens and flow Even if the period is close for data entry user can open periods for journal creation In order to open periods please follow the steps below Click Consolidation gt Journals gt Periods Oracle Enterprise Performance Management System Workspace Fusion Edition Window ORACLE Enterprise Performance Management System Workspace Fusion Edition Favorites Tools Consolidation Di Documents S Journals 4 Manage ail Intercompany ka Templates Data e S Periods E Maintenance S Groups s Load Sh Reports bei Extract When it is clicked on Periods tab the screen Favorites Tools Consolidation Help on the left will appear Selectable Point of Views POVs are only Scenario and
59. stem AS Help Log Off a Navigate File View Favorites Tools Consolidation Help a Se Explore re EE scorch I 2 200 E Application Tasks Ui Documents ICP001 Balance sheet accounts ICP Documents ICP001 Balance sheet accounts ICP Balance sheet accounts ICP information r Currency RUR A E Adions LH te IT B EB c ia ee EA GS amp Eu E IS Data Point of View Maintenance EE Scenario ICP_Matching Zi Year 2012 d Period December A View lt Scenario View gt st Entity G20 E100 E PS Load dx Value lt Entity Currency gt v a E E115 Anadolu Efes Biracilik E118 Anadol ve Malt Sanayii AS Ticaret A S Aefe yo r n After you input data you must run calculations in order to see BS and PL values To do that you need to right click on a data cell yellow or green cells and select Calculate or Force Calculate If both options are listed prefer Force Calculate Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer ORACLE Enterprise Performance Management System Workspace Fusion Edition Logged in as Ko Sistem AS Help Log Off Navigate File View Favorites Tools Consolidation Help L Se Explore sl EFESCONS Search EE advanced El Application Tasks Documents gt ICP001 Balance sheet accounts ICP x Do Documents ICP001 Balance sheet ac
60. stem Workspace Fusion Edition aad Explore pl HomePage Explore AEFESMNG English AEFESMNG English BALANCE SHEET Year 2012 Period December Entity G40 Value lt Entity Curr Total gt Automatic Zoom BALANCE SHEET Anadolu Efes Biracilik ve Malt Sanayii Anonim Sirketi December 2012 2014 21yE map 20124 Cash and cash equivalents 522 181 522 181 Current financial investments 3 804 3 804 Current trade receivables 283 781 283 781 Other receivables 13 184 13 184 Current biological assets Inventories 268 242 268 242 Current deferred tax assets Other current assets 164 509 164 509 Curent derivative financial instruments asset e Asset held for sale and discontinued operation Receivables from continuing construction contracts Assets related to current period income tax 22 930 22 930 Current prepaid expenses 140 842 140 842 1 884 589 279 514 1 005 446 13 908 870 452 253 796 279 40 349 237 363 Current assets 1 419 473 419 473 Investments in associates Non current financial investments Non current trade receivables Other non current receivables 1 966 1 966 Non current biological assets Property plant and equipment 1 707 181 1 707 181 Non current deferred tax assets 1 906 1 906 Other non current assets Intangible assets 93 656 593 656 Investment properties Non current derivative financial instruments asset Non current prepaid e
61. vigate File View Favorites Tools Consolidation Help LS Se Explore Rica EFESCONS Application Tasks 1 Task Lists Filters Docume Descri Time ity Class Owner J EANES EI HQ Consolidation Process zeen 2013 9 54 AM PA kocsistem Native Directory Pai Se HM a Blues reporting process ai EI ICP confirmation process July 12 2013 2 27 PM Default kocsistem Native Directory PE Y im Management reporting process 2 EN ICP matching reports July 12 2013 3 04 PM Default kocsistem Native Directory All a IFRS reporting process July 23 2013 4 06 PM Default kocsistem Native Directory Document Category Management reporting process July 30 2013 9 11 AM Default kocsistem Native Directory ll ei aen op 4 EI Reporting Comments and Notes September 23 2013 1 03PM SC_HOL selman Native Directory DEENEN ee Borrovings Entry October 31 2013 10 44AM _ Default kocsistem Native Directory amp Borrovings Entry Test Debug October 31 2013 3 08PM _ _ Default kocsistem Native Directory LL lt gt Borrowing information entry November 7 2013 9 25AM SC HO baris dinc efespilsen com
62. xpenses 63 006 63 006 4 585 697 41 786 70 818 779 5 092 4 529 212 62 755 7 489 3 862 909 173 048 Non current assets 2 367 715 2 367 715 3 753 888 Total assets 3 787 183 3 787 183 13 339 585 a P T You can convert the report PDF format by click on PGDF icon in the toolbar Favorites Tools Help xplore a De Wi Open In DIE xplore AEFESmints cngusn h BALANCE SHEET iod December Entity G40 Value lt Entity Curr Total gt BALANI 39 You can save the report on your computer as a static PDF report by click on the Acrobat Reader save button Oracle Enterprise Performance Management System Workspace Fusion Edition Windows Internet Explorer ORACLE Enterprise Performance Management System Workspace Fusion Edition rite Explore a a E Ip BALANCE SHEET Anadolu Efes Biracilik ve Malt Sanayii Anonim irketi Cash and cash equivalents Current financial investments Current trade receivables Other receivables Current biological assets Inventories Current deferred tax assets Other current assets Current derivative financial instruments asset Asset held for sale and discontinued operations Receivables from continuing construction contracts Assets related to current income tax Non current trade receivables Other non current receivables Non current biological assets Property plant and equipment Non current deferred tav arcate

User Manual - Anadolu EFES Financial Consolidation and Reporting

Contents

Download Pdf Manuals

Related Search

Related Contents