Newly created dimension member not pulling in data
I created a new dimension member as a child of our direct_department member in UD2. I have updated all of the transformation rules and mirrored the member properties of its siblings. I have loaded this month's data which includes the new department and none of that department's data is showing up following the load/transform process. I'm not receiving any errors either. Has anyone experienced this or has an idea of where I can look to resolve the issue?Solved14Views0likes2CommentsExtensible dimensionality for different scenarios Account dimension
Hello, everyone, Could you please advise if we will need for Budget scenario more detailed accounts, than for Actual scenario, am I right that it will be solved by the following way: Create second Accounts dimension Apply this new Account dimension to Budget scenario on tab Cube Dimensions in Cube Could you please also advise how to copy existing Account dimension members into new Account dimension (as the first step before members updating for Budget scenario)?Solved32Views0likes2CommentsExtensibility Question
I have a Summary & Detailed Account dimension. The Detailed Account dimension extends from Summary dimension.Ex Account Dimension Cash Summary A Detailed B Detailed C Detailed I have a Cube where I have set the Cube dimension Properties of a Scenario to use the Summary Account dimension. I was able to load the data at Cash account level as shown above. However when I retrieve the data with BalSheet.Base , OS still treats A,B,C as base member instead of Cash and show up no balances. When I specifically identify A#Cash I get the balances I loaded. Is this expected behavior that OS doesn't treat "Cash" as Base member from Summary Account Dimension? If so is there a solution to retrieve the Cash account as Base. Thanks ManojSolved396Views0likes3CommentsSQL_Table Editor
Hi All, I have trying to get the Combobox type of drop down in the custom created data table . SQL Table Editor Searchable Drop-Down List (onestream.com) The above link the documentation to achieve that requirement however it does not work even tough i follow the instruction given in the document. Below are the screenshot of my datatable and parameters. Kindly help me to achieve this requirement . Thank YouSolved918Views0likes11CommentsCube/Metadata Design Question
We are building a Consolidation application with 10 Base Entities and approx. 2000 Cost Centers. Each Cost Center is valid for only one Entity. In Other words a group of Cost Centers are valid for One Entity and the same group of Cost centers are NOT valid for any other entities. Given this requirement is it best approach to create Separate cubes for the 10 Entities and apply Extensibility on Cost Center dimension with Valid Cost centers for the Entity OR Create One Cube and apply UD Constraint on Entity with the Group of Valid Cost Centers ? Appreciate any thoughts or recommendation between these 2 options.Solved972Views0likes5CommentsNew Cube vs Scenario Type in Existing Cube
Hello, What are the factors one should consider while deciding between whether to create new cube vs using new scenario type in existing cube for different processes like Forecast/Budgeting etc. Will creating new scenario type would put any performance issues on existing processes (say for Actuals)? We don't use any extensibility currently in application, and only using Consolidation (Actuals) with Account recs. Thanks, Gaurav438Views0likes2CommentsMoving account dim member with extensibility from one hier to other
Hi We have an account dimension with extensibility applied. Say first level is Forecast where we capture 4 digit accounts. Forecast is then extended to Actual where we capture 8 digit accounts. Now the requirement is to move one of the 8 digit accounts to Forecast level. Is this even possible and how can we do this if yes? Thank you, MikkiSolved361Views0likes1CommentHo to extract a hierarchy for any dimension in Level format in OneStream?
Originally posted by Vignesh Mohan Hi, How can we extract the hierarchy of any dimension in an excel in a Level based format starting from top most level to the bottom most level for every base member ? Basically I do not want a Parent-Child format extract. Please find the attachments for the sample screen shot.2.2KViews2likes3Comments