05-26-2022 04:34 AM
Team
I have 2 concerns:-
Regards
Varun
Solved! Go to Solution.
05-26-2022 08:25 AM
Hi,
1. Your account members appear in gray as they are inherited at Account_VK level. Please access these at DRM_Account level to edit. Kindly read about extensibility feature of OneStream.
2. XML load is easiest to delete bulk metadata members along with their relationships. If selecting bulk members looks tedious to you, pull just one member in XML and then edit this XML in notepad++ to add additional metadata members you want to delete.
Alternatively you can write a system business rule to remove the required metadata members along with their relationships.
05-26-2022 06:20 AM
Hi,
1. For this point it is not clear where are you seeing the account members in read only mode, is it in a cube view or spreadsheet or form template or journal template. Check basic things like "Allow Input" property should be true for those accounts. All other intersections like origin, entity, etc should be base nodes. Workflow channel should be appropriate to allow input.
2. Refer to KB article for mass deleting metadata members:
https://onestreamsoftware.service-now.com/sp?id=kb_article&sys_id=2ce683b7dbd3a380a5405eea4b961949
You can also explore ACM marketplace solution for this.
Hope this helps.
05-26-2022 06:39 AM
Thanks Bharati for your response.
05-26-2022 06:58 AM
Hello,
1. Still not clear on which screen are you seeing the accounts as read only.
2. Please read the second method mentioned in KB article "Use the Load/Extract Metadata feature in OneStream".
https://onestreamsoftware.service-now.com/sp?id=kb_article&sys_id=2ce683b7dbd3a380a5405eea4b961949
05-26-2022 07:09 AM
Hi
Please see the attached screenshot for 1 & 2.
#1 - Application > Dimensions > Account Dimension is the screen am refereeing to
#2 - Pls refer screenshot
05-26-2022 08:25 AM
Hi,
1. Your account members appear in gray as they are inherited at Account_VK level. Please access these at DRM_Account level to edit. Kindly read about extensibility feature of OneStream.
2. XML load is easiest to delete bulk metadata members along with their relationships. If selecting bulk members looks tedious to you, pull just one member in XML and then edit this XML in notepad++ to add additional metadata members you want to delete.
Alternatively you can write a system business rule to remove the required metadata members along with their relationships.
06-01-2022 04:28 PM
For #2, If data exists for these orphan members, Will this remove member work even without clearing the data?
06-01-2022 11:37 PM
Hello,
Please try this on a dummy member having data and observe the behaviour. I have not used this routine myself so not sure of the result at present.
Thanks
06-02-2022 10:29 AM
Using the Load/Extract Metadata feature in OneStream to delete member fails if data is present for the member which we are trying to delete, so i guess it should behave in similar way even with routine but let me try and check
05-26-2022 09:44 AM
Thanks a lot !! I was able to get to the point#1.
Am very new to the OneStream.. If you can share a sample business rule to delete members/hierarchy, that will help please.