OneStream Community

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 · 01-17-2023

Hi, I have a CV Form where the input is a "Date" Cell Type. I need to use the date to translate to a OS Time Period. I am struggling with using the Date value in a Business Rule. It only returns an Integer and I can't seem to convert the integer to a...

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...

GregHertling · 04-05-2023

I'm using a delimited file (.csv)

OneStream Community

User Statistics

User Activity

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

Using Date Cell Type in a BR

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

Re: matrix parser rule to change date to long