@Indranil Basak-Oracle, in the advanced system settings in the console, you can change the currency xml which is usially in the OAC config file. The instructions at https://docs.oracle.com/en/middleware/bi/analytics-server/administer-oas/change-default-currency-analyses.html#GUID-673A10AC-ED09-4FCE-A4F5-EEF5CFECCFB1 may…

Hi @Indranil Basak-Oracle Have you tried looking at your profile options? There is a currency option in there. When I look at mine I only have 'None' as an option. Not sure if you will have other options in yours. This might resolve the issue.

Hi @Siddharth Dang You can use a self hosted LLM for the OAC AI features by going into the console. For the FDI AI content such as DA Scripts and AI Concierge, the Oracle LLM will be optimised for these features so wondering what benefits a custom LLM would bring?

I'm not sure on the functional side. Check with your Fusion environment manager to see if there is a scheduled refresh due to take place any time soon or if they can get one scheduled.

@marcfromhawaii, I have just checked one of my instances and that is showing I am using 2.4gb. Interestingly, these are all shown as System extensions. Might be worth raising an SR to see if support can tell you exactly what tables they relate to?

I am not 100% sure on the OBIEE side sorry. I know in the Autonomous Data Lakehouse you can create table structures directly using sql and load data via Sql Developer. For bulk upload, you should be able to use any integration ETL tool you already use to move your data.

Hi @marcfromhawaii Your best bet here would be to get a prod to test done to your source environment then do a data warehouse reset in your FDI environment which will effectively wipe everything and do a new full load with the latest data. The other option would be to re-point your development FDI environment to production…

Hi @marcfromhawaii Product management will need to confirm but as far as I understand, anything loaded direct into OAC as a dataset does not touch the data warehouse and only exists in cache and so not contribute to the 50gb. Similarly, as views are virtual they do not store physical data and so wouldn't affect the storage…

Hi @Priya Parthiban Might there be security restrictions causing you to not be able to see the data with your roles? You would need to ensure your role has the appropriate data role assigned to return any data along with the data security being set in Fusion. What I have also found in the past is that quite often,…

Hi @User_SYYDG I'm not 100% sure but I don't think you can use between with a text field. Have you tried using IN instead of BETWEEN? Also, it doesn't look like you are filtering anything here and this is more of a conversion statement. What are you trying to limit the values to?

Hi @Sisanda This looks like an OTBI analysis. If that is the case then it can only report what is in Fusion. If it is OAC, do you have any dataset that has all the information in it? If you do, you have two options: Load the data as a dataset directly in OAC and then add it to your workbook. You should be able to combine…

Hi @User_SYYDG Curious on the use case for this one. Are you trying to restrict the dataset itself or just the output? Generally, when creating a dataset you would load the whole set then add Workbook filters or dashboard prompts to restrict the output. If you are trying to apply security to the dataset I don't believe…

Hi @User_SYYDG @Chere-Oracle is correct that you can only add a fact/measure in a tile. The way I would achieve this is to use just COUNT(SAAR_ID) as the Fact and label it Pending SAARs and add it to the tile. I would then use a custom description for the tile and use the Current Date Time Parameter in there. I have…

Hi @Trang Tran UCD, You could try bringing in the extra information using Data Augmentation to connect to the PVOs. The reference documents for Projects Business Objects is at https://docs.oracle.com/en/cloud/saas/project-management/26c/fabpm/bo_oraErpCoreProjectCostTransactions_ProjectCostTransaction.html Hope this helps

Thanks @RVohra . I have managed to work around this by navigating to a dashboard page with prompts at all the levels rather than directly to the analysis which seems to have worked.

Hi @Subash Aryal Headcount is based off the headcount number stored in Fusion. I have found that not all organisations use that field and so the alternative seeded metric for worker count which is just a row count of workers is used.

Hi @Raghavendra Raghunath-Oracle. Great to hear this is on the roadmap as it has been requested by multiple customers I have worked with. @Priya Parthiban The reason you get all the records when creating a dataset is because the data security isn't being applied. There is actually logic to the way FDI is reporting this. As…

@Usha Athimakula Maybe this is something your data migration team could help with?

H @Usha Athimakula Are there specific tables you are looking for. Just asked the question on chat GPT and it came up with this EBS Table Fusion Table Fusion PVO (BICC/Extract) MTL_SYSTEM_ITEMS_B EGP_SYSTEM_ITEMS_B ItemExtractPVO MTL_ITEM_CATEGORIES EGP_ITEM_CATEGORIES_B ItemCategoryExtractPVO MTL_PARAMETERS…

Hi @Youstina Nasr How complicated is the query in OTBI? It may be something that can be optimised rather than moving it to BIP which would have impact n other aspects of the user experience and make maintenance more difficult.