Congratulations.

@Alan Lee - Oracle-Oracle can the default option be considered?

thanks Parag, for supporting the idea.

thanks Mitch, for supporting the idea. Lets hope Oracle reconsider the decision.

thanks Sandeep. Just wanted to check the reasons behind 'decline' in spite of many votes and justification. It saves lots of time over the period.

try this and search in Forums, I have suggested it earlier. <?if@inlines: <column>!='N/A'?> <fo:basic-link external-destination="{.//<column>}" color="blue" text-decoration="underline"> <column description> </fo:basic-link> <?end if?>

your summary has two extra filters, the last two.

give a try: 1) "Workforce Management - Accrual Real Time"."Employee Plan Participation"."Accrual Type" 2) ANC_PER_ACRL_ENTRY_DTLS.TYPE

'Edit' option automatically appears for Users with 'BI-Author' role or even if it's inherited as part of Fusion custom roles. The only option is to remove the BI-Author privilege from the roles.

can you double-check the parameters/filters in both the summary and drill-down? they have to be the same.

correct; you can easily achieve that with the steps mentioned earlier.

@Sravan Komminedi, try these pick-up a measure from your summary report navigate to its column properties / interaction / value 'Primary Interaction' select Action Links / click + / select your detailed/drill-down reports make sure measure from (1) is set to 'is prompted' and the rest of the filters/prompts should be the…

I doubt it, and the whole idea is to distinguish the source, whether it's from Oracle BI Publisher or some other source. There may be an option to have aliases; it's worth checking with Oracle through an SR.

That's a standard feature of Oracle BI Publisher, and I don't think it can be customized. Also, what's the real purpose of renaming it from Oracle BI Publisher to Oracle BI?

if you maintain the same folder structure in your target environment, there is no need to re-point.

hi Swetha, Good to meet you here :) You will have to get the instance from this query : ( select external_virtual_host instance_url from fusion.ask_deployed_domains where deployed_domain_name='FADomain' ) and then based on instance_url, construct your fusion instance. ,case when instance.instance_url =…

1) I just ran the same statement in my instance and I dont get any duplicate rows. The best way to debug this type of issues is to include all the ID columns in your select statement like PERSON_ID, ADDRESS_ID, etc. 2) try to add this condition as well : and sysdate between PER_PERSON_ADDR_USAGES_F.EFFECTIVE_START_DATE and…

@Swapnil Kashid - Thanks for the note about 22a upgrade. However, cannot find any references to the techstack upgrade from 11g to 12c.

@Oracle Prod Dev team - any updates on this feature?

The current version of OTBI is 11g (11.1.1.9) which is very old and does not have many features compared to on-premise OBIEE version. I have raised this many times in Product Office Hours sessions.