nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

I am trying to get first submission date

Khalid Aldosari-Oracle

Hello All,

I am working on dashboard and I am trying to find the first submission date for the supplier registration. as you can see in the following picture.

Procurement -> Supplier -> Task ->Manage Supplier Registration Request

I am using subject area called "Supplier Registration - Real Time" I tried to take the min for creation date and request date but non of them working with me. Also, I tried the last update to take the min but still did not change anything.

the second question, there is column in this subject area called "Supplier Registration Request"."Registration Approval Time in Days", how to make it count from the fist submission date not from the last one.

Thank you in advance!

kind regards,

Khalid

Find more posts tagged with

OTBI

Fusion SCM Analytics

Accepted answers

Rajasekhar Bandaru-Oracle

Hi Khalid,

Please review the OTBI subject area help center documentation and check the "Time Reporting" section and include the recommend

https://docs.oracle.com/en/cloud/saas/procurement/24d/faopb/Supplier-Registration--Supplier-Registration-Real--SA-19.html#Description

In the OTBI analysis count of "Supplier Registration Request"."Registration Approval Time in Days" and add a filter at the column by BIN option.

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/edit-formulas-or-calculated-measures.html#GUID-56B8E03F-E6A6-4421-AD81-DDD72B5D68F4

All comments

Rajasekhar Bandaru-Oracle

Hi Khalid,

Please review the OTBI subject area help center documentation and check the "Time Reporting" section and include the recommend

https://docs.oracle.com/en/cloud/saas/procurement/24d/faopb/Supplier-Registration--Supplier-Registration-Real--SA-19.html#Description

In the OTBI analysis count of "Supplier Registration Request"."Registration Approval Time in Days" and add a filter at the column by BIN option.

https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/edit-formulas-or-calculated-measures.html#GUID-56B8E03F-E6A6-4421-AD81-DDD72B5D68F4

Khalid Aldosari-Oracle

Hi @Rajasekhar Bandaru-Oracle

Thank you for responding I found the answer in the first link which is not supporting historical data.

Have good day

Bhaskar Konar

https://community.oracle.com/products/oracleanalytics/discussion/comment/61827#Comment_61827

Very helpful information.

Thank you very much @Rajasekhar Bandaru-Oracle!