11 Replies Latest reply on Sep 30, 2011 10:43 AM by 225297

    Question reg HFM

    726987
      Hi,

      I am new to Hyperion. I am using "hyperion system 9 financial management:create and manage applications" guide alongwith Hyperion 9 VM.

      The guide mentions about these two steps to begin with:

      1. In the Hyperion folder on the Windows desktop, double-click Start BI+ Server.
      2. In the Hyperion folder on the Windows desktop, double-click Financial Management Web
      Client.

      However, I am not able to find the paths for the same. Could someone please help me with the same?

      Thanks.
        • 1. Re: Question reg HFM
          726987
          Hi Hyperion Gurus,

          To add to the question..following the same guide, I am facing an error at point 7.1 - Loading a data file. Error file attached. I could load EastWest.dat but then got stuck at load of Traindata.dat.

          Any help in this regard shall be much appreciated.

          Regards,
          Karan

          -----------------------

          Error Log (File Name: TrainData.log)


          Load data started: 9/21/2011 18:56:15.
          Line: 328, Error: No such member
          WestSales; USD; Cash; [None]; [None]; [None]; Movement; 250 ; 257 ; 262 ; 267 ; 273 ; 278 ; 284 ; 289 ; 295 ; 301 ; 307 ; 313
          Movement
          Line: 331, Error: No such member
          WestSales; USD; ShortTermRec; [None]; [None]; [None]; Movement; 1200; 1245; 1350 ; 1377 ; 1405 ; 1433 ; 1461 ; 1491 ; 1520 ; 1551 ; 1582 ; 1613
          Movement
          Line: 336, Error: No such member
          WestSales; USD; TangibleAssets; [None]; [None]; [None]; Movement; 1890; 1700; 2000 ; 2040 ; 2081 ; 2122 ; 2165 ; 2208 ; 2252 ; 2297 ; 2343 ; 2390
          Movement
          Line: 434, Error: No such member
          Plant1; USD; Cash; [None]; [None]; [None]; Movement; 175 ; 180 ; 183 ; 187 ; 191 ; 195 ; 199 ; 202 ; 207 ; 211 ; 215 ; 219
          Movement
          Line: 437, Error: No such member
          Plant1; USD; ShortTermRec; [None]; [None]; [None]; Movement; 840 ; 872 ; 945 ; 964 ; 984 ; 1003 ; 1023 ; 1044 ; 1064 ; 1086 ; 1107 ; 1129
          Movement
          Line: 442, Error: No such member
          Plant1; USD; TangibleAssets; [None]; [None]; [None]; Movement; 1323 ; 1190 ; 1400 ; 1428 ; 1457 ; 1485 ; 1516 ; 1546 ; 1576 ; 1608 ; 1640 ; 1673
          Movement
          Line: 520, Error: No such member
          EastSales; USD; Cash; [None]; [None]; [None]; Movement; 150 ; 154 ; 157 ; 160 ; 164 ; 167 ; 170 ; 173 ; 177 ; 181 ; 184 ; 188
          Movement
          Line: 523, Error: No such member
          EastSales; USD; ShortTermRec; [None]; [None]; [None]; Movement; 720 ; 747 ; 810 ; 826 ; 843 ; 860 ; 877 ; 895 ; 912 ; 931 ; 949 ; 968
          Movement
          Line: 528, Error: No such member
          EastSales; USD; TangibleAssets; [None]; [None]; [None]; Movement; 1134 ; 1020 ; 1200 ; 1224 ; 1249 ; 1273 ; 1299 ; 1325 ; 1351 ; 1378 ; 1406 ; 1434
          Movement
          Line: 597, Error: No such member
          1100; USD; Cash; [None]; [None]; [None]; Movement; 75 ; 77 ; 79 ; 80 ; 96 ; 97 ; 99 ; 101 ; 94 ; 96 ; 98 ; 100
          Movement
          Line: 600, Error: No such member
          1100; USD; ShortTermRec; [None]; [None]; [None]; Movement; 360 ; 374 ; 405 ; 413 ; 492 ; 502 ; 511 ; 522 ; 486 ; 496 ; 506 ; 516
          Movement
          Line: 605, Error: No such member
          1100; USD; TangibleAssets; [None]; [None]; [None]; Movement; 567 ; 510 ; 600 ; 612 ; 728 ; 743 ; 758 ; 773 ; 721 ; 735 ; 750 ; 765
          Movement
          Line: 675, Error: No such member
          1200; USD; Cash; [None]; [None]; [None]; Movement; 50 ; 51 ; 52 ; 53 ; 68 ; 70 ; 71 ; 72 ; 71 ; 72 ; 74 ; 75
          Movement
          Line: 678, Error: No such member
          1200; USD; ShortTermRec; [None]; [None]; [None]; Movement; 240 ; 249 ; 270 ; 275 ; 351 ; 358 ; 365 ; 373 ; 365 ; 372 ; 380 ; 387
          Movement
          Line: 683, Error: No such member
          1200; USD; TangibleAssets; [None]; [None]; [None]; Movement; 378 ; 340 ; 400 ; 408 ; 520 ; 531 ; 541 ; 552 ; 540 ; 551 ; 562 ; 574
          Movement
          Line: 753, Error: No such member
          EmeaSales; EUR; Cash; [None]; [None]; [None]; Movement; 130 ; 134 ; 136 ; 144 ; 147 ; 150 ; 145 ; 147 ; 150 ; 166 ; 169 ; 172
          Movement
          Line: 756, Error: No such member
          EmeaSales; EUR; ShortTermRec; [None]; [None]; [None]; Movement; 624 ; 647 ; 702 ; 744 ; 759 ; 774 ; 745 ; 760 ; 775 ; 853 ; 870 ; 887
          Movement
          Line: 761, Error: No such member
          EmeaSales; EUR; TangibleAssets; [None]; [None]; [None]; Movement; 983 ; 884 ; 1040 ; 1102 ; 1124 ; 1146 ; 1104 ; 1126 ; 1149 ; 1263 ; 1289 ; 1315
          Movement
          Line: 831, Error: No such member
          1400; EUR; Cash; [None]; [None]; [None]; Movement; 100 ; 103 ; 105 ; 120 ; 123 ; 125 ; 119 ; 121 ; 124 ; 132 ; 135 ; 138
          Movement
          Line: 834, Error: No such member
          1400; EUR; ShortTermRec; [None]; [None]; [None]; Movement; 480 ; 498 ; 540 ; 620 ; 632 ; 645 ; 614 ; 626 ; 638 ; 682 ; 696 ; 710
          Movement
          Line: 839, Error: No such member
          1400; EUR; TangibleAssets; [None]; [None]; [None]; Movement; 756 ; 680 ; 800 ; 918 ; 936 ; 955 ; 909 ; 927 ; 946 ; 1011 ; 1031 ; 1052
          Movement
          Line: 908, Error: No such member
          Plant2; EUR; Cash; [None]; [None]; [None]; Movement; 150 ; 154 ; 157 ; 160 ; 164 ; 167 ; 185 ; 188 ; 192 ; 196 ; 200 ; 203
          Movement
          Line: 911, Error: No such member
          Plant2; EUR; ShortTermRec; [None]; [None]; [None]; Movement; 720 ; 747 ; 810 ; 826 ; 843 ; 860 ; 950 ; 969 ; 988 ; 1008 ; 1028 ; 1048
          Movement
          Line: 916, Error: No such member
          Plant2; EUR; TangibleAssets; [None]; [None]; [None]; Movement; 1134 ; 1020 ; 1200 ; 1224 ; 1249 ; 1273 ; 1407 ; 1435 ; 1464 ; 1493 ; 1523 ; 1554
          Movement
          Line: 985, Error: No such member
          EmeaServices; GBP; Cash; [None]; [None]; [None]; Movement; 225 ; 231 ; 236 ; 240 ; 243 ; 247 ; 253 ; 257 ; 271 ; 277 ; 282 ; 288
          Movement
          Line: 988, Error: No such member
          EmeaServices; GBP; ShortTermRec; [None]; [None]; [None]; Movement; 1080 ; 1121 ; 1215 ; 1239 ; 1250 ; 1275 ; 1300 ; 1327 ; 1398 ; 1427 ; 1455 ; 1484
          Movement
          Line: 993, Error: No such member
          EmeaServices; GBP; TangibleAssets; [None]; [None]; [None]; Movement; 1701 ; 1530 ; 1800 ; 1836 ; 1852 ; 1889 ; 1927 ; 1965 ; 2072 ; 2113 ; 2156 ; 2199
          Movement
          Load data completed: 9/21/2011 18:56:51.
          • 2. Re: Question reg HFM
            Erich Ranz
            Do you have a non-calculated base account set up named 'Movement'?
            • 3. Re: Question reg HFM
              Erich Ranz
              Do you have a non-calculated base account set up named 'Movement'?
              • 4. Re: Question reg HFM
                Erich Ranz
                Do you have a non-calculated base account set up named 'Movement'?
                • 5. Re: Question reg HFM
                  726987
                  Yes, it is under Custom 4 -> AllCustom4 -> Movement.

                  Thanks.
                  • 6. Re: Question reg HFM
                    Erich Ranz
                    Custom4 would be in a different position in the file than Account. Try putting your load data in the following format:
                    scenario;year;period;view;entity;value;account;icp;c1;c2;c3;c4;amount
                    1 person found this helpful
                    • 7. Re: Question reg HFM
                      Sofia
                      Or you can put the following line to said in which order you are loading

                      !COLUMN_ORDER= Year, Value, Entity,Custom1,Custom2, Account,ICP
                      1 person found this helpful
                      • 8. Re: Question reg HFM
                        726987
                        Hi,

                        I have gone through your responses. The issue is as follows: if I follow the approach mentioned in user guide and reach till the point I save training3.xml, the one which is given as sample and the one which I have created are different as in the 'Movement' member is not there in the sample training3.xml. Also the guide does not specify the properties for Movement member so I left at default , which I am not sure is the right way of doing it. Apart from that, in the sample file 'TrainLoad2.app', there is no mention of word 'Movement' anywhere which I think is the reason why I am getting this error because in the data file 'TrainData.dat', Movement member records are there.

                        I tried editing the 'TrainLoad2.app' file by adding a row under 'Custom 4' at the same level as 'ClosingBalance', taking all parameters as 'N' but that did not help. Rather now when I see the error file, I am seeing 12 records per errored row no (one for each month). Earlier before editing the 'TrainLoad2.app' there was only one error row per record, as I had pasted earlier.

                        Regards,
                        • 9. Re: Question reg HFM
                          225297
                          As mentioned by other user, please order the columns in the below order
                          scenario;year;period;view;entity;value;account;icp;c1;c2;c3;c4;amount

                          Once you change the order, try loading the file again. If you see any errors, then check if that error is because of which dimension. Based on that we can take a call.

                          Hope this helps.

                          Mark the response accordingly Helpful/Answered so that we will know how to help you.
                          • 10. Re: Question reg HFM
                            726987
                            Hi,

                            I tried doing that. Since data section having 'Movement' (Custom4 dimension) had problem, I modified the same in .DAT file as shown below - added !COLUMN_ORDER=Entity, Value, Account, Custom1, Custom2, Custom3, Custom4 (but copying first 3 data rows only). Please note that I have not changed the order of Scenario, View, Year, Period and ICP as it was same in one more file EastWest.DAT which got loaded without error:

                            OLD*

                            !SCENARIO=Actual
                            !VIEW=Periodic
                            !YEAR=2005
                            !PERIOD=January...December
                            !ICP=[ICP None]

                            !DATA

                            'California.WestSales BS;;;;;;;;;;;
                            WestSales; USD; Cash; [None]; [None]; [None]; Increases; 900 ; 990 ; 1105 ; 1127 ; 1150 ; 1173 ; 1196 ; 1220 ; 1244 ; 1269 ; 1295 ; 1321
                            WestSales; USD; Cash; [None]; [None]; [None]; Decreases; -100 ; -110 ; -115 ; -117 ; -120 ; -122 ; -124 ; -127 ; -130 ; -132 ; -135 ; -137
                            WestSales; USD; Cash; [None]; [None]; [None]; Movement; 250 ; 257 ; 262 ; 267 ; 273 ; 278 ; 284 ; 289 ; 295 ; 301 ; 307 ; 313

                            NEW (After Change)*


                            !SCENARIO=Actual
                            !VIEW=Periodic
                            !YEAR=2005
                            !PERIOD=January...December
                            !ICP=[ICP None]

                            !COLUMN_ORDER=Entity, Value, Account, Custom1, Custom2, Custom3, Custom4

                            !DATA

                            'California.WestSales BS;;;;;;;;;;;
                            WestSales; USD; Cash; [None]; [None]; [None]; Increases; 900 ; 990 ; 1105 ; 1127 ; 1150 ; 1173 ; 1196 ; 1220 ; 1244 ; 1269 ; 1295 ; 1321
                            WestSales; USD; Cash; [None]; [None]; [None]; Decreases; -100 ; -110 ; -115 ; -117 ; -120 ; -122 ; -124 ; -127 ; -130 ; -132 ; -135 ; -137
                            WestSales; USD; Cash; [None]; [None]; [None]; Movement; 250 ; 257 ; 262 ; 267 ; 273 ; 278 ; 284 ; 289 ; 295 ; 301 ; 307 ; 313

                            After loading the modified DAT file, I got the following error (as per log file):

                            Load data started: 9/29/2011 16:04:50.
                            Line: 330, Error: No such member
                            WestSales; USD; Cash; [None]; [None]; [None]; Movement; 250 ; 257 ; 262 ; 267 ; 273 ; 278 ; 284 ; 289 ; 295 ; 301 ; 307 ; 313
                            Movement
                            Line: 333, Error: No such member
                            WestSales; USD; ShortTermRec; [None]; [None]; [None]; Movement; 1200; 1245; 1350 ; 1377 ; 1405 ; 1433 ; 1461 ; 1491 ; 1520 ; 1551 ; 1582 ; 1613
                            Movement
                            Line: 338, Error: No such member
                            WestSales; USD; TangibleAssets; [None]; [None]; [None]; Movement; 1890; 1700; 2000 ; 2040 ; 2081 ; 2122 ; 2165 ; 2208 ; 2252 ; 2297 ; 2343 ; 2390
                            Movement
                            Line: 436, Error: No such member
                            Plant1; USD; Cash; [None]; [None]; [None]; Movement; 175 ; 180 ; 183 ; 187 ; 191 ; 195 ; 199 ; 202 ; 207 ; 211 ; 215 ; 219
                            Movement
                            Line: 439, Error: No such member
                            Plant1; USD; ShortTermRec; [None]; [None]; [None]; Movement; 840 ; 872 ; 945 ; 964 ; 984 ; 1003 ; 1023 ; 1044 ; 1064 ; 1086 ; 1107 ; 1129
                            Movement
                            Line: 444, Error: No such member
                            Plant1; USD; TangibleAssets; [None]; [None]; [None]; Movement; 1323 ; 1190 ; 1400 ; 1428 ; 1457 ; 1485 ; 1516 ; 1546 ; 1576 ; 1608 ; 1640 ; 1673
                            Movement
                            Line: 522, Error: No such member
                            EastSales; USD; Cash; [None]; [None]; [None]; Movement; 150 ; 154 ; 157 ; 160 ; 164 ; 167 ; 170 ; 173 ; 177 ; 181 ; 184 ; 188
                            Movement
                            Line: 525, Error: No such member
                            EastSales; USD; ShortTermRec; [None]; [None]; [None]; Movement; 720 ; 747 ; 810 ; 826 ; 843 ; 860 ; 877 ; 895 ; 912 ; 931 ; 949 ; 968
                            Movement
                            Line: 530, Error: No such member
                            EastSales; USD; TangibleAssets; [None]; [None]; [None]; Movement; 1134 ; 1020 ; 1200 ; 1224 ; 1249 ; 1273 ; 1299 ; 1325 ; 1351 ; 1378 ; 1406 ; 1434
                            Movement
                            Line: 599, Error: No such member
                            1100; USD; Cash; [None]; [None]; [None]; Movement; 75 ; 77 ; 79 ; 80 ; 96 ; 97 ; 99 ; 101 ; 94 ; 96 ; 98 ; 100
                            Movement
                            Line: 602, Error: No such member
                            1100; USD; ShortTermRec; [None]; [None]; [None]; Movement; 360 ; 374 ; 405 ; 413 ; 492 ; 502 ; 511 ; 522 ; 486 ; 496 ; 506 ; 516
                            Movement
                            Line: 607, Error: No such member
                            1100; USD; TangibleAssets; [None]; [None]; [None]; Movement; 567 ; 510 ; 600 ; 612 ; 728 ; 743 ; 758 ; 773 ; 721 ; 735 ; 750 ; 765
                            Movement
                            Line: 677, Error: No such member
                            1200; USD; Cash; [None]; [None]; [None]; Movement; 50 ; 51 ; 52 ; 53 ; 68 ; 70 ; 71 ; 72 ; 71 ; 72 ; 74 ; 75
                            Movement
                            Line: 680, Error: No such member
                            1200; USD; ShortTermRec; [None]; [None]; [None]; Movement; 240 ; 249 ; 270 ; 275 ; 351 ; 358 ; 365 ; 373 ; 365 ; 372 ; 380 ; 387
                            Movement
                            Line: 685, Error: No such member
                            1200; USD; TangibleAssets; [None]; [None]; [None]; Movement; 378 ; 340 ; 400 ; 408 ; 520 ; 531 ; 541 ; 552 ; 540 ; 551 ; 562 ; 574
                            Movement
                            Line: 755, Error: No such member
                            EmeaSales; EUR; Cash; [None]; [None]; [None]; Movement; 130 ; 134 ; 136 ; 144 ; 147 ; 150 ; 145 ; 147 ; 150 ; 166 ; 169 ; 172
                            Movement
                            Line: 758, Error: No such member
                            EmeaSales; EUR; ShortTermRec; [None]; [None]; [None]; Movement; 624 ; 647 ; 702 ; 744 ; 759 ; 774 ; 745 ; 760 ; 775 ; 853 ; 870 ; 887
                            Movement
                            Line: 763, Error: No such member
                            EmeaSales; EUR; TangibleAssets; [None]; [None]; [None]; Movement; 983 ; 884 ; 1040 ; 1102 ; 1124 ; 1146 ; 1104 ; 1126 ; 1149 ; 1263 ; 1289 ; 1315
                            Movement
                            Line: 833, Error: No such member
                            1400; EUR; Cash; [None]; [None]; [None]; Movement; 100 ; 103 ; 105 ; 120 ; 123 ; 125 ; 119 ; 121 ; 124 ; 132 ; 135 ; 138
                            Movement
                            Line: 836, Error: No such member
                            1400; EUR; ShortTermRec; [None]; [None]; [None]; Movement; 480 ; 498 ; 540 ; 620 ; 632 ; 645 ; 614 ; 626 ; 638 ; 682 ; 696 ; 710
                            Movement
                            Line: 841, Error: No such member
                            1400; EUR; TangibleAssets; [None]; [None]; [None]; Movement; 756 ; 680 ; 800 ; 918 ; 936 ; 955 ; 909 ; 927 ; 946 ; 1011 ; 1031 ; 1052
                            Movement
                            Line: 910, Error: No such member
                            Plant2; EUR; Cash; [None]; [None]; [None]; Movement; 150 ; 154 ; 157 ; 160 ; 164 ; 167 ; 185 ; 188 ; 192 ; 196 ; 200 ; 203
                            Movement
                            Line: 913, Error: No such member
                            Plant2; EUR; ShortTermRec; [None]; [None]; [None]; Movement; 720 ; 747 ; 810 ; 826 ; 843 ; 860 ; 950 ; 969 ; 988 ; 1008 ; 1028 ; 1048
                            Movement
                            Line: 918, Error: No such member
                            Plant2; EUR; TangibleAssets; [None]; [None]; [None]; Movement; 1134 ; 1020 ; 1200 ; 1224 ; 1249 ; 1273 ; 1407 ; 1435 ; 1464 ; 1493 ; 1523 ; 1554
                            Movement
                            Line: 987, Error: No such member
                            EmeaServices; GBP; Cash; [None]; [None]; [None]; Movement; 225 ; 231 ; 236 ; 240 ; 243 ; 247 ; 253 ; 257 ; 271 ; 277 ; 282 ; 288
                            Movement
                            Line: 990, Error: No such member
                            EmeaServices; GBP; ShortTermRec; [None]; [None]; [None]; Movement; 1080 ; 1121 ; 1215 ; 1239 ; 1250 ; 1275 ; 1300 ; 1327 ; 1398 ; 1427 ; 1455 ; 1484
                            Movement
                            Line: 995, Error: No such member
                            EmeaServices; GBP; TangibleAssets; [None]; [None]; [None]; Movement; 1701 ; 1530 ; 1800 ; 1836 ; 1852 ; 1889 ; 1927 ; 1965 ; 2072 ; 2113 ; 2156 ; 2199
                            Movement
                            Load data completed: 9/29/2011 16:04:53.
                            • 11. Re: Question reg HFM
                              225297
                              Are you sure "Movement" is a member in custom4 dimension? Also check if the account member attributes has Custom4TopMember filled so that the intersection works.