Answer The DSO formula uses the standard countback methodology, rounded to the nearest full day. Therefore, the P&L account view is fixed to Periodic and the BS account view Periodic/YTD. As a dynamic calculation, you will see the same figure no matt...
Answer For most situations, this would most likely require either A dynamic UD8 calculation against the statistical account, or A Cube View data helper rule called within the cube view to display the desired results Source: Office Hours 2020-01-31 Pa...
Answer We have customers who have such solutions in place, but the approach will vary on the specific requirements. Source: Office Hours 2020-01-31 Partner Enablement
Answer The number of days in each period will reflect whatever has been defined in the time profile (found within the application tab). Calendar Months will show the standard days per month but you can customize the month type or start date for each ...
Answer Assuming that the date being shown is always the last day of the month and the client is using calendar months, it is possible to use XFBR string rule to call a function to get the number of days in the month. Source: Office Hours 2020-01-17 P...
Answer There is an archive data function to manage late changes. Typically it is not something that would be used as part of every load since the previously imported data is being snapshotted and stored (essentially a back up of relevant stage and th...
Answer Attached is a sample project plan showing the typical build activities and the ordering of such. Source: Office Hours 2020-01-17 Partner Enablement
Answer Option 1 – Instead of using the register in specialty solutions, a ‘lighter’ option would be to use the data import staging area, where you can use attribute columns for text. This is set on the cube settings, where you can enable additional a...
Answer Use the workflow type of “BI Blend, Workspace”. This way you can import/transform the data and then immediately afterwards use a dashboard to query review the data on each cycle. If the workflow tracking frequency is monthly then the a new BI ...
Answer In principle, an extensibility rule could be used to copy the data from one period to the next, however it would be inefficient use of space to simply duplicate data that is the same each period. Source: Office Hours 2019-12-12 Partner Enablem...
Answer For the raw data, you can download as a CSV out-of-the box.However, the column order may not be the same as what was used in the Excel upload register template, and of course there is no formatting. Using an Extensibility rule, you could run a...
Answer Not possible to remove this, however some customers usethese ‘cultural’ descriptions for alternative descriptions for use in reports, even if it has nothing to do with language. Source: Office Hours 2019-12-12 Partner Enablement
Question This concerns the list of reconciliations…in the guide, it mentions that if there are items you don’t need then then can be selected and deleted. But can this be done through a multi-select? Answer Multi-selection is not possible at the mome...
Answer No it is not possible at the moment, in the FX Rates screen. The tool-tip text can be misleading, in that it mentions. You have to remove the rate type, then re-create it with a new name. Source: Office Hours 2019-12-12 Partner Enablement
Question Continued Is it possible to dynamically reference the Source Field Name mapping “Figure 2”. For example, the application created is a 4-4-5 time series and dependent on the quarter interfaced the first week could be WK14, WK27 or WK40. Ideal...
Question (Cont) A Cube View was created which has a row defined as S#ACT “Actuals” and a Column defined as U1#Product.Children. An Advanced Chart was created with the Diagram Type = XY2D, Swap Axes set to True and Type is Bar Stacked. Otherwise, defa...
Answer Source: Office Hours 2019-11-26 Partner Enablement
Answer No, not currently. The Object search is limited to the object types shown in the figure. You can submit an enhancement request to have additional objects added. Source: Office Hours 2019-11-26 Partner Enablement
Answer It is not possible to override the aggregation and store a different value in a parent because UD parents are not stored members. The only way to accomplish this is make the parent member a dynamic calculated member and define the calculation ...
Answer It is always recommended to specify as many members as possible. Any members not specified for dimensions not applicable will default to the “None” member. Source: Office Hours 2019-11-26 Partner Enablement
JackLacava
akloepfer
jvonallmen
