Here In above report I am trying to print class category column values as a separate column like GP Budget,GP Plan Year and GP Project Category. also want to print the value of column class code in it.
Is It possible in OTBI, please comfirm.
yes plenty examples on here -Just create a CASE statment for each one you want
case when Classcatgory = 'A' then value end
case when Classcatgory = 'B' then value end
@gclampitt yes I tried that before but here we are getting 3 different rows. will it be possible to get it in one row.
Make sure rhe Dimension Class Category isn't in the table, then it will aggregate up and make sure the Aggregation of the measures are set to sum. My simple Example:
@gclampitt No not working for me even I removed the column from table. what next
Start of with a basic table and get it working, then add in the other dimensions one by one….there must be something causing an issue
@gclampitt This is OTBI report not a BIP report for table. we have to pull the data from subject area.
Yes i know - above is for OTBI.
So create a simple otbi report and get it working like my example above, then add the rest of the detail you want one by one…
@gclampitt I used below formula
case when "- Project Classification"."Project Classification Category Name"='GP Budgeted' then "- Project Classification"."Project Classification Name" end
I hope this is correct
so if category is GP Budgeted , return the Classification name. if thats what you want, then yes seems correct Is it giving you what you want?
Where AI meets business outcomes Oracle AI World brings the Oracle community together to explore how AI and other technology innovations are driving real business outcomes across industries. Discover what’s new through: Mainstage keynotes to hear the latest directly from Oracle leadership Product demonstrations Customer…
Our Requisition OTBI analysis is having many values Requisition Number Requisition Title Requisition Status Hiring Manager Full Name Recruiter Full Name am able to see values for all. When am passing Prompt(Hiring Manager Full Name or Recruiter Full Name) am not able to see the data. Am sure we have values/data for passed…
Hi Experts, We are using Oracle BI Publisher Email Bursting to distribute reports via email. Currently, one of our bursting outputs generates a report of approximately 20 MB, and we are trying to understand whether there are any size limitations that could impact email delivery. Scenario: Report Delivery Method: Email…
Team, We have a requirement to select below PVOs HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfileItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ProfilePVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentItemPVO HcmTopModelAnalyticsGlobalAM.ProfileAM_ContentTypePVO Do we have any documentation around these?
We have a requirement of enabling OTBI report in Purchase Requisition Redwood page similar to classic UI.How can that be done?
