Implementation Q&A Archive
Questions and Answers from real consultants

Knowledge Base Articles

Question: During initial build, we used Workflow suffixes on Scenario Types thinking they would be needed. Now, they are not and should now be removed. It is our understanding that to get rid of these, we would need to clear all data in those scenarios…is this correct?

Answer Yes, once data has been loaded or the workflows have been used in any way and have logs associated with them, the only way either change the suffix or get rid of the root profiles is to clear all data and workflow logs using the Reset Scenario...

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

Is there a way a user can export all pages of grid data (e.g., from Stage Import)…sometimes we will 100 pages and we can’t expect users to export individually.

Answer There are different options options: •Expand the number of “Grid Rows Per Page” for the User on System tab in Security (default is 50 but could go up to 1000) •Use a business rule to extract •Use the standard Import dashboard for displaying al...

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

Question: Users would like to copy form data to an excel for quick analysis without having to export, currently when copying to excel it seems to bring it back as text and puts the data into separate cells wherever commas are.

Answer This is a function of the Excel settings when last using an import of CSV data. Make sure comma is not the active delimiter choice in Excel…you can check by highlighting data & selecting “Text to Columns”. Source: Office Hours: 2019-08-22

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

Member formula is missing the ability to execute chart logic for limited dimension intersections, similar to an Essbase FIX statement (e.g. ability to calculate one cash flow account). Can see that the function is in the dll but it is not exposed to the API functions.

Question Answer General approach is to use a Custom Calculation function so that you can limit the calculations to what is actively displayed on the forms. Disadvantages of this approach: •By not having the calculations on member formulas, you lose t...

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

When using standard eliminations, how does the system react in the case of non-matching details of source accounts and plug account (e.g., source is supporting some flows, the plug account some others)?

Question Example: In the balance sheet it might happen, that the plug account of the elimination is part of the equity accounts. In equity, I have a detailed movement table with additions and disposals where the receivables and payables support openi...

OSAdmin_0-1628699034244.png OSAdmin_1-1628699071344.png QandA.png
OSAdmin by Valued Contributor
  • 604 Views
  • 0 comments
  • 0 kudos

Question: Regarding migration of People Planning, there is a step in the documentation that requires copying the PLP tables in the database. Once we go live and in production, is the procedure to copy the tables in which case, isn't there a risk of overwriting data?

Answer •Beyond the initial migration of the table, there shouldn't be a need to create those tables again. •Depending on what change is being made, you may have to consider how to migrate the modifications. That could involve copying the table or mak...

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

Question: In relation to allocation methods in People Planning, is it possible to show some examples of dynamically pulling data from the cube using a Business Rule or Xfcell? When would one be used over the other?

Question Answer •There are a number of substitution variables available which can be used within the allocation methods. These can be used to create the allocation (e.g |Wage| * |Bonus|), however, they can also be used with XFCell and XFBR strings to...

OSAdmin_0-1628698249231.png OSAdmin_1-1628698270771.png QandA.png
OSAdmin by Valued Contributor
  • 528 Views
  • 0 comments
  • 0 kudos
Labels
Top Contributors