Recent Discussions
Excel 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.
CVR and GetDataCell Issue in cube views
Hello, I currently have a cube where I am having an issue calculating variances. The row has GetDataCell(CVR(Row1)+CVR(Row2)) and Column is has T#POV, T#POVPrior12, GetDatacell(T#Pov-T#POVPrior12). When I run the report, the first two columns run correctly for T#POV and T#POVPriorYear, but the third column where the two get data cells meet does not calculate correctly. I can't get it to work on a column override either as I know there is a order of operation for the GetDataCell. I want to keep the report as dynamic as possible, is there a way this can be achieved without breaking the columns out and manually doing the overrides?
