OneStream Community

osdevadmin

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 product that let us administrators use a chat based inter...

osdevadmin

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 a very rudimentary code to do this and it works but...

osdevadmin · 02-20-2024

Hi Community, We have a cubeview that pulls more than 40k records when run for a period in a dashboard. It runs base level for couple of UDs that have ~30k members and 200 members. It renders fairly quickly on dashboard although with paging, but when...

osdevadmin · 10-04-2023

Hi community,I am trying to pass a custom name function in the manner below:XFBR(XFBR_CubeViews, CustomTimeExpansion, timeExp=T#2020.Base, desc = :Name(|MFTimeShortDesc|))Somehow the XFBR is not able to append custom name function to the periods that...

osdevadmin · 08-15-2023

Hi there, thankful for immense contribution from community that has made life easier as a system admin. Currently working on a requirement to query stage data for specific Entity, Account, Scenario, UD1 through UD5 and reseed it back to a intersectio...

osdevadmin

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 11 still work? api.data.calculate(sourcePov & " =...

osdevadmin

Thanks @db_pdx , for getting cumulative numbers till 2023M6 i also used V#YTD:T#2023M6 and it worked!

osdevadmin

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#100001:UD5#ADJ = 0.4 *(E#A:O#Import:F#EndBal_Load:A#100...

osdevadmin

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#" & fiscalYearShort & "M" & monthIndex & ":" & filterString).CellAmount

osdevadmin

thank you sir, most important thing to remember

OneStream Community

User Statistics

User Activity

OneStream Admin Copilot?

"YTD" like calculation but for custom periods

CubeView Performance - OneStream Dashboard Vs FDX

XFBR not working when passing Custom Name Function

Getting data from Stage in Finance Business Rule

Re: Allocation

Re: "YTD" like calculation but for custom periods

Re: Allocation

Re: "YTD" like calculation but for custom periods

Re: Rule Rules - ONLY write rules when necessary.