ContributionsMost RecentMost LikesSolutionsUSD Override is aggregating with translated balance I created a USD Override form, however the translated value and the override value are both getting to the Top member. I was expected the override value to be getting to Top. Here is the fo...How to prevent column name from repeating How can I format this cube view to not display column names after it's been identified once? I want to retain the first instance of the Consolidation member, Local and Elimination (in red) but not ha...Intercompany Mapping using Derivative Rules Hi, I am using Derivative Rules in order to generate additional records in Stage. In this example, I have two derivative rules per I/C transaction. The account mappings will bypass the original so...SolvedRe: Intercompany Mapping using Derivative Rules Hi Mike, I updated the IC mapping rule by adding40L1CA.001A_DER to map to170. I revalidated to process the new IC mapping rule but it's still being mapped to None. Entity Related Reporting Why doesn’t the report list the by month activity for entities 44, 87, & 55 from Feb to Sep? It does so for #77. YTD ties because Sept is the catchup month. Parent Entity 56 (Children Entities: 44, ...Dependent Status in Workflow How can I Certify even though one of the Import steps are not started? It's an Import, Validate and Load process. Want to change column width I am trying to get both columns (April 30, 2022 and April 30, 2021) to spread out a bit in the report shown above. I would also like to center ASSETS when my columns are not so close to the mi...Dynamic Prior T#PeriodPrior1(|!DRU_Year!|):Name(April 30, 2021) The member filter above is not dynamic since I am hard-coding 2021 in the second column. How can I make the second column be a prior per...SolvedZeroes into - I am trying to change the zeroes in my report to become '-'. Can I accomplish the above with an If Statement? Alignment of Columns in Reporting In my screenshot above, I would like to add a $ sign. I know this is done under Number Format. However I would like the $ sign to be aligned to the left-hand side. Would adding a narrow column...