OneStream Community

AndreaF

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

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

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

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

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

@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

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

AndreaF

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

AndreaF

Example of Smart Integration Function to retrieve the Local Gateway configuration values: Imports System Imports System.Collections.Generic Imports System.Data Imports System.Data.Common Imports System.Globalization Imports System.IO Imports System.L...

AndreaF

Hi, the Gateway Server has 2 SIC, a direct connection and a database connection type. The solution has been to change the ExecuteRemoteGatewayBusinessRule to use the Database connection for the purpose of retrieving the configuration values: Dim objR...

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

Re: Smart Integrator Connector - Retrieve configuration values

Re: Smart Integration Connector - RemoteEndPointProviderIsInvalid