OneStream Community

Ioana · 03-12-2024

Hello, I am trying to adjust the code below to handle the following situation: The client loaded data for Test Rate and Test Count on UD1 "ID". The data buffers defined for prior month (TotDirCOGSDataBuffer and DirCOGSDataBuffer) do not have any valu...

Ioana · 03-08-2024

Hello, The client has a calculation for the planning process where I used the prior period values in the calculation for current month values. Here is the data buffer I created: Dim OpCostsDataBuffer As DataBuffer = api.Data.GetDataBufferUsingFormula...

Ioana · 02-16-2024

Hello, I am using a cube view that has the same rows, but it needs different columns based on the UD8 member. I built multiple template columns cube views, and created a parameter for UD8 members. I want to retrieve the column template CV based on th...

Ioana · 06-21-2023

Hello, The client that I am working with is moving from an import process consisting of loading .csv files over to a direct connector. The issue is that in the periods where .csv files were loaded, one UD was manually adjusted in the import file, and...

Ioana · 06-07-2023

If I have data coming from a connector in OneStream, and then I submit a sheet having XfSetCell formulas, what values will remain in OneStream after consolidation (having the same dimensions intersection)? The data coming from the connector, or the d...

Ioana · 03-12-2024

Hi Robb, The data buffers should look at prior period. The Test factors should look at current period, as how the code shows. Data buffers do not have values on UD1 ID on prior period. Test factors have data on UD1 ID on current period. The calculati...

Ioana · 03-08-2024

It seems like T#2024Q4 type is not valid for V#MonthAvg:  

Ioana · 03-08-2024

I tried to test the V#QuarterAvg, but it does not get the Average when picking T#2024Q4 for example, it puts the average on Q4 periods (M10, M11 and M12), but T#2024Q4:V#QuarterAvg retrieved the total amount: I needed to see the 208K put on T#2024Q4:...

Ioana · 03-08-2024

Also, the POVPERIODNUM is defined like this: Dim POVPERIOID As Integer = api.Pov.Time.MemberIdDim POVPERIODNUM As Integer = api.Time.GetPeriodNumFromId(POVPERIOID)

Ioana · 03-08-2024

Hello, I tried to replace the /3 and put it inside the GetDataBufferUsingFormula, but got an error. This is how I placed it: OpCostsDataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(RemoveZeros(F#Top:O#Top:T#" & Year1 & "Q4" &":I#Top:U5#...

OneStream Community

User Statistics

User Activity

Redirect Data Buffer result

Change data buffer based on time

XFBR for Column Sharing

Moving from an import process of loading .csv files over to a direct connector

XfSetCell vs data imported - which one will remain in the cube after consolidation?

Re: Redirect Data Buffer result

Re: Change data buffer based on time

Re: Change data buffer based on time

Re: Change data buffer based on time

Re: Change data buffer based on time