Extensibility 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 ManojSolved387Views0likes3CommentsSQL_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 YouSolved913Views0likes11CommentsCube/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.Solved963Views0likes5CommentsNew 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, Gaurav427Views0likes2CommentsMoving 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, MikkiSolved355Views0likes1CommentHo 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.2KViews2likes3Commentschange Workflow Status from data management
Hi all, I use the dashboard to trigger data import from external database. After successfull import I want to make the workflow step (type Workspace) complete by callingSetWorkflowStatus. Strange thing is that is does work when I directly call the Extensibility rule from Button, but it does not when I call the same rule from data management process. Do you know why this happens and how can this be bypassed? Thanks for help! Pavel1.4KViews0likes6CommentsExtract full extensible dimension
Hello, Let's assume we have an extensibility on the dimensions account with 2 cubes. When we need to export the dimension account, we are only able to export the accounts for the 1st cube, and the accounts for the 2nd one (two files). Is it possible to export the full account hierarchy (within a single file), with a field specifying the associated cube ? Thanks for your support, HarrySolved1.6KViews0likes6Comments