10 Replies Latest reply on Jul 4, 2014 5:38 AM by Roshin

    FDMEE to Planning Data Loaded sucessfully but not able to see data in Planning - Export Fish is Showing in FDMEE

    Roshin

      Hi All

       

      We have loaded Data  from FDMEE to  Planning, Data was  Loaded sucessfully but not able to see data in Planning Application.

       

      In process log i can see its mentioned Data loaded to Cube . Please advise on this . 

       

      Thanks,

      roshi

        • 1. Re: FDMEE to Planning Data Loaded sucessfully but not able to see data in Planning - Export Fish is Showing in FDMEE
          Francisco Amores

          Hi,

          I assume you are selecting the correct POV. DId you check it with Smart View?

           

          Being said that, are you using File or SQL load method?

          If SQL, then switch it to File and check the file exported. Has it data?

           

          Is that a HP multicurrency application? if you use SQL as load method and currency is NULL, the SQL query may not return data.

           

          Hope that helps

          1 person found this helpful
          • 2. Re: FDMEE to Planning Data Loaded sucessfully but not able to see data in Planning - Export Fish is Showing in FDMEE
            Roshin

            Yes I checked in Correct POV using Smartview . Am using File Load Method.

             

             

            The planning application is Multicurrency application only .

             

             

            Method am following is .

             

             

             

            1.Created Flat file .

            2.Defined import formats.

            3.Using Data rule Imported and Validated . ( I got two fishes ) .

            4.Exported in FDMEE - I got the Fish .

             

             

            Please find the log from FDMEE .

             

             

            **************************

            2014-06-19 12:26:44,161 INFO  [AIF]: -------START IMPORT STEP-------

            2014-06-19 12:26:44,598 INFO  [AIF]: -------END IMPORT STEP-------

            2014-06-19 12:26:45,223 INFO  [AIF]: -------START EXPORT STEP-------

            2014-06-19 12:26:45,676 INFO  [AIF]: File Name: dummy.txt

            2014-06-19 12:26:45,739 INFO  [AIF]:

            Move Data for Period 'Jan'

            2014-06-19 12:26:46,848 INFO  [AIF]: [HPLService] Info: Cube Name: Capex

            2014-06-19 12:26:46,848 INFO  [AIF]: [HPLService] Info: Export Mode: ADD_DATA

            2014-06-19 12:26:46,848 INFO  [AIF]: [HPLService] Info: updateMultiCurrencyProperties - BEGIN

            2014-06-19 12:26:48,458 INFO  [AIF]: [HPLService] Info: Currency Properties Exist for Planning Application: XXXXPlan

            2014-06-19 12:26:48,973 INFO  [AIF]: [HPLService] Info: Number of existing multi-currency property rows deleted: 69

            2014-06-19 12:26:49,067 INFO  [AIF]: [HPLService] Info: Base Currency for Application 'XXXXPlan': YYY

            2014-06-19 12:26:50,567 INFO  [AIF]: [HPLService] Info: Number of multi-currency property rows inserted: 69

            2014-06-19 12:26:50,567 INFO  [AIF]: [HPLService] Info: updateMultiCurrencyProperties - END

            2014-06-19 12:26:50,567 INFO  [AIF]: Updated Multi-Curency Information for application:XXXPlan

            2014-06-19 12:26:50,567 INFO  [AIF]: Connecting to essbase using service user:roshin

            2014-06-19 12:26:50,583 INFO  [AIF]: Obtained connection to essbase provider:Embedded

            2014-06-19 12:26:50,598 INFO  [AIF]: Obtained connection to essbase cube Capex

            2014-06-19 12:26:50,629 INFO  [AIF]: Locking rules file AIF0028

            2014-06-19 12:26:50,645 INFO  [AIF]: Successfully locked rules file AIF0028

            2014-06-19 12:26:50,645 INFO  [AIF]: Copying rules file AIF0028 for data load as AIF0028

            2014-06-19 12:26:50,676 INFO  [AIF]: Unlocking rules file AIF0028

            2014-06-19 12:26:50,676 INFO  [AIF]: Successfully unlocked rules file AIF0028

            2014-06-19 12:26:50,676 INFO  [AIF]: The data rules file has been created successfully.

            2014-06-19 12:26:50,676 INFO  [AIF]: Locking rules file AIF0028

            2014-06-19 12:26:50,692 INFO  [AIF]: Successfully locked rules file AIF0028

            2014-06-19 12:26:50,692 INFO  [AIF]: Load data into the cube by launching rules file...

            2014-06-19 12:26:50,692 INFO  [AIF]: Loading data into cube using sql...

            2014-06-19 12:26:50,801 INFO  [AIF]: The data has been loaded by the rules file.

            2014-06-19 12:26:50,801 INFO  [AIF]: Unlocking rules file AIF0028

            2014-06-19 12:26:50,801 INFO  [AIF]: Successfully unlocked rules file AIF0028

            2014-06-19 12:26:50,801 INFO  [AIF]: Executed rule file

            2014-06-19 12:26:50,879 INFO  [AIF]: [HPLService] Info: Creating Drill Through Region for Process Id: 355

            2014-06-19 12:26:50,879 INFO  [AIF]: DrillRegion msg:[createDrillRegions:355] BEGIN

            2014-06-19 12:26:50,879 INFO  [AIF]: [HPLService] Info: Drill Through Region created for Process Id: 355

            2014-06-19 12:26:50,879 INFO  [AIF]: [HPLService] Info: [loadData:355] END (true)

            2014-06-19 12:26:51,051 INFO  [AIF]: -------END EXPORT STEP-------

            2014-06-19 12:26:51,645 INFO  [AIF]: [HPLService] Info: [consolidateData:355,Jan] END (true)

             

             

            **************************

             

             

            But Am not able see the data in Planning Cube .

             

            Thanks,

            Roshin

            • 3. Re: FDMEE to Planning Data Loaded sucessfully but not able to see data in Planning - Export Fish is Showing in FDMEE
              SSN01

              Did you define  the currency  as (Local) in the Location field?

              • 4. Re: FDMEE to Planning Data Loaded sucessfully but not able to see data in Planning - Export Fish is Showing in FDMEE
                Roshin

                Yes I Defined the currency as local in Location Field .

                 

                In Location :

                 

                Functional Currency : Local

                 

                Is it some thing with HSP_Rates . I have put the filed HSP_Rates in Data file and put Hsp_InputValue for that .

                 

                Please advice , its my first work with FDMEE ---> Planning . I was able to load the same data file use Data Sync and Data is available .

                 

                Thanks,

                Roshin Rasheed

                • 5. Re: FDMEE to Planning Data Loaded sucessfully but not able to see data in Planning - Export Fish is Showing in FDMEE
                  Francisco Amores

                  Couple of things:

                   

                  - I was not referring to method you import data but export data. You are using SQL method. Go to Target Applications, select your planning/essbase application, and then set load method as File. Save your settings

                   

                  2014-06-19 12:26:50,692 INFO  [AIF]: Successfully locked rules file AIF0028

                  2014-06-19 12:26:50,692 INFO  [AIF]: Load data into the cube by launching rules file...

                  2014-06-19 12:26:50,692 INFO  [AIF]: Loading data into cube using sql...

                  2014-06-19 12:26:50,801 INFO  [AIF]: The data has been loaded by the rules file.

                  2014-06-19 12:26:50,801 INFO  [AIF]: Unlocking rules file AIF0028

                  2014-06-19 12:26:50,801 INFO  [AIF]: Successfully unlocked rules file AIF0028

                   

                  - Then export again and review .DAT file generated in outbox folder. Is it empty?

                   

                  - You need to add a new dimension to your import format (Add Dimension > Currency). Then add Local as expression

                   

                  - Import data again, validate, and export

                  • 6. Re: FDMEE to Planning Data Loaded sucessfully but not able to see data in Planning - Export Fish is Showing in FDMEE
                    Roshin

                    Thank you Franc !!!

                     

                     

                    I was able to see the Data file and was able to identify the problem . It was with Period Mappings .

                     

                    Franc one doubt . Can i Omit Period , Scenario and Some other fields which is specific to Planning not to Source system in Data file . Can i map that in FDMEE .

                    For Eg : i have CostCenter which is not available in Source , We are pushing that to a Dummy Bucket . As of now in Data File i have added that field and added the member field mannually in the file from Source .

                     

                    Can we do that process using FDMEE . Please advice .

                     

                     

                    Thanks for your help in this

                     

                    roshi

                    1 person found this helpful
                    • 7. Re: FDMEE to Planning Data Loaded sucessfully but not able to see data in Planning - Export Fish is Showing in FDMEE
                      Francisco Amores

                      Hi,

                       

                      Yes you can.

                       

                      You can setup your import format so you type in Expression field the value you want to import for Cost Center. Then set field number to 1.

                      BTW, Period and Scenario are managed by period and category mappings so you don't really need to import these values as they will be exported to your target application from mappings.

                      1 person found this helpful