Unable to reference the SingleJournalDetail_ONC in the Guided Report?
We used to be able to reference and retrieve the RPTA Audit Reports from the Guided Reporting Solution. After we upgraded the RPTA to Navigation Center, we are unable to retrieve the Single Journal Detail Report from the Guided Reporting or our custom homepage dashboard. See the prompt box displayed in the Guided Reporting when retrieving the Single Journal detail report:
Excel Addin - Calculate
Hi, I am using OneStream version 8.2 and the Excel Add-In with a workbook that contains XFGetCell formulas. The workbook retrieves data successfully, and Refresh Workbook works as expected. However, the Calculate, Translate, and Consolidate buttons in the OneStream ribbon are disabled (grayed out). I am logged in successfully and can retrieve data through XFGetCell formulas, but I cannot perform any processing actions from Excel. Could anyone help me understand: What conditions must be met in OneStream 8.2 for the Calculate, Translate, and Consolidate buttons to become enabled? Is there any way to trigger Calculate, Translate, or Consolidate from Excel when working with XFGetCell-based templates? Thank you!
Excel Add-in - Quick view - Style for dates
Hi everyone ! We'd like to recover data in a date format using Quick Views. First step is to setup a CubeView that can recover this data. To do so, the CubeView setup is done in "Cell Type = Date " in the Data tab of the given line on the CubeView definition. Then data can be correctly input in the CubeView: . This particular date is saved as 639,160,344,000,000,000 (numeric value) in the data base. Next step it to recover this data using the quickview, but I can't get the correct style. It seems that the data in Onestream is different to that of the Excel date style (Excel starts from 1/1/1900 as day 1). Does anyone know how to properly set up the style to recover dates using a QuickView? Thank you Carlos
Balance Sheet report: displaying two CubeViews in a two-column layout
Hi everyone, I'm building a Balance Sheet report in the Text Editor. For various reasons, I have two separate CubeViews: one for Assets and another for Liabilities & Equity. I've placed both CubeViews inside a table within the Text Editor (one per cell, side by side), trying to display them in the classic balance sheet layout — Assets on the left, Liabilities & Equity on the right. However, I'm having trouble getting them to render correctly next to each other. Has anyone done this before? Is a two-cell table in the Text Editor the right approach, or is there a better/recommended way to place two CubeViews side by side in a single report? Any tips or examples would be greatly appreciated. Thanks!
Excel Add-in and Task Activity Log
Hello, I'm responding to audit requests regarding user task activities and found an active user which has no task activity logged. The user uses the Excel Add-in. What Excel activities are/aren't recorded on the Task Activity log? Is there a way to capture the Excel activities? Thanks!
