ContributionsMost RecentMost LikesSolutionsRe: Considerations for Changing Cube Consolidation Algorithm Type Hi, I don't see an issue if you are not changing the consolidation and ownership percentages in the existing entity structure. I would be more interested to understand if this does create any issue i...Time Description for non standard time profiles Hi, Would be great to get your thoughts on the below: I have 2 cubes with 2 different time profiles attached – Standard (Jan-Dec) and AugYearEnd (Sep – Aug) I have used the below qu...Scenario Type Corruption? Hi experts, I would like to get some feedback on an issue that I am facing with the current build. I was unable to submit data for the Actual scenario via forms. I had tagged the scenario with th...SolvedDrill down to all journals from AdjConsolidated member Hi experts. I have a query with regards to drill-down feature to locate the journals from 'AdjConsolidated' member. The entity hierarchy of the client has multiple levels and they post journals a...Translate Opening Balance Adjustment member at Opening Rate Hi Experts, I have the following rule to translate my opening balance adjustment (entered manually in the current year) at an opening rate. If (api.Cons.IsCurrency() And Not api.Cons.IsL...Opening balance calculation on OwnerPostAdj Hi experts, The business users had posted some retained earnings adjustments to both base and parent entities at OwnerPostAdj consolidation level. I have a very simple opening balance rule that w...SolvedRe: QTD Column in a Cube View Hi, You can use an XFBR rule to dynamically retrieve the scenarios in the report columns based on the current period selection. Use View as 'Periodic' for the respective columns with a 'Total' colum...Re: Derivative rules Hi Nic, Based on what you suggested, this is what I tried: 1. Aggregate the accounts into Map_SwapProd 2. Multiply by 1 and create Map_SwapProd_New 3. Check if Map_SwapProd_New >0 0r <0 ...Re: Derivative rules Thanks for your response Nic. So, you are saying I can't get this working through a >x and <x operator, but I actually have to write a rule for this? Regards, S Derivative rules Hi experts, I have a group of GL accounts that I need to map to either an expense / revenue based on the sum of the balances. I thought this would be easy enough with a derivative rule; first cr...Solved