Essbase
Discussion List
-
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 62 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 52 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 32 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…
-
Balances are not reflecting in "Inquire on Detail Balances"Summary: Balances are not reflecting in "Inquire on Detail Balances" Content (please ensure you mask any confidential information): Balances are not reflecting in "Inqui… -
Essbase Report Writer decommissioningSummary: Are there any plans to decommission Report Writer, and if "yes" - when? Thanks!
-
How to create a trial Balance either in OTBI or FRC ?Summary: How to create a trial Balance either OTBI or FRC ? Content (please ensure you mask any confidential information): Hello The company would like to have a trial b…Cesar Saveedra 51 views 1 comment 0 points Most recent by Lakshmi Alagappan-Oracle General Ledger & Intercompany
-
Looking for the easiest way to view an essbase outlineI'm trying to debug an issue with a current cloud planning and have the outline extracted from the essbase data artifact. I'm looking for the easiest way to view it. Are… -
Essbase Error (1270073) Failed to read data from file.Summary: In ERP, when posting a Journal, it ended in error 1270073.- Failed to read data from file .../temp/ess00001.dat, does someone know the reason? We must explain i…
-
Is there a way to facilitate loading over a billion records into a cube on Essbase 21c?Summary: I have a cube where I will need to load a billion records in a timely manner. Are there any efficiencies that I might gain by employing something like Cameron d…
-
Essbase Error (1270073) Failed to read data from file.Summary: Essbase Error (1270073) Failed to read data from file. What is the reason? or what does this error mean? Content (please ensure you mask any confidential inform…