OneStream Community

Afone

Hi, I have an existing extensibility rule which copy some data from a source scenario/period to a target scenario/period. This is the "core" of the codeDim listDriversDataCellExFilterdForDriversTarget As New List(Of DatacellEx)For Each itemDataCellEx...

Afone

Hi,I have an Extensibiity rule which uses the "Imports WinSCP" command as is used to connect to an SFTP server. The rule works fine. I have just made a copy of the rule within the same application because I wanted to try and make some changes, with t...

Afone

Hi,is it possible to use time functions other than "WF" in cube view point of view? For example, I have the time function "T#WFYearM12" (it takes the current workflow year and add M12 at the end to get the December month). The function works as expec...

Afone

Hi,I've build an dynamically calculated account that should show the FTE YTD average, so that if the month is February it returns the average FTE of the Jan and Feb, if the month is March it returns the average FTE of the Jan, Feb and March, etc.It m...

Afone · 10-13-2022

Hi,I'm trying to build a cube view having a list of Entities on the rows. I'd like the row label to be the entity description followed by the entity currency.I was trying to use the Name function to do that. I am able to display the entity currency l...

Afone

I think a good starting point is looking at one of the market place solutions, most of which have buttons to upload files. You can copy the code from there. For example in People Planning there is a dashboard extender rule called PLP_SolutionHelper w...

Afone

Excellent! Yes, I forgot to do that, thank you!

Afone

Thank you for your reply. I now can see I can use the standard time functions like WF and WFYear in the CV POV. I guess my question then become the following: how do I create a function similar to the "T#WFYearM12", which is working in the row/column...

Afone

I have just noticed I can use the YearAvgToDate member from the View dimension to return the average. The members seems to work fine with balance accounts too!Now my formula is much much simpler:'Return the YTD average of the FTE accountReturn api.Da...

Afone · 10-13-2022

That works brilliantly, thank you very much!

OneStream Community

User Statistics

User Activity

Filter datacell on UD dimension

Imports WinSCP

Use time functions in cube views POV

Dynamically calculate YTD average

Concatenate strings in the "Name" function

Re: Automation to upload files from Sharefolder to OS

Re: Imports WinSCP

Re: Use time functions in cube views POV

Re: Dynamically calculate YTD average

Re: Concatenate strings in the "Name" function