Announcement
ABC
Recent Activity
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. ThanksDoes 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
Data loading into BeforeAdj member
Hi All, Apologies if this question has been answered before. I tried search community but couldn't find. I noticed that data can be loaded via Forms into BeforeAdj member. Two questions: (1) Wouldn't it mean that if data is subsequently loaded into both Forms and Import, the previously loaded data into BeforeAdj member would get replaced? Isn't BeforeAdju supposed to be an Aggregated member? (2) Why would anyone want to load data into BeforeAdj member in the first place? What is the benefit of loading data into BeforeAdj member directly and not using Forms member if data is input via Forms? Thanks in advance for any insights.
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!!
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!Tech Talks: Designing with OneStream Genesis Replay Available!
1 MIN READ Tech Talks: Designing with OneStream Genesis is now available. On this edition of Tech Talks, Doug Kinchley and Jacqui Slone return to take a further look at OneStream Genesis, including using embedded blocks and layouts. This replay is FREE to all OneStreamers and does not have an expiration date so watch as often as you like!Conditional format based on Row Member Name and Row Headers hidden
Hi the Community! I need to show, in a cube view, the subtotals of my rows, showing the dimension members presented in the Row1 header (I have 2 rows in this case). To achieve this, I built an UD8 dynamic calculated member and that works pretty well - when on the Row2 base members, then it shows the description of the members, if i am on the Total member, then it shows the member descriptions of the dimension which is set on the row 1). However, sounds quite basic, but I need to set another format on those subtotals, so I used the Conditional format based on the Row Member names (If RowE1MemberName ...), what is working perfectly fine, until I hide those row headers - in this case, then the conditional format doesn't work anymore ! How do you achieve this kind of basic requirement in this case? Any idea would be very helpful :) Thanks is advance, Regards, Florence
