osdevadminNew Contributor IIIJoined 2 years ago32 Posts7 LikesLikes received1 SolutionView All Badges
ContributionsMost RecentMost LikesSolutionsCore Platform Architect Exam GA Hi OneStream, Please let me know when shall Core Platform Architect certification exam become GA? In the exam portal i still see OCP - LA certification exam. Thank you, SolvedRe: Conditional Formatting to Show "0" I think you may have to change the formula to round off values to 0. Even if conditional formatting is able to make it zero, it would not impact calculation as it would still go ahead and calculate l...OneStream Admin Copilot? Hi Community, do we have a onestream admin copilot? i recently came across copilot for azure sql database and was really impressed by DBA capabilities. I was wondering if OneStream has similar produc...Re: Allocation thanks JackLacava ! hope OP finds this useful, i have one query in above code is writing Line 11 optional as we are sort of clearing sourcePov in line 10 and if we don't write line 10, then will line...Re: "YTD" like calculation but for custom periods Thanks db_pdx , for getting cumulative numbers till 2023M6 i also used V#YTD:T#2023M6 and it worked! Re: Allocation attempted this, but unsure if my OFFSET is correct: api.Data.Calculate("E#B:O#Forms:A#100001:UD5#ADJ = 0.5 *(E#A:O#Import:F#EndBal_Load:A#100001:UD5#ADJ",False) api.Data.Calculate("E#C:O#Forms:A#...Re: "YTD" like calculation but for custom periods This is the code that gets cumulative number from specific month its very rough so don't like it: For monthIndex As Integer = 1 To 6 cumulativeAmount += api.Data.GetDataCell("T#"..."YTD" like calculation but for custom periods I am writing a member formula/dynamic BR where i have to get 'YTD" like cumulative members but instead get it from month 7 onwards i.e. if i want to get cumulative data from month 7 onwards, i wrote ...Re: Rule Rules - ONLY write rules when necessary. thank you sir, most important thing to remember Re: CubeView Performance - OneStream Dashboard Vs FDX Thank you Sai, this should work
