Question (cont) On occasion, the import fails because of the order of components within the XML, even if the components are all in the same maintenance unit. Is there any way to address this other than manually reordering items within the XML file? A...
Question Answer •The Replace (All Time) option was newly introduced in v5 that was likely affecting the testing as a result of the upgrade. •When utilizing a workflow that imports data to multiple time periods (such as using a forecast scenario using...
Answer Need to be part of the Certification Signoff group, for the workflow. Also check there are no exclusion groups setup. Source: Office Hours 2019-10-31
Answer •Yes, you can do this with a dynamic UD8 calculation (sample rule below). •The formula concatenates the commentary in the descendant entities at view-time. The concatenated commentary is never stored. •You can tailor-make the formula to concat...
Answer •We do not support the use of DRM for metadata updates in OneStream, as it does not know the concept of “Extensible Dimensions” •However, there are ways of adding metadata “on the fly” using Transformation Event Handler business rules. •Update...
Answer Yes, this can be done within the application and is discussed in Knowledge Base article KB0010541 (https://onestreamsoftware.service-now.com/sp?id=kb_article&sys_id=2ce683b7dbd3a380a5405eea4b961949 Source: Office Hours 2019-07-11
Question (cont) We are running our CTA rules at IsForeignCurrency and limited origin in Forms, Import, and AdjInput in our filter. •The app is CAD and now we want to post a CAD journal to a USD entity or basically to CAD consolidation member. In this...
Answer •When this question was posed, there were some workarounds involving the use of row/column overrides. •However, with the release of 6.0.0 (March 2020), you can now create calculations against hidden rows/columns Source: Office Hours 2019-07-11
Answer Yes…see the attached Splash presentation which covers how to do this…
Answer We have a few BRApi related to Batch Loading but we don’t have a Batch Event Handler that we can code against. Therefore, we are not able to pick and choose which files to load once they get into the Batch Harvest folder Hypothetical Scenario…...
Answer In general, dimension sizes of this nature should be avoided and would tend to indicate transactional level members. In this case, the following alternatives should be considered:• Can the additional detail be captured via stage attributes, wh...
Answer • The first consideration is memory available on the server• Next, there are stage settings that can be tweaked to optimize performance with very large volumes…see next slide for guidelines as discussed from our Implementation Class Source: Of...
Answer Example: I have grid in my BI Viewer and it is referencing a cube view that uses literal parameters to determine the prior scenario. In order to have the scenario show up in the columns, I created a calculated field with an expression that har...
Question (cont) This is what I have and it’s not working…I’d appreciate some guidance: Answer Add “.XFToString” after the updatedValue variable in your api.Data.Calculate string. Source: Office Hours 2021-01-21 - Partner Enablement
Question Answer The relevant account(s) needs the follow setting updating to Data Entry rather than Journals See knowledge base article KB0010218 for complete instructions https://onestreamsoftware.service-now.com/sp?id=kb_article&sys_id=1bc22565db47...
Question (cont) Is there a way to automatically change the start dates using a business rule? Can those start dates be referenced in business rules (i.e., in a parser rule)? Answer In any new Time Profile, the Fiscal Year Month type defaults to “Cale...
Answer It is possible to use a data entry form to update the AdjInput member of the Origin dimension. This is achieved by setting the adjustment type on an account-by-account basis. Each account member has an Adjustment Type property which gives cont...
Question (cont) The client has a working forecast scenario from which data is copied to reporting scenarios. The client has a load from a HR system (via Excel), but also makes manual changes in the register. The client reloads data from the HR system...
Answer I don’t want to see Row4 when I run the cube view so I set the Header Format to IsRowVisible = False. When I do this I get an error for the Row 5 – the calculated row. It seems like for a calculated row the rows that make it up have to be visi...
Answer Cell Format can be set to display NoData cells as dashes in Reports (PDF rendering) using this property: ReportNoDataNumberFormat = "- “. Data Explorer cannot render dashes where there is NoData; this is how zero data cells are differentiated ...
JackLacava
akloepfer
jvonallmen
