Recent Discussions
Reducing size of the XFGetCell function
The XFGetCell function has 20 arguments, when you have a large sheet (e.g. for data validation) there can be many of these functions increasing the size of the excel file. In SmartView it was possible to create 1 cell with commonly used arguments and reference that cell at once. In OneStream i'm not able to do so. Off course i cannot imagine that SmartView has a feature that OneStream doesn't so i probably need to change my syntax a bit. Hope you guys can help. So instead of: =XFGetCell(TRUE, "Finance",$A274, "",F$4,F$14,F$5,F$2,$C274,$D274,F$3,$B274,F$6,F$7,F$8,F$9,F$10,F$11,F$12,F$13) I want to create a cell (lets say A1) that has the content: TRUE, "Finance",$A274, "",F$4,F$14,F$5,F$2,$C274,$D274,F$3,$B274,F$6,F$7,F$8,F$9, So my formula would look like: XFGetCell($A$1, F$10,F$11,F$12,F$13) Unfortunately the function put double quotes around the cell so i get the whole string as my DisplayNoDataAsZero parameter and the next few down, missing many parameters (see picture below).
ABS function in GetDataCell formula
Hi all, We encountered an issue with the ABS function in a GetDataCell formula. Our cube view has two rows: the first tagged to account A#100, and the second with the formula GetDataCell(ABS(CVR(Row1))). The data displays correctly in the data explorer, but when using ‘Show Report’ or ‘Export to Excel,’ both rows show the absolute value of the original amount, which is not the expected output. An example is provided below Data explorer view (correct amount) Row Name Member Filter Output Row1 A#100 $ -1,000 ABS_Row1 GetDataCell(ABS(CVR(Row1)) $ 1,000 Show Report/Export to Excel view (incorrect amount) Row Name Member Filter Output Row1 A#100 $ 1,000 ABS_Row1 GetDataCell(ABS(CVR(Row1)) $ 1,000 Does anyone know whether this is an issue in OneStream? Thank you. Best, JackyExcel add-in V9: Not able to drilldown
We recently upgraded from V7.4 to V9.1 and we’re seeing an issue with the Excel Add-In. A small group of users (about five) are unable to use the Drilldown feature (the option is completely greyed out), while the rest of our users can access it without any issues. All users have been upgraded to the 9.1 Excel Add-In and every other function appears to be working correctly. Has anyone else run into this? Any ideas on how to fix it?Form Template Naming Restrictions
Hello, Since when are Form templates no longer allowed to include a dot (.) or a hyphen (-)? We built our naming convention using dots, and it is now unusable under these restrictions. Please confirm when this change was introduced and what alternative naming format you recommend. Best regards,
Loading a Journal Excel Template into Multiple Periods
Hi, is there syntax similar to forms to load journals into multiple wf periods? My WF is 1 period, 12 months: I tried using similar syntax to form loads: Template set up as monthly: And I return no messages when I load. Confirmed xfj range is set up on file and all dimensions match. Thinking maybe its my "Time" thats preventing the journal from getting into the system and want to confirm I have valid syntax. Maybe the other option is to set Workflow Time to 2026M1 and make individual journals for each period: Is it possible to do all months in 1 journal?ONC - IntercompanyDetailAllPlugaccounts - Suppress matches
Hi, We have moved to v9, and the previously used IC matching methods are giving us issues. For this we have a ticket open with support, and they have pointed us towards ONC. We use something very similar to the intercompany all plugs, but then supressing any combinations that are matching. Is there a way to filter the IntercompanyDetailAllPlugAccountsGridView_ONC to suppress the matches? It seems to be working in our development environment, but would be great if we can supress the matches as this is something that will be required. We have tried this: {WS}{GetIntercompanyDetailAllPlugAccountsGridView}{View = |!Members_View_Numeric_ONC!|, SuppressMatches=True} But that does not seem to work. With kind regards, Tim
OS Genesis CubeViewTreeView
Hi All, When opening a cube view via OS Genesis cube view tree view, the content block can take a while to open. Even though there is no data, it is a simple cube view PnL. Opening it via cube view or dashboard takes only 2 seconds with data. Is there a way to improve the performance of the cube view tree view content? Appreciate your help on this.
