Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Business Intelligence Foundation
Business Intelligence Suite Enterprise Edition
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Feb 22, 2013 12:18 AM by
Grant Total Issue in OBIEE
Feb 20, 2013 7:13 PM
I have am having issue in grant total for Overall vacancy rate, I did modified my instanceconfig.xml file with report aggregate enabled, calculated cloumns from rpd, still not working any feedback for me get the right total?
Org Job Requisitions Open Associate Headcount Contingent Worker Headcount Total Headcount Overall Vacancy Rate
AHMSC 11 940 212 1,152 0.95%
ALMOB 151 2 300 302 33.33%
FLPEN 387 19,512 848 20,360 1.87%
NYBIN 119 10,068 1,876 11,944 0.99%
TNNAS 344 2 4,136 4,138 7.68%
TXWAC 117 9,608 1,612 11,220 1.03%
Grand Total 1,129 40,132 8,984 49,116 11.16%
This content has been marked as final.
Show 1 reply
Re: Grant Total Issue in OBIEE
Feb 22, 2013 12:18 AM
in response to
Are you looking for 45.8% in Grand Total view. Try to give Aggregation Rule as Sum instead of default in edit view, and try once.
Please let me know whether it is working or not.
Thanks and Regards