Uderc programming article aggregator sites
Index -> Load Data

Load Data

Advertisement

Loading data one year at a time

Hi, We have a situation where we need to load data one year at a time. I saw this done a few years ago but do not remember the details. What I am thinking is that we could initially run a full load with the following parameters: $$ANALYSIS_START: 1/1

Input ready query is not showing loaded data in the cube

Dear Experts, In Input ready query we have problem that it is not showing the values which was not entered by throught hat query. Is any settings in input ready query that we can do to populate the loaded data on the cube as well as data entered thro

Can we load data using .xls in user define format(without using default template)

Hi All, I'm new bee to FDM. Part of HFM support i use FDM to load flatfile data. Just has a bit more knowledge than end user. Requirement is that i need to load data from MS excel to Planning application via FDM. Previously application is in Excel(Ma

Can we load data in chunks using data pump ?

We are loading data using data pump. So I want to clear my understanding. Please correct me if I am wrong on my understandings - ODI will fetch all data from source (whether it is INIT or CDC ) in one go and unload into staging area. If it is true, w

Can not load data into the ods.

When I was trying to load data into BW3.5 from R3 system, I am getting this message "For InfoSource ZSD_A507_011, there is no Hierarchies for master data in source system R3PCLNT300 "  any idea.  There is no hierarchies for this.Hello Mat, What

Can't load data through smart view (ad hoc analysis)

Hi, There is EPM application where I want to give ability to planners to load data through smart view (ad hoc analysis). In Shared Services there are four options in EssbaseCluster-1: Administrator, Create/Delete Application, Server Access, Provision

Can we load data for all levels in ASO?

Hi All, Im creating cube in ASO can i load data for all levels in ASO we can load data for all Levels In BSO but in ASO i need confirmation???? and one more wat is the consider all levels option in ASO is used for ? wat is the purpose? Can any one he

Can we load data for all levels in ASO cube

Hi All, Can we load data for all levels of members in ASO cube in 9.3.1. RegardsYes you can load data for all levels in an ASO cube in any version HOWEVER, none of the upper level data in any cube will be there when you look for it. You will get a wa

Not able to load data in tables with correct way

Hi i made one trigger to load data in view and tables. CODE FOR TRIGGER>>>> Object Details Code Errors SQL CREATE OR REPLACE TRIGGER "WELL_GENERATOR_TRIGGER_1" INSTEAD OF INSERT ON VIEW_WELL_GENERATOR_FORM FOR EACH ROW DECLARE rowcnt

BI 7.0 data load issue: InfoPackage can only load data to PSA?

BI 7.0 backend extraction gurus, We created a generic datasource on R3 and replicated it to our BI system, created an InfoSource, the Transformation from the datasource to the InfoSource, an ODS, the transformation from the InfoSource to the ODS.  Af

How to View the Loaded Data

Hi, I have loaded the data into an ODS from an External Flat file and executed the job. Can anyone guide me how to view the loaded data in the ODS ? ThanksHi Madhu, You can simply Goto Transaction LISTCUBE and give the ODS name -> Execute. Regards He