Categories
Projects - Performance Reporting Real Time
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.
Answers
-
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
0 -
@gclampitt yes I tried that before but here we are getting 3 different rows. will it be possible to get it in one row.
0 -
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:
0 -
@gclampitt No not working for me even I removed the column from table. what next
0 -
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
0 -
@gclampitt This is OTBI report not a BIP report for table. we have to pull the data from subject area.
0 -
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…
1 -
@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
0 -
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?0
