OneStream Community

michaelkeung · 01-12-2024

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 is overridden ( to existing system data) and the number...

michaelkeung · 11-21-2023

Hi,I have a cue view report of below settings:Net Sales row: A#NSStd cost row: A#SCgross Margin row: GetDataCell(A#NS - A#SC):Name("GROSS MARGIN") Col1: S#BudgetCol2: S#RollingBud Col3: GetDataCell(CVC(Col1) - CVC(Col2)):Name("VARIANCES")Col4:GetData...

michaelkeung · 10-05-2023

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 different settings but still not working.Can you share with me ho...

michaelkeung · 09-07-2023

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)api.data.calculate("A#COG762D:U1#None = A#COG931:U1#ALLDEPT *...

michaelkeung · 01-05-2024

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])

michaelkeung · 11-23-2023

I can only place 4 overrides and my reports have more than that.Why cannot the system calculate under such situation?

michaelkeung · 11-22-2023

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 use A#NS - A#SC . Is there a way to do that?

michaelkeung · 10-26-2023

I am afraid it doesnt work....

michaelkeung · 09-08-2023

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#COG762D:U1#None",True,True,True) api.Data.Calculate("A#COG76...

OneStream Community

User Statistics

User Activity

Excel Cube view submission before refresh

Cubeview CVR CVC calculation error

Book if statement

multiply 2 cell value

Re: Book if statement

Re: Cubeview CVR CVC calculation error

Re: Cubeview CVR CVC calculation error

Re: Book if statement

Re: multiply 2 cell value