Background Orphan members in OneStream are the members with no parent. Due to this, they are bit difficult to locate using Search Hierarchy feature, since technically they do not sit anywhere in hierarchy. They even do not get captured in grid view. Sometimes, an organization might want to delete them as they are no longer […]
Posts Tagged ‘metadata’
Data Virtualization with Oracle Enterprise Semantic Models
A common symptom of organizations operating at suboptimal performance is when there is a prevalent challenge of dealing with data fragmentation. The fact that enterprise data is siloed within disparate business and operational systems is not the crux to resolve, since there will always be multiple systems. In fact, businesses must adapt to an ever-growing […]
How to Query & Extract data from OneStream metadata XML using XPath & XSLT
Background OneStream supports exporting metadata into XML file for backup and restore purpose (via menu Application > Tools > Load/Extract). This blog covers technique to extract this information from metadata XML using technology named XSLT (eXtensible Stylesheet Language Transformation), which can read XML hierarchy & extract information from it. Tools Required Microsoft Visual Studio […]
Make EDMCS Approval workflows easier with Policy filters
Approval policies in Oracle Enterprise Data Management Cloud Services (EDMCS) enable approvers to review requests and approve or reject their contents. You configure the request by specifying who can approve the request and how many approvals are needed. You can define these policies on an EDMCS application or on each individual dimension within. In most […]
VIDEO: Sitecore Content Hub DAM Admin Training
Since Sitecore Content Hub emerged, a lot of content marketers, including myself, wanted to learn more about the new addition to the Sitecore family. The combination of Digital Asset Management (DAM), Product Content Management (PCM), Content Marketing Platform (CMP) and Marketing Resource Management (MRM) tools certainly sounds like a great source of truth. One that […]
The Value of Data and 5 Things We’ve Learned From COVID-19
First of all, big kudos to first responders such as doctors, nurses, police, front-end-shop staff, and mental health workers for keeping your communities running during these troubling times. At the same time, my heart felt condolences for anyone who has lost a loved ones during this time. One of the things that the COVID-19 pandemic […]
Update Member Relationship in OneStream XF
In my previous blog post, I demonstrated how members meeting the appropriate criteria could be deleted from an OneStream XF application with a XML file. In this blog, I will demonstrate how a member relationship “parent / child” can be deleted and more importantly changed using a XML file which is a necessary part of […]
Mass Delete Members in OneStream XF
During one of my previous projects, we needed to delete approximately 200 accounts that were distributed throughout a large Account dimension. This blog discusses how we solved it. One approach would have been to delete each account one time. Obviously, that wasn’t appealing as it is time-consuming and can be prone to error. Another approach […]
Enabling Checkboxes in AEM Assets Metadata Schema
Recently, a client requested I add a checkbox in AEM Asset’s image metadata schema. Surprisingly, checkboxes are not a field type in the OOTB metadata schema editor field options. After further investigation, I found that AEM list of OOTB form fields for metadata schemas includes a checkbox, but we cannot use the field as it […]
Governance in Healthcare: Ownership and Consistency
Democratization of Ownership and Stewardship The rise of big data, self-service, and more powerful and flexible end-user information visualization and preparation tools, consumer/ member/patient experience is impacting governance in a significant manner with regard to structure, decision rights, and accountabilities. End-users are gaining more control of these assets, including the ability to integrate and manipulate […]
Handling Site Metadata with SXA Modules: Part 1
Background If you’re using Sitecore 9.0+, chances are high that you’ve heard of or are currently utilizing Sitecore Experience Accelerator to accessorize your instance. In my opinion, one of the better things to come out of SXA is the use of modules to add discrete amounts of functionality to a tenant or site by leveraging […]
Responsibility of Data Architecture in Data Governance
The data architecture capability will supply the components and standards necessary to implement other capabilities coherently and enable them to work together. A primary responsibility of data architecture is to define and have an accepted enterprise-wide set of models, standards, glossaries and hierarchies which allow a standard description of data across business lines, products and […]