Answer Although this is possible either by loading the file via a dashboard or calling the SQL text in memory via the business rule itself, it is not recommended as it violates the audit trail functionality within OneStream as no changes to the rules...
Answer If there is a consolidate elimination, there is an elimination finance type that can be utilized. You can utilize a set data cell, set data buffer, or api.data.calculate inside the finance rule. The api.data.calculate is similar to hs.con. Sou...
Answer You can sum YTD through the view but not by days in a month, unless you have the days in a UD member. Source: Office Hours 2020-04-23 Partner Enablement
Answer Write a calculation on the member filter of the dimension member. You need to sum all the prior years together in the calc. Source: Office Hours 2020-04-23 Partner Enablement
Answer See examples in the attached slides: Source: Office Hours 2020-04-09 Partner Enablement
Answer Transformation rules can be set-up to map the time range period in order to load only applicable periods. Use a global variable in allocation methods to allow dynamic period selection for loading. Source: Office Hours 2020-02-13 Partner Enable...
Answer No, you would need to create a custom DSO calculation (example overleaf, based on Design & Reference Guide, pages 34-35). Source: Office Hours 2020-01-31 Partner Enablement
Answer The DSO formula uses the standard countback methodology, rounded to the nearest full day. Therefore, the P&L account view is fixed to Periodic and the BS account view Periodic/YTD. As a dynamic calculation, you will see the same figure no matt...
Answer The number of days in each period will reflect whatever has been defined in the time profile (found within the application tab). Calendar Months will show the standard days per month but you can customize the month type or start date for each ...
Answer No, not currently. The Object search is limited to the object types shown in the figure. You can submit an enhancement request to have additional objects added. Source: Office Hours 2019-11-26 Partner Enablement
Answer It is always recommended to specify as many members as possible. Any members not specified for dimensions not applicable will default to the “None” member. Source: Office Hours 2019-11-26 Partner Enablement
Answer There are different options options: •Expand the number of “Grid Rows Per Page” for the User on System tab in Security (default is 50 but could go up to 1000) •Use a business rule to extract •Use the standard Import dashboard for displaying al...
Answer Yes, you can do this by dragging the freeze bar from the left side of the grid across when viewing in Data Explorer. Source: Office Hours: 2019-08-22
Answer This is a function of the Excel settings when last using an import of CSV data. Make sure comma is not the active delimiter choice in Excel…you can check by highlighting data & selecting “Text to Columns”. Source: Office Hours: 2019-08-22
Question (cont) For example we have certain Balance Sheet accounts that have certain Flows they can go to, the user wants to see a constrained list. We obviously have the use of journal templates or excel but customer would rather see in the OS journ...
Question Is there a way to persist objects in memory across a particular session. Specifically, related to Specialty Planning and transforming time periods, which are dynamically based on the workflow scenario & year into the proper cube periods. Now...
Question Answer General approach is to use a Custom Calculation function so that you can limit the calculations to what is actively displayed on the forms. Disadvantages of this approach: •By not having the calculations on member formulas, you lose t...
Question Example: In the balance sheet it might happen, that the plug account of the elimination is part of the equity accounts. In equity, I have a detailed movement table with additions and disposals where the receivables and payables support openi...
Answer Use the “GetLastPeriodInPriorYear” function instead:
Question Answer: : No, not at this time
