0 Replies Latest reply on Jun 12, 2014 7:37 AM by User9947495-Oracle

    When import flat file through FDMEE 11.1.2.3 to hyperion planning, CANNOT find the drill through option.

    User9947495-Oracle

      Environment: epm 11.1.2.3 all the FDMEE, HFM, PLANNING, DRM I've installed in the same vmware with Chinese character.

       

      in the same environment, I've successfully tested import flat file through FDMEE to HFM. (data is correct and drill through function also works fine.)

      While for planning, after successfully import data to planning, I can see the highlighted data cell with little triangle up right indicating the drill through function. But when I right click the data cell, there prompt a weird empty small window without any option like what I can find in HFM data cell.So I cannot drill back to FDMEE interface with valid data in web page. While in smartview, I can find default drill through button and open a drill through interface with no data when using essbase connection.

       

      I check FDMEE settings for the specific planning application. I've set the drill through function as "Yes".

      I cannot find .dat file in FDMEE root folder outbox.

      Then I check EAS, drill through setting and find NO definitions in the drill through settings. 

      I've checked several documents, but unfortunately, I cannot find any guide to set the definitions. .

      Here below is the log file from my FDMEE outbox. As you see in the last several lines, "the drill through region is created"

       

      2014-06-12 14:04:38,000 INFO  [AIF]: FDMEE Process Start, Process ID: 95

      2014-06-12 14:04:38,000 INFO  [AIF]: FDMEE Logging Level: 4

      2014-06-12 14:04:38,000 INFO  [AIF]: FDMEE Log File: C:\FDMEE\outbox\logs\CEAIR_95.log

      2014-06-12 14:04:38,000 INFO  [AIF]: User:admin

      2014-06-12 14:04:38,000 INFO  [AIF]: Location:预算数据导入 (Partitionkey:7)

      2014-06-12 14:04:38,001 INFO  [AIF]: Period Name:2007年三月 (Period Key:07-3-1 上午12:00)

      2014-06-12 14:04:38,001 INFO  [AIF]: Category Name:预算导入 (Category key:2)

      2014-06-12 14:04:38,002 INFO  [AIF]: Rule Name:预算数据导入 (Rule ID:9)

      2014-06-12 14:04:39,234 INFO  [AIF]: Jython Version: 2.5.1 (Release_2_5_1:6813, Sep 26 2009, 13:47:54)

      [Oracle JRockit(R) (Oracle Corporation)]

      2014-06-12 14:04:39,234 INFO  [AIF]: Java Platform: java1.6.0_37

      2014-06-12 14:04:40,850 INFO  [AIF]: -------START IMPORT STEP-------

      2014-06-12 14:04:40,905 INFO  [AIF]: -------END IMPORT STEP-------

      2014-06-12 14:04:40,969 INFO  [AIF]: -------START EXPORT STEP-------

      2014-06-12 14:04:41,016 INFO  [AIF]: File Name: Trial_Balance___Detail_220909_ZJEG.txt

      2014-06-12 14:04:41,027 INFO  [AIF]:

      Move Data for Period '2007年三月'

      2014-06-12 14:04:48,056 INFO  [AIF]: [HPLService] Info: Cube Name: Plan1

      2014-06-12 14:04:48,056 INFO  [AIF]: [HPLService] Info: Export Mode: STORE_DATA

      2014-06-12 14:04:48,057 INFO  [AIF]: [HPLService] Info: updateMultiCurrencyProperties - BEGIN

      2014-06-12 14:04:48,164 INFO  [AIF]: [HPLService] Info: Currency Properties Exist for Planning Application: CEAIR

      2014-06-12 14:04:48,166 INFO  [AIF]: [HPLService] Info: Number of existing multi-currency property rows deleted: 3

      2014-06-12 14:04:48,168 INFO  [AIF]: [HPLService] Info: Base Currency for Application 'CEAIR': CNY

      2014-06-12 14:04:48,169 INFO  [AIF]: [HPLService] Info: Number of multi-currency property rows inserted: 3

      2014-06-12 14:04:48,170 INFO  [AIF]: [HPLService] Info: updateMultiCurrencyProperties - END

      2014-06-12 14:04:48,170 INFO  [AIF]: Updated Multi-Curency Information for application:CEAIR

      2014-06-12 14:04:48,170 INFO  [AIF]: Connecting to essbase using service user:admin

      2014-06-12 14:04:48,184 INFO  [AIF]: Obtained connection to essbase provider:Embedded

      2014-06-12 14:04:48,187 INFO  [AIF]: Obtained connection to essbase cube Plan1

      2014-06-12 14:04:48,197 INFO  [AIF]: Locking rules file AIF0009

      2014-06-12 14:04:48,199 INFO  [AIF]: Successfully locked rules file AIF0009

      2014-06-12 14:04:48,199 INFO  [AIF]: Copying rules file AIF0009 for data load as AIF0009

      2014-06-12 14:04:48,204 INFO  [AIF]: Unlocking rules file AIF0009

      2014-06-12 14:04:48,206 INFO  [AIF]: Successfully unlocked rules file AIF0009

      2014-06-12 14:04:48,206 INFO  [AIF]: The data rules file has been created successfully.

      2014-06-12 14:04:48,208 INFO  [AIF]: Locking rules file AIF0009

      2014-06-12 14:04:48,210 INFO  [AIF]: Successfully locked rules file AIF0009

      2014-06-12 14:04:48,212 INFO  [AIF]: Load data into the cube by launching rules file...

      2014-06-12 14:04:49,816 INFO  [AIF]: The data has been loaded by the rules file.

      2014-06-12 14:04:49,821 INFO  [AIF]: Unlocking rules file AIF0009

      2014-06-12 14:04:49,825 INFO  [AIF]: Successfully unlocked rules file AIF0009

      2014-06-12 14:04:49,825 INFO  [AIF]: Executed rule file

      2014-06-12 14:04:49,833 INFO  [AIF]: [HPLService] Info: Creating Drill Through Region for Process Id: 95

      2014-06-12 14:04:49,835 INFO  [AIF]: [HPLService] Info: Drill Through Region created for Process Id: 95

      2014-06-12 14:04:49,835 INFO  [AIF]: [HPLService] Info: [loadData:95] END (true)

      2014-06-12 14:04:49,867 INFO  [AIF]: -------END EXPORT STEP-------

      2014-06-12 14:04:49,888 INFO  [AIF]: -------START CHECK STEP-------

      2014-06-12 14:04:49,936 INFO  [AIF]: -------END CHECK STEP-------

      2014-06-12 14:04:50,085 INFO  [AIF]: FDMEE Process End, Process ID: 95