Use Views and Viewpoints
Discussion List
-
How can I create an extract that pulls from a specific spot in a viewpoint?Summary: Need to create extract to pull from specific node in a viewpoint Content (please ensure you mask any confidential information): I have a viewpoint called Accoun… -
I am using a lookup dimension for a property but cannot use it for a filter in a Query?Summary: I am using a lookup dimension for the user to select a COID for a specific property. Since the table is very large and we cannot sort the list viewpoint by COID…John Burton 49 views 9 comments 0 points Most recent by BBrocklesby-Oracle Enterprise Data Management -
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 17 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 15 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…
-
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 27 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…dmpnyc2 45 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 22 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 12 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 11 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 32 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…Sergei Pecherskyy-Oracle 11 views 1 comment 1 point Most recent by KiranTR-Support-Oracle Enterprise Data Management -
sumitkumar 22 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 33 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 52 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