ContributionsMost RecentMost LikesSolutionsVariance Analysis in Cube View I'm working on a cube view that does a variance analysis between 2 difference scenarios. The scenarios will always vary based on the scenario member selected by the user. Some of the rows use the f...Calculating the difference between CY LTM versus PY LTM Hi, I'm trying to setup a variance account under UD8 that will calculate the variance between the current year last 12 months and the prior year last 12 moths. Any suggestions on how to write t...Excluding a base member when running an XFGet at a Top member Hi, I have a saved report setup with XFGets. One of the dimensions on the report points to the member "Top." Is there a way to have the XFGet show Top of the dimension and exclude a base member...Multiple UD4 members used in Quickview Has anyone experienced an extensible finance message stating "stream was too long" while using a quickview? I received the message after using UD4 as a column dimension and selecting more than 1 memb...Cube View data not consolidating I have created a cube view that I am having issues with some of the rows not totaling correctly. The cube view is designed to display an income statement. Some background on the cube view. It has 2 c...Data Validations within Cube View I've been creating cube views and have sometimes found that I may forget to update a row that is part of a reporting segment. This results in the sum of the rows not equaling the total row for the re...SolvedBuilding a CV with a trailing 5 quarter view I'm working on a cube view that displays reporting data in a quarterly trend. The end user would select which quarter they want displayed and the CV would display that quarter along with the 4 prev...SolvedBook to present P&L by location This is my first time creating a book. I'm working on creating a book that presents an income statement by location. The ideal outcome is that the IS is displaying location at the top and each subseq...Clearing Data from Data Management Step Hi, I'm working on clearing data from a Plan scenario and ran across this error. Has anyone encountered the image below? If so, what did you need to do to clear the data out? Re: Excluding a base member when running an XFGet at a Top member Thanks for the recommendation on the alternate hierarchy. I will be skip that since this is more like a one off request. I’m still new to XFGets. How would you write a subtraction of an XFGet wit...
