Question: Can historical override balances be calculated differently based on account/currency?
Answer •Yes, but this is highly dependent on your specific application’s financial model and flow dimension design. Source: Office Hours 2020-06-04
Answer •Yes, but this is highly dependent on your specific application’s financial model and flow dimension design. Source: Office Hours 2020-06-04
Answer •The quickest way is to load the mappings into a new group and delete the group if no longer needed. •Currently, the functionality to bulk delete mappings is not available. Source: Office Hours 2020-06-04
Answer •Change the inventory table to Allow Multiselect = True. •This allows multiple lines to be selected for deletion. •This setting should be changed back immediately after deleting in bulk. Source: Office Hours 2020-06-04
Question •When comparing the difference in balance between the two periods to determine if the account is eligible for auto certification, does the system require that the previous period is in a completed state?•Or is OS simply looking at the differ...
Question Answer •It is possible to pass parameters from the task manager execution screen into a custom dashboard using a custom task. •An example of this can be found in the Task Manager Setup Instructions (UTM) within the Tasks section.
Answer •See the following slides from the Level 2 Rules training regarding the ConvertDataBufferExtendedMembers function. Source: Office Houses 2020-06-18
Answer •Generally, derived values are dependent upon Scenario No Data zero view settings or overrides to the Account No Data Zero View Settings which dictate how the system interprets the lack of data on an intersection basis. •In cases like the belo...
Answer •Yes, it is possible. Change the inventory table to Allow Multiselect = True (see screenshot) and you will be able to select multiple records. •This setting should be changed back immediately after deleting in bulk. It is recommended to use th...
Answer The DUC processes completes each formula pass for all dimensions before moving onto the next formula pass. •This ordering can be seen when you run a Calculation with Logging: The full calculation sequence is as follows: Clear previously calcul...
Answer There is a knowledge base article detailing where the URLs are stored. (KB0010872) https://onestreamsoftware.service-now.com/sp?id=kb_article&sys_id=591346c31bf0085060122026ec4bcb47 For ease of reference, the list of excel URLs will be found i...
Answer There are a number of knowledge base articles related to the Excel add-in (Category: Excel Add-in). Without details on the error message being received, we would suggest looking through these articles. If the KB articles do not assist, raise a...
Answer By default, any dimension set as an aggregation will return the name field, however, this can be modified within the aggregation controls. Using one of the following at the end of the aggregation control will replace the label: N – Name D – De...
Answer One option to be able to see all relevant intersections is to increase the Grid rows per page for the user. This would allow up to 1000 rows to be shown per user. Alternatively, the intersection errors are stored to the database so it is possi...
Question (cont) (e.g., for all top UD members)? I did that often in HFM to simplify the scripting: Public Const ALLTOP = ".I#Top:F#FLTot:U1#BUTot:U2#AUTot:U3#PRTot:U4#None:U5#None:U6#None:U7#None:U8#None“'All top members of cube dimensions Answer Usi...
Question (cont) (example: Set oDataUnit = HS.OpenDataUnit("A{rle_IC1}.I{[ICPEntities].[Base]}.FL{rle_AllWithoutClosing}.AU{rle_SourceForElim}.CF#[None].TE{FXSimulation.[Base]}")). This enables me to have modular consolidation scripts and just loop th...
Question (cont) For example, I would like to translate an equity account with the dividend flow by the FX rate which I would like to store in an account flow A#Fxrate_Equity:F#HistoricalRate. Do you have examples / can you share some snippets of cust...
Question ( cont) In some cases the API and BRApi have similar functions (e.g., Brapi.ErrorLog.LogMessage vs api.LogMessage). Is there a recommendation when to use which function? Answer You will find that we have many API functions that have a BRAPI ...
Answer Answer: Yes, this can be done by using the load/extract feature on the application tab by choosing the extract Metadata/Business Rules option. Source: Office Hours 2019-7-25 - Partner Enablement
Question (cont) If I have an equity account which I would like to have a USD override amount, a GBP override amount, etc. On the Override account settings, I can only choose 1 currency. How can I resolve this? Answer Yes, this is possible but on your...
Answer Would suspect this is going to be environment specific and will need some analysis of the logs. Advised to reach out to support for assistance in understanding and resolving the error. Source: Office Hours 2020-7-2 - Partner Enablement