Answer You cannot list multiple accounts within the same XFGetCell function. The XFGetCell function retrieves a cell from the cube based on parameters supplied. To retrieve multiple accounts, you can add multiple XFGetCell functions within the same E...
Answer •OneStream will export just the data that is presented on the screen. •It is possible to increase the amount of records presented using an XFBR, but this must be performed with caution as the system can become overloaded when too many records ...
Answer There is a knowledge base article detailing where the URLs are stored. (KB0010872) https://onestreamsoftware.service-now.com/sp?id=kb_article&sys_id=591346c31bf0085060122026ec4bcb47 For ease of reference, the list of excel URLs will be found i...
Answer There are a number of knowledge base articles related to the Excel add-in (Category: Excel Add-in). Without details on the error message being received, we would suggest looking through these articles. If the KB articles do not assist, raise a...
Answer Submitting data via excel will respect the security model set up in OneStream. So consider typical security setup. Also consider using constraints to manage "valid" data intersections. Inputting data via set cell will get tracked in the audit ...
Answer OneStream is storing the true value and using a number format to display the values as scaled. If the client only takes scaled amounts, rounding could cause reports to not foot correctly in Workiva. Possible options: Dynamic calculation on the...
Answer Table views are available in the spreadsheet component which allow a user to query relation tables and present this in spreadsheet format. This functionality is not available, however, within the Excel add-in. Within a dashboard, the stage dat...
