HI All, Thanks for suggestions. I have taken correct home path. Now i am getting different error. Kindly check below error and please help on this. $ /test/oraclebi/mwh/Oracle_BI1/jdk/bin/java -jar /ood_repository/test1/bi-migration-tool.jar out /test/oraclebi/mwh/Oracle_BI1 /test/admin/user_projects/domains/bi_test3…

Hi , Week file data have (weeks, weekend date, month, year, countries, sales, stocks). using odi week file data loaded into database we have weekly data in database. it is not stored in day wise data. Thanks to every one, you people are helping a lot to me we have historical data in data base. 2000 to 2017 years data. If…

Hi , week is dimension, sales data is measure. we have historical data in data base. 2000 to 2017 years data. If year is leap year then no problem we wil dispaly 53 weeks . every year is not a leap year. we are facing issue with non leap years. that is why i am trying hide 53 column for non leap year. Thanks, Kavya.

Hi Sir, Apology for this, customer wants to see all 53 weeks sales data in report (for example year =2000). so that we created 53 columns in report. Now year 2017, upto 52 weeks data should be display in report. 53 week column should be hide dynamically. In future, if year= 2020 then 53week columns should be display…

Hi, if apply your logic, it wil display either 53 or 52 week. It wont hide entire column. In my report 53 columns in report ( week data display in 53 columns) . in every column , some logic applied. week column:filter (sales measure) using week=1.. , week2 column formula: filter (sales measure) using week=2. :: .and week…

Hi Martin, Thanks Martin ..data should be store in mintues. As you I have tried. but problem is total sum duration is incorrect. Finally I have applied custom format in column properties in obiee report as follwing below. [duration(min)][opt:dd]mm:ss. Now our data is coming correct in obiee report as per time based…

Hi Martin, In database , fact.hour_assigned_actual column data is looks like as following below. how to convert above data into h:mm and how to calculate the sum the h:mm values based on time analysis. 0.60 (h:mm) means 1 hour. how it is possible in obiee report. can you please explain briefly. Please give idea and tell me…