• RELEVANCY SCORE 4.80

    DB:4.80:Fdm To Essbase Error - Dimension Cache s9





    We are trying to load data via FDM into Essbase and are getting a repeated error that does not allow data to be exported to Essbase. FDM can successfully load to Planning, but not Essbase.

    The error reads: "Dimension cache is empty. Cannot get proper case for member" We have the dimension cache switch set to off - but have tried toggling it to on and running the UpdateDimensionCache script. Neither have worked. We have tried creating a dummy Essbase app from scratch to see if Essbase was the issue and we are getting the same error.

    Thoughts?

    DB:4.80:Fdm To Essbase Error - Dimension Cache s9

    We are trying to load data via FDM into Essbase and are getting a repeated error that does not allow data to be exported to Essbase. FDM can successfully load to Planning, but not Essbase.

    The error reads: "Dimension cache is empty. Cannot get proper case for member" We have the dimension cache switch set to off - but have tried toggling it to on and running the UpdateDimensionCache script. Neither have worked. We have tried creating a dummy Essbase app from scratch to see if Essbase was the issue and we are getting the same error.

    Thoughts?

  • RELEVANCY SCORE 3.53

    DB:3.53:Essbase Adapter For Fdm Guide ma





    Hi,

    Anyone have an essbase adapter guide for FDM version 9.3.1? I downloaded from edelivery and from docs.oracle.com but didn't help me to solve my problem.

    The problem is, I don't know how to retrieve essbase dimension, members and data using FDM. And I don't know, isn't my FDM installation correct and work successful. :(

    Thanks for your advance.

    Regards,
    Sumardi

    DB:3.53:Essbase Adapter For Fdm Guide ma

    Hi,

    Thanks for your information. I have read the installation doc, now the problem is when I open Workbench and run HET_EditNameCat script (VBScript), nothing happen.

    Isn't I have wrong configuration? Can you help me?

    Thanks for your advice.

    Regards,
    Sumardi

  • RELEVANCY SCORE 3.53

    DB:3.53:Single Kick Out Per Load Through Fdm To Essbase 11.1.2 3s





    How do you get FDM to provide multiple kick outs during a single period data load. Currently it kicks out one member of one dimension at a time.

    DB:3.53:Single Kick Out Per Load Through Fdm To Essbase 11.1.2 3s

    This is on the Essbase Side. When you load it will return only the first error in the load. FDM is simply streaming the load error log from Essbase.

  • RELEVANCY SCORE 3.53

    DB:3.53:Fdm 11.1.2.2 Cannot Connect To Essbase mp


    I have installed FDM 11.1.2.2 and configured it successfully. However when I login into the workbench I am getting Connection failed under Target Dimension on the Dimension tab.

    Beow is what i am getting when i look into Tools - View Error Log from from workbench

    ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2013-01-15-03:24:59] **
    -------------------------------------------------------------
    Error:
    Code..............53
    Description.......File not found: esbapin
    Procedure.........clsHPConnection.fConnect
    Component.........upsES11XG4J
    Version...........100
    Thread............1920

    Identification:
    User..............admin
    Computer Name.....AMIWSD04

    Essbase Connection:
    App Name..........AMIPLN
    DB Name...........AMIPLAN
    Server Name.......dblx509.mycmsc.com
    Connect Status.... No Connection Open

    ** Begin FDM Runtime Error Log Entry [2013-01-15 03:24:59] **
    -------------------------------------------------------------
    ERROR:
    Code............................................. 53
    Description...................................... File not found: esbapin
    Procedure........................................ frmIntegrateES.tabMain_Click
    Component........................................ upsES11XG4J
    Version.......................................... 100
    Thread........................................... 1920

    IDENTIFICATION:
    User............................................. admin
    Computer Name.................................... AMIWSD04
    App Name......................................... FDMTEST
    Client App....................................... WorkBench

    CONNECTION:
    Provider......................................... ORAOLEDB.ORACLE
    Data Server......................................
    Database Name.................................... AMIHYDEV
    Trusted Connect.................................. False
    Connect Status.. Connection Open

    GLOBALS:
    Location......................................... SAMPLE
    Location ID...................................... 748
    Location Seg..................................... 2
    Category......................................... WLCat
    Category ID...................................... 12
    Period........................................... Jan - 2013
    Period ID........................................ 1/31/2013
    POV Local........................................ False
    Language......................................... 1033
    User Level....................................... 1
    All Partitions................................... True
    Is Auditor....................................... False

    Can someone kindly help me out

    DB:3.53:Fdm 11.1.2.2 Cannot Connect To Essbase mp

    Hi,

    I have reinstalled FDM and now its working fine. Thanks for all your help. Kinldy let me know if anyone is facing the issues. i can help them as i have learned so many things in the process of FDM installation and configuration.

    Regards,
    AS

  • RELEVANCY SCORE 3.52

    DB:3.52:Installation Of Fdm 11.1.1 8c


    Hi All,

    I am going to install FDM 11.1.1 on my machine

    I have installed
    hyperion shared service,
    essbase ,
    hyperion Planning,
    hyperionWorkspace,
    hyperion Repoting and analysis
    for hyperion 11.1.1.1.0 version on my machine.
    Can any one tell me what other softwares and the steps do I need for the installation of FDM 11.1.1 .

    Thanks

    DB:3.52:Installation Of Fdm 11.1.1 8c

    Hi

    The FDM adaptors for HFM, Essbase and Planning

    You'll need to import them into the workbench client. After that you should be able to communicate with the products as long as you've specified the App Name in the Integration settings

    Regards
    G

  • RELEVANCY SCORE 3.50

    DB:3.50:Dimension Build Error Essbase Error(1007083) In Epma Aso Cube fk


    Hi All,

    I am redeploying the EPMA ASO application again but while doing so getting the following error.

    Essbase error occured: Failed to deploy Essbase cube.
    Caused by: Failed to build Essbase cube dimension: (Account) .
    Caused by: Cannot end stream build. Essbase Error(1007083): Dimension build failed. Error code [1060190]. Check the server log file and the dimension build error file for possible additional info.

    Can anyone please let us know how to resolve this and what are the possible causes of this error?

    DB:3.50:Dimension Build Error Essbase Error(1007083) In Epma Aso Cube fk

    As a follow up to John's reply, have a read here too:

    http://glennschwartzbergs-essbase-blog.blogspot.com/2010/12/aso-dimension-deletion-limit.html

    Hope this helps,

    Tim Young

  • RELEVANCY SCORE 3.47

    DB:3.47:Fdm Can Ping Essbase, Not Fully Connect z7


    Good Friday afternoon all -

    Over the weekend our DBAs patched our Exadata database, where all of the Hyperion back end databases are stored. All Hyperion services were down for the procedure, then brought back up afterwards. As expected, we had a myraid of issues. FDM could not see HFM, but that was resolved when we figured out the database kept dropping and the server couldn't see Shared Services. The sole remaining issue is that FDM cannot see Planning. If I try to view the Planning application from mappings, it just spins until the web application times out. If I try to connect to the Essbase cluster via ESSCMD from the FDM server, it spins in the same manner. Neither event produces a log or an error - just sits there. I can ping both the Essbase Cluster and the individual servers from the FDM server.

    The FDM server has been bounced, but I don't know that the Essbase servers were, as they are Linux boxes.

    Any thoughts as I wait on the good guys at Oracle Support?

    Thanks,
    Sarah

    DB:3.47:Fdm Can Ping Essbase, Not Fully Connect z7

    Greetings -

    Thanks for your response.

    I made the mistake of assuming that because Essbase/Planning was up, the entire cluster was up. At somet point our primary node had gone done and I was unaware that the cluster would not work if the primary node was down (my misunderstanding of Essbase clusters at work). I've pointed to our secondary node and FDM can connect now. When the entire cluster is back on its feet I will repoint to the cluster.

    Thank you again,
    Sarah

  • RELEVANCY SCORE 3.42

    DB:3.42:Re: Error Bpma c7


    This is probably not the best forum for your question. This forum focuses largely on FDM which manages data. You may want to consider posting in the HFM or Essbase forums.

    DB:3.42:Re: Error Bpma c7

    Dear all,

    I have an error using BPMA(strange I am not surprised). I am using the version 9.3.1, and I loaded an ads file where some members has been moved. When I validate, I have the error below:

    Trace: com.hyperion.awb.web.appmanager.Service.validate(Service.java:128)
    com.hyperion.awb.web.appmanager.Action.validate(Action.java:231)
    sun.reflect.GeneratedMethodAccessor716.invoke(Unknown Source)
    sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
    java.lang.reflect.Method.invoke(Unknown Source)

    Exception org.apache.axis.AxisFault rethrown

    Server stack trace:
    at Hyperion.DimensionServer.Validations.PlanningApplicationValidation.CheckRename(Int32 lastDeployedTxnID, TransactionHistoryRecord txnRecord, Dictionary`2 dimClassLookup, Dictionary`2 renamedMembers, Library snapShot)
    at Hyperion.DimensionServer.Validations.PlanningApplicationValidation.c__DisplayClassd.CheckForRenamesb__b(TransactionHistoryRecord txnRecord)
    at Hyperion.DimensionServer.DAO.TransactionManagerDAO.c__DisplayClass8.CheckForRenamesb__7(DALDatasetCommand command)
    at Hyperion.DataAccessLayerCore.DataAccessLayer.ExecLoadSQL(String SQL, Action`1 onSetParams, Action`1 onRead, DatabaseContext context)
    at Hyperion.DataAccessLayerCore.DataAccessLayer.ExecLoadSQL(String SQL, Action`1 onSetParams, Action`1 onRead)
    at Hyperion.DimensionServer.DAO.TransactionManagerDAO.CheckForRenames(Int32 libraryID, Int32 masterApplicationID, Int32 applicationID, Int32 startTransactionID, Int32 endTransactionID, Action`1 action)
    at Hyperion.DimensionServer.TransactionManager.CheckForRenames(Int32 libraryID, Int32 masterApplicationID, Int32 applicationID, Int32 startTransactionID, Int32 endTransactionID, Action`1 action)
    at Hyperion.DimensionServer.Validations.PlanningApplicationValidation.CheckForRenames(String[] dimensionClasses)
    at Hyperion.DimensionServer.Validations.PlanningApplicationValidation.CheckForRenames()
    at Hyperion.DimensionServer.Validations.PlanningApplicationValidation.InternalValidate()
    at Hyperion.DimensionServer.Validations.ApplicationValidation.Validate(Application app)
    at Hyperion.DimensionServer.Proxies.ApplicationsProxy.Validate(ApplicationLocator locator)
    at System.Runtime.Remoting.Messaging.StackBuilderSink._PrivateProcessMessage(IntPtr md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[] outArgs)
    at System.Runtime.Remoting.Messaging.StackBuilderSink.PrivateProcessMessage(RuntimeMethodHandle md, Object[] args, Object server, Int32 methodPtr, Boolean fExecuteInContext, Object[] outArgs)
    at System.Runtime.Remoting.Messaging.StackBuilderSink.SyncProcessMessage(IMessage msg, Int32 methodPtr, Boolean fExecuteInContext)

    Exception rethrown at [0]:
    at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
    at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData msgData, Int32 type)
    at Hyperion.DimensionServer.Interface.IApplications.Validate(ApplicationLocator locator)
    at Hyperion.DimensionServer.WebServices.Applications.Validate(ApplicationLocator locator)

    I already encountered this error on my development environment, and I created a new application to workaround the problem.
    Oracle support answered that I have to restore the application and avoid delete renamed currency dimension even thouht I never rename any member on this dimension.
    I need help from people who manage this module, I won't restore this application if each time I have this problem when I move a member in an ads file. I don't understand what's happen.

    Thanks you for your help.

    Jrmy Devendeville

    Edited by: 812999 on 18 nov. 2010 09:11

  • RELEVANCY SCORE 3.41

    DB:3.41:Re: How Ro Map Version And Cuirrency Dimension Or Custom Dimensions In Erpi a1


    Hi All,
    I didn't want to open a new thread since I am running into a similar issue. If anyone thinks that I should open a new thread, I will do that.

    I have setup the ERPi and my target application is a planning app. I have setup the data rule mapping for all the dimensions but it doesn't show me the Currency dimension. The EBS data pulls Functional Currency USD, but I want to load it to Local. When I run the data load, I can see the data in TDATASEG table in EPM_ERPI schema but I don't see the data in my Essbase cube. If someone can breifly explain how is this all connected, that would be great.

    - If FDM is selected in ERPi, how does ERPi know which location in FDM to load to.
    - If data load is successfull from ERPi, how do I validate the data in FDM or ESSBASE. I don't see the data in FDM and data is not there in Essbase.
    - How does ERPi load data to Essbase database, which is through a Planning app since I don't see a Essbase connection in ODI.
    - Are there any logs in ERPi that I can check which would show me the errors or data load success.

    Thanks a lot

    DB:3.41:Re: How Ro Map Version And Cuirrency Dimension Or Custom Dimensions In Erpi a1

    Hi All,
    I didn't want to open a new thread since I am running into a similar issue. If anyone thinks that I should open a new thread, I will do that.

    I have setup the ERPi and my target application is a planning app. I have setup the data rule mapping for all the dimensions but it doesn't show me the Currency dimension. The EBS data pulls Functional Currency USD, but I want to load it to Local. When I run the data load, I can see the data in TDATASEG table in EPM_ERPI schema but I don't see the data in my Essbase cube. If someone can breifly explain how is this all connected, that would be great.

    - If FDM is selected in ERPi, how does ERPi know which location in FDM to load to.
    - If data load is successfull from ERPi, how do I validate the data in FDM or ESSBASE. I don't see the data in FDM and data is not there in Essbase.
    - How does ERPi load data to Essbase database, which is through a Planning app since I don't see a Essbase connection in ODI.
    - Are there any logs in ERPi that I can check which would show me the errors or data load success.

    Thanks a lot

  • RELEVANCY SCORE 3.32

    DB:3.32:Fdm To Load Data In Essbase Aso Cube ps


    Anybody have used FDM to load data in Essbase ASO cube? How do you clear and run calc on ASO cube?

    Thanks

    DB:3.32:Fdm To Load Data In Essbase Aso Cube ps

    Anybody have used FDM to load data in Essbase ASO cube? How do you clear and run calc on ASO cube?

    Thanks

  • RELEVANCY SCORE 3.24

    DB:3.24:Fdm 11.1.1.3 Drill Through Error From Smartview To Essbase d3


    Hi all,

    I'm implementing a fresh FDM install to Essbase using version 11.1.1.3 with the ES11x-G4-E adapter.

    When the data was loaded to Essbase and retrieved using Smartview the balloon for drill through is shown.

    When drilling through the FDM screen is shown but with the following error:
    Error: No application name was specified
    and
    Error: Unable to cast object of type 'System.Boolean' to type 'upsAppServerDM.clsAppServerDM'.

    The strange is that when drilling to Firefox instead of IE the FDM drill through does work but in an incorrect formatting (caused by firefox).

    The provider services url is already workspace server:19000/aps/SmartView
    But the FDM web client is on another server.

    any suggestions where to look?

    Thanks in advance,

    Marc

    DB:3.24:Fdm 11.1.1.3 Drill Through Error From Smartview To Essbase d3

    Hi all,

    I'm implementing a fresh FDM install to Essbase using version 11.1.1.3 with the ES11x-G4-E adapter.

    When the data was loaded to Essbase and retrieved using Smartview the balloon for drill through is shown.

    When drilling through the FDM screen is shown but with the following error:
    Error: No application name was specified
    and
    Error: Unable to cast object of type 'System.Boolean' to type 'upsAppServerDM.clsAppServerDM'.

    The strange is that when drilling to Firefox instead of IE the FDM drill through does work but in an incorrect formatting (caused by firefox).

    The provider services url is already workspace server:19000/aps/SmartView
    But the FDM web client is on another server.

    any suggestions where to look?

    Thanks in advance,

    Marc

  • RELEVANCY SCORE 3.23

    DB:3.23:Pointing Single Fdm Application To Multiple Essbase Databases jm


    Is it possible to point a single FDM application to multiple Essbase applications and databases? I have heard it is possible to (re-)add the Essbase adapter multiple times to the same FDM application, to then point to different Essbase applications databases.

    Does this work successfully and are there any potential problems with having duplicate adapters registered?

    DB:3.23:Pointing Single Fdm Application To Multiple Essbase Databases jm

    Just a note that there are issues with multiple essbase adapters when doing drill through.

  • RELEVANCY SCORE 3.22

    DB:3.22:Adding Metadata To Fdm Control Tables To Map To Extra Dimension as


    We have our Period dimension in our Essbase database going down to day-level, which has resulted in a very large Period control table in FDM. This maps the FDM Period "day" members to the Essbase Period "day" members. However, we also need to map these FDM "days" to specific Essbase "Version" members too, whilst catering for a 4-4-5 calendar year.

    The day members are invisibly grouped by "load weeks" (in terms of where we want to load data to with respect to the "Version" dimension in Essbase). These load weeks do not feature in the FDM control table, but a custom event script in FDM needs to update the load week Essbase subsitution variable value to carry out some calculations and load data to the correct cells.

    The problem we have is how to map each day to a specific load week without writing a huge, unwieldy IF statement. It cannot be established numerically since we are using a 4-4-5 calendar year in the Essbase Period dimension. So essentially, this is about mapping the level-0 Period members to the level-0 Version members in Essbase:

    Period dimension (level 0):
    - Day 7
    - Day 14
    - Day 21
    - Day 28
    - Day 35
    - etc etc

    Version dimension (level 0):
    - LW1
    - LW2
    - LW3
    - LW4
    - LW5

    Based on the above:
    - Day 7 implies LW1
    - Day 14 implies LW2
    - Day 21 implies LW3
    - Day 28 implies LW4
    - Day 35 implies LW1 again
    - Etc...

    I was hoping to simply be able to add the LW# values to a spare column in the Period control table in FDM. Ideally it would be useful to be able to add the Version member names into the FDM control table alongside the days (under a different "Target Per (#)" column), so that the values could then be accessed via the Event Script to dynamically construct and pass some MaxL to ESSMSH, to update the Essbase substitution variables. However, only members from the Period dimension can be added here.

    Another idea was to have an alternative hierarchy in the Period dimension, to effectively get the load week Version names (or something similar to avoid duplicate member names) into the Essbase Period dimension. However it seems a bit drastic to alter the outline to such a large degree for this. Consequently, the only workable solution so far appears to be a horrible IF statement in our FDM event script.

    Hoping there is a more elegant solution out there? :-)

    DB:3.22:Adding Metadata To Fdm Control Tables To Map To Extra Dimension as

    Does the mapping of the week to the version change each year? One option might be along the lines to create a dummy location (or use the same location and add a new dimension as lookup) in FDM and in the account dimension source column enter the mapping e.g.
    7:LW1
    14:Lw2
    21:LW3
    etc
    (I think ':' is not classed as a special character to be avoided in the mapping table)
    and map the target as ignore.

    then as part of the script load the source fields into an array and using the day from the POV period to search the array to find the value for the version.

  • RELEVANCY SCORE 3.22

    DB:3.22:Unable To Configure The Fdm-Essbase f8


    Hi Guru,

    I had created one FDM application and register the adaptor, i have FDM on windows server and Essbase on linux. i had installed the essbase 64 bit client and done the environment variable setting aslo.

    but while mapping , i am getting below error.

    ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2010-12-29-09:59:31] **
    -------------------------------------------------------------
    ERROR:
    Code..............48
    Description.......File not found: esbapin
    Procedure.........clsHPConnection.fConnect
    Component.........upsES11XG4G
    Version...........100
    Thread............7684

    IDENTIFICATION:
    User..............admin
    Computer Name.....EPMAPP02-D

    ESSBASE CONNECTION:
    App Name..........bmhcdev
    DB Name...........BMHCDEV
    Server Name.......EPMAPPDB03-D
    Connect Status.... No Connection Open

    Thanks and help to fix the error

    DB:3.22:Unable To Configure The Fdm-Essbase f8

    What version of Essbase/FDM is this? If this is 11.1.2.0 the install of the essbase client automatically installs the Essbase 32 and 64 bit runtime clients. The Environment variable needs to point to the products\essbase\essbaseclient-32 directory. Also, I would suggest placing the Essbase adapter .exe in the Essbaseclient-32\bin directory and registering it from this location using the workbench. The esbapin.dll file is located in this directory.

  • RELEVANCY SCORE 3.20

    DB:3.20:Loading Data Into Aso Application Using Fdm ak


    Hi All,Can we load data into Essbase ASO Application using FDM in following version 1.FDM 11.1.1.3 ?2.FDM 11.1.2.2 ?3.FDM 11.1.2.3 ?Thanks

    DB:3.20:Loading Data Into Aso Application Using Fdm ak

    In 11.1.2.3, you can use the functionality already found in FDMEE - just map to the ASO cube and you can load data.In FDM, you can use custom syntax custom code at the OS level- however this is not supported by Oracle. You could use ERPi to do so though.

  • RELEVANCY SCORE 3.20

    DB:3.20:Epma Server Service Not Started 37


    Hi All,

    I installed Hyperion 11.1.2.2 Essbase, Planning, EPMA, Calculation Manager, FDM and HFM in the single machine in windows server 2008 R2.

    but i am facing two issues.

    1. In services, EPMA Server service not started.
    2. In FDM, I am getting error in connecting to Essbase.
    Error: Unable to retrieve target system data.

    Is any thing, i have to install additionally?

    Regards,
    mady

    DB:3.20:Epma Server Service Not Started 37

    Hi Tonka,

    Thanks for reply.

    Problem solved. EPMA server services started now.

    regards,
    mady

  • RELEVANCY SCORE 3.19

    DB:3.19:Drill Through From Planning To Fdm 11.1.2 Not Working ff


    Hi,
    I have FDM with Essbase adapter installed, version 11.1.2.0.0.
    And i have FDM application configured to load data from files to essbase. When in Planning form i am clicking 'drill through' icon on cell with loaded data it opens new window with error:

    Error: No locations were found matching the passed intersection values. Please verify:
    1) that the target system (originating the drill through) is properly configured;
    2) that FDM POVs have not been retroactively modified or compromised.

    In the FDM error log the following record:

    ERROR:
    Code............................................. 7123
    Description...................................... INSERSECTION SQL DEBUG
    Procedure........................................ SELECT vDataFact.PartitionKey, PartName, CatName, CatTarget, PeriodKey, PeriodDesc, DataView, AccountX, EntityX, ICPX, UD1X, UD2X, UD3X, UD4X, UD5X, UD6X, UD7X, UD8X, UD9X, UD10X, UD11X, UD12X, UD13X, UD14X, UD15X, UD16X, UD17X, UD18X, UD19X, UD20X, SUM(DECODE(ChangeSign, 0, (Amount), 1, (Amount *-1), (Amount))) AS Amt From vDataFact Where (((CatTarget) = N'EXP.011201PDV.BDRS.BUDGET') And ((PeriodTargetM) = N'Jan') And ((YearTarget) = N'FY10') And ((CalcAcctType) 0) And ((AccountX) = N'EXP.011201') And ((EntityX) = N'EXP.011201PDV.BDRS.BUDGETV.FACTEXT.KNT.NAAC.3200EN.GD') And ((ICPX IS NULL) or (ICPX = N'') or (upper(ICPX) = N'[ICP NONE]')) And ((upper(UD1X)) = N'EXP.011201PDV.BDRS.BUDGETV.FACTEXT.KNT.NA') And ((upper(UD2X)) = N'EXP.011201PDV.BDRS.BUDGETV.FACTEXT.KNT.NAAC.3200') And ((upper(UD3X)) = N'EXP.011201PDV.BDR') And ((upper(UD4X)) = N'EXP.011201PDV.BDRS.BUDGETV.FACT') (and so on...)

    And we can see that (CatTarget) = N'EXP.011201PDV.BDRS.BUDGET' consist of three joined together elements from three different dimension EXP.011201(account) and PDV.BDR(custom3) and S.BUDGET(scenario).
    With other custom dimensions in this select statement - the same error, in front of correct element - string with other joined elements.

    Can anybody help me to understand why i have this error in drill through?
    FDM error or Oracle RDBMS errors or Planning with Essbase? Something wrong with locale setting may be, with "," or "." delimiter somewhere in the settings?

    DB:3.19:Drill Through From Planning To Fdm 11.1.2 Not Working ff

    It is a bug in one of the FDM's dlls.

    The error occured when in intersaction we have two or more members with dots in their names.

    I have solved the problem for my customer by editing procedure in dll.

  • RELEVANCY SCORE 3.17

    DB:3.17:Dcom Component Not Found After Essbase Adapter Configured For Fdm 11.1.2.2 11


    We are migrating FDM from version 11.1.1.3 to 11.1.2.2 following the official guide.

    After schema update, we can log in to the FDM Workbench fine, but we are having trouble when upgrading Essbase adapter.
    The existing adapter is outdated (for Essbase 11.1.1.3), and we followed the document to import, register, configure new Essbase adapter.
    However, after machine profile, adapter options (which application to connect and so on) are set, we tried to configure dimension mappings.
    In the "Target Dimension" field in the "Dimension" tab of adapter configuration window, it only shows "Connection failed." in the drop down list.

    Then we discovered that we need 32-bit Essbase Runtime client after reading an Oracle KM Article, then we copied it from Essbase server and set the environment variables.
    After doing so, and register the adapter again, now the dimension is shown in the pop-up window when configuring dimension of the Essbase adapter.

    The progress of our FDM adapter registration:
    1. Import the adapter ES11X-G4-J.xml in FDM workbench.

    2. Put the upsES11XG4J.exe file under EPM_Oracle_Home\common\EssbaseRTC\bin

    3. Create a system environment variable ESSBASEPATH with value "EPM_Oracle_Home\common\EssbaseRTC\11.1.2.0" and add following value to PATH environment variable: "EPM_Oracle_Home\bin-32; %ESSBASEPATH%\bin; EPM_Oracle_Home\products\Essbase\EssbaseClient-32\bin", where the EPM_Oracle_Home resemble our EPM location.

    4. Register the adapter from "File - Register Adapter" in workbench and select the upsES11XG4J.exe file.

    5. Executed "Run - dcomcnfg" trying to update the launching user right for corresponding DCOM component (upsES11XG4J.cluHypWindowEB) but could not find it there.

    Does anyone encountered this situation before?

    DB:3.17:Dcom Component Not Found After Essbase Adapter Configured For Fdm 11.1.2.2 11

    Thanks Jeff.Sorry I didn't notice your reply here, since Oracle Support has answered that for Windows Server 2008 R2, this step is no longer needed when configuring FDM Essbase Adapter. That's sweet.Warm Regards,John

  • RELEVANCY SCORE 3.17

    DB:3.17:How To Remove The Default Members Of A Dimension From The Control Table? f7


    Hi all,

    I am new to hyperion FDM 11.1.1.2.0.0 .

    When I navigate to MetadataControl Tables and try to delete the default memmbers
    for the dimension like category and period i got the following error.

    Error: Period( 8/31/2009 ) is an active Global or Local Period and cannot be deleted.

    Then again i unchecked active checkbox for that dimension from Hyperion Essbase Integration Setup of Workbench Client.
    After doing that i got the following error

    Error: Unable to retrieve target System Data.

    Can anyone tell me how to remove the default members of a dimension from the control table?

    Thanks

    DB:3.17:How To Remove The Default Members Of A Dimension From The Control Table? f7

    Create a new record for the table.
    Go change the POV to the new record.
    Return to the control table and delete the default record.

  • RELEVANCY SCORE 3.17

    DB:3.17:Fdm 11.1.2.1 &Amp; For Essbase Adapter Configuration On 64bit Windows c7


    Hi All,
    I had a few doubts with the configuration of Essbase adapter for FDM ver.11.1.2.1 on a X64 Windows environment:

    1) With release 11.1.2.1 , the Essbase adapter upsES11GXH for FDM no longer requires the Arborpath user and system variables. Is this correct? This is clearly mentioned in the essbase adapter document es_g4_h_target_adapter_readme available on Oracle Website. It asks you to delete the Arborpath if you are upgrading from version 11.1.2.0 to 11.1.2.1. If you are doing a fresh install the document does not suggest anywhere to set the Arborpath environment variable. Version 11.1.2 required both the Essbasepath and the Arborpath variable to be set to EPM_HOME\products\Essbase\EssbaseClient-32. In 11.1.2.1 version the Essbasepath should be EPM_ORACLE_HOME\common\EssbaseRTC\11.1.2.0

    2) I read some-where in the forum that in order for FDM to work on a x64 windows environment the essmsh.exe should start and show up in the task manager as essmsh.exe*32. I tried starting it from the EPM_ORACLE_HOME\common\EssbaseRTC folder and it gave me an error "failed to initialize MaxL". If I start the MaxL shell from the EPM_ORACLE_HOME\products\\Essbase\EssbaseClient-32 it seems to work fine. I am able to start the MaxL shell and I am also able to see essmsh.exe*32 in my task manager processes. What is the rationale behind this?

    3) With respect to question 2, if you open the startMaxL.cmd file in a text editor, you can see a line which says that "SET ARBORPATH=%ESSBASEPATH%". So is Arborpath required or not to start maxL shell and what is the relevance of this with FDM?

    3) Is the EPM_ORACLE_HOME\products\\Essbase\EssbaseClient-32 ( folder or path) irrelevant in version 11.1.2.1 as the ESSBASEPATH needs to be set to EPM_ORACLE_HOME\common\EssbaseRTC\11.1.2.0. The esbapin.dll is located the bin folder of this path.

    DB:3.17:Fdm 11.1.2.1 &Amp; For Essbase Adapter Configuration On 64bit Windows c7

    1) With release 11.1.2.1 , the Essbase adapter upsES11GXH for FDM no longer requires the Arborpath user and system variables. Is this correct?

    YES, this is correct. You do not need the ARBROPATH system or user variable begining with 11.1.2.1

    This is clearly mentioned in the essbase adapter document es_g4_h_target_adapter_readme available on Oracle Website. It asks you to delete the Arborpath if you are upgrading from version 11.1.2.0 to 11.1.2.1. If you are doing a fresh install the document does not suggest anywhere to set the Arborpath environment variable. Version 11.1.2 required both the Essbasepath and the Arborpath variable to be set to EPM_HOME\products\Essbase\EssbaseClient-32. In 11.1.2.1 version the Essbasepath should be EPM_ORACLE_HOME\common\EssbaseRTC\11.1.2.0

    CORRECT, in 11.1.2.1 you only need the ESSBASEPATH variable which will point to the EssbaseRTC\11.1.2.0 directory as noted in the Adapter Readme guide.

    2) I read some-where in the forum that in order for FDM to work on a x64 windows environment the essmsh.exe should start and show up in the task manager as essmsh.exe*32. I tried starting it from the EPM_ORACLE_HOME\common\EssbaseRTC folder and it gave me an error "failed to initialize MaxL". If I start the MaxL shell from the EPM_ORACLE_HOME\products\\Essbase\EssbaseClient-32 it seems to work fine. I am able to start the MaxL shell and I am also able to see essmsh.exe*32 in my task manager processes. What is the rationale behind this?

    That is something you can use to test if the environment variables are setup properly. IF you follow the Essbase Adapter readme explictly in regards to the environment variable changes, the integration will work as expected.

    3) With respect to question 2, if you open the startMaxL.cmd file in a text editor, you can see a line which says that "SET ARBORPATH=%ESSBASEPATH%". So is Arborpath required or not to start maxL shell and what is the relevance of this with FDM?

    See the answer to #2

    3) Is the EPM_ORACLE_HOME\products\\Essbase\EssbaseClient-32 ( folder or path) irrelevant in version 11.1.2.1 as the ESSBASEPATH needs to be set to EPM_ORACLE_HOME\common\EssbaseRTC\11.1.2.0. The esbapin.dll is located the bin folder of this path.

    Yes, that path must be set in the PATH variable. This is documented in the adapter readme guide.

  • RELEVANCY SCORE 3.15

    DB:3.15:Epm 11.1.2.1 Fdm Connectivity With Planning/Essbase Application pa


    I have 64 bit Windows 2008 R2 server and I have installed EPMA, Planning, Essbase, Foundation service on just one server. I have to add FDM and I already installed and created FDM application using workbench. I can login through web or workbench. I have imported and registered ES11X-G4-H adapter. I have also added ESSBASEPATH system variable and added PATH variable as per the manual.But when I go to Essbase adapter configuration and click on dimension; the target dimension always shows 'connection failed'. As per manual, it should show dimension member from Essbase application.I have already added account and Entity dimension name and its alias from Essbase App.The PATH is as below:-e:\app\Administrator\product\11.2.0\client_32bit;e:\app\Administrator\product\11.2.0\client_32bit\bin;e:\app\Administrator\product\11.2.0\client_64bit;e:\app\Administrator\product\11.2.0\client_64bit\bin;e:\Oracle\Middleware\EPMSystem11R1\bin;e:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseServer\bin;e:\Oracle\Middleware\EPMSystem11R1\bin;e:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Server;e:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Client;e:\Oracle\Middleware\EPMSystem11R1\products\FinancialManagement\Common;e:\app\Administrator\product\11.2.0\dbhome_1\bin;e:\orant\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0;E:\Oracle\Middleware\EPMSystem11R1\common\ODBC-64\Merant\7.0\Drivers;E:\Oracle\Middleware\EPMSystem11R1\common\SAP\bin;E:\Oracle\Middleware\EPMSystem11R1\opmn\bin;E:\Oracle\Middleware\EPMSystem11R1\opmn\lib;E:\Oracle\Middleware\EPMSystem11R1\perl\bin;e:\orant\jdk\bin;e:\Oracle\Middleware\ohs\bin;e:\Oracle\Middleware\ohs\opmn\bin;e:\Oracle\Middleware\ohs\opmn\lib;e:\Oracle\Middleware\ohs\perl\bin;e:\Oracle\Middleware\EPMSystem11R1\common\ODBC-64\Merant\6.0\Drivers;e:\Oracle\Middleware\EPMSystem11R1\products\Essbase\eas\console\bin;e:\Oracle\Middleware\EPMSystem11R1\common\JRE\Sun\1.6.0\bin;E:\Oracle\Middleware\EPMSystem11R1\bin-32;E:\Oracle\Middleware\EPMSystem11R1\common\EssbaseRTC\11.1.2.0\bin;E:\Oracle\Middleware\EPMSystem11R1\products\Essbase\EssbaseClient-32\binCan someone pls suggest, what could have gone wrong.RegardsNitin

    DB:3.15:Epm 11.1.2.1 Fdm Connectivity With Planning/Essbase Application pa

    Hi John!Admin log for the FDM application. Do you mean E:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\fdqm folder?If so, it has just one file taskmanager-install.txt and content is as below:-Running a transacted installation.Beginning the Install phase of the installation.See the contents of the log file for the e:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\TaskManager\TaskManagerService.exe assembly's progress.The file is located at E:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\fdqm\taskmanager-install.log.Installing assembly 'e:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\TaskManager\TaskManagerService.exe'.Affected parameters are: logtoconsole = assemblypath = e:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\TaskManager\TaskManagerService.exe logfile = E:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\fdqm\taskmanager-install.logInstalling service HyS9FDMTaskManagerSrv...Service HyS9FDMTaskManagerSrv has been successfully installed.Creating EventLog source HyS9FDMTaskManagerSrv in log Application...The Install phase completed successfully, and the Commit phase is beginning.See the contents of the log file for the e:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\TaskManager\TaskManagerService.exe assembly's progress.The file is located at E:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\fdqm\taskmanager-install.log.Committing assembly 'e:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\TaskManager\TaskManagerService.exe'.Affected parameters are: logtoconsole = assemblypath = e:\Oracle\Middleware\EPMSystem11R1\products\FinancialDataQuality\TaskManager\TaskManagerService.exe logfile = E:\Oracle\Middleware\user_projects\epmsystem1\diagnostics\logs\fdqm\taskmanager-install.logThe Commit phase completed successfully.The transacted install has completed.

  • RELEVANCY SCORE 3.14

    DB:3.14:Connecting Essbase To Fdm p1


    Hi guys,So we currently use FDM to accommodate our HFM close process. That's how the users load. But our essbase users currently do a manual load through the essbase excel add-in. Is there anyway to connect our existing FDM server to Essbase? Do i simply need to create a new FDM application or do we need erpi/odi or other tools/programs?Also, is there anyway to automate FDM loads to HFM/Essbase?Version = 11.1.2.1Env = Windows 2008 R2/ SQL db

    DB:3.14:Connecting Essbase To Fdm p1

    Thanks for the input. This is what i'm looking for; i needed someone to bounce ideas of instead of the sales reps.1) In terms of requirements, there's a then, and there's a now. Now I have different applications which require users to load separately for cost centers, entities and even some sales cubes that have separate loads per sales person. But all in all, its collective loading. Its not multi-period because we load by a close process and our essbase isn't audited. I'm just trying to get a way to load one cube (for example a cube that is made up of multiple cost centers) faster and via an Interface. "Then" would be the automaticon of the loads. 2) I'm trying to figure out if the users extract the info from the Gls/systems, format it and dump it in a particular location, i could get a method (fdm/,maxl/odi) to pick that up and load it to the different cost centers. Currently we use FDM with HFM to load figures per location.

  • RELEVANCY SCORE 3.13

    DB:3.13:Error Loading Data To Essbase Through Fdm Using Adapter Es9x-G4-A sp


    Hi there,
    When i am trying to upload data to Essbase using ES9x-G4-A 9.3.1 adapter from FDM 9.3.1 It is giving me error during Export, My import and Validate are successful only export is giving error.

    Error is : Export failed.
    Detail: Object required: 'API.IntBlockMgr.IntegrationMgr.PobjIntegrate.varCon'
    At Line: 622

    When i checked it through FDM client(workbench) i didn't find Varcon Variable in FDM Objects.
    am i missing something do let me know?

    Please Reply soon

    Thankyou,

    DB:3.13:Error Loading Data To Essbase Through Fdm Using Adapter Es9x-G4-A sp

    Method to fix:

    1. Navigate to the FDM Workbench Client
    2. Log into the appropriate application as a power user
    3. Navigate to the adapters tab and expand Target System Adapters and expand the Essbase Adapter (ES9x-G4*)
    4. Expand the Actions Folder and double-click on the Export Action to open the script
    5. Navigate to Line 357 in the Export Action Script (Please refer to the attached bug for the exact code on the line)
    6. Place a single apostrophe (') at the beginning of the line to comment out the destruction of the premature object.
    7. Save the script by clicking the diskette icon on the toolbar
    8. Retest the export.
    9. If the issue is resolved, please migrate the solution as appropriate to other environments.

  • RELEVANCY SCORE 3.13

    DB:3.13:Fdm Configuration pz


    Hi,

    I want to upload the data from Oracle RDBMS table to Hyperion Planning / ESSBASE through FDM.

    I am very new with the FDM.

    Can anyone please provide me the steps required for the same?

    I am using the version 11.1.1.3

    Thanks Regards,
    Sunil.

    DB:3.13:Fdm Configuration pz

    You will probably get lots more replies on the FDM forum Financial Data Management
    Is there a reason for using FDM as you could load direct to the essbase database from Oracle

    Cheers

    John
    http://john-goodwin.blogspot.com/

  • RELEVANCY SCORE 3.13

    DB:3.13:Fdm To Structures Of Dimensions Is Possible cf


    Hello Expert

    I'm new with EPM - FDM.

    One must understand a point.

    You can only upload via FDM values for the Accounts dimension (fact), or can also upload their own accounts for essbase, ie I can carry through FDM structures of dimensions?

    If possible is there any documentation on this?

    obrigdo,

    user_mmb

    DB:3.13:Fdm To Structures Of Dimensions Is Possible cf

    Dear

    user735469, sorry my English is not always good.

    SH:

    It is exactly this.

    I would love to be able to transact with metadata tool for the end user could interragir.

    Thanks

  • RELEVANCY SCORE 3.12

    DB:3.12:Essbase Connection To Fdm ds


    Hi ,

    Can anybody tell me how to set adapters from FDM to Essbase? I heard that it is different for essbase, not like HFM, need to create for each and every dimension.. Where can i get the documentation for this.

    Thanks in advance....

  • RELEVANCY SCORE 3.12

    DB:3.12:Fdm Ports dc


    Hello experts,

    how can I figure out, which ports are in use for FDM / and which port are used for connecting FDM to Essbase.

    Version 11.1.1.3
    OS: Wind Server 2003

    Thanks and regards
    kfor

  • RELEVANCY SCORE 3.10

    DB:3.10:View Dimension Mysteriously Filled With Ytd In Essbase Adapter 3j


    Hi,

    I don't understand how my view column is automatically filled with the value YTD during my FDM import.
    I have a source file without a view dimension, i have no view dimension in my import format i have 'YTD_Inp' as the no-data value in the dimension specification.
    But still the view in the export is filled with YTD.

    When i change my datavalue dimension to View and set YTD_INP as the no data value it works fine.

    Has anybody an idea where the YTD comes from and how i can change it to YTD_Inp?

    Thanks in advance,

    Marc

    DB:3.10:View Dimension Mysteriously Filled With Ytd In Essbase Adapter 3j

    Marc,

    What Matt is saying to do is not use the pre-built view dimension. But to leverage one of the custom dimensions as 'view' instead. This way it will not have the limitation of 5 characters.

    Hopefully this helps....

  • RELEVANCY SCORE 3.10

    DB:3.10:Validation Lookup Error c8


    Hi there,

    I am using FDM 11.1.2.1 with the Essbase adapter.

    I have set up a validation rule to report the entities that have been loaded but that are not at the bottom level of the ENTITY dimension.
    For that, I added an account "+LevelNumber+" is Essbase ACCOUNT dimension that returns the current entity level number.
    The rule is set as #ModeRule and the rule logic is "+|,,,,,,LevelNumber,,,,,,,,,,,,,,,,,,,,,|0+"
    However when the validation is executed upon "Check" in the workflow and the report is generated, it returns a "LOOKUP ERROR" in the report value column and each entity has the status of "Error".

    Anybody faced this issue before?

    Thanks,

    Regis

    DB:3.10:Validation Lookup Error c8

    Hi there,

    Interesting point. No I haven't.
    I just did and now I can browse Entity and Account and test my rule!
    One thing I also had to do was to include all Essbase dimensions in FDM. I had excluded three of them and defined them in a load rule.

    Now it works.

    Thanks,

    Regis

  • RELEVANCY SCORE 3.09

    DB:3.09:Fdm Export To Essbase Error fz


    Hello,

    I'm trying to Export data from FDM to Essbase. When I export using the 0-Replace method, I get the following error:

    Data Clear Error
    Calc Script Failed.
    Code=10410
    Description=Essbase API Procedure: [EsbCalc] Threw code: 1012004 - 1012004 - [Wed Jul 28 15:40:11 2010]XXXXX/PLANNING/IncStmt/admin/Error(1012004)

    Invalid member name [ ]
    .

    The 1-Merge method doesn't return this error - is load w/ replace not supported with Essbase?
    If so, does anyone know how to script a custom export event? It seems there is a way to link to a Load Rule, but I would like to generate these scripts in FDM.

    There is a related thread:
    FDM - Script
    but this doesn't work for me. Do I link to a script of type Custom (General)?

    Thanks in advance!

    DB:3.09:Fdm Export To Essbase Error fz

    Looks to be an essbase permission error. Check that the admin user has access to the calc script that is identified in the error code.

  • RELEVANCY SCORE 3.09

    DB:3.09:Allowing Re-Loads Of Data To Essbase Without Deleting Existing Data z1


    When exporting data from FDM to Essbase, the following options are provided:
    0- Replace
    1- Merge

    These settings can also be set as the application global default in FDM Workbench. We have noticed that if "0 - Replace" is used, the following line appears in the Essbase application log:

    +[Mon May 14 13:51:36 2012]Local/Flash/Flash/admin@Native Directory/140397557860096/Info(1012555)+
    +Clearing data from [Week 44] partition with fixed members [Service(Service N/A); Scenario(FLASH Raw)]+

    The "Service" dimension is not one of the two POV Control Table dimensions (Period or Category). We were under the impression that "0 - Replace" would allow the same Essbase data cells to be reloaded, without other data being affected. However, it appears to be clearing all data in the database whilst fixing on the above three members, and it does not appear to make much sense as to why it has opted to fix on these particular dimensions either. We are loading data to Essbase from FDM using an Essbase load rule. This load rule has no data clearing options set in it.

    The "1 - Merge" option adds the reloaded values to the existing values in Essbase (as expected). Please advise on how we might be able to reload data to Essbase (using the "0 - Replace" option) whilst ensuring other data cells are not affected.

    DB:3.09:Allowing Re-Loads Of Data To Essbase Without Deleting Existing Data z1

    One final question on this, how does one post a message to the information panel?

  • RELEVANCY SCORE 3.09

    DB:3.09:Fdm Essbase Adapter - Duplicate Members From Same Dimension On Data Records ka


    I am getting this error message when trying to export data to Essbase using FDM.

    Error - Duplicate members from same dimension on data records.

    Though this error looks quite straight forward, I could not find any thing in the data file to indicate the same. I even tried loading a single row data, but still got the same message.

    What other things I should be looking at to fix this issue?

    Thanks.

    DB:3.09:Fdm Essbase Adapter - Duplicate Members From Same Dimension On Data Records ka

    There are one or two previous threads on this, but this might give you some help to start with as it links to an esssbase document which gives suggestions for the error message:

    Error in dataload- Duplicate Members From Same Dimension On Data Record

    another thread indicated that the first record had a blank in it and by re-sorting to have the first records with all fields populated resolved the issue (not sure on this one).

    from the FDM side:

    1. Are the dimensions correctly mapped in the Essbase adaptor?

    2. Are the dimensions in the correct sequence for loading to Essbase.

    3. Does the same value appear In more than one field (Can't remember but i think essbase didn't use to allow the same member name across dimensions).

  • RELEVANCY SCORE 3.09

    DB:3.09:How To Import Data From Excel File To Essbase Database Using Fdm sf


    Hi experts,I'm a newbie in Hyperion. I'm searching for how to import data from excel file to Essbase Database using FDM. The Essbase database have 12 dimentions.Please help me to do this.Thanks,Hai Mai

    DB:3.09:How To Import Data From Excel File To Essbase Database Using Fdm sf

    Are you referring to import data from Excel Trial Balance template provided by FDM? or do you want to import data from a csv file?The process is the same but you need to take into consideration that if you use the Excel TB template, the import format will not be applied.

  • RELEVANCY SCORE 3.08

    DB:3.08:Need Steps To Load Data In Essbase Via Fdm p8


    Hi all.

    Weve a requirement on loading a particular combination of data into Essbase through FDM.

    Do any of you have steps to do data load in Essbase using FDM..??

    Also,i'm trying to do thid using FDM thick client essbase adapters.

    Requirement is:

    Load act_FDM for FY10 in essbase

    Any help is appreciated..

    Regards,
    Rev

    DB:3.08:Need Steps To Load Data In Essbase Via Fdm p8

    Rev,

    Your message is a bit too broad. Forums are meant as a way to help with a specific issue, not to teach you how to use an entire function set of the product. What you are asking requires a fair amount of experience with the product and attempting to communicate that through a forum would simply not be feasible.

    I would suggest looking into an Oracle University training class for FDM or engaging a consulting partner to help you.

    Sorry that I can't be of more assistance.

  • RELEVANCY SCORE 3.08

    DB:3.08:Re: Fdm 11.1.2 Connect To Essbase kp


    Do you get an error in the period/category control table like "Unable to Retreive Target System Data"? If so, choose Tools Clear Error Log. Then choose Metadata Control Tables to return the error and choose Tools View Error Log. What is the error message recorded in the log?

    DB:3.08:Re: Fdm 11.1.2 Connect To Essbase kp

    A) Login to the Application using the workbench client
    B) Expand Target System Adapters and right-click on the Essbase Adapter and choose "configure"
    C) Click on the Dimensions tab
    D) In the left-pane scroll down to see the global dims "Period, Year, Category"
    E) Click on each one and choose the corresponding dimension from the essbase outline from the drop down list to populate the Foreign Name field.

    *Note: If you do not have a year dimension, uncheck the "user list" option on the Year Dimension.

  • RELEVANCY SCORE 3.08

    DB:3.08:Drillback Issue With Multiple Adapters ds


    I have a single FDM app (v11.1.2.1) with 2 adapters: Primary adapter Essbase, Secondary adapter Pull adapter.
    The Essbase adapter is enabled for drillback and I have a single location which I load data via. The issue I have is whaen I drillback from Planning drillback fails on the FDM landing page.

    The reason for the error is pretty apparent as the dimension structure displayed on the Landing page is that of the Pull adapter not the Essabse adapter associated with the location. Any idea as to why this is happeneing, Essbase is the default adapter.

    DB:3.08:Drillback Issue With Multiple Adapters ds

    If you enable debug what shows in the trace info for the dimension values? Drill Through with multiple adapters in a single application does have issues and has been logged as a bug/enhancement. I woudl suggest creating a dedicated application for the Essbase Adapter.

  • RELEVANCY SCORE 3.07

    DB:3.07:Export Data To Hpcm Cube Using Fdm 17


    Hi,

    I am trying to export data to an HPCM cube using FDM. The Import and Validate steps in HPCM are successful. But when i try to export data, I get the following error - "Duplicate member exists in the outline".
    The export file gets generated successfully.
    Also when I try to load this file into the Essbase cube through EAS by creating a rule file, it loads successfully.

    Is this a problem with FDM/Essbase adapter?
    FDM version - 11.1.2.1.00
    Essbase adapter version - ES11X-G4-H

    Could someone please advise on this?

    Thanks in advance!

    DB:3.07:Export Data To Hpcm Cube Using Fdm 17

    Yes I am using the load rule to load via FDM as well. I have set the 'Enable String Load' to 'True' and provided the Load Rule File name. Also placed the rule file on the Essbase server in the directory of the HPCM app. But it still gives the same error.

  • RELEVANCY SCORE 3.07

    DB:3.07:Fdm Essbase Error ca


    Hi All,

    I am getting this error file in my FDM Outbox each time I load a multiload file (as Replace) into Essbase from FDM.

    Data Clear Error
    Calc Script Failed.
    Code=10410
    Description=Essbase API Procedure: [EsbCalc] Threw code: 1042006 - 1042006 - [Fri Apr 13 15:35:16 2012]TORNTSDBS92/ESSCON/ESSCON/admin/Error(1042006)
    Network error [10048]: Unable to connect to [TORNTSDBS92:1423]. The client timed out waiting to connect to Essbase Agent using TCP/IP. Check your network connections. Also make su
    .

    When I look in my error log file, the following details are displayed:

    ERROR:
    Code..............10410
    Description.......Essbase API Procedure: [EsbCalc] Threw code: 1042006 - 1042006 - [Fri Apr 13 15:35:16 2012]TORNTSDBS92/ESSCON/ESSCON/admin/Error(1042006)
    Network error [10048]: Unable to connect to [TORNTSDBS92:1423]. The client timed out waiting to connect to Essbase Agent using TCP/IP. Check your network connections. Also make su
    Procedure.........clsHPDataManipulation.fCalculate
    Component.........upsES11XG4F
    Version...........100
    Thread............7480

    IDENTIFICATION:
    User..............xxxxxx
    Computer Name.....TORNTSAPP156

    ESSBASE CONNECTION:
    App Name..........ESSCON
    DB Name...........ESSCON
    Server Name.......TORNTSDBS92
    Connect Status.... Connection Open

    I broke up the file I was loading into smaller pieces (still as Replace) and it worked. I was also able to load the whole file after I changed it to 'merge'.

    Does anyone have any ideas? It seems like it isn't able to clear the data anymore prior to loading.

    Thx,
    Mike

    DB:3.07:Fdm Essbase Error ca

    Looks to be an issue with the Essbase Application Database when the load is happening:

    [Mon Aug 13 19:29:59 2012]Local/ESSCON//xxxxx/Error(1013013)
    Active Database Needed To Execute This Command

    I would post to the Essbase Forum and see if they have any insight.

  • RELEVANCY SCORE 3.07

    DB:3.07:The Remote Procedure Call Failed In Fdm 9.3.1 fd


    Recently we have implemented FDM 9.3.1 with HFM and Essbase adaptor. Frequently we receive The remote procedure call failed error. Can you suggest resolution for this error?

    DB:3.07:The Remote Procedure Call Failed In Fdm 9.3.1 fd

    Recently we have implemented FDM 9.3.1 with HFM and Essbase adaptor. Frequently we receive The remote procedure call failed error. Can you suggest resolution for this error?

  • RELEVANCY SCORE 3.07

    DB:3.07:Error While Modifying Control Tables In Fdm With Essbase Adapters 18


    Hi,

    While trying to edit Control Tables for Period / Category, we are getting an Error 'Unable to retrieve Target System'. We have installed FDM with the Essbase Target Adapter from ES11x-G4-D_1002.zip

    Any help will be greatly appreciated

    Thanks,
    Prasad

    DB:3.07:Error While Modifying Control Tables In Fdm With Essbase Adapters 18

    Hi,

    Thanks for the quick response.
    We are now able to edit the Control Tables by converting the Dimensions to Global mode
    However, while trying to export, we are getting the following error:

    Error(1012004) Invalid member name

    Thanks Regards,
    Prasad

  • RELEVANCY SCORE 3.05

    DB:3.05:Cannot Look Up Dimension Members In Validation Rules Editor 8c


    Dear All,

    I have installed FDM+Foundation+HFM+Essbase+Planning 11.1.1.3
    I have stacked with the following problem:
    when I try to look up dimensions members in validation rules editor,
    I am getting - message from webpage *data for this dimension not found*
    I cannot select the members here, which I have selected in Activities-Map
    Can somebody help me to look up my existing members?

    Best Regards,
    Siarhei

    DB:3.05:Cannot Look Up Dimension Members In Validation Rules Editor 8c

    Thanks,

    what is the relationship between mapped and global dimensions ('VALxxxxx')
    Why does for some dimensions VALdimension have to exist, and for others it can be absent

  • RELEVANCY SCORE 3.05

    DB:3.05:Missing Option "Use Sso" 7k


    Hi Experts,

    I am using FDM 11.1.1.3 with Hyperion Planning 11.1.1.3.I am able to connect load data using essbase adapter through FDM.
    As per FDM admin guide "USE SSO" feature should be available under FDM application intergration settings,currently it is not available under my FDM application.

    How do I make it available?

    Please guide me.

    DB:3.05:Missing Option "Use Sso" 7k

    This is option appears by default. Goto the workbench and check if you are getting this option there.

    Nick

  • RELEVANCY SCORE 3.05

    DB:3.05:Fdm While Exporting Data Member Not Found jd


    Hi When i am exporting data from FDM to essbase i am getting error when i clicked ExportI have these dimension in essbase ,1.Account 2.entity3.businessunit- dim14.currency- dim25.project-dim36.costcenter-dim47.version-dim58.buytype - dim69.year- dim 710.period- dim811.HSRates- dim9 12.ScenarioThese are my TB format members Revenue, 430_ABC, 4010HOTEL, Curency, Project-holiday, 3010-marketing. Version1, 10-cutting, FY13 , JAN, HSP-INPUTVALUES, Actual, 10000In the above TB all members are loaded in FDM except Actual (i guess this is why i am getting error )i had created import format like this Filed Name FiledNumber Number of Fields 1. SorceEBAccount 1 13 2 .Source EBEntity 2 133. Source custom 1 3 13 4. Source custom 2 4 135 .source custom 3 5 136. Source custom 4 6 13 7. Source custom 5 7 13 8. Source custom 6 8 13 9. Source custom 7 9 1310. source custom 8 10 1311. source custom 9 11 1312. (we dont have scenario) 12 1313.Amount 13 13when i imported TB in to FDM i am not able to find Scenario Dimension Member when i clicked export in FDM i am getting Member not found in Database Please help me in this issue Thanks

    DB:3.05:Fdm While Exporting Data Member Not Found jd

    Hello,The scenario mapping is done within the Control Tables of FDM. You should set up the global Category mapping between your incoming records and Target applications. You would also want to do so for any additional adapters.So map the incoming category to a target application scenario.

  • RELEVANCY SCORE 3.05

    DB:3.05:Fdm Configure For Essbase Adapter Returns Connection Error jp


    When I'm trying to configure the FDM Essbase Adapter ES11X-G4-H, I am getting the "Connection Failed" error for Dimension Mapping.
    I have followed all the steps from the Adapter Readme.

    1. Imported the Adapter
    2. Registered it (from the Hyperion Home\common\EssbaseRTC\11.1.2.0\bin directory.
    3. Created the Machine Profile
    4. Double checked the ARBORPATH and ESSBASEPATH variable values.

    OS: Windows 64 bit.

    Thanks in advance for the help.

    DB:3.05:Fdm Configure For Essbase Adapter Returns Connection Error jp

    You no longer need the ARBORPATH variable, this can be removed, it has beenb replaced with ESSBASEPATH

    Can you post your PATH and ESSBASEPATH variables

  • RELEVANCY SCORE 3.02

    DB:3.02:Kms For Essbase Source j8


    Hi
    Can you tell me what are the KMs need to be imported for using Essbase as Source.
    Essbase as target is working juz fine to load data.

    Curently I have
    LKM Hyperion Essbase Data to SQL
    LKM Hyperion Essbase MetaData to SQL
    IKM SQL to Hyperion Essbase (Data)

    So when I use Essbase as Source to get Account Dimension to SQL table I get the error message target Column has no sql capabilities..

    -app

    DB:3.02:Kms For Essbase Source j8

    You should be able to extract from essbase and then load into essbase in a single interface, though once again you will probably need to use a staging area.

    Cheers

    John
    http://john-goodwin.blogspot.com/

  • RELEVANCY SCORE 3.01

    DB:3.01:Essbase Error(1021001): 8x


    Hi all,

    I am getting following Error while deploying the cube

    Failed to deploy Essbase cube
    Caused By: Failed to build Essbase cube dimension: (Accounts)
    Caused By: Cannot incremental build. Essbase Error(1021001): Failed to Establish Connection With SQL Database Server. See log for more information

    could you please help me on this

    Regards,
    Raghavendra

    DB:3.01:Essbase Error(1021001): 8x

    HI..

    Go through this one.. might help u...!!

    Error: 1021001 Failed to Establish Connection With SQL Database Server

  • RELEVANCY SCORE 3.01

    DB:3.01:Fdm Automation Error - 440 fp


    Hi Expert,

    I tried to automate process to load data from FDM 9.3.3 into Essbase. User want to click Import fish to import data first and then validation/Export/load will be automated to run at the backend. We try to copy the file to OpenBatch folder with Parallel Batch Loading. But it generated Loop there. So I wrote automation script from validate to Export/Load by using API, after that, I added the calling function from AftFileImport Event Script . So I start to test import a file from FDM Web Client, but it reports Automation Error. I check view error log. it report like below. Have anyone had any idea ?

    Regards
    David Wang

    ** Begin FDM Runtime Error Log Entry [2011-09-02-09:28:16] **
    -------------------------------------------------------------
    ERROR:
    Code......................................... 440
    Description.................................. Automation error
    Procedure.................................... clsImpProcessMgr.fLoadAndProcessFile
    Component.................................... upsWObjectsDM
    Version...................................... 933
    Thread....................................... 4736

    DB:3.01:Fdm Automation Error - 440 fp

    Hi Expert,

    I tried to automate process to load data from FDM 9.3.3 into Essbase. User want to click Import fish to import data first and then validation/Export/load will be automated to run at the backend. We try to copy the file to OpenBatch folder with Parallel Batch Loading. But it generated Loop there. So I wrote automation script from validate to Export/Load by using API, after that, I added the calling function from AftFileImport Event Script . So I start to test import a file from FDM Web Client, but it reports Automation Error. I check view error log. it report like below. Have anyone had any idea ?

    Regards
    David Wang

    ** Begin FDM Runtime Error Log Entry [2011-09-02-09:28:16] **
    -------------------------------------------------------------
    ERROR:
    Code......................................... 440
    Description.................................. Automation error
    Procedure.................................... clsImpProcessMgr.fLoadAndProcessFile
    Component.................................... upsWObjectsDM
    Version...................................... 933
    Thread....................................... 4736

  • RELEVANCY SCORE 3.00

    DB:3.00:Essbase And Fdm 13


    Hi all,

    I am trying to load data from FDM to essbase and I am getting the error file not found esbapin.dll and the export is failing .

    Mike

  • RELEVANCY SCORE 3.00

    DB:3.00:Fdm Application zs


    Hi all,

    I am having one Source system(Oracle Apps) and three Target system(HFM,Essbase,Planning).

    My question is with the help of one FDM application, can we able to connect to all the three 3 Target system (or)
    we need to have 3 different FDM application to connect the Target system.

    Regards,
    Sanjeev

    DB:3.00:Fdm Application zs

    Ok.. thanks for the info Tony.. can You look into a Matter that I have posted.. I m facing a problem with that.. I need to deliver in a short span of time..

    Amount Export Problem

    Edited by: user13576137 on Jan 13, 2011 6:43 AM

  • RELEVANCY SCORE 3.00

    DB:3.00:Essbase Client Installation On Fdm Application Server jp


    Hi Everyone,I have Win 2008 Ent SP2 64 bit FDM App server and I just read: its a prerequisite that the Essbase 32bit Runtime Client is installed on the FDM Application Server in order to integrate target adapter for Essbase with FDM.Please can somebody let me know:1.What are the executable files which I need to download and install and from where i can get them?2.At which path on my FDM app server I need to put and install Essbase client executables?3.Do i need to modify system variable and reboot the server to put Essbase client into effect after installation ?4.I have 11.1.2.1.000 FDM version. Is it compulsory to install the same version of Essbase client ?Thanks for your help...----Sunny

    DB:3.00:Essbase Client Installation On Fdm Application Server jp

    Hello,Go through the url which contains all the informationsamp;lt;hyperion readme templateamp;gt;You need to install 32 bit oracle client on your Win 2008 Ent SP2 64 box ( if you are using oracle as your db)Register the adapters in workbench client or in workbench webBefore i would like to ask you whether have you created an FDM application first?Thanks,Sreekumar Hariharan

  • RELEVANCY SCORE 3.00

    DB:3.00:Re: Fdm Script Error 8m


    This is likely a permissions problem on the FDM share. Ensure that the fdm service account has full access to the FDM share.

    DB:3.00:Re: Fdm Script Error 8m

    can you share what the "access issue" was? I am also receiving the 'Parallel process shell [2] failed to start' error.

  • RELEVANCY SCORE 3.00

    DB:3.00:Fdm Essbase Adapter Is Missing Dimension Member dp


    We are running FDM 11.1.1.3

    We installed the Essbase adapter and configured it for a specific Planning application\database.
    In FDM web we can browse for target in the Account Dimension we can see the essbase account members, but there is a specific account that we cannot find.

    When we check Planning\Essbase the account we are searching for exists and is a member of the Account dimension.

    How can we get FDM to locate this missing member? is there a way to force a refresh on the adapter or account dimension?

    DB:3.00:Fdm Essbase Adapter Is Missing Dimension Member dp

    Glad you found it.

    (Must do some checking to see if FDM caches them in memory hence them being there after logging off / on).

  • RELEVANCY SCORE 3.00

    DB:3.00:Essbase Adaptor For Fdm 9.3.1 a3


    Hi Frnds,

    I need to use essbase target adaptor for FDM 9.3.1. we have .xml file but esbapin.dll file was missing. So please tell me from where we will get this file.
    Also we need to pick data from essbase and put it into HFM using FDQM .Are there any souce adapters available for picking data from essbase.

    thanks
    vikram

    DB:3.00:Essbase Adaptor For Fdm 9.3.1 a3

    Hello,

    Please ensure that the Essbase RTC w/ API is installed and that the server is rebooted.
    The key thing that most people miss is a reboot of the server.

    Thank you,

  • RELEVANCY SCORE 2.99

    DB:2.99:Essbase Load - Abort On Error a9


    Is there a way in FDM to configure the load to Essase to continue loading after it encounters an error? Right now our loads abort on error.

    DB:2.99:Essbase Load - Abort On Error a9

    What kind of error do you mean exactly?
    In my case when a member is not in the outline it gives an error after the export but still uploads all the other data.

    When an error occurs during the export action (clearing the data for example) then it doesn't load the data because the process is stopped in the Eport action of the adapter.

  • RELEVANCY SCORE 2.99

    DB:2.99:Error Whille Adding New Mapping Into Fdm 91


    Hi,
    When i am trying to add new account mapping into account(The account already having 4000 mappings already) in FDM am getting error like, "Error: Error adding new record.
    Detail: An invalid value was entered for the dimension (Customer)" .

    What should I correct for this situation?
    Thanks so much!!!

    DB:2.99:Error Whille Adding New Mapping Into Fdm 91

    HFM server was down, so i got the error.

    Thanks every one who gave me responce.

  • RELEVANCY SCORE 2.99

    DB:2.99:Unable To Retrieve The Targeted System Data Error With Essbase 9k


    hi all,I am getting an error while connecting to the target system, Essbase, stating that "Unable to Retrieve the targeted system data." Here are the specs of my setup:FDM - 11.1.2.2Essbase - 11.1.2.2Windows OS - Windows Server 2008 R2 64bitSQL - 2008 R2FDM Adapter - ESS11X64-JI tried several things:1) Registered adapter again2) Check integration settings - a) Machine profile - It's all going ot the same machine, meaning Essbase and FDM are installed on the same machine. This is a dev box. b) Essbase Integration - Essbase app name, Essbase db name, logon method = 2- Global, and setup dimensions to match exactly with my Essbase cube. I tried with and without the Domain name but no luck. c) Dimension - make sure that the Dimension names mirrored my Essbase cube. Checked Active, Use List, and Set Matching Label for each dim 3) Checked Essbase RTCAny advice folks? Thanks in advance!Here's the error I am getting: ** Begin Oracle Hyperion FDMAdapter for Essbase Runtime Error Log Entry [2013-06-29-17:46:51] **-------------------------------------------------------------Error:Code..............10404Description.......Essbase API Procedure: [EsbInit] Threw code: 1030803 - .Procedure.........clsHPConnection.fConnectComponent.........upsES11XG4JVersion...........100Thread............6364Identification:User..............hypadminComputer Name.....HYP11122Essbase Connection:App Name..........LongFinDB Name...........FinanceServer Name.......HYP11122Connect Status.... No Connection Open** Begin FDM Runtime Error Log Entry [2013-06-29 17:46:52] **-------------------------------------------------------------ERROR:Code............................................. 10404Description...................................... Essbase API Procedure:[EsbInit] Threw code: 1030803 - .At Line: 124Procedure........................................ clsBlockProcessor.ActConnectComponent........................................ upsWBlockProcessorDMVersion.......................................... 1112Thread........................................... 3284IDENTIFICATION:User............................................. hypadminComputer Name.................................... HYP11122App Name......................................... FDMLLClient App....................................... WebClientCONNECTION:Provider......................................... SQLOLEDBData Server...................................... HYP11122Database Name.................................... HYP_FDM_LLTrusted Connect.................................. FalseConnect Status.. Connection OpenGLOBALS:Location......................................... SampleLocation ID...................................... 748Location Seg..................................... 2Category......................................... WLCatCategory ID...................................... 12Period........................................... Jun - 2013Period ID........................................ 6/30/2013POV Local........................................ FalseLanguage......................................... 1033User Level....................................... 1All Partitions................................... TrueIs Auditor....................................... False** Begin FDM Runtime Error Log Entry [2013-06-29 17:46:52] **-------------------------------------------------------------ERROR:Code............................................. 10404Description...................................... Essbase API Procedure:[EsbInit] Threw code: 1030803 - .At Line: 124Procedure........................................clsBlockProcessor.DimensionListComponent........................................ upsWBlockProcessorDMVersion.......................................... 1112Thread........................................... 3284IDENTIFICATION:User............................................. hypadminComputer Name.................................... HYP11122App Name......................................... FDMLLClient App....................................... WebClientCONNECTION:Provider......................................... SQLOLEDBData Server...................................... HYP11122Database Name.................................... HYP_FDM_LLTrusted Connect.................................. FalseConnect Status.. Connection OpenGLOBALS:Location......................................... SampleLocation ID...................................... 748Location Seg..................................... 2Category......................................... WLCatCategory ID...................................... 12Period........................................... Jun - 2013Period ID........................................ 6/30/2013POV Local........................................ FalseLanguage......................................... 1033User Level....................................... 1All Partitions................................... TrueIs Auditor....................................... False** Begin FDM Runtime Error Log Entry [2013-06-29 17:46:52] **-------------------------------------------------------------ERROR:Code............................................. -2146817884Description...................................... Essbase API Procedure:[EsbInit] Threw code: 1030803 - .At Line: 124Procedure........................................ObjScriptReturnMarshaler.GetDimensionListIDENTIFICATION:User............................................. hypadminComputer Name.................................... HYP11122App Name......................................... FDMLLClient App....................................... WebClientCONNECTION:Provider......................................... SQLOLEDBData Server...................................... HYP11122Database Name.................................... HYP_FDM_LLTrusted Connect.................................. FalseConnect Status.. Connection OpenGLOBALS:Location......................................... SampleLocation ID...................................... 748Location Seg..................................... 2Category......................................... WLCatCategory ID...................................... 12Period........................................... Jun - 2013Period ID........................................ 6/30/2013POV Local........................................ FalseLanguage......................................... 1033User Level....................................... 1All Partitions................................... TrueIs Auditor....................................... False

  • RELEVANCY SCORE 2.99

    DB:2.99:Drillable Region Load Returned Errors. Please See Log 39


    When loading a data file to Essbase via FDM, the load failed and the FDM error log displayed the following:

    FDM Error Log:
    ** Begin Oracle Hyperion FDM Adapter for Essbase Runtime Error Log Entry [2012-06-27-15:16:46] **
    -------------------------------------------------------------
    Error:
    Code..............10438
    Description.......Drillable Region Load returned errors. Please see Log.
    Procedure.........clsHPDataManipulation.fLoadDRArray
    Component.........upsES11XG4H
    Version...........100
    Thread............3940

    Identification:
    User..............*******
    Computer Name.....*******

    Essbase Connection:
    App Name..........*******
    DB Name...........*******
    Server Name.......*******
    Connect Status.... Connection Open

    The Essbase Application log gave the following error:

    Essbase Application log:
    [Wed Jun 27 15:16:46 2012]Local/*******/*******/*******@Native Directory/140011248002816/Info(1013091)
    Received Command [Update Drill through URL ] from user [admin@Native Directory]

    [Wed Jun 27 15:16:46 2012]Local/*******/*******/*******@Native Directory/140011248002816/Error(1200315)
    Error parsing formula for [REGION DEFINITION] (line 0): invalid object type

    [Wed Jun 27 15:16:46 2012]Local/*******/*******/*******@Native Directory/140011248002816/Warning(1080014)
    Transaction [ 0x30002( 0x4feb15ce.0x7ff66 ) ] aborted due to status [1040022].

    Does anyone please know what this means, and how I can resolve this? Previous data files loaded fine, so not sure why this has occurred this time round. We are using FDM and Essbase version 11.1.2.1.

    DB:2.99:Drillable Region Load Returned Errors. Please See Log 39

    As an update, I have had to uncheck the "Enable Drillable Region Load" checkbox in the FDM Essbase adapter Integration Settings for now.

    Oracle are investigating further.

  • RELEVANCY SCORE 2.98

    DB:2.98:Re: Essbase Error When Trying To Modify Dimension Through Rule File fz


    try giving some points :)

  • RELEVANCY SCORE 2.98

    DB:2.98:Essbase Studio Error During Deployment Cube Into Essbase a8


    Hi all,

    I'm using Essbase studio11 and trying to deploy my cube into essbase using the deployment wizard. But I keep getting this error:

    Failed to deploy Essbase cube
    Caused By: Cannot begin incremental build. Essbase Error(1007151): Wrong incremental dimension build sequence

    Please help and advise.
    thanks in Advance.

    -Avishek Sarkar.

    DB:2.98:Essbase Studio Error During Deployment Cube Into Essbase a8

    I know it's an old post, but i've faced the same issue with EPMA v 11.1.2.1.0.I've solved restructuring the database.Maybe this can be usefull for someone.regards,Daniele

  • RELEVANCY SCORE 2.97

    DB:2.97:Essbase Substitution Variables And Import Formats cp


    Does anyone please know of a way to make use of Essbase Substitution Variable values in FDM Import Format scripts? We would like to load data through FDM to Essbase based on the current version substitution variable (i.e. CurVersion), so that the data is submitted against the correct member.

    We have tried writing "CurVersion" into the respective column of the .DAT file, however Essbase is unable to import data to "CurVersion", throwing an error saying that this is not a valid member (even with the quotation symbols removed)

    Does the FDM Essbase adapter allow for substitution variables to be used? If so, how can we go about this? The only other alternatives we can think of are to:
    a) Process the .DAT file before it is imported to Essbase, to replace all occurrences of "CurVersion" with the actual subsitution variable value retrieved using MaxL inside a batch script)
    b) Load the data to a different member, and then copy inside Essbase using a calc script.

    A better solution would be more preferable!

    DB:2.97:Essbase Substitution Variables And Import Formats cp

    Perfect, this will definitely be a more preferable solution, thanks!

  • RELEVANCY SCORE 2.97

    DB:2.97:Error At Line 125 aj


    Hi All,
    I am using Hyperion 9.3.1.4
    Installed and configured FDM for HFM and Essbase targets.
    For HFM as Target , its working fine
    .But
    = For Essbase as target, when i try to retrieve from target(in maps) I am getting an error "Error: at Line 125".
    .
    I think this is only related to Essbase adapter, i am using "Es9X-G4-A"

    Kindly help me out bcoz there is no point to Re-install/Re-configure FDM as application for HFM is working fine..

    Is this related to some DCOM component/user

    J

    DB:2.97:Error At Line 125 aj

    Hi,
    I found the solution

    Currently the ES9x-G4-G adapter is configured to run as the "Launching User" under the identity tab of the adapter DCOM object".
    If the identity is changed to "This User" and the FDM Service account is entered and the connection attempt is re-established, the connection to Essbase is successful and the target periods are returned.

    Thanks All

    J

  • RELEVANCY SCORE 2.97

    DB:2.97:Data Upload Without Mapping kd


    We have received a file, which is to be uploaded in Essbase through FDM,and the columns and rows in it consist of dimension members appearing in Hyperion Planning.

    Can we upload data without creating a mapping in this case?

    DB:2.97:Data Upload Without Mapping kd

    No,
    sorry but mapping is a FDM processs stage(part of validate) which cannot be skipped.

    Yes, there is a way to do this very quickly.

    For that you need to add some "Like" mappings to your location maps across all dimensions.
    Make Sure, Each dimention in the maps should have atleast one entry that defines the target of Members in loaded data.

    J

  • RELEVANCY SCORE 2.96

    DB:2.96:Essbase Drillback To Fdm - Error: 2067 - Shared Services Provisioning xj


    Working with EPM 11.1.1.3. Trying to get Essbase Studio to drillback to FDM. Getting the following error:

    Error: An error occurred logging on to the system using single sign-on. Please contact your administrator:
    Error: 2067 - You do not have access to the application!

    I've reviewed and re-reviewed FDM setup, DCOM config, and Shared Service provisioning. Everything appears correct. Including Provisioning FDM Users using Shared Services:

    http://download.oracle.com/docs/cd/E12825_01/epm.111/fdm_config_help/frameset.htm?ch10s02.html

    Anyone else run in to this? Any solutions?

    Thanks,

    Bob

    DB:2.96:Essbase Drillback To Fdm - Error: 2067 - Shared Services Provisioning xj

    Hi,

    I am facing the same issue.
    Can you please list down your solution in stepwise manner.It would be of great help.

    Thank You!

  • RELEVANCY SCORE 2.96

    DB:2.96:Loading Data Into Essbase Through Fdm ad


    Dear Guru's,

    Can any one provide any document or Pdf related to loading data into Essbase through FDM?

    Thanks in Advance.................

    DB:2.96:Loading Data Into Essbase Through Fdm ad

    Dear Alp Burak,

    You are superb. That link is very useful to me.

    Thank a lot.
    Sekhar

  • RELEVANCY SCORE 2.95

    DB:2.95:Fdm Environment For Hfm And Essbase kz


    Hello all,

    Currently I am using FDM for HFM account mapping only. I have two questions with regards to adding on Essbase environment

    1) For Hyperion Planning (Essbase), can I leverage the same FDM application to register import essbase adaptor OR do I have to create a separate FDM application(s).

    2) I have two Essbase cubes in one Hyperion Planning application. One has 13 dimensions while the other has 11. Do I need separate table spaces in Oracle database for each cube or one common tablespace should be sufficient?

    Thanks you

    DB:2.95:Fdm Environment For Hfm And Essbase kz

    Tony, I'm unable to locate this bug on Oracle Support nor in the readmes. Do you have a link or a kb article #?

    Regards,
    Robb Salzmann

  • RELEVANCY SCORE 2.95

    DB:2.95:Out Of Memory Fdm 9.3.1 Export To Essbase 1d


    Hi all,

    When I try to Export to Essbase about 200k lines from FDM, we are getting the error Out of Memory. Seems to be the essbase plugin upsES9XG4B is not capable of handle that much of information.
    We are running FDM and Essbase 9.3.1.
    I got the follow error:

    ** Begin Runtime Error Log Entry [2010-08-26-11:27:09] **
    -------------------------------------------------------------
    ERROR:
    Code............ -2147024882
    Description..... Out of memory.
    Procedure....... clsHPDataAccess.fFixMemberCase
    Component....... upsES9XG4B
    Version......... 100
    Thread.......... 7928

    ** Begin FDM Runtime Error Log Entry [2010-08-26-11:27:10] **
    -------------------------------------------------------------
    ERROR:
    Code......................................... 7
    Description.................................. Out of memory.
    At Line: 478
    Procedure.................................... clsBlockProcessor.ActExport
    Component.................................... upsWBlockProcessorDM
    Version...................................... 931
    Thread....................................... 1372

    If anyone has some clues about it, please, help me.

    Best Regards,

    -- Bruno Alvim.

    DB:2.95:Out Of Memory Fdm 9.3.1 Export To Essbase 1d

    This is a known problem. You will either need to upgrade FDM or modify the adaptor to stop the case fixing - assuming your Essbase app has not been set up to be case sensitive.

  • RELEVANCY SCORE 2.94

    DB:2.94:Can We Have More Than 1 Essbase Db Per Fdm App ? zf


    Hi,

    We need to load data into 2 essbase DBs. They are under the same Planning app.

    Do we need to create 2 FDM applications, one for each DB, or can we have just 1 FDM app and reference the 2 Essbase DBS ?

    Please help

    Haz

    DB:2.94:Can We Have More Than 1 Essbase Db Per Fdm App ? zf

    Hi,

    We need to load data into 2 essbase DBs. They are under the same Planning app.

    Do we need to create 2 FDM applications, one for each DB, or can we have just 1 FDM app and reference the 2 Essbase DBS ?

    Please help

    Haz

  • RELEVANCY SCORE 2.94

    DB:2.94:Fdm Application Not Able To Login In Hyperion 11.1.2.3 3k


    Hi All,I have installed Hyperion 11.1.2.3 version on Windows 2008 server (64 bit). Installed Essbase, Planning, HFM and FDM in one box only.Now the issue is, i have created FDM application then i am not able access that application through FDM Web Client.wired thing is, it is not showing any error msg in the web client, but able to login from work bench client.Any one have any ideas please share??Thanks,mady

    DB:2.94:Fdm Application Not Able To Login In Hyperion 11.1.2.3 3k

    I got for this, so i am closing this discussion.IE 10 not supports Hyperion 11.1.2.3 version. so we need IE 9 to access this. i am working on that.from my laptop i am able to open FDM application its IE 8, in IE 9 also it is working fine.Thanks,mady

  • RELEVANCY SCORE 2.94

    DB:2.94:Can Fdm Handle More Than One Year At A Time? c7


    Hi,

    I'm trying to load a multi-load file through FDM with the target being an Essbase cube and the source being a text file. The file is for 36 months which crosses 3 years. The problem is Oracle support is saying FDM can only handle one calendar year at a time and we need to load 3 separate files.

    The file imports and validates ok. And the export only pushes data to the first year '2010' but it doesn't error out.

    Any ideas?

  • RELEVANCY SCORE 2.93

    DB:2.93:Fdm : Error While Checking Integration Settings f1


    Hi,

    I am in the process of setting up an FDM App (Version 9.3.1)) for loading data to Essbase.

    I've Imported and Registered ES9X-G4-A Adaptor via Workbench. I've also added the Machine Profile.

    When I try to test Integration Settings in the Web Client by 'Browsing for Target Value' in Maps, I get the following error:

    ERROR:
    Code......................................... 53
    Description.................................. File not found: esbapin.DLL
    At Line: 125
    Procedure.................................... clsBlockProcessor.ActConnect
    Component.................................... upsWBlockProcessorDM
    Version...................................... 931
    Thread....................................... 2668

    For the moment, I have mapped only 2 Dimensions. The peculiar thing is if within any Dimension, I check the 'Use List' Box, I get the above error, during Integration Check.
    But if I leave that box blank, I do NOT get an error, but only a 'No Items to display' box.

    Am I missing any steps? My feeling is the Adaptor has not been configured correctly.

    Kindly advise.

    Regards,
    Tejas.

    DB:2.93:Fdm : Error While Checking Integration Settings f1

    Once importing the essbase adapter is done, have you registered adapter with dll file.
    this can be done from file-register adapter

  • RELEVANCY SCORE 2.93

    DB:2.93:Active Target Category Is Empty 1f


    Hi All,

    We have migrated FDM app from 9.3.1 to V11.1.2.1 ...configured Adapters everything looks good..

    In Activities\Maps\Target FM Account -Browse for Traget Value..we are able to see the target Dimension members...

    We have 2 adapter HFM Essbase.

    The Issue is in Adapter POV's "Active Target Category" is Empty...even when we change the Location,Active Period Active FDM Category the *Active Target Category is showing as [Empty] for both Adapters..*

    In Workflow when we export a file and Validate its failing.....

    How can we solve it .

    Appreciate your response........

  • RELEVANCY SCORE 2.92

    DB:2.92:Fdm And Essbase zk


    Hi all,

    I am trying to load data from FDM to essbase and I am getting the error file not found esbapin.dll and the export is failing .

    Mike

    DB:2.92:Fdm And Essbase zk

    I am having the same problem. When I try to test my target mappings, I get an Esbapin.dll error stating that the file can not be found.

    I had to load the Essbase Client onto the FDM machine in order to get the .dll files. I then copied the files to E:\Essbase\products\Essbase\bin. However, my Arborpath Essbasepath are set to E:\Hyperion\Products\Essbase\EssbaseClient. Is this where the file really needs to be located? The files were initially in E:\Hyperion\Products\Essbase\EssbaseClient\bin

    Currently, FDM is installed on one server and Essbase is on a separate server. The configuation guide said that I should set up the Arborpath Essbasepath on the FDM server to be the same as what is on the Essbase server. I have done that but used E:\Hyperion\Products\Essbase\EssbaseClient.

  • RELEVANCY SCORE 2.92

    DB:2.92:Planning And Fdm az


    Hi,

    Can FDM load metadata to planning? For now i am using architect to load metadata and rules files to load data to essbase. Can I do it all in FDM?

    Thank you

    DB:2.92:Planning And Fdm az

    Just to be clear, you certainly can load data from external sources into Planning with FDM (Planning data is actually loaded into Essbase, of course, via the Essbase adapter for FDM).

    As already noted, you cannot load metadata into Planning with FDM unless you get creative and write some custom code.

    If you want one tool that can do both, then ODI is one option. A restricted use ODI license is now included with Planning.

  • RELEVANCY SCORE 2.92

    DB:2.92:Fdm Help Urgent.. 9p


    Experts,
    Can you please validate my below understandings if these are correct or not. I am concerned only on FDM(without ERPi). Appreciate if can be commented point by point.

    1. FDM is a tool for loading data to Essbase and HFM
    2. FDM can extract data from flat file and load the data to Essbase and HFM
    3. FDM can extract data from Oracle table and load the data to Essbase and HFM
    4. FDM can not connect to Essbase to extract data directly. Rather some native process like data export calculation script first extracts data to flat file and FDM can take that flat file and load it to other Essbase database or HFM based on need.
    5. FDM can not connect to HFM to extract data directly. Rather some native process like data export process in HFM first extracts data to flat file and FDM can take that flat file and load it to other HFM Application or Essbase database.
    6. FDM can never load the data to Oracle table.

    I am really struggling with these points and not getting some definite answer. If anyone of you knows the answer will be of great help.

    Thanks for all your help.
    Dev

    Edited by: Dev on Jun 25, 2010 3:58 AM

    DB:2.92:Fdm Help Urgent.. 9p

    Thanks a lot. I got all my alswers. Thanks again.

    Dev

  • RELEVANCY SCORE 2.91

    DB:2.91:Configuring Fdm With Essbase Adapter-Dimension Tab fj


    I get Connection failed under Target Dimension on the Dimension tab. I have the essbase client installed and the path statement setup properly.

    I'm going against the Demo App and Basic DB. Application is started in EAS.

    Ideas?

    DB:2.91:Configuring Fdm With Essbase Adapter-Dimension Tab fj

    The essbase runtime client must be installed on the FDM application server(s) in the environment to integrate with Essbase.

  • RELEVANCY SCORE 2.91

    DB:2.91:339 - Component 'Srcvw3.Dll' Missing / Not Configured Correctly 97


    Hi,
    I'm trying to connect to essbase through FDM. I met this error in Tool View error: "339 - Component 'Srcvw3.dll' or one of its dependencies not correctly registered: a file is missing or invalid."

    I moved ES11X-G4-H.xml to FDM Shared component and upsES11XG4H.exe to Essbase-client-32/bin folder. I also configure ARBORPATH and ESSBASEPATH to essbase 32 bit client directory.

    Please help

    DB:2.91:339 - Component 'Srcvw3.Dll' Missing / Not Configured Correctly 97

    'Srcvw3.dll' is the file name.

    You can place this in the FinancialDataQuality\SharedComponents directory and register from this location using regsrv32

  • RELEVANCY SCORE 2.91

    DB:2.91:Essbase Bso Cube From Epma d7


    Dear all,I have an essbase BSO cube. The cube is refreshed from EPMA.It was working fine. But after making some changes (add members), the deployment was being aborted with the following message.Error.Failed to deploy Essbase cube.Caused by: Failed to build Essbase cube dimension: (XX_MONTHS) .Caused by: Cannot end stream build. Essbase Error(1007083): Dimension build failed. Error code [1060056]. Check the server log file and the dimension build error file for possible additional info.Failed to deploy Essbase cube.Caused by: Failed to build Essbase cube dimension: (XX_MONTHS) .Caused by: Cannot end stream build. Essbase Error(1007083): Dimension build failed. Error code [1060056]. Check the server log file and the dimension build error file for possible additional info.\\Error Updating Dimension MA_MONTHS\\Error Initializing Rule File Information.Kindly help.Thanks and Regards,

    DB:2.91:Essbase Bso Cube From Epma d7

    Dear Celvin.That was exactly the case.My DTS was wrogly set-up for the time dimension.Thanks very much for your help.Thanks and Regards

  • RELEVANCY SCORE 2.91

    DB:2.91:Essbase Data Cache Full Error ff


    Hi, All,

    I am encountering an Essbase data cache full error while running some calc scripts. I have already try to set the data cache size to 800MB to 1.6GB, and index cache to around 100MB. It is quite a large BSO Essbase, with one dimension over 1000 members, another about 2500 members, and the last one about 3000 members.

    I have three similar scripts and each is for different entities to aggregate on some of those dimensions.

    For example, I started with unload the app/db, and run the calc script 1 for Entity1, it is successfully; However, I continue to run on calc script 2 for Entity 2, it showed the "data cache full error". However, after I unload the app/db, and then run calc script 2 again, I can have the calc scripts completed with no errors.

    I am running on Essbase 11.1.1.3 on AIX platform 32-bit Essbase.

    Anyone had encountered that before. Is it a problem with Essbase RAM handling, in this case?

    Thanks in advance

    DB:2.91:Essbase Data Cache Full Error ff

    Hi, All,

    I am encountering an Essbase data cache full error while running some calc scripts. I have already try to set the data cache size to 800MB to 1.6GB, and index cache to around 100MB. It is quite a large BSO Essbase, with one dimension over 1000 members, another about 2500 members, and the last one about 3000 members.

    I have three similar scripts and each is for different entities to aggregate on some of those dimensions.

    For example, I started with unload the app/db, and run the calc script 1 for Entity1, it is successfully; However, I continue to run on calc script 2 for Entity 2, it showed the "data cache full error". However, after I unload the app/db, and then run calc script 2 again, I can have the calc scripts completed with no errors.

    I am running on Essbase 11.1.1.3 on AIX platform 32-bit Essbase.

    Anyone had encountered that before. Is it a problem with Essbase RAM handling, in this case?

    Thanks in advance

  • RELEVANCY SCORE 2.91

    DB:2.91:Es9x-G4-B Fdm Adaptor For Essbase x3


    Hi,

    I'm looking for the ES9x-G4-B FDQM adaptor for Essbase.

    I can't find it in edelivery.

    I have FDM 9.3.1 and ES9x-G4-A adaptor but need to upgrade to FDM 9.3.1.1 to solve a bug.

    The problem is that ES9x-G4-A is can't work with FDM 9.3.1.1 wich is suppose to work with ES9x-G4-B according to Oracle support and the only version i can find in edelivery is ES9x-G4-C wich can't work with FDM 9.3.1.1 (still according to Oracle support).

    Does anyone know where i can find this adaptor? Because Oracle don't...

    DB:2.91:Es9x-G4-B Fdm Adaptor For Essbase x3

    You're right.

    It's clearly stated in FDM 11.1.1.1 readme that EB9x-G4-C is compatible with FDM9.3.1.1 as well as EB9x-G4-B.

    I didn't see this readme since i'm not installing 11.1.1.1

    Strange that Oracle support were not able to tell us that.

    Thank you very much for your help.

  • RELEVANCY SCORE 2.91

    DB:2.91:Loading Data Into Essbase Using Fdm Edition 11.1.2.1 aj


    Hi
    I need to load data from Oracle DB to Hypeiron Essbae by using FDM 11.1.2.1
    any document or guide.

    Regards

    DB:2.91:Loading Data Into Essbase Using Fdm Edition 11.1.2.1 aj

    FDM Admin guide explains the use of fixed / delimited flat files, and the use of an integration script (with sample script) to pull directly from a relational DB. If the Oracle DB is part of the products / applications available to ERPi, then the ERPi adaptor could also be investigated.

  • RELEVANCY SCORE 2.91

    DB:2.91:Fdm Cannot Access Calc Script p7


    We use FDM to load data to Essbase and then run a script after export to Aggregate the data using Vlaidation Entities in FDM. We wrote a new Agg Script and so I changed the Validation entity from CalcALL to CALCCMA and now I get the below error.

    Error: Essbase API Procedure: [EsbCalcFile] Threw code: 1030214 - 1030214 - [Tue Aug 03 13:25:25 2010]XXXXX/PLANNING/IncStmt/admin/Error(1030214)
    User [admin] cannot access calc script: CALCCMA

    The script is in the same folder as the old one. What is also strange is that when I try to change back the Script to CalcALL in the FDM valdiation entity I get an error as well. I checked all the integration settings and they are correct. I checked every script in FDM and asearched the adapter XML and found no references to the CalcALL script. I can't figure out where else the script would be referenced in FDM or if I need to change something on the Essbase side.

    DB:2.91:Fdm Cannot Access Calc Script p7

    Jft85's point is that you can write the command to execute the calc script directly within the LOAD action script within the FDM adapter. This would be a direct call and would bypass using the validation entities.

    -Nate

  • RELEVANCY SCORE 2.91

    DB:2.91:Dynamically Connect To Multiple Essbase Cubes From 1 Adapter j7


    Hi Guys,

    i have 14 Essbase cubes (containing the same dimensions).
    What i like to accomplish is that based on the selected location in the POV an essbase cube is selected..

    I've updated the connect action with:

    If RES.pstrLoc = "SampleGreece" Then
    objHW.Connection.PstrDatabase = "TstGRE"
    ElseIf RES.pstrLoc = "SampleSpain" Then
    objHW.Connection.PstrDatabase = "TstSPA"
    Else
    objHW.Connection.PstrDatabase = API.DataWindow.DBTools.fGlobalOptionGet(API.IntBlockMgr.IntegrationMgr.PstrSysKey "DBName").Value
    End If

    And this works fine for the first location..

    However, when i change the pov to another location the 'browse for target value' still points to the first one. After re-logon it works fine for the new location.

    It looks like its stored in some kind of cache memory so i'm looking for a method to clear this cache or to reconnect while changing the POV.

    It's FDM and Essbase 11.1.1.3

    Thanks in advance,

    Marc

    DB:2.91:Dynamically Connect To Multiple Essbase Cubes From 1 Adapter j7

    If maintenance of the control tables is the issue, you could write a VB script to update them all at once as well depending on what your trying to accomplish and throw it in taskflows. That may help with some of the overhead.

    Regards
    JTF

  • RELEVANCY SCORE 2.90

    DB:2.90:Fdm And Hfr For Essbase ?? 3j


    Guys,

    We have a requirement to report chart of accounts, etc through Essbase from Oracle ERP and I want to validate the following

    1) Can we use FDM/ODI and connect to Essbase from ERP for building cubes and loading data?
    2) Can we use HFR to connect to Essbase cubes for reports?

    DB:2.90:Fdm And Hfr For Essbase ?? 3j

    For question 1 it may be worth having a read of the ERPi doc to see what it is capable of - http://download.oracle.com/docs/cd/E17236_01/epm.1112/erpi_admin/launch.html
    Depending on your system ERPi may be able to do what you are looking for -

    "ERP Integrator supports loading data into EPM applications from general ledger source systems and also writing back budget data from target EPM Planning applications to general ledger source systems.
    Loading data from the General Ledger Source System - ERP Integrator supports loading data from general ledger source systems. ERP Integrator can load both metadata (dimension members and hierarchies) from the ERP source system as well as the related data."

    There are other possibilities like loading data into FDM and pushing into essbase or not even using FDM, metadata would have to be built another way e.g. load rules, ODI.

    Second question the answer is Yes.

    Cheers

    John
    http://john-goodwin.blogspot.com/

  • RELEVANCY SCORE 2.90

    DB:2.90:Epma Essbase Error fj


    Hi All

    We are trying to deploy 13000 - 90000 members (for a dimension) in essbase from EPMA. Error: server.TaskOutOfMemoryException

    Thanks in advance

    Regards

    DB:2.90:Epma Essbase Error fj

    Hi,

    No you cannot. Is there data in the cube when you deploy?

    Thanks,

    Nathan

  • RELEVANCY SCORE 2.90

    DB:2.90:Write Back Capability Of Fdm ap


    Hi,

    Is anyone aware where FDM is having write back capability to transaction systems.
    Example,is it possible to load data from Essbase/Planning/HFM to source systems such as Oracle GL or EBS using FDM?

    Thanks

    DB:2.90:Write Back Capability Of Fdm ap

    This functionality was introduced in 11.1.2 to write back budget data from Planning to the ERP. This is done using ERPi. Download the ERPi admin guide and take a look.

  • RELEVANCY SCORE 2.89

    DB:2.89:Integration Hfm- Hcpm pa


    Hi,

    I'm trying to load data from FDM to Esbasse using adapater ES11X-G4-H , HPCM generates a essbase cube that allows duplicate member name , so when I try to export i recieve a log error.

    Error:
    Code..............10410
    Description.......Essbase API Procedure: [EsbCalc] Threw code: 1200618 - 1200618 - [Tue May 08 16:37:58 2012]HYPERIONSERVER/BanNacC/BanNacC/admin/Error(1200618)

    Unable to resolve duplicate member name ["Avenida Central"] on line [1]
    Procedure.........clsHPDataManipulation.fCalculate
    Component.........upsES11XG4H
    Version...........100
    Thread............15228

    Identification:
    User..............admin
    Computer Name.....HYPERIONSERVER

    Essbase Connection:
    App Name..........BanNacC
    DB Name...........BanNacC
    Server Name.......HYPERIONSERVER
    Connect Status.... Connection Open

    I created a load rule in essbase based on the generated FDM file , I have set the 'Enable String Load' to 'True' and provided the Load Rule File name But it still gives the same error

    Any ideas?

    Thanks in advance,

    DB:2.89:Integration Hfm- Hcpm pa

    Hi Bruno,

    Thanks in advance for you answer, but I have another question the rule file that you mentioned, i have to configure that in FDM o ESSBASE? , you can explain to me with a simple example how to use a prefix of the dimension in the rule file.

    Thanks,

    Claudia

  • RELEVANCY SCORE 2.88

    DB:2.88:Single Record In Export Error Log - Essbase Adapter zp


    We are using FDM to load data to Essbase cubes. Currently in the export.err log file, we are getting the kickout details for a single record at a time. Is there any setting that would give us the entire list of kickouts in a sinlge log?

    Thanks.

    DB:2.88:Single Record In Export Error Log - Essbase Adapter zp

    Use a load rule to load a data and you will get a error log listing all errors up to the max errors specified in the Essbase configuration. To use this method from FDM instead of the standard Adapter load check the Enable String Load option in the Adapter configuration settings and specify the name of the Load Rule you wish to use. Personally I would always go for the Load Rule option when loading Essabs from FDM

  • RELEVANCY SCORE 2.88

    DB:2.88:Connection To Dimension Failed In Workbench 7k


    Hi all,

    v11.1.2, win server 2008

    I am trying to configure FDM with essbase for the first time. I have got the read helpfully referenced in a previous post I searched for. I have added in the essbase 32 bit location for both the aborpath and essbase_path and rebooted the server. I have imported the adaptor and registered it. I am logged in as an admin user to the server.

    I also referred to this post: unable to configure the FDM-Essbase

    When I go to configure the adaptor I get connection failed on the target for the measures dim. I cannot understand why.

    My knowledge of fdm is very limited at the moment but here is what I have done.

    1. Added machine name as the server name of where fdm is installed. The target server is where essbase is.
    2. Entered credentials for machine profile and essbase integration. User is an admin.

    I am unsure what the source and target servers should be. I have tried the using the same server where fdm is for both but it makes no difference.

    I would appreciate any assistance you would be kind enough to give.

    Thanks,

    Nathan

    DB:2.88:Connection To Dimension Failed In Workbench 7k

    Hello Nathan,

    While I agree with Support on what they stated as a 'work-around' .... it is not something that should have to be done. Being an ex-Support engineer I can tell you that there is a root-cause to the issue and this is only a side-step.

    But I am glad that it is working for you.

    Thank you,

  • RELEVANCY SCORE 2.87

    DB:2.87:Planning And Essbase Adaptors For Fdm cs


    Hi all,
    I wanted to know if the adaptors for planning and essbase are same or different in FDM. I found the adaptor for essbase in FDM but was not able to find any adaptor for planning. Any help will be appreciated.

    Thanks Regards.

    DB:2.87:Planning And Essbase Adaptors For Fdm cs

    HFM is a data integration tool only and cannot be used to load metadata.

    For metadata you can use HAL (if you still have it) or DIM or Oracle are now pushing towards ODI.
    HAL, DIM and ODI all have a Planning adapter (for metadata) and an Essbase adapter.

    Hope this helps.
    Seb
    www.capiotech.com

  • RELEVANCY SCORE 2.87

    DB:2.87:Fdm Security Question 9a


    Does anyone know if you need FDM access in order to use the (FDM) Drill-back functionality in HFM, Essbase, or Planning? I am trying to figure out licensing requirements.

    DB:2.87:Fdm Security Question 9a

    Thanks for the reply. Do you know what access has to be set up in FDM?

  • RELEVANCY SCORE 2.87

    DB:2.87:Fdm And Essbase a7


    Does anyone know what tasks are involved with setting up Essbase 9.3.0 as a target system in FDM? We are currently using FDM to load HFM. Do we need to download additional FDM adapters or other software?

    Also, does FDM have the capability of pulling data directly from an Oracle database using SQL statements. If so, do we need to download additional FDM adapters or other software?

    Thanks in advance for your help.

    DB:2.87:Fdm And Essbase a7

    Attend FDM training.

    You would need to get an adapter and install it. You would probably want a new FDM app just to load essbase.

    Look into integration. This is the part of FDM that is built to directly query tables in databases.

  • RELEVANCY SCORE 2.86

    DB:2.86:Error: File Not Found: Esbapin 38


    Hi,

    while testing the essbase adapter from fdm , we are getting the below error.. fdm runs on windows and essbase servers runs on unix.

    Error: File not found: esbapin
    At Line: 128
    Detail: InnerException1: File not found: esbapin
    At Line: 128

    hyperion 11.1.1.3. adapter used : ES11x-G4-E.xml

    please advise.

    thanks,

  • RELEVANCY SCORE 2.86

    DB:2.86:Data Load Transaction Aborted With Error [1130203] Unexpected Essbase Error dm


    Data Load Transaction Aborted With Error [1130203]
    Unexpected Essbase error 1003050

    While trying to load data into essbase I am getting the above error. I tried to run it via FDQM which showed the same error. Thinking there might be something wrong with FDM, I tried the load data from EAS and I get this error. Can anyone help me shed some light on how I can overcome this?

    Thanks,

    Shehzad

    DB:2.86:Data Load Transaction Aborted With Error [1130203] Unexpected Essbase Error dm

    Hi Vasavya,

    The outline is not locked. I have checked this.
    Members in the data load all exist.
    There is a space in the member name but the same outline and data load works in my DEV environment
    There is not space in the file path
    I have loaded the same file in DEV to ensure there is nothing wrong with the data.

    ESSBASE.log:

    [Mon Jun 04 00:29:42 2012]Local/ESSBASE0///6936/Info(1051160)
    Received Validate Login Session request

    [Mon Jun 04 00:29:42 2012]Local/ESSBASE0///7020/Info(1051001)
    Received client request: Get Server Locale Description (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:42 2012]Local/ESSBASE0///10100/Info(1051001)
    Received client request: Get Allowed Storage Types (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:43 2012]Local/ESSBASE0///8460/Info(1051001)
    Received client request: Get Extended Application Info (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:46 2012]Local/ESSBASE0///7548/Info(1051001)
    Received client request: MaxL: Execute (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:46 2012]Local/ESSBASE0///6936/Info(1051001)
    Received client request: MaxL: Describe (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:46 2012]Local/ESSBASE0///6936/Info(1243002)
    Output columns described

    [Mon Jun 04 00:29:46 2012]Local/ESSBASE0///7020/Info(1051001)
    Received client request: MaxL: Define (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:46 2012]Local/ESSBASE0///7020/Info(1051001)
    Received client request: MaxL: Fetch (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:46 2012]Local/ESSBASE0///10100/Info(1051001)
    Received client request: List Objects (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///8460/Info(1051001)
    Received client request: List Objects (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///7548/Info(1051001)
    Received client request: MaxL: Execute (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///6936/Info(1051001)
    Received client request: MaxL: Describe (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///6936/Info(1243002)
    Output columns described

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///7020/Info(1051001)
    Received client request: MaxL: Define (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///7020/Info(1051001)
    Received client request: MaxL: Fetch (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///7020/Info(1243003)
    Record(s) fetched

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///10100/Info(1051001)
    Received client request: MaxL: Fetch (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///10100/Info(1243003)
    Record(s) fetched

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///8460/Info(1051001)
    Received client request: MaxL: Fetch (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///8460/Info(1243003)
    Record(s) fetched

    [Mon Jun 04 00:29:47 2012]Local/ESSBASE0///7548/Info(1051001)
    Received client request: MaxL: Fetch (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:49 2012]Local/ESSBASE0///6936/Info(1051160)
    Received Validate Login Session request

    [Mon Jun 04 00:29:49 2012]Local/ESSBASE0///7020/Info(1051001)
    Received client request: Get Database Info (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:52 2012]Local/ESSBASE0///10100/Info(1051001)
    Received client request: List Objects (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:52 2012]Local/ESSBASE0///8460/Info(1051001)
    Received client request: List Objects (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:52 2012]Local/ESSBASE0///7548/Info(1051001)
    Received client request: List Objects (from user [shehzad@Native Directory])

    [Mon Jun 04 00:29:52 2012]Local/ESSBASE0///6936/Info(1051001)
    Received client request: List Objects (from user [shehzad@Native Directory])

    [Mon Jun 04 00:30:05 2012]Local/ESSBASE0///7020/Info(1051001)
    Received client request: MaxL: Execute (from user [shehzad@Native Directory])

    [Mon Jun 04 00:30:05 2012]Local/ESSBASE0///7020/Info(1051009)
    Setting application APPNAME active for user [shehzad@Native Directory]

    ESSBASE_ODL.log:

    [2012-06-04T00:29:42.726-07:29] [ESSBASE0] [AGENT-1160] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:6936] Received Validate Login Session request
    [2012-06-04T00:29:42.726-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7020] Received client request: Get Server Locale Description (from user [shehzad@Native Directory])
    [2012-06-04T00:29:42.726-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:10100] Received client request: Get Allowed Storage Types (from user [shehzad@Native Directory])
    [2012-06-04T00:29:43.648-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:8460] Received client request: Get Extended Application Info (from user [shehzad@Native Directory])
    [2012-06-04T00:29:43.648-07:29] [ESSBASE0] [NET-16] [ERROR] [16][] [ecid:1338095042299,0] [tid:8460] RegEnumValue() Failed
    [2012-06-04T00:29:43.648-07:29] [ESSBASE0] [NET-16] [ERROR] [16][] [ecid:1338095042299,0] [tid:8460] RegEnumValue() Failed
    [2012-06-04T00:29:43.648-07:29] [ESSBASE0] [NET-16] [ERROR] [16][] [ecid:1338095042299,0] [tid:8460] RegEnumValue() Failed
    [2012-06-04T00:29:43.648-07:29] [ESSBASE0] [NET-16] [ERROR] [16][] [ecid:1338095042299,0] [tid:8460] RegEnumValue() Failed
    [2012-06-04T00:29:43.648-07:29] [ESSBASE0] [NET-16] [ERROR] [16][] [ecid:1338095042299,0] [tid:8460] RegEnumValue() Failed
    [2012-06-04T00:29:43.648-07:29] [ESSBASE0] [NET-16] [ERROR] [16][] [ecid:1338095042299,0] [tid:8460] RegEnumValue() Failed
    [2012-06-04T00:29:43.648-07:29] [ESSBASE0] [NET-16] [ERROR] [16][] [ecid:1338095042299,0] [tid:8460] RegEnumValue() Failed
    [2012-06-04T00:29:43.648-07:29] [ESSBASE0] [NET-16] [ERROR] [16][] [ecid:1338095042299,0] [tid:8460] RegEnumValue() Failed
    [2012-06-04T00:29:43.648-07:29] [ESSBASE0] [NET-16] [ERROR] [16][] [ecid:1338095042299,0] [tid:8460] RegEnumValue() Failed
    [2012-06-04T00:29:46.975-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7548] Received client request: MaxL: Execute (from user [shehzad@Native Directory])
    [2012-06-04T00:29:46.975-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:6936] Received client request: MaxL: Describe (from user [shehzad@Native Directory])
    [2012-06-04T00:29:46.975-07:29] [ESSBASE0] [MLEXEC-2] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:6936] Output columns described
    [2012-06-04T00:29:46.975-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7020] Received client request: MaxL: Define (from user [shehzad@Native Directory])
    [2012-06-04T00:29:46.975-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7020] Received client request: MaxL: Fetch (from user [shehzad@Native Directory])
    [2012-06-04T00:29:46.991-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:10100] Received client request: List Objects (from user [shehzad@Native Directory])
    [2012-06-04T00:29:47.6-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:8460] Received client request: List Objects (from user [shehzad@Native Directory])
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7548] Received client request: MaxL: Execute (from user [shehzad@Native Directory])
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:6936] Received client request: MaxL: Describe (from user [shehzad@Native Directory])
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [MLEXEC-2] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:6936] Output columns described
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7020] Received client request: MaxL: Define (from user [shehzad@Native Directory])
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7020] Received client request: MaxL: Fetch (from user [shehzad@Native Directory])
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [MLEXEC-3] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7020] Record(s) fetched
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:10100] Received client request: MaxL: Fetch (from user [shehzad@Native Directory])
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [MLEXEC-3] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:10100] Record(s) fetched
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:8460] Received client request: MaxL: Fetch (from user [shehzad@Native Directory])
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [MLEXEC-3] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:8460] Record(s) fetched
    [2012-06-04T00:29:47.22-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7548] Received client request: MaxL: Fetch (from user [shehzad@Native Directory])
    [2012-06-04T00:29:49.630-07:29] [ESSBASE0] [AGENT-1160] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:6936] Received Validate Login Session request
    [2012-06-04T00:29:49.630-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7020] Received client request: Get Database Info (from user [shehzad@Native Directory])
    [2012-06-04T00:29:52.661-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:10100] Received client request: List Objects (from user [shehzad@Native Directory])
    [2012-06-04T00:29:52.676-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:8460] Received client request: List Objects (from user [shehzad@Native Directory])
    [2012-06-04T00:29:52.676-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7548] Received client request: List Objects (from user [shehzad@Native Directory])
    [2012-06-04T00:29:52.707-07:29] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:6936] Received client request: List Objects (from user [shehzad@Native Directory])
    [2012-06-04T00:30:05.906-07:30] [ESSBASE0] [AGENT-1001] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7020] Received client request: MaxL: Execute (from user [shehzad@Native Directory])
    [2012-06-04T00:30:05.906-07:30] [ESSBASE0] [AGENT-1009] [NOTIFICATION] [16][] [ecid:1338095042299,0] [tid:7020] Setting application APPNAME active for user [shehzad@Native Directory]

  • RELEVANCY SCORE 2.86

    DB:2.86:Unknown Member Name ["Explicit"] In Function [@Idescendants] d7


    Hi,

    V11.1.2

    I am trying to export data to essbase from fdm. I have got a data file to import and validate. However, when I do an export I receive the following error

    Data Clear Error
    Calc Script Failed.
    Code=10410
    Description=Essbase API Procedure: [EsbCalc] Threw code: 1200497 - 1200497 - [Tue Mar 01 10:19:59 2011]server/appname/databasename/nathan.goodearl/Error(1200497)

    Error parsing formula for [FIX STATEMENT] (line 1): unknown member name ["Explicit"] in function [@IDESCENDANTS]

    I have exported the data load and there is a single data entry which shows each dimension and the amount aggregated. From the error is appears it is trying to load this one line instead of the level zero data. I am fairly new to FDM so the way to data is presented might be correct....either way the data isn't being loaded to Essbase.

    Thanks,

    Nathan

    Edited by: NathanG on 01-Mar-2011 03:27

    DB:2.86:Unknown Member Name ["Explicit"] In Function [@Idescendants] d7

    HI Guys,Am facing same issue can any body please give any solution.Any body from got solution for above issue please share with us.Thanks,SM

  • RELEVANCY SCORE 2.86

    DB:2.86:Fdm 7f


    how to load the .txt or excle files into planning application or essbase application through FDM.
    pls provide me any steps....

    DB:2.86:Fdm 7f

    Please use .csv or .txt file and use 'comma' type in Import format.Assign this import format to specific location and then import the data.
    Also ensure you have connected target adpater of essbase/planning.

  • RELEVANCY SCORE 2.86

    DB:2.86:Stat Data Load Using Fdm fs


    Hi,

    I have a requirement where statistical data is to be loaded to essbase using FDM. Below are few issues that I am facing.

    1) Is it possible to import only the first record when data is not unique? Any pointers to script would help.
    2) Can the format for amount dimension be changed? I am looking to remove comma separator for the amount.

    Thanks in advance.

    DB:2.86:Stat Data Load Using Fdm fs

    Thank you very much.

    I have a start point to work on now.

  • RELEVANCY SCORE 2.86

    DB:2.86:File To Erpi To Fdm In 11.1.2.2 md


    HI All,Can we work for ERPI Like this File (txt)source - ERPI - FDM - ESSBASE(target)if the above scenario works do i need to create any Data server and Physical schema for FDM in Topology -Physical Architecture-Technologiesin ODI 11.1.1.6 i had not found any FDM in Topology -Physical Architecture-Technologies what is the process i need to do if i want to load data from FILE - ERPI - FDM -ESSBASEThanks,

    DB:2.86:File To Erpi To Fdm In 11.1.2.2 md

    In 11.1.2.2 if you are just using a flat file source, there is not a reason to use ERPi if you are using FDM. You can just create a flat file source import format in FDM and import the source and then create the proper mapping in FDM and use the proper target system adapter to export and load to your target system.

  • RELEVANCY SCORE 2.86

    DB:2.86:Do A Dimbuild Before A Dataload - All From Fdm 38


    greetings,

    We are currently doing data loads using FDM. The issue arises when there are new accounts in the data file. The load will fail and we have to manually add them to the database, then re-run the load.

    Is there a way to perform a dim build where for each new members of that dimension, I can have FDM add it to a specific hierarchy within the dimension? Thus if member ABC is new and not yet in the database, the dimbuild will add it to the database, then once done, do a dataload.

    I cannot simply use the Essbase dim build functionatlity because the specific dimension I need to do this against contains some mapping within FDM...

    We're on 11.1.1.4

    Many thanks.

    DB:2.86:Do A Dimbuild Before A Dataload - All From Fdm 38

    thank you all for your help. I was able to do a dimbuild as the mapping is straighforward (ie 1 to 1 mapping). The day will come when I'll have to deal with the type of mappings where I'll have many to one... I'll deal with that when time comes.

    Again thank you for all of your help.

  • RELEVANCY SCORE 2.86

    DB:2.86:Unable To Map To Ignore Member For Essbase xd


    I have an FDM application, created in 9.3.1, which has Essbase as the target. I am able to map to leaf members, but unable to map to 'Ignore'. I get the following:
    Error: Error updating record.
    Detail: An invalid value was entered for the dimension (Entity)

    The 'Ignore Map Item' in Application Settings is set to "Ignore."

    Does anyone have any idea why this does not work? I've used targets of HFM and Essbase in the past without issue.

    Thank you for your help,

    DB:2.86:Unable To Map To Ignore Member For Essbase xd

    The best way to handle this is while in the Mapping Tables, Doubl-click the Target Account (or target dimension member) field, place your mouse over the little sideways triangle and click "Browse For Target Value". If you can locate the "Ignore" in the member list then select and click the Update Grid but if you do not see the value then the Essbase metadata will have to be updated to include it.

  • RELEVANCY SCORE 2.85

    DB:2.85:What Is Fdm Used For??? 1z


    Hi

    I have worked on Essbase,DIM,HFR,IR,WA,Planning.ODI...

    I am new to HFM FDM. i am trying to learn FDM . I have been reading FDM_admin..................but it left me confused,,............................

    1.What is the function of FDM????

    2. IS it like DIM,ODI to load members data into HFM...

    3. is FDM used with essbase,planning??

    Appreciate ur response

    DB:2.85:What Is Fdm Used For??? 1z

    We use FDM to load our GL files and map GL information into HFM.

    In FDM you can set up maps for accounts, entities, ICP, and Custom dimensions.

    For example if you have a GL acount of 123456 that belongs to HFM account 100000 you can set up the map to do that. Maps can be "explicit" like the example, or "between", or "like", or "In".

    The nice thing about FDM is that you can load files in many different formats (csv, comma delimited, semi colon delimited, and many more).

    You can import, validate, and export in FDM.
    Import - Allows you to import the file into FDM (Import Formats for the file must be set up first).
    Validate - validates the mapping.
    Export - Export the information into the applicaton (in our case HFM, but it can go other places (Essbase) depending on your set up).

    I am pretty sure FDM is used with Essbase but I am not sure about planning. We currently do not use Essbase and Planning.

    Hope this helps.

  • RELEVANCY SCORE 2.85

    DB:2.85:Fdm 11.1.2.3 Error While Exporting kd


    Helloi am using FDM 11.1.2.3. when i load data in essbase my import, validation, are succeeded but when i am try to execute the essbase script from FDM is failed.Tokenizing calc: Script Error accessing calc script file '\\Servername\hyphome\App\DB-Name\Script.csc' Error -2147023570 - Path is correct and we are able to access the the script remotely.Thanks

    DB:2.85:Fdm 11.1.2.3 Error While Exporting kd

    Problem is that- user are not able to access the following calc script.I found the solution and resolved it.i mapped the following path into my FDM server and provide the username name and password in FDM script.

  • RELEVANCY SCORE 2.85

    DB:2.85:Fdm To Load Data In Essbase Aso Cube kc


    Anybody have used FDM to load data in Essbase ASO cube? How do you clear and run calc on ASO cube?

    Thanks

    DB:2.85:Fdm To Load Data In Essbase Aso Cube kc

    Thank you for the correction Tony.

    Just to clarify something that's clearly over clarified. :)

    ERPI does support a target ASO Essbase application providing that the metadata/data is loading directly to Essbase either via the classic or EPMA method.
    As FDM doesn't currently support ASO it is not possible to load the data from ERPI via FDM to an ASO Essbase application.

    Cheers,
    David