Simply I try to navigate Country -> Drill in Report "# of Account " -> Properties -> interaction -> Naviagte to BI content -> drill in report Drill in : filters are Country is Prompted But I am not able to achieve my requirement because as I observe Country report it is navigating to State Report then following City like…

Hi Thomas, Thanks for reply, # of Account -> Properties -> interaction -> Navigate to BI content -> Drill in report But Still it is navigating to when I click on Country -> State -> City -> postal -> Drill in. Regards, MD Hyder

Error Codes --------------------------------------------------- [nQSError: 14078] This query requires the External Expression to be set in the physical Complex Join

Step1 : 1. Create a analysis select only column "Time.Enterprise Quarter" 2. Save the analyses as "Enterprise Quarter" Step2: SQL expression: '@{SelectedQuarter}{All}' = 'All' AND Enterprise Quarter is equal to any Enterprise Quarter in Enterprise Quarter /*Becareful while applying the filter or '@{SelectedQuarter}' =…

Hi Srini, Thanks for your reply, Standard timefram bin prompt available with two option 1. Current Quarter 2. Next Quarter 3. I am trying to add third option i.e "ALL" SQL expression: '@{SelectedQuarter}{Next Quarter}' = 'Next Quarter' AND "Time"."Enterprise Quarter" = VALUEOF("NEXT_ENTERPRISE_QUARTER") or…

Thanks Berg, Please let me which Forum I need to select? Regards, MD Hyder

The above report is for Oracle sales cloud Fusion CRM. i.e is in OBIEE