Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 212 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI Expression not working
Answers
-
Hello, after applying the sql above, I'm still extracting the same values.
(with Payroll Time Type Column)
(without the Payroll Time Type Column)
0 -
Hello,
Please see screenshot below.
The expectation for this OTBI report is to extract the reported hours of employees with these conditions.- If employee did not work on a holiday, it should return 'PH'; - this should be tagged 'PH' as this employee did not work on Public Holiday, please see row number 2
- If employee worked on a holiday, it should return the number of reported hours; - this condition is already met via row number 1
0 -
What aggregation type have you selected for Hours?
0 -
Hello, I didn't add any aggregrate functions. I've only used the sql you provided in the hours column
0 -
Can you please see the data in a table view instead of Pivot Table and send us a screenshot. Actually any measure that you are using in pivot view need to have a specific aggregation.
If possible attach your report catalog or xml here.
Cheers,
0 -
Hi Bhaskar,
Please see the attached catalog for your reference.
Thank you.0 -
youve still not provided your desire output. put the table in excel and show how you want it to be in the report
0 -
Hello, please see the screenshot below. Thanks
0 -
The pivot table should aggregate the data.
So you should just have 2 rows for public hol and. regular - but you are getting multiple rows so its not aggregating.
Just put payroll type in the row, date in the col, hours as the meaure - then check the aggregation of the hours - click on the cog - try setting it to sum.
The 1st part is to get the pviot table correct with 2 rows, showing all data needed in the calc, then can work out the case statement.
here's my simple example:Data in pivot
Case statement - if standby, set to PH
case when "Reported Time Entry Details"."Payroll Time Type Name" = 'TL Standby' then 'PH' else cast("Reported Time Cards"."Reported Hours" as char) end
Results
0 -
Can you set the aggregation rule as per the below screenshot for the pivot table? select 'Max' instead of 'Default'.
Can you also check your data in 'Table' View with the latest formula that I provided.
0
