ContributionsMost RecentMost LikesSolutionsHierarchy Validation tool Security We have added a power user who has the ability to manage some dimensions, however they cannot access the hierarchy validation tool and receive the error Security Access Error. User XXXX is not aut...SolvedPull Fx Rate based on scenario I am trying to create a fx account that would dynamically pull based on scenario. Below is the code I used for actuals and budget rate and it works great, however, for our forecast rates it does not...Sub groups in Oneplace Cubeview I have the following cube view in Oneplace and I would like to know if it is possible to create subgroups below the Main group. For example I would like to create a subgroup of Income Statement ...SolvedQTD Average In Mid Quarter Trying to do a QTD Average during the second month of the quarter. Using the v#QuarterAvg did not work as it includes all months in the calculation. Re: Entensible Finance ( Not enough memory) Yes we are receiving this as well, did you find a solution? Re: Excel "Save Offline Copy" hanging during Save Same issue, it hangs up when trying to save offline and we have to kill the process. Show Month name only I have a cube view that is comparing two years and the better worse for each month. Is there a way to show only the month name only (no year) in the Better Worse column header? Pull Currency in Quickview Is there a way to pull the functional currency in a Quickview, for example we have a Quickview showing entity and account (cash) in the rows and time in the columns. I would like to pull the entity,...Keep Excel Color Formatting upon refresh Our team uses cubes views for reporting. Often times they will highlight a cell for analysis purposes in a separate color, however when they refresh the cube view the color reverts back to the origi...Re: Return the parent member using XFGetHierarchyProperty function I would like to do the same.
