@Lokesh Obhilineni-Oracle Hi Lokesh, Please pull calculated column and use case when statements along with like operator. example: case when New to clinic indicator like '%use your text keyword%' then <yes> else <No> End please see if it helps.

@Paulina Vega It looks like you are using real time subject area which are part of otbi analytics .could you please check in fusion otbi forum . or in faw/fdi ,you created oracle applications connection and created a report on top of the real time subject areas in faw/fdi oac dv/ui ? kindly please clarify

Hi Mohammad, Please review below video and see if it helps

Hi Yogesh, As your new query is about impact of flattening and publish hierarchies from oracle erp system ,please consult oracle erp team or post your query on the impact on fusion community. From fdi perspective ,pre-requisites has to be followed.

@Yogesh Yadav Hi yogesh,1) If pre-requisites were not followed correctly it can lead to incosistencys or missing some levels in fdi hierarchies used in subject areas. For example there is a natural account hierarchy setup in fdi under segments folder and while drilling down the hierarchy it may lead to incosistencies.…

@Vismay Barot Please access hamburger icon from left hand side from oac home page ,from connection tab you would see adw connection ,click on action menu (3dots) and inspect . Also from the screenshot shared earlier ,there is an enter sql option ,please click on enter sql and share the screenshot. or without passing any…

@Vismay Barot Could you verify if the connection service name is selected as low service and verify.

Hi Mohammad, Please follow oac documentation for migrating catalog items.The recommendation is to use rest api for oac instance as these are compatible with oac native product features. Other suggestions are welcome

@Kirk Li please pull crtd ,rsum and filter calculated column and create tabular view and share the screenshot. could you also share filter calculation logic.

@User_VMJII ,Please create a new calculated column and use Rsum or running sum function like Rsum("measure name")

@User_BKO8T As this is DDR request ,please see if you could incorporate order by clause in the query and sort it at the query itself.

@Vaigu_27 To test the session variable ,you can access any subject area in oac dv and create custom calculation and use this code VALUEOF(NQ_SESSION.ANALYTICS_CURRENCY_CODE). Analytics_currency_code is system provided variable. Please replace it with your variable name. To check further on existing session variables and…

@JPK Please share the screenshot showing the error Please login to oci console and update fusion application credentials screen and just test the connection and confirm if the connection is successful. Refer below documentation ,on how to navigate Update fusion application credentials screen

@JPK If the financial category assignment upload status as completed ,then there is no option showing to delete the csv file . But for failed status ,it shows delete option. Please refer Documentation Note: Replace existing configuration settings deletes existing data security assignments. Also if you do not want to use…

@Sambasivarao Manam Please follow ER filed in idea lab

@Jorge Olmeda Please check the following documentation and play around with the graph settings. This looks like formatting issue due to incorrect settings.

@User_WYDQH From oas dv home page ,access create button and check if semantic model is visible. Then create a test semantic model and import a file and save the semantic model . From oas dv home page,Access hamburger icon from left hand side top and check if semantic models link is visible. please share application roles…

@Devashish Saun FAW: Semantic Model Extensions: System Extensions / Apply System Steps scenarios (Doc ID 2921522.1) Please refer apply system step scenario and there is no control mechanism to reschedule system steps .

@Aarvi-Oracle .I had reviewed the documentation and could not find audit related to obiee currently it is not possible to have audit of Administration updates in OAS, like creation of new catalog groups, adding members in catalog groups, granting privileges to catalogs and managing privileges. Please raise an ER in idea…

@Abdur Rehman Please refer Unable To Select Multiple Values For Parameter. Scheduled Job Fails With 'ORA-00909: invalid number of arguments' (Doc ID 2740185.1) The document suggests to decrease the values till the error is resolved. Please raise Enhancement request under otbi bip product.