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
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 •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
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 =
top members of cube dimensions Answer Usi...
Question (cont) (example: Set oDataUnit =
This enables me to have modular consolidation scripts and just loop
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