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 41 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 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 12 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 22 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