Looking for Radio button type for Prompts!! for time being: You may go for report level validations for those 2 prompts using Presentation variables.

Based on above all is good. can you share different result value? Btw: did you try with field1 & field2 with your own calculation instead of pivot table calculation?

this file is owned by em. Check this Configuring and Managing Analyses and Dashboards - 11g Release 1 (11.1.1)

Check the file location ex: \OFM\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 You may go with timestamp to identify OOB or modified xml file with other files' timestamps

This might be helpful How To Send Text Messages Free

DAC itself dont have that ability, you need to give that strength through your own command line script like shell or batch.

Check this link cool-bi.com/Blog/Tweaks/PortaBI.php

How you are getting these 201404,201512 values when user selects APR-2014 to DEC2015?

Add Narrative view with the below code make sure you select check box for html <style> .PT_SI { display: none;} </style>

Use filter is Not Like ex: ("Time"."Year" NOT LIKE '%5' AND "Time"."Year" NOT LIKE '%0') in your case that would something like (ColumnName NOT LIKE '%99' AND ColumnName NOT LIKE '%00')

you need to write outer query based on all those union clause as inner query and can exclude nulls or zeros but this might need to recreate whole report formatting and headings etc

also check this Doc ID 1535769.1

Check this Paul Cannon's BI Blog: Deploy OBIEE 11g as Services under Windows

Keep look into this, I believe something is wrong in your report !!

Use these with nested isnull functions for scenarios SUBSTRING('J.D.Doe' FROM LOCATE('.','J.D.Doe',-1)+1) SUBSTRING('J_D_Doe' FROM LOCATE('_','J_D_Doe',-1)+1) 

Try selecting "Use Agent Owner's Credentials" if not I would suggest to read this and validate your settings Setting Up the SA System Subject Area

Check this Passing prompt presentation variable in Navigate URL

if you need responses you have to share that used formula or error message 

You need to refine the condition to see both date values in that range

CAST("Service Request Secondary Dates"."Open Date" AS DATE) >= date '@{OpenDate}{2016-01-01}' and CAST("Service Request Secondary Dates"."Close Date" AS DATE) <= date '@{CloseDate}{2016-01-31}'