Significance of TDATASEG, TDATASEG_T, and TDATAMAP

TDATASEG table stores the actual data. However TDATASEG_T tables are the staging tables that holds the data until successful data execution and then data will get copied to TDATASEG table
The TDATASEG table is used to store the data loaded by the user, and the transformation between the source dimension members and results of the mapping process.

Only in a successful data rule execution data transformations stored in TDATASEG_T be copied over to TDATASEG.

TDATASEG_T Temporary data table used for transforming data from source to target in a data rule execution.

To ensure read consistency, data is extracted from the corresponding staging table (for example, AIF_EBS_GL_BALANCES_STG, AIF_EBS_GL_DAILY_BAL_STG, or AIF_PS_LEDGER) and copied to TDATASEG_T (partitioned by LOADID), which is then used for transforming source data to target data based on the data mappings specified in TDATAMAP_T.

TDATASEGW Temporary data table used for transforming write-back data from source to target in a write-back rule execution.

Writeback data is extracted from the temporary staging table (AIF_WRITEBACK_ESS_DATA_T) and copied over to TDATASEGW (partitioned by LOADID), which is then used for transforming source data to target data based on the data mappings specified in TDATAMAP_T.

If you have selected to only “Import from Source,” you can query this table by LOADID to view the data transformations that were applied during the write-back rule execution.

TDATASEG Audit table describing the data transformations in a data rule execution.
Only in a successful data rule execution data transformations stored in TDATASEG_T be copied over to TDATASEG.

FDMEE vs SAP HANA, S/4HANA and HANA Cloud

I would like to share some information regarding FDMEE integration with SAP HANA, S/4HANA and HANA Cloud – General Guidelines


In cloud Data management SAP HANA, S/4HANA and HANA Cloud it is not supported.

     In FDMEE we can connect to SAP HANA, S/4HANA and HANA Cloud using UDA.

• The UDA feature allows you to register a table or view in on-premises FDMEE, and you must select one of the technologies in ODI as the basis for the table or view. 
• So for on-premises SAP this should work for the UDA, but not for cloud. 
• For cloud, you will need to connect to the SAP cloud instance via one of their APIs which you should be able to call from the cloud.

Is there any other method in FDMEE other than using UDA to connect  to SAP HANA, S/4HANA and HANA Cloud ?

• UDA does not connect to the cloud, but you can connect to a cloud instance by calling the SAP API from a script in FDMEE.

     
Can we push data directly into EPBCS Cloud from SAP HANA / SAP HANA Cloud. Is it possible to achieve this using REST API’s?

• You will need to call the SAP API and then the EPM REST API/EPM Automate for this. 
• You can choose any tool you want to orchestrate the APIs

Regarding the integration there is a Blog which explains the Integration which includes the setup made in ODI and FDMEE

https://fisingmania23.blogspot.com/2017/05/universal-data-adapter-for-sap-hana.html


With on-premise FDMEE, we should be able to call an API on the SAP side to pull the data we need.
  

Here are a number of useful links from SAP

•  https://www.sap.com/developer/topics/api.html
•  https://api.sap.com/package/SAPS4HANACloud?section=Artifacts
   
• In the list of APIs, the following looks like it gives you the trial balance for a ledger:  https://api.sap.com/api/C_TRIALBALANCE_CDS/resource

To do this, the customer will need an SAP resource that knows how to call the required API, and the API that will provide what we are looking for.

EPM cloud new feature in FCCS / PBCS "Data Export to File" - June monthly update

Data Export to File

The Data Export to File option in Data Management enables you to export data from an EPM application to a data file. You can use the data file to load data into an ERP application or an external system. The new Data Export to File option provides several enhancements over the existing Custom Application option and will provide performance improvement when using the Simple workflow mode option.

Both the Data Export to File option and custom target application options are supported in this release.  Eventually, the Data Export to File option will supersede the custom target application option due to its enhanced functions and capabilities.

Starting with this release, you can migrate your existing custom target applications to Data Export to File application using a new Upgrade Custom Application script.  The new script is available under the System Maintenance and it can be run for an individual or all scripts.

You will find this option in FCCS / PBCS > Navigate > Data Management > Setup > Target Application > Add > Local > Data Export to file






To know more about the functionality kindly refer below link

• Administering Data Management for Oracle Enterprise Performance Management Cloud
• Creating a Data Export File
• Upgrade Custom Applications