ContributionsMost RecentMost LikesSolutionsRe: Restricting access to specific accounts in specific scenarios Thanks for the help and guidance. This looks like the solution that I needed. Restricting access to specific accounts in specific scenarios Hello We have a set of cost recovery related accounts where the recoveries are calculated and captured centrally for budgeting purposes, but the actual recoveries are invoiced to the different entit...SolvedRemove the value of a child Is there a way that you can exclude the value of a specific child in the account hierarchy without losing drill down functionality in cube views? For example to exclude bonuses from staff costs. SolvedCreating a parent dimension within an existing UD Attribute Hi We have set up a line of business attribute in our UD3 dimension based on cost centres. It has become clear that in several reports we need to aggregate some of these members. I think the easie...SolvedCalculate variance percentages for different rows Hi I'm struggling to add lines to show Gross Margin % ((Total income less product related costs)/Total income)*100), overhead as a percentage of total income etc. I've tried using Getdatacell ref...SolvedRe: Creating a parent dimension within an existing UD Attribute Thanks for this solution. I messed about about trying to move them and probably took the long route by eventually deleting and then setting up the children again ...but it works fine for both my new ...Re: Calculate variance percentages for different rows Thanks Peter Appending data through "Import Register Items from an Excel File" I have a loaded set of base data in our People Register, but this needs to be amended to capture New Hires, Leavers, Promotions etc. I had thought that this would be possible by using the excel file ...SolvedRe: Appending data through "Import Register Items from an Excel File" Many thanks for your advice, that looks like it solves it. Re: Remove the value of a child Thanks for the great tips. I can see the data at the detailed level but was hoping to get to a single row called Staff costs excl Bonus. Using the remove function is there a way to deduct a single ac...
