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.

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