Donu00B4t load duplicates File to a cube through DTP

10-11  Source: Network gathering  Views:0 

Advertisement
Hi gurus... i want to know if is possible to avoid load the same data from files to a cube.. doing this trough a DTP.
I think to do this with a step in a process chain that eliminate dupplicates entry in the cube, but the problem is that i haven´t any selection in DTP... this is a full load.
Regards..
Neo,
do you want to avoid loading duplicate files to a cube using  DTP or avoid loading duplicates from the file to the cube ?
if it is avoid loading duplicate records from file to cube - then ideally you can use a DSo in between...
Related articles
  • Donu00B4t load duplicates File to a cube through DTP 10-11

    Hi gurus... i want to know if is possible to avoid load the same data from files to a cube.. doing this trough a DTP. I think to do this with a step in a process chain that eliminate dupplicates entry in the cube, but the problem is that i haven´t an

  • Job cancelled While loading data from DSO to CUBE using DTP 10-11

    Hi All,   while i am loading data frm DSO to CUBE the job load is getting cancelled. in the job overview i got the following messages     SYST: Date 00/01/0000 not expected.    Job cancelled after system exception ERROR_MESSAGE wt can be the reason f

  • Loading XML File in Oracle Tables through Concurrent Request 10-11

    I am posting a working program which reads an XML File and loads in Oracle database table through Concurrent Request. Input parameter for this program is file name. I have added directory name ASPEN_DIR as /interface/inbound in ALL_DIRECTORIES table.

  • Error 4 when loading flat file for Demo cube 11-30

    Hi gurus I've exported the csv file for 0D_SD_C03 and store it on my local disk. when i try to preview the file using the file that i stored in my local drive , the execution close w/o any error message but during loading it shows no data found. ( i

  • Error while loading data from PSA to Infoobject through DTP(URGENT) 10-11

    Hi- I am running into an issue while loading the data from PSA to Infoobject. It says Data Package 1 : error during processing. Updating Attributes for Infoobject Error in substep Process Terminated Please let me know ur solution as this is very urge

  • Error while loading the data into the cube using DTP. 10-11

    No SID found for the value'UL' of characterstics 0BASE_UOM. Please give me the idea ,to solve the error. Thanks&Regards Syam Prasad Dasarihttps://forums.sdn.sap.com/click.jspa?searchID=23985990&messageID=6733764 https://forums.sdn.sap.com/click.js

  • Unable to load prn file in LedgerLink 10-11

    I am working with HE641 and having to use LedgerLink to load files since there is some account translation. For some reason I am unable to load the file. This is through Citrix. During the load process, the files appears to load because the status ba

  • How to load flat file in existing Architecture. 10-11

    Hi everyone! There is an existing architecture that I have to upload data into.  There is a cube on top, followed below by an ODS and its update rules to the cube, followed below by an Infosource and its corresponding update rule to the ODS above it,

  • Data load through DTP giving Error while calling up FM RSDRI_INFOPROV_READ 11-30

    Hi All We are trying to load data in Cube through DTP from DSO. In the Transformation, we are looking up Infocube data through SAP Standard Function Module 'RSDRI_INFOPROV_READ'. The Problem we are facing is that our loads are getting failed & it is

  • Not fetching the records through DTP 10-11

    Hi Gurus, I am facing a problem while loading the data in to infocube through DTP. I have successfully loaded the data till PSA but not able to load the records into infocube. The request was successfully with status green but able to see only 0 reco

  • Error while loading data on to the cube : Incompatible rule file. 10-11

    Hi, I am trying to load data on to essbase cube from a data file. I have a rule file on the cube already, and I am getting the following error while loading the data. Is there any problem with the rules file? SEVERE: Cannot begin data load. Essbase E

  • How to load date and time from text file to oracle table through sqlloader 10-11

    hi friends i need you to show me what i miss to load date and time from text file to oracle table through sqlloader this is my data in this path (c:\external\my_data.txt) 7369,SMITH,17-NOV-81,09:14:04,CLERK,20 7499,ALLEN,01-MAY-81,17:06:08,SALESMAN,3

  • How to load flat file in BPS through Web-debugging 10-11

    Hi, We are working on flat file upload in BPS thru guide 'How to load flat file in BPS through Web'. Can some one guide on how to debug the function modules used while uploading the data. We have set up the break point in the function modules and als

  • Can I load several files in parallel through one file infopackage? 11-30

    Can I load several files in parallel through file datasource?Hi Alex I am sorry but am not able to understand your requirements completely. If you are using BSP then how come infopackage comes in picture? As through a BSP application you can load the

  • Loading file in Merge Mode through the batch loader in FDM 11-30

    Hi, I have multiple locations loading in replace mode and 1 location loading in merge. We are using the batch loader and following the naming convention specified in the admin guide. Is there a way to specify in the location name to load the file to

  • Duplicate File Handling Issues - Sender File Adapter - SAP PO 7.31 - Single Stack 10-11

    Hi All, We have a requirement to avoid processing of duplicate files. Our system is PI 7.31 Enh. Pack 1 SP 23. I tried using the 'Duplicate File Handling' feature in Sender File Adapter but things are not working out as expected. I processed same fil

  • Issues Missing files & duplicate files and not enough screen space 11-30

    Hello everyone, I'm using a 1.67 Ghz 15 in tibook with 1 gig of ram I had issue yesterday, missing files, I was in the rating/keywords panel scrolling through my images, one was a bit soft so I deleted it using the command delete combo. Somehow all o

  • Insane XML Import, Huge Project, Duplicate file names work around... 10-11

    I planned on kicking off my journey attempting to edit a massive multi year documentary on FCPX with a nice introduction of the blog I'm going to keep about the experience, but I've run into a bit of a roadblock, or maybe major speed bump at least be

  • Infopackage-Load Many Files from Application Server and later Archive/Move 10-11

    Hi All..   I have a doubt,   I have a requirement of take many files to load into BI 7.0..  I used the infopackage before with option: Load Binary File From Application server   I load information successfully... only with one file ...but If I can lo

  • Cannot connect to specific Cube through BI Semantic Model for Power View in SharePoint 2013 10-11

    I'm trying to create a connection to an Analysis Services Cube through a BI Semantic Model connection in SharePoint 2013 to create a Power View report. I'm able to connect to other cubes on the same server, and I have SQL Server 2012 SP1 Update 9 ins