OneStream Community

AndreaF · 07-19-2024

Hi, I have an SQL data adapter that queries an application table, and one of the columns is the CostCenter. This CostCenter is also a dimension in our cube, where the table values correspond to the base-level members of that dimension. In the CostCen...

AndreaF · 07-08-2024

Hi, I am trying to use Smart Integration Connector for connecting to an SFTP server. We have followed the instructions on setting up the Local Gateway servers and the SIC have been created (see picture below). I have written a SIC function to retriev...

AndreaF · 07-05-2024

Hi, we have just added some local configuration values to local Gateway like in the following example: I am trying to retrieve those values. My understanding is that a Smart Integration Function must be created and that can than be called from a dash...

AndreaF · 07-03-2024

Hi, I have a scenario member which workflow properties are setup as follow: However, this means we will have to Reset the scenario next year to change WF Time to 2025 and t change the WF start and end times. Is there a way of using the Range in the w...

Member formula stored items · 06-27-2024

Hi, I have a member with 2 stored items formulas, one on default time and one on 2021. If I am in 2024, which one apply? Thank you

AndreaF · 08-02-2024

Hi, if it is a one-off you can write an extensibility rule to execute your SQL code. From there you are not restricted on the SQL commands you can run.

AndreaF · 08-02-2024

Hi, APILibrary is the class containing the new remote BRApi methods. See an example of a specific use case here: Smart Integration Connector - RemoteEndPointProviderIsInvalid. I agree, the documentation is not great, but there are quite few examples ...

AndreaF · 07-23-2024

@Nikpowar97 thank you for your reply. Option 1 is too complex in my case because the cost centers are not just children of Member A and B, are descendants at various levels down the hierarchy, so it would not be enough to join the Member and Relation...

AndreaF · 07-11-2024

I would also be interested to know if it has been solved in versions 8.1 & 8.2

AndreaF · 07-08-2024

There is no workaround to this, scenario members have to be Reset every year for the Start and End Time parameters to be updated. Only alternative solution is to set up scenarios with ranges that are specific to each year's cycle, but that would mean...

OneStream Community

User Statistics

User Activity

Combine application table and UD dimension information

Smart Integration Connector - RemoteEndPointProviderIsInvalid

Smart Integrator Connector - Retrieve configuration values

Range workflow scenario - Avoid resetting every year

Member formula stored items

Re: How do I clear/truncate/delete BIBlend tables?

Re: Smart Integration Function OneStreamGatewayService Import

Re: Combine application table and UD dimension information

Re: Using the Trailing3MonthAvg View Member in a Data Buffer Across Years

Re: Range workflow scenario - Avoid resetting every year