Announcement
ABC
Recent Activity
New Course Announcement: OneStream Architecture: Implementing Analytic Blend
1 MIN READ OneStream Global Education Services is excited to announce the newly launched OneStream Architecture: Implementing Analytic Blend course available now On-Demand (OD). Course Description Analytic Blend is built into OneStream import functionality. It allows you to blend external data using OneStream cube characteristics. Analytic Blend is typically used for voluminous, operational, and highly transactional data, which is unsuitable for the cube, but for which reporting and analysis in a cube-context is desired. In this course, you will learn how to import, transform, and enrich your data using OneStream’s Stage and Blend engines. You will also learn how to pull your imported data from the external SQL Blend database and report on it responsively in OneStream. In addition, you will learn how to manage performance using FDX, automate imports, apply Blend derivative rule calculations, and use Dynamic Cube Services to enable cube-based reporting using Cube Views and the Excel Add-in. Delivery Types On-Demand (OD) Availability Customers Partners Employees Who Should Take This Course? This course is intended for seasoned Administrators and OneStream Implementers. Duration On-Demand (OD): 12 Hours Prerequisites Prior to taking this course, you should have completed the following course, or possess equivalent knowledge: OneStream Essentials: Getting Started with OneStream OneStream Essentials: Building Basic Reports OneStream Essentials: Implementing OneStream Micro Credential Upon completion of this course a micro credential will be issued. Important Links Register via OneStream Navigator: On-Demand (OD) Course Description PDF Pricing and Learning Paths PDF
Issue with Cubeview with comments Genesis content block
I'm creating a cubeview with comments page and trying to have comments tied to each individual group but comments are only saving with our top level group and not moving with the parameter. I've entered comments on our other groups and get the same result. Below is what I have entered in commentary configuration. Any ideas?
Replace not working
Hi all, I'm experiencing an issue with the connector in one of the cubes. Although everything is set to "replace," the stage is not being cleared, and old data is being loaded together with the new data. As a result, I have to manually clear the stage to resolve it. The log, is says replace Data keys are 2025M10,2025M11,2025M12,2026M1, but if i check th estage after the import i have periods outiside this range The log indicates 9,261 lines, exacly the same amount of rows that the query produces. But the import shows 248 pages. With 50 rows per page, that would be around 12,400 rows loaded, which is quite different from what the log reports. I'm not sure if I'm missing something here, but I haven’t noticed this happening in other data loads. I still need to replicate the issue in a different app. Has anyone seen this before? Thanks in advance!
Invalid destination data unit in script
I'm making my first attempt at using the DataBuffer to perform a data copy from a source scenario to a destination scenario. This is being done through a Data Management (DM) step and a Custom Calculate business rule. To keep things simple for this initial version, the input values are hard-coded. Dim dbSource As DataBuffer = api.Data.GetDataBufferUsingFormula("S#Budget:T#2026M7:A#CF101:O#AdjInput:E#ES", DataApiScriptMethodType.Calculate, False) Dim destinationInfo As ExpressionDestinationInfo = api.Data.GetExpressionDestinationInfo("S#Forecast_Q2:T#2026M7:A#CF101:E#ES:O#AdjInput") api.Data.SetDataBuffer(dbSource, destinationInfo,,,,,,,,,,,,,False) Appreciate any inputs to fix this. Thanks
Does OneStream have the capability to refresh Cube View connections within Excel workbooks via XFDoc or some other type of functionality? Goal is to schedule the refresh & distribution of an Excel workbook via the Book or other functionality, so that both CVs and XFGetCells can be used. Per our prior testing, when using an XFDoc.Xlsx file type, the XFDoc will refresh XFGetCells when retrieved. However, it does not refresh cube view connections embedded in the Excel XFDoc.
Answer There are numerous Enhancement Requests related to this: PF-385, PF-1309 Source: Office Hours 2020-10-08 Partner Enablement
Transparent color in Excel
Hello the Community, Currently working on the formatting in a cube view, we noticed that the Transparent color in excel isn't working, most probably because Transparent isn't a police color recognized in Excel. Do you confirm you have the same on your side and do you have any other workaround than setting the text with the same color as it's background? Thanks in advance, Florence
Narrative Reporting Issue
Hello! Has someone tried Narrative reporting in 9.1 version? I am currently experiencing issues: 1.- Inserting charts/Advanced Charts / Reports if someone could insert an exaple on how they have done it. 2.- I cannot vie the artifacts and acces them, this message keeps popping up (and the names are fine) Thank you so much for the help!!
