Thanks a lot Thomas for your help!! I am troubling the system team to build this in the RPD for us it will be great if you can just send some formula or snap using the aggregate at function , or can you just send some basic formula to calculate sum?

Hi Thomas, I am using prem OBIEE but have no access to RPD

Hi Thomas, I literally didn't understood how to use aggregate function to resolve my issue my metric now is : candidate counts. # apps and i am trying to create sum(candidate counts. # apps) but getting very weird values i have around six columns in my reporting grid

so using this approach? how will my formula be? do i need to include all my dimensions in the report ?

hey, can't we create the same in OBI web? i don't have access to it? Also, i was working on another metric and was able to create that reason being , the values appearing were like this Column Hires Total A 10 10 B 20 200 C 20 200 etc. so i created my sum metric and then divided by the orignal metric and getting correct…

Hi Thomas, How to create that level based measure? i am new to OBI so little confused

Hi Thomas, SQL is exactly the same Below are sql , for first i am getting values whereas for second no data Saw the SQL from advanced tab in analysis WHERE (cast("Start Date"."Start Date" as date) = date '2006-08-01') WHERE (cast("Start Date"."Start Date"as date) = date '2009-05-15') One thing which i observed now, i tried…

Hi Kavya, Were you able to resolve your issue. I am facing similar issues in of my reports

Hi Andrew, I am seeing that it only gets correct results if the value is top , i mean the top value. there is not even second value which is getting correct results

it doesn't have time part which i have validated. worst case is i have no idea who the backed team is and alsothe admins know. i thought i'll raise a case with obiee

I am able to see correct data for first query but for second it says no data returned and check filter conditions i don't have access to backed or admin too

Hi Andrew, SQL is exactly the same Below are sql , for first i am getting values whereas for second no data Saw the SQL from advanced tab in analysis WHERE (cast("Start Date"."Start Date" as date) = date '2006-08-01') WHERE (cast("Start Date"."Start Date"as date) = date '2009-05-15')

Dude thanks a lottt for your help thnx

if possible can u share the code, i jsut want the basics u can share the code in a simple way if you worry about data nd all will be really helpful Andrew

Looks like there isn't any direct solution to it

haha is it possible in dashboard?

Hi Andrew, I was able to fulfill that need but now they have asked us to modify the need eg: candiate name abc fname lname age city abc asd 10 NYC job startdate enddate test today tomorrow candidate name bcd fname lname age city job startdate enddate test2 yesterday tomorrow Basically instead of displaying just one table…

yessss exactly this