Implementation Q&A Archive
Questions and Answers from real consultants

Knowledge Base Articles

Question: Within a Cube View, I have defined a row using a list of members as the member filter. Can I use a column override against a specific member within that row definition?

Answer The column/row overrides apply to a specific row or column definition (not individual members). In the above case, the solution would be to break out the list of members into additional row definitions to give the granularity to control the ov...

QandA.png

When creating a new task in Task Scheduler, the task will only run on the first scheduled StartDate/Time but won’t continue to run although set to a Daily Schedule without an expiration date.

Answer This was a known bug at the time and was resolved in Version 6.3. If on a prior version, the suggested workaround is to create 7 weekly tasks for each day of the week. Source: Office Hours 2020-11-05 Partner Enablement

QandA.png
OSAdmin by Valued Contributor
  • 240 Views
  • 0 comments
  • 0 kudos

End users are being prevented from Certifying Workflows due to incomplete dependent steps. Is it possible to have the Workflow auto complete the Workflow certification when leveraging a direct connection?

Note: The Import is set to be an optional data load. Answer Yes, this is possible with an Extender rule…refer to the sample rule attached. Source: Office Hours 2020-11-05 Partner Enablement

QandA.png
OSAdmin by Valued Contributor
  • 405 Views
  • 0 comments
  • 0 kudos

I have a Workflow contains a dashboard that executes a data management job that then populates a cube view. What are the settings needed on the Workflow Profiles so that the Completion step is automated after the DM job runs?

Answer This can be completed by referencing a business rule as the last step of the data management sequence. See sample rule attached Source: Office Hours 2020-11-05 Partner Enablement

QandA.png
OSAdmin by Valued Contributor
  • 498 Views
  • 0 comments
  • 0 kudos

We have a cube view with 3 levels of expansion – Account, UD4 (Currency) and Entity. We would like to see the entities summed for each account, by currency.

Thus, in the example shown for A#TOT_REV in U4#AUD, we want the 3 entities to be summed and return a single value. We know it can be done via XFBR, but am having trouble envisioning what that would look like…can you share examples or suggestions? Ans...

OSAdmin_0-1628186227442.png OSAdmin_1-1628186232131.png OSAdmin_2-1628186255538.png OSAdmin_3-1628186260130.png
OSAdmin by Valued Contributor
  • 496 Views
  • 0 comments
  • 0 kudos

We have a Flow member that we want to calculate only when a different member has an amount present. How can we write this calculation?

Answer If the member you’re checking to see if a value is present is part of the calculation inputs, then you can use the RemoveZeros or RemoveNoData functions in the formula: If the member you’re checking is NOT part of the calculation inputs, then ...

OSAdmin_0-1628186485817.png OSAdmin_1-1628186495871.png OSAdmin_2-1628186515685.png OSAdmin_3-1628186524505.png
OSAdmin by Valued Contributor
  • 400 Views
  • 0 comments
  • 0 kudos

I have a dashboard with two combo boxes which display options for UD1 and UD2 respectively. How can I make the UD2 combo box update to provide a specific list based on what was selected for UD1?

Answer First, make sure the UD1 combo box is set to refresh the dashboard: Then, the UD2 combo box would need to reference a business rule, whereby you apply the logic to query the appropriate UD2 members based on the UD1 value. Source: Office Hours ...

OSAdmin_0-1628186611528.png QandA.png
OSAdmin by Valued Contributor
  • 544 Views
  • 0 comments
  • 0 kudos

Question: How do I resolve this error message, “Error creating parent-child relationship. Members in a hierarchy path cannot transition between the current dimension and inherited dimensions more than once”?

Question (cont) We have an Account Dimension for Actuals that we are extending for Plan. In the extended Plan dimension, we need to use members that are inherited from the ACTUALS dimension. We need to use some of the Actuals accounts within the Plan...

QandA.png

Question: Looking at the time dimension, it seems only one time dimension can be created per application. If you add time profiles, it still uses the same time dimension of the application.

Question (cont) Is this expected and what should clients do when they want to do some processes weekly and other processes monthly? Answer It is correct that each application has a time single time dimension. This can be customized to include additio...

QandA.png

Question: We’ve inherited an application which has a CORP cube with a corporate COA and additional cubes with extended account dimensions which include the relevant local GL accounts.

Question (cont) Is this a common OneStream approach and, if so, is there additional documentation about this approach? Answer This approach is not generally advocated by OneStream. We are aware that many customers request this and require their appli...

QandA.png
Labels
Top Contributors