Use Views and Viewpoints
Discussion List
-
Validation on All Ancestors to fails to stop Remove actionSummary: Have Validation that checks a base account node is in two key Hier, by counting hits in AllAncestors where "name starts with"… "Global Accounts (" = 1, and equa… -
Deletion of a node within the OCGL application for accountSummary: I thought, at one time, I was informed that it is not possible to Delete a bottom level Account Node within the EDMCS OCGL application, thus the OCGL. We had so…John Burton 11 views 1 comment 0 points Most recent by BBrocklesby-Oracle Enterprise Data Management -
How are other overcoming the hurdles of list viewpoints (crosswalk tables)?Summary: Up until very recently Humana has been maintaining OCGL hierarchical structures and some small list viewpoint leveraged for mappings and crosswalks. Now EDMCS i… -
How to limit access or seeing a viewpointSummary: Is there a way to limit the access to the viewpoints that a users has if the user needs to have access to the Dimension the Viewpoint is built on? For example, …John Burton 11 views 2 comments 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management -
Does the excel batch upload template no longer need the node type?I noted the other day that I was doing an excel batch upload in the test environment for a list viewpoint and accidently left off the node type (only one node type in th… -
equivalent nodes filterSummary: Hi, We have Balance Sheet and Income Statement rollups in the same hierarchy and viewpoint. We also have 2 alternate viewpoints for BS and IS. We've tried to us… -
Now that the Name prop can be stored and calculated is there any way to hide the propertySummary: Now that the Name prop can be stored and calculated is there any way to hide the property from the Viewpoint. Content (please ensure you mask any confidential i… -
Email report with select propertiesSummary: Team, How do we email out /notify a select group of users from EDM directly with only few specific properties when a new request is created ? .The current notif…Rajshri R 11 views 1 comment 0 points Most recent by EDCMS Support-Oracle Enterprise Data Management -
Logo, Banner and Color theme in EDMCSSummary: How to add Logo, Banner and Color theme in EDMCS Content (please ensure you mask any confidential information): Version (include the version you are using, if a…joelroshan92 11 views 3 comments 0 points Most recent by LeelaKumar-Oracle Enterprise Data Management -
Node Relocation in the source creates duplicates in the targetSummary: Content (please ensure you mask any confidential information): Hi All, We are comparing entity (app1) to entity (app2) in EDM and is enabled for shared nodes.Ou… -
Alias property is not updating in PCMCS with merge Import using subscriptionsSummary: Content (please ensure you mask any confidential information): Hi All, We are importing ERP account dimension with merge mode and subscription is created to aut… -
How to get new custom property column in EDM Export File?Summary: Get new custom FCC property as column in EDM Export File Content (please ensure you mask any confidential information): We created a new custom property in EDM … -
Changing a Property from Derived and Stored to DerivedSummary: I have noted that Derived and Stored does not recalculate if there is already a value in the input. This becomes an issue when the request is not an updated but…John Burton 21 views 5 comments 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
Node Prop ValueSummary: Is the DRM concept of Node Prop Value on the roadmap anytime soon? Content (please ensure you mask any confidential information): Version (include the version y…User_2025-11-28-00-40-57-291 41 views 11 comments 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management -
Is there a way to search for a "sibling" node in a list viewpointI want a validation that searches the other nodes within a viewpoint table/list . I do this when the viewpoint is a hierarchy by using siblings and ancestors. How can I … -
How to generate a parent and its child through a subscriptionSummary: What is the best way to update a viewpoint, creating a new parent and child each time through a subscription. Content (please ensure you mask any confidential i…John Burton 21 views 1 comment 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management -
How can I check the entire hierarchy in my RegexSummary: I want to create a validation that checks the entire hierarchy for specific values. For example, if a user has a request to ADD Geography H001, I want to check …John Burton 11 views 2 comments 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
Shared node generation with subscriptionSummary: How to generate a node and it's shared node with subscriptions Content (required): I am trying to set up a subscription within EDM that will generate not only t… -
What is the upper limit for the number of records we can load via Viewpoint Load vs Merge ImportSummary: We are trying to do an incremental load from an external application into EDMCS (It is a list viewpoint). The load will be around 150,000 records. We want the s…Anisha Mohanty-256661 31 views 2 comments 0 points Most recent by Anisha Mohanty-256661 Enterprise Data Management -
Delete Orphan NodesSummary: What is the best way to delete an orphan node? We can delete the orphan node after we add it back to a hierarchy, but is there a way to delete the orphan node w… -
How to assign the values/actions to Operation Column in EDMCSSummary: Content (please ensure you mask any confidential information): Hi All, We need to assign some values /action (Update,Delete) to the "Operation" column in our EP…Ayeshan 31 views 7 comments 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management -
While searching a member in View, the member name is postfixed with (2), what does it signifies?Summary: When We are searching a member in the viewpoint, the Search result is returning member name along with (2) post fixed. What could be the reason? Content (please… -
What is the best way to create or differentiate unique records when creating and loading to a table?Summary: There is new development for Humana's EDMCS tool. Up until this point EDMCS has been governing and maintain the Chart of Account structures, with unique and dif… -
Learn how to access data in a node set from a historical point in timeSummary: Watch a new video to learn how you can use them to solve your data integration needs. Content (required): Working with Time Labeled Viewpoints In this video, yo…Sergiy Pecherskyy-Oracle 12 views 1 comment 1 point Most recent by KiranTR-Support-Oracle Enterprise Data Management -
sumitkumar 91 views 1 comment 0 points Most recent by KiranTR-Support-Oracle Enterprise Data Management -
How to enable approval workflow using tree hierarchy structure in EDMSummary: Approval Workflow policy using a hierarchy structure Content (please ensure you mask any confidential information): The customer would like to follow the tree h…Krishna_0601 41 views 1 comment 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
Creating nodes into different parents in multiple hierarchies in EDMCSWe would like to create a node that will be introduced under a parent for Base hierarchy and it should be created under a different parent for a different hierarchy auto…Suriaraj.Krishnamurthy 71 views 5 comments 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management
-
Option to delete converted member when deleting base member?Summary: Hi All, I was wondering if there is a feature or methodology which allows you to delete converted members via subscription, when the base member is deleted? Exa…DylanPauwels 11 views 1 comment 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management -
Validation on alphanumeric EDMCS attributeHi Team, We want to apply a validation on alphanumeric fields which contains alphabet and numbers. We want to extract the number from the string and apply validation on …Shrikant Bambaras 21 views 1 comment 0 points Most recent by Rahul Kamath-Oracle Enterprise Data Management -
What is the best way to add an existing viewpoint to the FCGL app and its exportWe currently have an alternate Geography/Market Viewpoint that leverages the same Geo Dimension as our primary FCGL structure. It wasn't until recently that I realized t…John Burton 41 views 2 comments 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management