ContributionsMost RecentMost LikesSolutionsExport a Cube View to Excel in Landscape Orientation GOAL Export cube view to Excel with Landscape printing orientation. METHOD There is a cube view setting on the Advanced tab, labeled as Landscape = True/False. I have set that setting to Landsc...Re: Has anyone ever had a data source that is two columns for the amount and they have to be added together in the file *-1? I had the same question!This is what I found worked: 1) In Data Sources, point the Amount to a row validator column*. This will NOT be the debit or credit amount column of data if that column might...Re: How to overview changes in EntityDim? As Andy points out, you can create a Quick View to surface the entity properties. Another quick and dirty answer is simply to: 1. View the Entity dimension in grid view. 2. Display Parent Child Re...Re: Dynamic Calc to Increase Column Value by 1 The formula is simply: Return 1 The account attributes are: Account Type = Balance Formula Type = DynamicCalc Allow Input = False Is Consolidated = False Re: Turn off suppression of repeated member names in a Cube View CHOICE 1 You can move the scenario columnafter the account column to trigger the repeating of the Actual label. But this may not be the look you are going for. CHOICE 2 1. Make a UDx parameter of ...Re: Dynamic Calc to Increase Column Value by 1 This might help. I use a counting account called One. It is a dynamic calc account with the formula: Return 1.I use it in reports. I might report on entities E#West.Base and if I include the A#One a...Re: Problem: Unable to Submit Comments within the #V Dimension due to Intersection Being Read-Only I think2022 &Top need to be changed to base members. Are all of these base members? SWINC, SWCON, PRODUCT_REVENUE, DEPT Variance explanations are loaded just like number data, at base members, in...Re: Problem: Unable to Submit Comments within the #V Dimension due to Intersection Being Read-Only Try Local instead of USD. Re: Forecasting Adjustments This approach is a great idea. We don't currently use this approach, so I don't have anything to say regarding that experience. But I did have something to add to the conversation. UD3 DIMENSION ...Re: Alignment of Columns in Reporting Yes, you can add a dollar sign by adding another thin column. Here's the steps I'd recommend: In your dimension library, create a UD member. I will use UD4, for this example. UD4 member name = Acc...