Recent Discussions
Dynamically replace header text with Description for Parents or Name and Description for base
Using an expansion such as .Tree is there a way I can have the header text display the member description for parents and the name & description for base members?Samwise20 hours agoNew Contributor II4Views0likes0CommentsRefreshing an emailed spreadsheet
We just upgraded from 8.4 to 9.0, and almost certain before we could email a spreadsheet with XF functions and immediately refresh the spreadsheet with button in the ribbon when already logged in. Now the Refresh Sheet button is grayed out, and now you have to "save as" the spreadsheet then refresh because the spreadsheet is in "read only" mode. I'm trying to decide if it changed with the upgrade, or if one of the Preferences settings affect this, or if we are just not remembering correctly. Any ideas or are we just wrong?johnal676 days agoContributor23Views0likes1CommentAutomate Excel workbook refresh
We have an Excel workbook with a *lot* of embedded cube views and table views. Some sheets have two Cube Views with Excel formulas showing significant differences. Others have stacked Cube Views showing Import, IFRS Adjustments and Total. We cannot use Books because of this. It takes about an hour to refresh the workbook so we want to automate the refresh somehow. Anyone have any suggestions about how to automate the refresh? Thanks MarcusMarcusH6 days agoValued Contributor9Views0likes0CommentsGenesis Parameters (Filters) Issue
I am having an issue with cube view parameters within the Genesis content block "Cube View Comments"? I receive one of two errors - (1) Index was out of range (parameter 'index') or (2) Parameter is not supported. However, if I put the exact same cube view in the "Cube View Advanced" content block, the parameters work exactly as expected. Is this a bug or is there something I'm doing wrong? Any help would be greatly appreciated.aricgresko6 days agoContributor III24Views0likes1CommentSave Offline Copy
I'm getting the below error message regarding location when trying to save a file with multiple XFGetCell formulas offline. I've updated my preferences that an earlier question showed as a solution and refreshed the workbook (again) before attempting to save...but am unable to save the file without the formulas. I've tried directly to my desktop, various folders, where downloads go.... I can't find an acceptable location. Any help would be appreciated.amwitmer7 days agoNew Contributor67Views0likes3CommentsV#Trailing12MonthTotal
Hi , I am trying to use the V#Trailing2-12MonthTotals in my reports. Could any expert users please advise if the TrailingTotal in View Dimension works only for P&L numbers or they work for Balance Sheet and Retained Earnings totals also. Any reponse will be much appreciated. Thanks SamSam_OS7 days agoNew Contributor17Views0likes2CommentsTop Ten and All Other
Hi. I have a cube view / customer sales report where I can get my top ten customer sales, and I have a row that has the total sales. How can I make a row to show 'All Others' so I can foot the lines to the total sales? I've tried a CVR calc but it pulls in the top customer only. Thanks, Brianbapaul9 days agoNew Contributor1.2KViews0likes6CommentsRow Formula is overring Ud8 Calc
Hi Team, In our report we are having multiple formula's in row and columns (Can't apply the row or column overrides). So, have created a UD8 Dynamic calc. though after applying the UD8 member in column, row formula is overring the UD8. Can please help us to resolve the issue.ShivaPrasad9 days agoNew Contributor III35Views1like3Comments