Data Exchange Data Mapping Target Expression SQL Case statement
Jan 15, 2025 · Summary: In an EPM Planning Data Exchange integration, I need to replace a parent value and member value of “T” with another value like “T_Fund”.
Logical SQL in calculation validated ok but Query Error in ...
Dec 12, 2024 · The functionality of VALUEOF() is different. It is used to reference BI Server variables. Please check the below: Use the VALUEOF function in a filter to reference the value …
Using TO_CHAR to Format Date and Time in SQL - Oracle …
Apr 15, 2025 · When managing data in SQL—especially within environments like NetSuite’s SuiteAnalytics or custom reporting—it’s common to work with timestamps. However, raw date …
Need a sql query to fetch Procurement BU under supplier-> …
Jun 12, 2024 · Summary: I need to fetch a Procurement BU name for a particular supplier. Navigation→. Login to ERP->Procurement->suppliers -> manage suppliers -> search for any …
Ago function — Oracle Analytics
Oct 30, 2017 · CAL_WEEK_DESC - call me psychic but I suspect that is a descriptor field, not a key. You need to reference a key in AGO function. Might be worth a punt with CAL_WEEK_ID, …
Sql to reconcile Receivable Invoices' balances with their applied ...
Aug 13, 2024 · Sql to reconcile Receivable Invoices' balances with their applied receipts Aug 13, 2024 10:34AM in Reporting and Analytics for ERP 4 comments So, I have constructed a sql …
how to get the names of week day in fast formula
Jan 5, 2025 · Summary: I need to get the Name of the day based on date. Content (please ensure you mask any confidential information):
how to get previous month first_date & last_date in bi publisher?
Jan 28, 2005 · Hi @Diane G123, if the date will always be defaulted and will never allow the user to change this date, then perhaps create a list of values with a sql query that will bring back …
How to use MAX Date in OTBI — Cloud Customer Connect
Dec 12, 2019 · How can use MAX function to select the latest row? ex. we have partners and there is Partnership Start Date. if partner get promoted to next level I'm getting 2 rows for …
Return the value of a function with Forms Personalization
May 21, 2015 · I'm trying to personalize the Sales Order Lines form with Forms Personalization. I want to create a button under the special menu, so that when it's clicked, it will return the value …