Scenario Type - Tax
Hi, What are the major considerations that need to be looked at before making a design decision for implementing "Tax" Scenario Type? What are the pros and cons of using this Scenario Type vis-a-vis "Actual" Scenario Type? Is there any guidance/ knowledge post on the same? Use Case: Want to integrate an erstwhile Tax application into OneStream Application where actuals are already available. The tax application has some additional tax related dimensions, rules, etc. which need to be used in OneStream.127Views0likes1CommentExtensibility 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 ManojSolved387Views0likes3CommentsChange of reporting period for entity (From Jan- Dec to Apr-Mar) in OS
Hello All, Is there a functionality ofChange of reporting period for entity (From Jan- Dec to Apr-Mar) in OS. For Example, if currently I am working for FY Jan to Dec but in future, I want my FY to be changed to April - Mar, so how can I achieve the changes without getting any impact in the historical data?464Views0likes6CommentsConsolidation stopped working
The client's consolidation stopped working on their top member after a specific point of time. From their earliest data point through 2023M11, it works fine. From 2023M12 forward it will consolidate only up to the members directly below the top parent. Nothing else has changed, except the data source. This was working as of a couple of days ago and suddenly stopped. I can see it running calcs fine, but the numbers in regular accounts do not roll up. Any thoughts? I've checked all the properties I could think of and turned off all calculations, but nothing helps.1.1KViews0likes6Comments-Ve Actuals in Oct TImeperiod
I have stats account, user is input the numbers for September Time period at base level in Actual scenario for Periodic combination and the -ve number are showing in October TImeperiod. that -ve number is YTD of September. as user is requesting to clear that October Actuals -ve data. Is there way that we can delete and also, I am surprised how this -ve number flow into the Oct Time Period. The flow is EndBal_Input. users are entering the number from quickview. Any suggestions to solve this issue?166Views0likes1CommentChange the Entity relation property from Dashboard
Hi, Good Day ! I would like to change the Entity Relationship property from dashboard. When the user clicks the button, the metadata associated with the entity relationship property should be updated to reflect the option the user has chosen from the dropdown menu. Can you please help me how can I achieve this requirement. Thank You328Views0likes2CommentsCube/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, Gaurav427Views0likes2Comments