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.

@Paras Negi You should be able to find the relevant PVOs at https://community.oracle.com/customerconnect/discussion/479636/r13-scm-and-procurement-otbi-subject-areas-to-database-lineage-mapping-spreadsheet/p1

@Paras Negi Just to add, looking at the latest roadmap released today, SQM is in the upcoming column for delivery so will hopefully be out of the box in the next 2 releases so may be worth waiting.

Hi @Paras Negi I would use Data Augmentation or the new Data Augmentation Scripts to bring the data into a table within the data warehouse. You can then create a new logical star or extend an existing one with the qualification data then create a new subject area or add it to an existing one. You just need to find the…

Hi @Priya Parthiban In the agent prompt, have you specified that if a user has multiple roles, it should clarify which role the query should be directed to? This might help. For the AI Agents to work properly, you need to ensure you add as much detail as possible so the agent can pick the correct context.

Hi @User_AYOKV Have you tried adding a fact to the report? It might be that there is no natural link between the dimensions used and needs a fact to tie it together. If the fact isn't relevant to the report itself, you can hide the column in the column properties.

hi @Sai Poorna You shouldn’t need to put the host name for the link for a BIP report. If you navigate to BI content as the action link, it just puts the catalog reference starting @catalog. I agree this is a pain when migrating and have raised an idea on the idea lab to help with this at although I haven’t tried the ideas…

Hi @Amber O. Have you tried using the Show All Members toggle in the properties below? This may help suppress null rows but not zeros. The reason for this is zero is a valid value made up if positives and negatives where as null would mean there is no underlying data.

Hi @Su Ma As far as I am aware, there is no option to simply turn on this feature. You can change the security settings to give access to or restrict access to the column as a whole but not based on any calculation logic. I think the way to achieve this would be to define a custom column in the semantic model that has a…

Hi @User_A63N1, you can change the interactivity options for each canvas in the Present mode but as far as I am aware there is no option to secure each canvas separately as this is set at a workbook level.

This is increasingly coming up as a customer requirement and would be a really useful function to be able to make notes against a specific transaction. It could possibly be achieved by using a specific DFF attribute.

Hi @marcfromhawaii You can try going into the admin screen in OAC Classic and select Reload Files and Metadata. Clearing your browser cache can also help.

Hi @Mohit Sobti The only ones available as standard in FAIDP are FscmTopModelAM.PrjExtractAM.PjbBiccExtractAM.BillingAccountingEventExtractPVO FscmTopModelAM.PrjExtractAM.PjbBiccExtractAM.BillingEventExtractPVO FscmTopModelAM.PrjExtractAM.PjbBiccExtractAM.BillingMethodTLExtractPVO Do you know if the column is available…

Hi @SERGIO BARRETO To do this you will need to create a sandbox in the Fusion environment with the relevant tools. I created this ppt a while ago but I think it should still work. You might also have to go into the console of OAC and add the Fusion environment as a safe domain.

hi @SrinathD This capability already exists. If you hit the export button at the top of the page you can do the entire workbook or just a canvas Was there something this doesn't cover?

Totally agree. Hierarchy Columns should be exposed as standard where possible, preferably with options for Code only, Description Only and a concatenation of both.

Hi @User_SPO74 I haven't seen anything that would match this requirement with the out of the box bar chart. From what I can tell, you can only have the value labels not the axis labels. If that is the case, the only way this would be possible is to have someone create an extension and load it via the console. I think it is…

Hi @User_OPW6Z This seems to be a bug. There is an Align option under Supress Repeat where you can select Start, Center or End. When I have tested this in my environment, it doesn't actually change anything. I would raise an SR. Dan

@Santa_B-Oracle, my environment is 26.R1.P1 and I seem to have the option for this You would just need to create the session variable in a sandbox first. Apologies if I am missing something.