Both are 32 bit version. MS word 2010 32 bit, template builder also 32 bit. regards, ram.

Hi, In my scenario, i am using cloud instance so i cannot access the path. I can do archive and un archive. Please let me know the process for this. regards, ram.

Hi Gianni, My apologies for adding one more question to this thread. Initially these two are requirements, but initially, i was unable to achieve week definition so i asked that question. Both are resolved. Thank you so much. Regards, Ram.

Hi, Thanks for the reply. I am working in the same way that you have suggested, it's working fine. I need the date on which max value of volume delivered in that particular week. Scenario: For the year 2017 and January month i have taken. columns are : Year, Month, Volume, date, week. I need to get the max value (volume)…

Hi, It's cloud instance (Oracle FTI instance) and do not have access to RPD. I have to give solution in the report only. Please let me know any other solution. regards, ram.

Hi all, Please let me know any possible solution or any workaround solution is most appreciated. regards, ram

one more thing ...my dashboard prompt as follows if user select 2017 year then in my report, i have to show both selected and previous year(2016) data. regards, ram.

Hi, Please find the difference for the following two scenarios: 1. I have used measure column : shipment count. For 2016: FILTER("- Shipment Facts"."Shipment Count" using("- Shipment Period Dimensions"."Year" in ('2016'))) 2016 query gives only 2016 data. For 2015: FILTER("- Shipment Facts"."Shipment Count" using("-…

Hi, Because of incorporating time series functionality (Current year and previous year). At my report level i put month as "is prompted". User can select year and month so that my report will filter based on user selection. If i select year 2016 and December the result as shown below. Regards, Ram.

hi, how to create calculated column for measures in pivot view? i tried to create calculated column for measure it is saying cannot be created for measures. regards, ram.

obiee version is 11.1.1.7 browser is mozilla firefox.

Hi, All dashboard prompts are page scope in all 5 db pages. regards, ram.

Hi all, Thank you so much for the reply and the solution. I should be very careful while developing. I could not notice about data types, blindly divided and unable to get the result. I will be more focused on while developing. Regards, Ram.

HI, I have done in both column and pivot view (to SUM). regards, Ram.

Hi, OBIEE version is 11.1.1.7 All are measure columns (Numerical values) and set to SUM. Regards, Ram

Hi Pedro, I tried with Hour/minute/second functions. But unable to convert min to hours..I tried 7 min to convert into hours like 7/60. its giving 0 because of date column. I have used the following formula to convert into hours: For eg: Convert 2.88 hours to hh:mm:ss * 2.88 hours can be broken down to 2 hours plus 0.88…

Hi Pedro, The following is the query and it's output....(considered hours and minutes not seconds in the time stamp). Query written: CASE WHEN HOUR("- Shipment Dimensions"."Attribute Date 5") >0 and HOUR("- Shipment Dimensions"."Attribute Date 5") < 8 then (case when minute("- Shipment Dimensions"."Attribute Date 5")>=0…

Hi Pedro, I have tried to include minutes in the above case statement, it become so many case loops. I have to include minutes also. I think this not right approach. I thought to convert time stamp to hours For eg: 9/21/2016 4:07:28 PM --> take 4:07:28 --> Convert to hours -----> 16.1245 hrs I tried to convert but unable…

Hi Pedro, I changed in the following way. CASE WHEN HOUR("- Shipment Dimensions"."Attribute Date 5") > 0 AND HOUR("- Shipment Dimensions"."Attribute Date 5") <= 8 THEN '12AM-8AM' WHEN HOUR("- Shipment Dimensions"."Attribute Date 5") > 16 AND HOUR("- Shipment Dimensions"."Attribute Date 5")<=23 THEN '4PM-12AM' WHEN HOUR("-…

Hi Pedro, The following is the range of hours. 08:01:00 to 16:00:00 (8AM-4PM) 16:01:00 to 00:00:00 (4PM-12AM) 00:01:00 to 08:00:00 (12AM-8AM) Regards, Ram.