Implementation Q&A Archive

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

Question: Can Transformation rules be edited in bulk? When loading rules, they merge instead of replacing.

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

Question: Regarding the deletion of Reconciliation Inventory Items in the Account Reconciliations solution…In the Admin page, I see the ability to delete Reconciliation Inventory Items one by one, but is there the functionality to delete in mass/bulk?

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: Regarding the AutoRec Limit in the Account Reconciliations solution…

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: Within Task Manager, how can I pass the task name into a Cube View that is being run when the task is executed?

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.

Question: Do you have any documents or information regarding seeding rules, where extensible dimensions are being used so the two scenarios do not share the same dimension?

Answer •See the following slides from the Level 2 Rules training regarding the ConvertDataBufferExtendedMembers function. Source: Office Houses 2020-06-18

Question: Is there any documentation to help in discussing calculated/derived values showing grey/black values?

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...

Question: In the Account Reconciliations solution, is it possible to delete more than one record from the reconciliation inventory?

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...

Question: In the data unit calculation (DUC) order, does it run formula passes 1-4 for the account dimension, then formula passes 1-4 for the flow dimension, etc.?

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...

Question: Where is the URL for the excel add-in stored on a user's machine?

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...

Client has just installed the OneStream Excel add-in but they have a conflicting add-in already installed. Do you have any advice?

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...

Question: When loading data in to BI Blend, can we get the description, instead of the name?

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...

Question: During the loading of source data into stage, if you have errors in the validations, can you export/view more than 50 rows at a time?

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: Is known as a good practice to use global constants in a separate helper routine?

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: Is there a comparable to OpenDataUnit in HFM to filter just a subset of accounts / details in a consolidation?

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: Is it possible to refer in a custom translation rule to an account with flow for an FX rate?

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: In some cases the API and BRApi have similar function, recommendation on when to use?

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 ...

Is there an option to export the Business Finance Rules? I did not find the selection in the export menu. Also, it is not part of the complete extract.

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 : Is it possible to have a historical override for a single account, but for multiple currencies?

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...

Question: What happens when a metadata change is committed? We are creating members on the fly and receiving errors when the members are being added during the transformation event.

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

OneStream Community

Knowledge Base Articles

Question: Can historical override balances be calculated differently based on account/currency?

Question: Can Transformation rules be edited in bulk? When loading rules, they merge instead of replacing.

Question: Regarding the deletion of Reconciliation Inventory Items in the Account Reconciliations solution…In the Admin page, I see the ability to delete Reconciliation Inventory Items one by one, but is there the functionality to delete in mass/bulk?

Question: Regarding the AutoRec Limit in the Account Reconciliations solution…

Question: Within Task Manager, how can I pass the task name into a Cube View that is being run when the task is executed?

Question: Do you have any documents or information regarding seeding rules, where extensible dimensions are being used so the two scenarios do not share the same dimension?

Question: Is there any documentation to help in discussing calculated/derived values showing grey/black values?

Question: In the Account Reconciliations solution, is it possible to delete more than one record from the reconciliation inventory?

Question: In the data unit calculation (DUC) order, does it run formula passes 1-4 for the account dimension, then formula passes 1-4 for the flow dimension, etc.?

Question: Where is the URL for the excel add-in stored on a user's machine?

Client has just installed the OneStream Excel add-in but they have a conflicting add-in already installed. Do you have any advice?

Question: When loading data in to BI Blend, can we get the description, instead of the name?

Question: During the loading of source data into stage, if you have errors in the validations, can you export/view more than 50 rows at a time?

Question: Is known as a good practice to use global constants in a separate helper routine?

Question: Is there a comparable to OpenDataUnit in HFM to filter just a subset of accounts / details in a consolidation?

Question: Is it possible to refer in a custom translation rule to an account with flow for an FX rate?

Question: In some cases the API and BRApi have similar function, recommendation on when to use?

Is there an option to export the Business Finance Rules? I did not find the selection in the export menu. Also, it is not part of the complete extract.

Question : Is it possible to have a historical override for a single account, but for multiple currencies?

Question: What happens when a metadata change is committed? We are creating members on the fly and receiving errors when the members are being added during the transformation event.