Home3

Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Home2

Home

Monday, March 28, 2016

Getting error SMTPSendFailedException: 530 authentication required when i am trying to send odi logs to mail in odi 11g??

In this post, it discussed about how to send daily status of odi log error / success status to mail.. Everyday wants to get mail from odi , we have to schedule the jobs.
To refer this, following link help for you

https://community.oracle.com/thread/3877296


How to use global variable in target table in odi 11g ?

In this post, it discussed about how to find filenames. Iam trying load multiple files into single interface. 92 files data loaded to single interface.for this i have used varaibles , packages.. My requirement is ,92 files data loaded to target table. Iwant to know which data is coming from which file..To find this, I find this, i have used global variable..
To see, remaining content please follow the below link

How to load all error logs into one single file in odi 11g?


In this post, it discussed about 'If i get errors, after execution of any interface/ package/ procedure in odi 11g,how to load operator navigator logs into single file. To resolve this
 please follow the below link
This link help for you.

While loading lacks of data into target table, odi performance is degrading?

In this post, i have discussed on 
" load data from source(Oracle DB1) to target table(Oracle DB2) in same server
Source table have 45lacks of data. this data have to be load into target table.
I have create interface. i have taken LKM SQL to SQL & IKM SQL to SQL  incremental append knowledge modules i used.. after 24 hours, i have checked status in operator navigator. "its showing status like  loading"
still , interface is in loading status.some times odi is not responded. For this I used different knowledge modules.. "
To see solution for this, Go through this link.

Table rows count is not updated in rpd obiee 11.1.1.9?

In this post, it discussed about Table rows count is not updated in rpd administration in obiee 11.1.1.9.
To resolve this, following link help for you

https://community.oracle.com/thread/3826550

Unable to view the data of Journalized Table in cdc-consistent and cdc simple in odi 11g?

In this post, i have discussed  about "Source table have 1000 rows data.. this data loaded into target table. now target table have1000 rows data. Every six months,
If add 2000 rows to existing source table.. Then newly added or changed data  only  loaded into target table in odi 11g.. then 2000 rows have to load to target table
(now source table have 3000 rows).. recent data only added to target table..
To resolve this, use the following links . It may help for you

https://community.oracle.com/thread/3782432
https://community.oracle.com/thread/3782453
https://community.oracle.com/thread/3784877

Pivot rows converted into columns in odi 11g?

In this post, i have changed rows to columns in odi 11g.
To see, remaining content please follow the below link.

 https://community.oracle.com/thread/3785613

Unable to get the updated rows in scd type3 in odi 11g ?

Flag value is not changing after update the column in SCD TYPE1 odi 11g

How to supress the rows of calculated item & add custom rows into middle of the rows in obiee11g analytics

Odiconsole error Unable to connect to the specified repository. Please select a different alias and try again.

Update schedule is not working in agents in odi 11g?

In this post, explain about "i have generated scenario in odi 11g for scheduling purpose. if i schedule the job, everyday automatically exceute the job". some times scheduling is not running.. agents are not working.." To reslove this..Pls follow this link

https://community.oracle.com/thread/3777189


Agent is not defined in the topology for master repository in odi 11g ?

In this post, an issue about ' agent is created in topology.. Eventhouh agent is not defined in topology in odi 11g?..

https://community.oracle.com/thread/3776644




Unable to see odi 11g projects, interfaces in odi console 11g?

In this post, it discussed about "Connect to odi console web page. we will see the staus of interfcaes, packages, procedures in odi client tool".. To configure odi console.. Please follow below link



Getting error while inserting data from source to target in procedures in odi 11g?

In this post, it discussed about "Using select statement, load data from source to target table in odi 11g".. To read content more.. Please refer this link..

https://community.oracle.com/thread/3774597

Getting error when load the data from oracle table to text file using odisqlunload tool in procedures?


In this post, it discussed about "load the oracle db table data to flat file in odi 11g".
To read this content.. use the following link.

https://community.oracle.com/thread/3771627



is it possible the manually data uploaded for creating report anywhere?

In this post, it discussed about I want to upload the excel data manually in india...
From US,Another person want to create reports using whatever i have upload data.in obiee 11g
To see remaining content.. Follow the blow link


Canot update scheduling, agent may not be running in odi 11g?

When update the scheduling jobs, some times agnet not working .To resolve this issue, please refer this link.. it will help for you.

https://community.oracle.com/thread/3755012

Column headings dynamically change selection based on date filter in obiee 11g analytics?

In this post, it discussed about  obiee 11g analytics.
i my report five coulmns.. those are branch, district, lcy, current year, previous year..
based on section on dtae filter , column headings will change dynamically.
column headings are current year, previous year;
current month , previous month ;  
current week, previous week.
for example, if i select year 2016,
column headings are branch, district, lcy, 2016, 2015 will change dynamically in the analytics report...
To read this remaining content .Use this link.. i hope this link help for you

ODI-15037: The interface Flat File has fatal errors.

In this post, it discussed about "load the data from ODI-15037: The interface Flat File has fatal errors." To solve this issue, please refer this link.. it may help for you




Friday, March 25, 2016

Automation of Loading excel file in ODI 11g?



In this post, It discussed about on automation of loading excel file in odi 11g..I am trying to load excel file into table by creating a DSN for the file and using this DSN name into my Excel topology data server.now my file name is changing on monthly basis and for that again i have to create a new DSN and then again reverse engineer the file. can anybody suggest me how to automate this process of loading excel data into table using Microsoft Excel Technology in ODI 11g.
To see solution for this, follow the below link..

https://community.oracle.com/thread/3869731?tstart=0