Hi @User_SYYDG Seems a bit odd if Canvas 1 is the only option. I would possibly try reselecting Canvas 1 from the dropdown (souns silly I know but it might just be passing a default value) or failing that, rename Canvas 1 in the target Workbook and then select it with the new name.

Hi @Stefano_Mazzocca You could look to create a parameter for the month and Year and use the year to filter the report. I did something similar for financials using the available values as logical sql using SELECT "Financials - GL Budgets"."Time"."Fiscal Year" FROM "Financials - GL Budgets" WHERE "Financials - GL…

Hi @User_SYYDG I don't think you need the second statement in there because you are excluding null twice.

Hi @Priya Parthiban, Have you checked the latest release documentation? It might be that these columns have been deprecated in a recent release. If they have then you could use Data Augmentations to update the schemas to re-introduce the data then change the visualisation to pick up the new version. If you could provide an…

Hi @User_VIM5S It might be worth looking at the SQL that is being generated to see what filters are being applied to the data. It could be that it is restricting based on org/line manager security and applying the most restrictive privilege. You can do this by activating the Developer Tools in your profile then using the…

Hi @Vidya Raj-Oracle Thanks for sharing. This workbook will help with a real use case I have with a customer at the moment but it doesn't seem to be available on the content library. Is it possible to share the DVA please? Thanks

Hi @Henrikues With that much data I would suggest building it into the semantic model. This will enable you to pre-calculate the results rather than it being done at runtime. Personally, I have always considered the dataset capability to be more for self service exploration and proof of concept work to prove the value of…

@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…