@ShyamVaran Please access oac dv console ,system settings and change default user preferred time zone and check the issue.If not resolving ,perform snapshot migration and check the issue . Also for testing ,manually migrate one or two agents and test the issue. Please also try the workaround mentioned in below document…

please use below documentation and correct the url in this format and see if it is resolving the issue https://gitserver.com/myorg/myproject.git https://docs.oracle.com/en/cloud/paas/analytics-cloud/acmdg/upload-semantic-model-git-repository-using-https.html

Hi ned,please try this once Insert into test_login_log(txt) values (':USER')

Please change the join conditions to 5 from join diagram and see if the modified date is changing to check the behavior

@Vismay Barot I did the following test ,I opened Dataset - Sales Order and edit definition ,added one column ,removed the added column and saved it ,then modified date is getting changed. In your case also ,though the same columns exists before and after ,there is a chance that some changes to the dataset could be done and…

@SERGIO BARRETO Please access otbi bip report and export it to csv and access fdi adw db and query bip augmented table (select * from <bip dataaugmented table>) and export it to excel at adw db and compare the data with respect to number of rows.

@User_VGJL1 This forum is related to FDI.For fusion application related queries please use below forum and request for assistance.

@User_VGJL1 Please confirm if issue is related to Fusion bip or fusion data intelligence?

@SERGIO BARRETO Could you please confirm the following 1)Username used to create bip report at otbi analytics/xmlpserver 2)Username used at faw bip datasource connection for the purpose of creating data augmentation. please confirm if both usernames are matching.

Hi @Saroj Kumar Behera ,It looks like query for init block is incorrect Please refer section Initializing a Variable with a List of Values from below documentation example: SELECT 'LIST_OF_USERS', USERID FROM RW_SESSION_VARSWHERE NAME='STATUS' AND VALUE='FULL-TIME'

@SERGIO BARRETO Hi Sergio, After bip table using data augmentation was created in ADW db ,please use this table at oac datasets and join with OOTB subject areas available from fdi. other suggestions are welcome.

@Yogesh Yadav Could you please validate idcs sync using below blog and video https://www.youtube.com/watch?v=16oxs7FKmM0

@Roelof de Groot Could you please share the latest above query with screenshots.

@Roelof de Groot Also if you are using SME sandbox,create a test sandbox ,perform action ,edit logical star as shown below Click on graphic tab Kindly please check if this helps

Hi @Roelof de Groot Please check below documentation about relationship diagram For other modules please refer Sample diagram for one fact table

Hi @User_SI7HK ,For combining 3 columns ,into a single field ,please use concat symbol || in my calculations from dv workbook concatenation logic: "Financials - AP Invoices"."Supplier"."Supplier City" || ', ' ||"Financials - AP Invoices"."Supplier"."Supplier State" || ', '||"Financials - AP Invoices"."Supplier"."Supplier…

@User_801US Please confirm the product you are using .Is it obiee ,oracle analytics server?please share the version of product Login to wls console ,left hand side please expand services and click on data sources . example: click on biplatform_datasource ,monitoring tab and testing and test the connection.Please verify for…

@Georgina Sawyer Could you please share more details. Expenses and corporate cards comes under which module Erp,scm ,hcm or cx from fdi product From fusion OTBI analytics ,Is there any sample ootb report .If yes please share the report criteria or please go to advanced tab and share the logical sql to verify the real time…

@SERGIO BARRETO please access fdi oax url ,enable features ,general available features and enable SME Options for Data AugmentationEnable semantic modeling options in Data Augmentation – Dimension, Extend Entity, and Fact.please check if you could be able to see dim ,fact etc.,

@User_PWOBY Please refer documentation on exists operator From the syntax we use exists along with sub query.If sub query returns atleast one row then condition is met and also sub query will be run for every row in outer query's table. when there are tables with huge volume of data there will be performance issues and…