How to place multiple UD1 members in Account dimension UD1 constraint
Hello OneStream experts: Thank you for the helps in the past. I have a quick question about place UD1 members in Account dimension UD1 constraint For example: In my account metadata dimension: I have 2 accounts 4001-Sale_IceCream 4002-Sale_Donut In my UD1 product dimension: I have 4 products all under one parent product Product_1,Product_2,Product_3,Product_4 I want to place Product_1, and Product_3 to the UD1 constraint in account 4001-Sale_IceCream's UD1 constraint field. But OneStream only allow me enter one product member in that filed. I can only enter Product_1 but cannot enter both Product_1 and Product_3 in the field. Thank you so much in advance to help me get through this issue.Converting Historical Data
We are in the process of changing our chart of accounts and department structure (for us, UD3 and UD1, respectively). Further complicating things is that some of the old UD3/1 members will likely be consolidated into one UD3/1 member, and vice versa. We will need to keep the existing data in its original intersections (e.g if UD3#ABC changes to UD3#123, we need the historical data to stay in UD3#ABC). Or do we? We currently map each of our 3 different GLs* in UD3 to accounts in the A# dim which is at the P&L/BS level. Has anybody out there done this before? What approach did you take? Can we simply create new transformation rules and somehow reference the old ones for historical data? Do we simply create a new hierarchy in UD3 for the new members (bloat?)? If so, how do we reference them in dashboards and cube views that compare past and present data? I have so many questions as to the best or simplest way to do this. Bonus points if they are one and the same. --Brooks *Only one GL is changing
Extracting entity hierarchy without constraints
Hi! Is there a way to extract the entity structure without constraints? In the current entity structure, every entity has a different UD1 constraint, but I need this to be set to Root for all entities when loading it in the other application. I know in Notepad++ you can use find/replace to modify this, but because every entity has a different UD1 constraint, it is still quite a manual process. Wondering if there is a more efficient way. Thanks in advance!
Data Audit Dashboard
Hi All, I am trying to create a dashboard to extract the data for the given point of intersection basically I have given all the dimension parameter for the user to select and click on the button download that runs the DataManagement job and will extract the data for the selected POV . I am able to achieve the above requirement just like an enhancement I want to also get the data of the user details who has loaded data into those point of intersection. Can some one help me with the lead how can I achieve the above user details that would be really great. Thank YouMetadata UD3 dimension update
I need to make some changes to the UD3 dimension hierarchy member names and was wondering if there is a way I can do a mass update. For example, the coding used for UD3 name OLD_XXX will need to change to NEW_XXX. There’s ~266 members I need to update and many more to come. Can you please advise if there is an easy way to make this change? Thanks!
