Category "business-intelligence"

OBIEE Custom format - changing a column data format with varchar datatype

In Oracle BI Admin Tool we can use REPLACE function in a measure to change a column data format(varchar as datatype) and then use it in report. But I need to do

OBIEE getting the latest dimension column value based on time

Say that I have an analysis with the columns Month, Difficulty, and Score. The report has a filter Month = August, but the column Difficulty changes within the

SSIS ERROR: The attempt to add a row to the Data Flow task buffer failed with error code 0xC0047020

I have problems with SSIS process(acctually the same problem occurs for two different processes). So, we are doing some ETL work using SSIS. We have Business In

SSIS loading data error

I have a CSV file which contains this data: EmployeeCode,EmployeeName,EmployeeSalary,Date 101,raju,1000,2/2/2003 102,krish,100,3/4/2005 103,rishbh,320,12/9/200