Dimensions
Discussion List
-
Making Period and Movement Dense: Report Performance Issues with QTD/YTD ViewsHi everyone, I am looking into making Period and Movement dense in our FCC application and am finding that the QTD/YTD View performance is unacceptable. 1-second Smart V…Matt Maurer 211 views 24 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Opening Balance on a units based account is currency converted instead of x 1 (FCCS)Summary: The account, being units based, should contain in parent currency the same value as in entity currency. This is the case for all movements, except for the openi…Erik De Rouck 32 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Rename the description within ECMAIt is possible to rename member name within ECMA to avoid member name clash. Is there any way also to "rename" the description within ECMA as well?Kenneth Kwok 31 views 2 comments 0 points Most recent by Kenneth Kwok Financial Consolidation and Close -
Numbers not getting rolled up to its Parent for few movement members (non-seeded)Summary: We have created several custom members in movement dimension for cashflow reporting, but we noticed that numbers does not roll up to its parent for few of the m…HarryEPMUser 21 views 6 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Best practice approach to adding a custom dimension to an existing FCC applicationSummary: We need to add a custom dimension to an existing FCC application which means we will have to recreate the application from scratch. Are there any best practices…MCV 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Change of Sparse to Dense dimension.Hi There, What happens if we change the sparse to dense dimension and vice versa in FCCS for certain dimensions? Can anyone tell us what's the impact on the system and t…Sneha Mallick 33 views 5 comments 0 points Most recent by Sneha Mallick Financial Consolidation and Close
-
When I export metadata from FCCS for account dimension the Account type is coming as blank.For the Preceded members (that start with FCCS_) in Account dimension of FCCS when I export the metadata the account type is blank in the .csv file. Where as in the syst…anusom 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Cannot use pipeline with EDM if you do not have the EPM Enterprise SKUSummary: It appears you cannot execute the EDM commands from FCC if you only have the STANDARD sku for FCC Content (please ensure you mask any confidential information):…Stuart.Porad 51 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Retrieve Entity currency in Essbase RulesSummary We need to obtain the entity currency of the current entity being processed to compare that against a list of currencies.Content In HFM you could extract the cur…Brian Butler 96 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS - "HFM Entity details option"??Summary FCCS - "HFM Entity details option"??Content Hi All, As in HFM if I right-click on any transaction it will show the option of "Entity Details" where we will get a…amaresh salagundi-Oracle 39 views 3 comments 1 point Most recent by SR912 Financial Consolidation and Close
-
FCCS Seeded Account Alias Extraction IssueSummary: Hi everyone, I'm encountering an issue while extracting the FCCS account dimension. When using the Application -> Dimension -> Export option, the "Default:Alias… -
Create drill regionSummary: Hello, now that we've migrated our EPM environment to Gen 2, I am unable to find the option to enable "Create Drill Region", as this is no longer available from…
-
Need a solution to change the Qtr rollups in the Period dimension for a 12 month calendarSummary: Need solutions to change Qtr rollups in the period dimension. Content (please ensure you mask any confidential information): Client requires Q1=Jan,Feb; Q2=Mar,…Dale Joosten 21 views 2 comments 0 points Most recent by Dale Joosten Financial Consolidation and Close
-
Entity Dynamic Calc SetupSummary: We have Custom1 as Dept and Custom2 as Loc where the Parents are setup as Dynamic Cal so if there's movement for these members to new Parents, we don't need to …Greg Hull 22 views 1 comment 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
FCCS Metadata Validation ErrorSummary: We are encountering the following Metadata Validation error in our standard FCC application: "The Data Storage should be Shared, Never Share, Store for Level 0 …Priyanka Bhat 42 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unable to delete/modify a custom Period member in FCCSSummary: I have a custom Period member which is a child of the dimension. The member also had children that were moved under a different parent. I would like to delete t…Priyanka Bhat 13 views 2 comments 0 points Most recent by Priyanka Bhat Financial Consolidation and Close
-
Maximum level of nodes for each dimension before performance degradationSummary: Does Oracle provide any guidance on maximum level of nodes for Account, Entity, Customs before performance degradation may occur? Content (please ensure you mas…Valerie Fisher-279201 41 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
units * price in FCCSI'm familiar with Essbase and Planning but now I'm struggling with the setup up a units * price mechanism in FCCS. Both units and price are inputs, the revenue total sho…Erik De Rouck 31 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How can I assign the (shared members) below the Alternate "Hierarchies" in Approvals?In approval unit while selecting the primary members, I can select all members for the (Main Hierarchy which is "Total Geography"), But also I need to apply the same on …Eman_Elbayadi 31 views 1 comment 0 points Most recent by Pavan-Oracle Financial Consolidation and Close -
Does anyone have configConsolWithThreadVar SV in their environment and know what it is used for?Summary: Does anyone have configConsolWithThreadVar substitution variable in their environment and know what it is used for? Content (please ensure you mask any confiden…Casey Kempel 72 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS DSO cube performance assessmentSummary: My client is updating their COA with a lot of nominal accounts and multiple reporting hierarchies with shared members in FCCS and even with the standard DSO opt…JulieLoretto 31 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Duplicate aliases/member names not being picked up in metadata validationSummary: One of our users was unable to post a journal after a recent deployment it turns out we had a conflict because of duplicate aliases in the same dimension, In th…Jeremy Stubbs 13 views 2 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close -
Hide attributes dimensions from member selectionSummary: The FCC administrator would like to hide the attribute dimensions so that it does not appear in the member selection dialog box. Content (required): The attribu… -
Will Proportion Consolidation Member be available in Entity Currency for children?Summary: We have base level entities that are consolidated or not consolidated on a given month that are based in a foreign currency. The parent is USD. We would like to…Casey Kempel 61 views 5 comments 0 points Most recent by Shailesh Kumar -Oracle Financial Consolidation and Close
-
Data input for FCCS_Amount OverrideHi There, Input of data is permitted for the parent entities across all periods at FCCS_Amount Override for all the users. Can someone explain why this is the case? Shou…Sneha Mallick 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can you change the intercompany report to show just entity and not [parent].[entity]Summary: Is it possible to get the intercompany report to use just the entity name even when there are alternate entity hierarchies? Content (please ensure you mask any … -
Parent Entity Movement form one parent to another parentHi, I have a scenario as below. Currently Parent B is directly rolling up to Parent A but when we introduce new Parent A1 in between A and B then we are facing the same …Narinder Arora-162322 81 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Validate Metadata - Variance ScenarioSummary: Hello, we are trying to create a new scenario to do a variance between the actual and the budget that are in FCCS. We are doing it with a member formula and the…
-
FCCS: When creating a new member in custom dimension it says "Object with name already exists".Summary: FCCS: When creating a new member in custom dimension it says "Object with name Saudi already exists". However custom dimension does not have any member named as…Sneha Mallick 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How To: Check if Member Already exists in a DimensionSummary: Today, in FCCS or for that matter any EPM Cloud service that uses Essbase, when we try to create a member in a dimension, and if it already exists, then dimensi…Ashutosh Bhatikar-Oracle 154 views 0 comments 1 point Started by Ashutosh Bhatikar-Oracle Financial Consolidation and Close