Create Views and Viewpoints
Discussion List
-
Create subscription to subscribe only '2' series EntitiesSummary: Is it possible to create subscription to subscribe only '2' series entities from source to target in Oracle EDMCS? Content (please ensure you mask any confident…
-
Disregard.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Subscription not working for Delete ActionSummary: The requirement is to set up a subscription between FCCS and Planning viewpoints for common sub hierarchies as part of Alternate hierarchies. Both the FCCS and …
-
When planning flag is set to TRUE subscription is not getting triggeredI have a node condition in place which will check whether planning flag is TRUE and only those nodes are included for subscription. For those members which already exist…Varun Yegnam 21 views 2 comments 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management
-
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
-
combination node typeSummary: How can a combination node type be used to represent more than one dimension as a combination (just like Account combination) Content (please ensure you mask an…Divye Taneja 11 views 1 comment 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management
-
Is there a way to generate request item base on Descendant Property valueSummary: Below is the example: A A|A1 A|A1|A11 If we set flag property value as True on base level which A11 here then subscription request need to generate to add All t…
-
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
-
I want to copy EDMCS Prod to Test, however, I have configurations in Test that I want to bring backSummary: I want to copy EDMCS Prod to Test, however, I have configurations in Test that I want to bring back after the migration since they are not in production and I a…
-
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…
-
Creating a property that looks up and allows users to select from a node type in a different appSummary: I want to create a property in an application called Humana - TTT with a node type of "COID". I want this property to look at the hierarchy/node type COMPANY in…
-
Property not available in the expression builder for deriving the value for Property of Top MemberSummary: We currently don’t have custom 1 as property to be selected in the expression builder for deriving the value for the custom 1 top member against the cMAS_OCM_3S…Chad_Hooper 11 views 3 comments 0 points Most recent by BBrocklesby-Oracle Enterprise Data Management
-
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
-
How to define approval based on Requester?Summary: Hi Team, We want to trigger approvals based on Requestor/Submitter in EDMCS. Kindly confirm how to define the same. Regards, Anisha Content (please ensure you m…
-
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…
-
Pushing duplicate members without any PCMCS validationSummary: Content (please ensure you mask any confidential information): Hi All, We are comparing GL functional center (FC) and PCMCS functional center (FC) viewpoints in…
-
Node Condition Expression to Exclude Top parent Nodes in Compare ProfileSummary: Content (please ensure you mask any confidential information): Hi All, I'm new to EDMCS and beginner in writing EDMCS expressions. We are comparing viewpoints w…
-
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…
-
EDM node deletion processHi Team, In our EDM application we had Hierarchy and we have deleted the nodes from the Actual Hierarchy but in backend i mean there are places still the nodes are being…
-
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 51 views 5 comments 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management
-
Performance Issues with large hierarchies?Summary: Hi, Will having a dimension with 100k nodes pose any performance issues? At what point would large hierarchies be an issue? Content (please ensure you mask any …
-
Drill Through Error "No drill-through reports found at this location"Hi everyone, im having the issue related to Dril-through and i already follow alot of steps and still not woking, can someone help by a guide or something related please…Caio Silva 141 views 16 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
REST API -Upload a request item fileSummary: REST API- Script for upload item file to a request does not seem to be working using powershell. Content (please ensure you mask any confidential information): …
-
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
-
Alternate hierarchy is not updating the values for top nodes.Summary: Alternate hierarchy is not updating the values for top nodes. the hierarchy is using same node type, same hierarchy set but different node set. If we update the…
-
Place a new account in multiple hierarchies at once.We have multiple Viewpoints (A Viewpoint per Hierarchy) for Account Dimension. Whenever there is a request to add an account, we have to add that account multiple times …
-
Node Converters allowing combining/conversion of String type to List TypeSummary: Node Converters allowing addition of String type to List Type or combining of 2 List Types Content (please ensure you mask any confidential information): Hello,…
-
How do you clear out a Lookup Dimension?Summary: Hi, We're discovering when loading data to a lookup dimension, the replace doesn't clear out existing data. Has anyone had any success clearing out the data so …
-
How do you compare Accounts between Fusion and FCC?Summary: Fusion has Accounts without prefix For example, 1010000 FCC has Accounts with prefix For example, AC_1010000 I've created an Account View with two View Points (…