Projects - Performance Reporting Real Time

Pooja_123

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.

gclampitt

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

Pooja_123

@gclampitt yes I tried that before but here we are getting 3 different rows. will it be possible to get it in one row.

gclampitt

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:

Pooja_123

@gclampitt No not working for me even I removed the column from table. what next

gclampitt

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

Pooja_123

@gclampitt This is OTBI report not a BIP report for table. we have to pull the data from subject area.

gclampitt

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…

Pooja_123

@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

gclampitt

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?