Hi @User_UA8ST, I would advise you to post this question in Pricing — Cloud Customer Connect Thanks

Hi @User_OJ47U It is currently not possible to restrict access to the tables. There is currently an idea https://cloudcustomerconnect.oracle.com/posts/9c82838cd2 Users having BI admin or BI author roles can query all the tables in Fusion schema from data model. It is not possible to restrict specific tables from BI…

As per Oracle Doc, create a bursting workbook email schedule to deliver data visualizations to recipients if the data visualizations contain confidential data that is accessed by specific application roles and user groups configured in Oracle Analytics. Each recipient receives a customized data visualization based on their…

As per my knowledge, FRS (Financial Reporting Studio) reports do not have a built-in "Auto-Increment" checkbox for the Accounting Period parameter like some standard ESS jobs do. However, you can achieve this exact functionality by using the Batch Scheduler in combination with the Current POV (Point of View) function.…

There could be many reasons for this error, please check following: Ensure the database instance hosting the DAC repository is actually UP and OPEN. Log in to the DAC server host and run tnsping <TNS_ALIAS> or telnet <DB_HOST> <PORT> to ensure the network path is open. Check if the DAC repository database user (e.g.,…

Please explore following PJF tables: PJF_PROJECTS_ALL_B PJF_PROJ_ELEMENTS_B PJF_PROJ_ELEMENTS_TL

As per my understanding, operational (non-transactional) project tasks / milestones are NOT supported for reporting in OTBI or FDI as of 25D. Only financially relevant plan lines (cost/revenue enabled) are exposed to OTBI PPM subject areas and the FDI DW_PROJECT_PLAN_LINE_DETAIL_CF fact.

Hi @kubrail, As per oracle documentation, you must add your KPIs and visualizations to the library using the Visualization Configurations page before they can be used on the Redwood Purchasing Landing Page. Here is the primary Oracle Help Center note that explains how the Visualization Configurations page works for…

It could be something like below … SELECT papf.person_number AS "EmpNumber", ppnf.display_name AS "EmpName", par.responsibility_name AS "RespName", flv.meaning AS "RepRole", prep_names.display_name AS "RepName" FROM per_all_people_f papf JOIN per_person_names_f ppnf ON papf.person_id = ppnf.person_id AND ppnf.name_type =…

Hi @jsmithA , Here are the few key tables that can help you to get the HR Rep and HR BP per_all_people_f per_person_names_f per_asg_responsibilities Hope it helps!

Thanks, SteveF for sharing extensive list of articles, appreciate it.

I am not sure if it is supported but it will be interesting to see if it is possible, please share if you are able to come up with a solution. thanks

I believe it is not supported for data visualizations. Please refer - https://docs.oracle.com/en/cloud/paas/analytics-cloud/acabi/allow-html-javascript-css-content.html Allow HTML/JavaScript/CSS Content Administrators use this system setting to determine whether users can apply and save HTML, JavaScript, and CSS markup in…

Thanks, Rajasekhar, for pointing it out. Yes, Java is required.

I know it is frustrating when such a simple thing should work but I do recall having some trouble while installing it. You might have tried all below steps but wanted to re-iterate following: Make sure to close all Microsoft Office applications before install Check word, it it 32-bit or 64-bit. 32-bit Word requires 32-bit…

@Daniel C Mohan-Oracle Thanks for the recognition!

It won't cost much if your use case is limited and setup is small.

I believe the DateTime filter widget uses a built-in calendar/time picker and the time selector is default to 5-minute increments. Internally it uses Oracle JET’s oj-date-time-picker, If we further look at the jet specs for this component…

Hi @Preethi Kondur As SteveF pointed above, let's create a new post in the correct forum https://community.oracle.com/netsuite/english/categories/netsuite-analytics-warehouse-nsaw We can get the NAW Admins/PMs/SMEs to pitch in and provide help. Thanks

Hope it helps!