Answer The Data management jobs are kicked off by a
DataQualityEventHandler. In the DataQualityEventHandler, there is a line
that actually runs the DM job. ExecuteDataMgmtSequence - Runs the DM job
and will not return control until it finishes. Sourc...
Answer There is currently no batch functionality for journals. A
workaround is to run a BR that loops through all the journals for a
specific time period and post each one. Source: Office Hours 2020-04-09
Clarification – this is referring to using Cube View Row/Column math
when members expansions are in use. Answer No “elegant” ways to address
this currently – options are: Avoid using member filters (i.e., break
the source rows down to more detail) Re...
Example: Row Definition = A#Sales.Children – this produces 3 children
rows Nested Row Member = U1#Product.Children – this produces 5 product
rows for each of the 3 Account rows Desired is if for the 3rd account
row, 3 products are removed from displa...
Answer No, not at this time. Enhancement Status: We have had requests
for a “Redo” function to be added to CVs and in Excel, but do not see
any such request for the BR editor. Source: Office Hours 2020-03-26
Answer Non-calculated data can be cleared outside of rules From
Workflow: From Data Management Jobs: However, there is no equivalent of
hs.clear to clear non-calculated data within OneStream (by
design…because it “breaks” the audit trail inherent in ...
Answer If you are using the Advanced Chart component, a Dashboard Data
Set Business rule must be used (example rule below) Ensure the following
settings on the Advanced Chart component are correct: Please note: This
can be achieved in BI Viewer by ad...
Answer For the Row Header width: This can be found under General
Settings > Header Size, and can be either set to a specific width, or –1
for default sizing. Needs to be set independently for Data Explorer,
Excel & Report modes.For the Column width: ...
Answer No, the Application Properties (found on the Applications Tab in
OneStream), contain settings for 'Standard Reports' but these only apply
to the Data Explorer and cannot be set for Excel or Report mode. It is
recommended to created standard Ex...
Answer Yes…you can use the “Solution Copy” feature within the
“MarketPlace Solution Tools” solution, which is available for download
on the MarketPlace: Source: Office Hours 2020-03-12 Partner Enablement
Answer For loading Analytical Blend, this is purposely stored separately
outside of the cube, as it is optimized for high-volume transactional
data.Loading Analytic Blend data into the cube normally defeats the
purpose.However… More specifically: Can...
Answer There is a Security Audit Report that covers most changes.Even
if there is not a standard report that you need, everything is audited
in the database. For other items, go to System/Database, all the tables
beginning with “Audit” contains all t...
Answer Answer: Configuration touchpoints:EntityTime ProfilesScenariosFX
RatesCubesData Integration – moving data between cubes Case Study A Two
completely separate organizations: Retail/Commercial organization –
“Business” FEBRUARY year-end Charitabl...
Answer No…Task Manager can be used to launch tasks, but is not there for
automation of tasks. Automation, as posed in the question, would still
need to be done using PowerShell, or other job automation mechanisms.
Underlying purpose of Task Manager i...
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...