ContributionsMost RecentMost LikesSolutionsExcel Cube view submission before refresh Hi, I sent out an excel cube view report to My colleague. He filled in the numbers and sent it back to me to submit. However, when I click the submit button in excel, the cube view report number ...Re: Book if statement Finally I fixed it by not reading the entity name but its member property of its currency: (XFMemberProperty(DimType=Entity, Member=|Loop1Variable| , Property=Currency) = [USD]) Re: Cubeview CVR CVC calculation error I can only place 4 overrides and my reports have more than that. Why cannot the system calculate under such situation? Re: Cubeview CVR CVC calculation error Thank you for your reply. But in some reports, I don't want to show NS and SC lines nor I don't want to create new accounts, I want to directly useA#NS - A#SC . Is there a way to do that? Cubeview CVR CVC calculation error Hi, I have a cue view report of below settings: Net Sales row: A#NS Std cost row: A#SC gross Margin row: GetDataCell(A#NS - A#SC):Name("GROSS MARGIN") Col1: S#Budget Col2: S#RollingBud Col...Re: Book if statement I am afraid it doesnt work.... Book if statement Hi, My company has entities 2,5,8,N,U,O,X,Z. When I prepare the loop and if statement in the books; not sure why I could only use the if statement for N/U/O/X/Z but not 2/5/8. I have tried differ...SolvedRe: multiply 2 cell value I fixed it using below: Dim scnType As ScenarioType = api.Scenario.GetScenarioType() If (scnType = ScenarioType.Actual Or scnType = ScenarioType.budget) Then api.Data.ClearCalculatedData("A...multiply 2 cell value Hi, I need to create an account to calculate two values multiply together. I had set formulapass2 and set the formula as below: api.Data.ClearCalculatedData("A#COG762D:U1#None",True,True,True) ap...
