OneStream Community

GregHertling

Hi, is there a limit on the number of cells that can be updated through Table Views? We have a large table, 250 rows by 140 columns. When we try to update all values at once, there are many cells that do not update. When we only load 10 or so rows at...

GregHertling · 06-29-2023

Hi, I have an Advanced Chart where I am displaying dates. The values, however, are stored as ticks(Long). This is great for the bars and points, however, I need the Axis labels to be displayed as date (not Long see below). I've tried a few versions o...

GregHertling · 04-04-2023

Hi, I have a matrix data source matrixed on Account. Sample below. One of the Account fields is a Date that I need to convert to a Long to store. I can do the conversion but not sure how to target the value to convert when in a matrixed data source. ...

GregHertling · 03-27-2023

Hi, is there an ability to change the Classification field in the Cell Detail right click from a combo box to a freeform entry?

GregHertling · 02-05-2023

Hi, how many periods can be loaded and validated at once? I have the need to load 360 periods, but I seem to be getting timed out. thanks,Greg

GregHertling

hi Chris, it seems to be working well.  thanks for the help!

GregHertling

hi Chris, I am in need of similar code for XIRR, can you point me to the post that you mention? I'm not seeing the link. thanks, Greg "I went another direction on this XIRR journey -- one that was simpler to code and uses the Microsoft IRR function a...

GregHertling · 07-05-2023

hi, I tried to pass the datetime values to the chart, but can't seem to do it. I can pass as a string, but that is not helpful. Below is the BR and Chart config. thanks Dim oSeriesCollection As New XFSeriesCollection() oSeriesCollection.FillUsingCube...

GregHertling · 04-07-2023

Hi, we actually have over 300 Account columns in the source file with various data types. I was finally able to get this to work. First I had to ignore any columns with no data. Then before the return statement I had to add: api.ValueIsnumeric = True...

GregHertling · 04-05-2023

unfortunately args.value is still only pulling the Account names and not the values. I am putting the Rule on the Account1 column. It seems it is only pulling the related Dimension values. When I use args.line on the Amount, surprisingly I can at lea...

OneStream Community

User Statistics

User Activity

Data Cell update limit on Table Views

Displaying ticks as Dates in an Advanced Chart

matrix parser rule to change date to long

Cell Detail Classification

Number of periods that can be validated at once

Re: Referencing C# Workspace Assemblies from VB.Net, Warning Access of ... not evaluated

Re: Referencing C# Workspace Assemblies from VB.Net, Warning Access of ... not evaluated

Re: Displaying ticks as Dates in an Advanced Chart

Re: matrix parser rule to change date to long

Re: matrix parser rule to change date to long