OneStream Platform Forums

I am trying to do a calculation for a few specified members (putting to E and U4) but only for base of certain hierarchies under Account and UD1.  Here is the example of what we want to do: api.Data.Calculate("E#NonRolled:O#BeforeElim:F#EndBal:U4#NonRolled_Calc = RemoveZeros(E#1000X:O#BeforeElim:F#EndBal:U4#Reported - E#2000X:O#BeforeElim:F#EndBal:U4#Reported )","A#Management_Income_Statement.base") However, I understand you can not have Entity as part of the left hand side the equation since it would create an invalid data unit. Does anyone know a way around this, or an alternate way to accomplish this?  

I am trying to assign the text field stored value in a variable in Business rule. Here is my code that I am trying- but getting a compilation error.  dim pov_U7text1 as String = api. pov.UD7.Tex1   Please advise  

Hello everyone, I am trying to create a data source with two numeric values, one being amount and the other one being volume. But I am not sure if this is possible. Objective would be to be able to look at a P&L either in currency amounts or in unit volume. Is it possible?like this 

I need to load a XML file with a Business Rule. Like read the XML in a folder and load it automatic in OS.Is it possible? Thx on advance

Hello ! I would like to use a data buffer that would read data from another Scenario than the one set in my data management job, is it possible ? Right now, I have a simple formula that should retrieve data from scenario S#Simul while I'm running the business rule from a data management which is set on S#Actual, but it returns nothing :   Dim dbr_keys As DataBuffer = api.Data.GetDataBufferusingformula("RemoveZeros(FilterMembers(S#Simul:V#Periodic:AEAccount1:F#None:I#None:O#Forms:U2#None:U3#US:U4#None:U5#None:U7#HO:U8#None:F#None, U6#C4.Base))",,False)dbr_keys.LogDataBuffer(api, "dbr_keys",100)   Is there a specific data buffer script to use in order to run on another data unit ?   Regards,

I need to update a WFP property through a Business Rule, properties like AccessGroup, WorkflowName, etcIs it possible? Thx on advance

I am building a cube view that has 3 row set options. The user selects their row set by a parameter, placed in the row sharing property of the cube view. Depending on the row set selected by the user, I need the page caption to change. The page captions for each row set options are static and will not change. Is it possible to pull the page captions when the row set is selected? Or, can I make the page caption change depending on which row set option is selected? I would like this to be selected concurrently with the single parameter that already exists. I don't believe I can pull the row set POV to the page description, and I cannot figure out a way to pull a delimited list based on another delimited list parameter selection.   Hypothetical example: The user selects from 3 row set options; GBP, EUR, or USD. Depending on their selection, the page caption should read 'Investment Report GBP', 'Investment Report EUR', or 'Investment Report USD'. The row sets are different depend

I am trying to load data into a new cube from the vStageSourceAndTargetDataWithAttributes table.  I am seeing most lines duplicated numerous times and the only field I am seeing with different values is the 'Ri' field.  I have not been able to find a listing of the definitions of the fields in this table and so am struggling to determine why the data is duplicated in Stage.  I have checked the actual data import from Snowflake and it does not show duplicates at any stage of the import process. The SQL I am using to pull the data is: SELECT TOP 100 *FROM"vStageSourceAndTargetDataWithAttributes"WHERE Si = 'SF_Rev_Summary'AND Ac = 'ACCT0334_AC'AND Et = '0034_ME'AND Tm = '2023M1'The results from the data adapter are below, the first 5 rows are duplicated apparently due to the 'Ri' fieldI appreciate an insight or feedback folks may have. Thanks

Hi dear Community, I'd like to know whether it's possible to create a dynamic CV description somehow. So far, I've tried using parameters, substitution variables, and Business Rules (BR) in the description field but it's always considered as a plain string. Thank you in advance for your help. Best regards, Carlos  

I am creating a cube view by defining "member.childrenInclusive" on the rows. Is there a way to increase indentation on the child members without defining each members on separate rows and specifying indent levels?

All,Is there a way to extract metadata(entity dimension) with just parent child relationship information and not all the application member properties  using the usual export process?

Hi All, We are using XFGetCell's all the time in excel and one of the user reinstalled MS Office recently and he started facing issues XFGetCell. Please see screenshot below. XFGetCell function is defaulting to OneStreamExcelAddIn.XFFunctions.XFGetCell and this is causing refresh issue. If I try to remove the highlighted part the sheets are working fine. Any suggestions will be appreciated ? Thanks Sridhar 

HiI am executing a data management sequence from a business rule and I would like to display the task progress dialog box. Is this possible?e.g. When I click run from the Data Management tab I get the following:I would like the user to see the same thing when I run the data management sequence from a business rule.Regards,Mark 

Outside if BI Blend, is there a use for the Attribute Dimensions and Attribute Value Dimensions?All of the documentation that I am reading, the search for Attribute Dimension only shows up in the BI Blend Section.

Does anyone have a solution to having the workflow period default to the global time? It's a minor annoyance, but for those switching workflow profiles often, it's annoying that it just always defaults back to Jan, and then you have switch to the current period. I understand that not all workflows are set monthly, but if your scenario Input frequency is monthly, it would be nice if it could read of the global time as the default period it goes to, versus just going back to a locked period.

Hello,I am running a Business Rule to extract Forecast data using Data Management task. The BR is working fine for Q1 Fcst, Q2 Fcst but when I am running the same BR for Q3 Fcst, it is failing and giving the below error.Error message -*********************************************************************************************************Summary: Error processing Data Management Step 'Export_TAX_PandL'. Unable to execute Business Rule 'extr_TEST_TAX_ExtractPandL'. Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (SQL Error Number -2146232060, -2). The wait operation timed outThe process is also running fine in QA without any issues for all the scenarios.Any inputs much appreciated!! Thank you!

Hello,We noticed that Workflow on entity can be unlocked and relocked even if the parent workflow (period) is locked. We need to have a direct dependency between the parent and child workflows for the lock of the period.

Does anyone know how the "Has Data" field in an FX Rates CSV file is actually being used?   The Design and Reference Guide lists it as one of the columns in the file. I've only seen it extracted with a value of Yes in this column. What is its actual use?  Is it necessary for Loading FX Rates?  What does "No" mean, for that matter what does "Yes" mean?  

Hi, do you know where can I find the Forgot Password option? 

I need to copy one application to another, for that I am wondering if i need to go to the OneStream SQL server and extract a database ( or database schema), and if so how would i do this?The goal is to extract the entire data of an application to import it in another app

Hi All, I need to calculate the base members and roll up to Total member as shown in the below picture I tried using GetDataCell formula but am getting error, can anyone suggest how to do that.Please find the below snaps for your reference. Thanks in Advance.   

Anyway we can copy cell details (Amount, aggregation Weight, Classification and description from period 1 to Period 2 via business rule?  

Hi, I am starting last month as Admin. I am trying to help one of our internal users with an issue. The amount that was imported by accounts and by base level LE_PC_CC that belongs to the gray area in this Workflow can't be seen or opened in this WF form to be manually adjusted. Is there something wrong with the configuration of the Workflow?  Thanks in advance!  

We leverage MS Azure single sign on for OneStream.It seems like lately we experienced an issue where users are not able to login using SSO.Is this a known bug with version 7.1.3.14022?The way the support team resolved it was do an IIS reset on the servers and disable/reenable SSO but we don't want to keep doing this.Thoughts???

Hey all!So I have noticed a strange behaviour on my Dashboard buttons with Workflow navigation "links" like below: Above works great it takes me to Profile, Scenario and Name. However when I want to go to below instance, the previous year (2024) remains, even though in this case I have hardcoded 2023. I have to press the button 2 times in order for below value (2023) to kick in!I have several buttons where I use substitution variables and business rules to fetch times. But for this particular example it is not working, only difference in this case is the scenario which has some set parameters: Does anyone have any solution how to get the button to work on the first click instead of having to click 2 times? Thanks in advance! Jones