ContributionsMost RecentMost LikesSolutionsRetrieve member values from GetDataCell using Dynamic Calculation? I have a UD8 dynamic calculation that returns different results based on the UD2 member value. E.g. If UD2 = Houston, return "A#:Total_Expenses:S#Plan...." This works well using api.pov.UD2.Name fo...Passing parameters into UD8 member I am building a UD8 dynamic calc to bypass the limit of 4 cube view overrides. The calculation will read the referenced member (e.g. A#Net_Income:S#Actual) and return a different member intersection ...SolvedExceeding maximum row/column overrides Hi all. I am building a report that requires more overrides than the standard cube view template allows for. 10 rows of this report require overrides to the scenario dimension for one column. These...Re: Pass through multiple time members for one XFBR After extensive testing, I've found that passing through a literal parameter accomplishes the objective. I putFirstPeriodInYearPrior1(|!TimeParameter!|) as the value of the literal parameter and pas...Pass through multiple time members for one XFBR I am building a Dashboard XFBR String to return a different Origin member depending on whether the time is before or after 2020. If the time is equal to or prior to 2020, it returns "Top". If the t...SolvedNested parameters to return one value I am building a report that uses a nested parameter. This report will run on a dashboard within Guided Reporting if it makes any difference. My parameters are Member List types. EntityParam1 uses ...Re: Additional math on GetDataCell expressions Thank you, unfortunately either calculation still ignores the *100. May not be possible to apply multiplication to CVMath. Re: Additional math on GetDataCell expressions If set to false, it defaults to scale = 0 and doesn't change since scale is set to 0 in the column formatting.. Re: Additional math on GetDataCell expressions Thanks for the reply. Unfortunately scale won't work because I need the number to become larger. My scale is set to 0 right now (to override other scale settings in the cube view), and that is the...Additional math on GetDataCell expressions I have a column performing the following expression: GetDataCell(Divide(CVC(CYAct)-CVC(PYAct)), CVC(PYAct))):Name(PY % Var) The column uses the following formatting: ExcelNumberFormat = 0.0%, Excel...
