OneStream Community

AndreaF · 01-04-2024

Hi, I know I could create a custom member list of an XFBR rule for the scope, but is there an easier option to get the cube view rows ordered alphabetically based on member names? Eg. currently, if I have E#Ent1000.Children in row, the cube view is b...

AndreaF · 12-12-2023

Hi, I have a Bound List parameter with Command type SQL. 1. I have first tried to use an XFBR rule within the string of the Like condition. This works fine. 2. I have then tried to use the XFBR to return the full condition "cvi.Name Like..." (see bel...

AndreaF · 11-23-2023

Hi, is there an BrApi command that returns the Application Currencies, ideally as a list of strings? I would like to use the output, i.e. the list of currencies, in an Extender business rule, where I need to loop through them. Thank you

AndreaF · 11-23-2023

Hi, I have an Application table containing a number of attribute columns, a currency column (EUR,USD,TRY...) and an Amount column. The client wants a twin table that has all rows from the table 1, but with all values converted to euros. I already hav...

AndreaF · 11-08-2023

Hi,I have a Custom Calc rule called by a data management step and I am experiencing a weird behaviour. I know there is data in Actual 2023M6, and I can get that data when running the data management step from either Actual 2023M12 or MF7 (name of ano...

AndreaF

The datatable exists within the data set business rule, so yes you can run a query against it, but within its limit of existence, as for any other variable, i.e. you cannot refer to it from other business rules or outside the function or loop where i...

AndreaF

Hi @AndreaTout , there are a couple of old threads on IdeaStream which have been closed on dark mode. Currently there is this one open which I have kudoed, and that I can suggest to you: Dark Mode For Business Rules and Assemblies code editing

AndreaF

HI, I suggest making the member dynamic calc, so that you can specify a formula for both the V#Periodic and V#QTD cases. The stored formula is not going to work: if you calculate on V#QTD, data calculated quarterly will be allocated to the dependent ...

AndreaF

Thank you. I don't have access to an on premise OS server at the moment. For cloud implementations I guess we will have to request the DLLs to OneStream support? I will contact them and let you know their reply.

AndreaF

@NicolasArgente , how do you add the OneStream intellisense to Visual Studio?

OneStream Community

User Statistics

User Activity

Sort cube view rows alphabetically based on member name

Use of XFBR in the SQL query of a Bound List parameter

Command returning all Application Currencies

Convert Application table data using FxRates

GetDataBufferUsingFormula not getting data when refering to a different scenario and time

Re: Execute sql on data table

Re: OneStream UI - Dark mode

Re: Monthly and Quarterly percentage

Re: Business Rules in Visual Studio

Re: Business Rules in Visual Studio