Essbase
Discussion List
-
How to update the Alias table name in ERP smartview?How to update the Alias table name in ERP smartview? We have loaded the Swedish description and the same is visible in Alias Table as "Language_S". We need to update the…Rishika Menezes 1 view 1 comment 0 points Most recent by Gabriela Patrascu-Oracle General Ledger & Intercompany -
abc costing using allocation in oracle fusionSummary: We need to use allocation to generate abc costing based on activities, need to distribute the salaries and some expenses. Any body have idea how can process. No…Christian Leon 11 views 1 comment 0 points Most recent by Gabriela Patrascu-Oracle General Ledger & Intercompany -
Our business has a requirement of loading 300 FBDI Journal files in single daySummary: Our business has a requirement of loading 300 FBDI Journal files in 20 hours with million lines in one file. There is no way to extend timeline of 20 hours as i…Prasad Sawant 1 view 1 comment 0 points Most recent by Laura Petre-Oracle General Ledger & Intercompany
-
Can use GL's rapid implementation to create a new enterprise structure (LE, Ledger, Calendar, COA) iSummary: I have to create a new gl enterprise structure (primary ledger, COA, calendar) in a cloud instance where the customer already has other structures created. I ca…Arturo Benitez-Oracle 11 views 2 comments 0 points Most recent by Julien_Dubouis General Ledger & Intercompany
-
How to Extract Chart of Accounts Values and HierarchiesSummary How to Extract Chart of Accounts Values and HierarchiesContent Hi I would just like to inquire if there is a standard report (OTBI), program or an API that can e…User_2025-02-11-12-30-38-982 1.5K views 9 comments 4 points Most recent by Truptesh Solanki General Ledger & Intercompany -
How can I use HypUIConnect without a friendly name?Summary: I need to convert multiple Smart View reports to point to a different database. The "from" and "to" database have different number of dimensions; some dimension…
-
How can you Dynamically copy multiple smart list members into single member in the same dimension?Summary: I need to copy allocated data into an unallocated member for two dimensions. Content (please ensure you mask any confidential information): I want to move data …
-
how can distribute retained earnings by business unitHow can to make our dsitribution of retained earnings by BU now we have 2 legal entity but 3 bussiness units This 2 BU are under 1 of legal entity but need to see this r…Christian Leon 11 views 2 comments 0 points Most recent by Christian Leon General Ledger & Intercompany
-
LCM Using ESSC Not Bringing in All BlocksSummary: I recently exported an LCM with data and imported into a new environment. Viewing the logs, all data was loaded successfully and the same number of blocks were …
-
What is this notepad type deployed status in allocation 'calculation manager'?Summary: In calculation manager in allocation, under system view we have 'Deploy' column where we are getting a third type of deployed status apart from green tick type …Arvind_Behura 11 views 3 comments 0 points Most recent by Hussian Sharief M-Oracle General Ledger & Intercompany -
How to build a FRS report to show trailing actuals and budget for an entitySummary: We have two separate FRS reports to print 12 month trailing budget and actual, which are working fine. The new requirement is to print the actual for the curren…SuniChacko 61 views 1 comment 0 points Most recent by Andreea Brem-Oracle General Ledger & Intercompany
-
Unable to Publish Account Hierarchies for few Value setsSummary: Unable to Publish Account Hierarchies for few Value sets Content (required): We are not able to publish Accounting Hierarchies for Some value sets which for few…Rohit Kumar Singh 1.4K views 12 comments 0 points Most recent by Cezar M-Oracle General Ledger & Intercompany
-
Do we really need the BIAdministrator role for the Account Inspector to show balances on parents?Summary: We noticed an interesting phenomena in General Ledger features that are based directly on the balances cubes (Inquire on Detail Balances, Account Monitor, Accou…Thomas De Leeuw 31 views 2 comments 0 points Most recent by Thomas De Leeuw General Ledger & Intercompany
-
Alias tables in SmartviewSummary: How are these created / where are they coming from? Can additional Alias Tables be created? Content (required): In SmartView (Essbase) when switching between Al…Delaney Wastler 51 views 4 comments 0 points Most recent by Bala Murali SV General Ledger & Intercompany
-
Drill through on parent of shared membersSummary: We have an Essbase 21c drillthrough report defined with filters set up to allow us to pull level 0 members of any dimension and pass them to Essbase drill throu…
-
Calc Script for YTDSummary: I am trying to create a separate dimension in Planning called "View" using a member formula to calculate MTD, QTD or YTD values based on the selection made in t…
-
Impact of Member Name Path when a Tree includes multiple versionsSummary: Impact of Member Name Path when a Tree includes multiple versions Content (please ensure you mask any confidential information): We have a tree that includes on…
-
How to connect to Oracle Cloud ERP in Smartview using HS Functions?Hi, We are trying to connect to Essbase cube of Oracle Cloud ERP via Smartview. Specifically, we are trying to use HS functions (Example: HSGet, HSset). But when we try …Guntuka VenkataKrishna 31 views 2 comments 0 points Most recent by Guntuka VenkataKrishna General Ledger & Intercompany
-
Hierarchies version is not visible in AllocationsSummary: Hierarchies version is not visible in Allocations Content (required): Hierarchies version is not visible in Allocations Version (include the version you are usi…
-
Intelligent agg with ILANCESTORSRe-posting my question here because it might be more appropriate than the Planning forum I have a data form with two sparse dimensions on the row (CC, Product). Groovy d…
-
Error using summation in MDX querySummary: I'm trying to pull data from Essbase using a group of members that I need to sum up. To do it, I'm using WITH statement that looks something like that: With Mem…
-
Is there a way to bulk enabling DFFs instead of one by oneSummary:We have many DFF that will need to enable for BI. Looking for a faster way to enable all at once instead of doing it one by one. Content (please ensure you mask …
-
Journal Posting errorJournal Posting error : No sequence version is enabled or defined for sequences with an expiration date of 01/31/24.
-
Changing Accounting Calendar from Fiscal to Calendar Year in Oracle FusionSummary I am trying to change our accounting calendar from Calendar Year to a Fiscal Year. Has anyone been able to do this and are there any downstream impacts?Content W… -
Account Cube UpdateSummary Account Cube UpdateContent I did an update to Account Hierarchy and generate the "Publish Chart of Accounts Dimension Members and Hierarchies" not publishing Hie…
-
Essbase certificationsSummary: Hi, should we expect Essbase certifications to be back on Oracle University. And when ? Same question for Essbase etraining on Oracle University. Content (requi… -
Passing parameters to Report Writer scriptSummary: I'm trying to create a universal data extraction process that will utilize Report Writer. The idea is to have a standard extract layout (placement of dimensions…