OneStream Platform Forums

Hi - I have created a routine in Connector Rule to fetch the Worker data from HCM and I was able to assign it to a variables and able to print it successfully.   My question is below    1. How I can assign the variables to the List because I am trying to use this connector rule in Data Source and trying to bring the data to the OS stage Area ? is it possible, My function return type is task for the RESTAPI call.   2. Or I can create a Extender Rule and create a Table in the Backend and import into the table and create an another connector rule to bring it to the stage.   Any suggestion would be appreciated.   Thanks Krishna

I'm working on a cube view that does a variance analysis between 2 difference scenarios. The scenarios will always vary based on the scenario member selected by the user. Some of the rows use the formula "GetDataCell" or a dynamic calc in the member filter. I've found that if I use GetDataCell then Col 4 does not calculate the variance correctly. I started using dynamic calcs to work around this issue. Unfortunately, I have also experienced this issue using dynamic calcs as well. Has anyone else had this issue and what were some of the things they did to resolve this?   My columns are setup like so: Col 1                     Col 2                   Col 3                           Col 4                           Scenario#1    &nbsp

Hi All, I'm looking to filter a dynamic calculation by the base of my income statement and balance sheet accounts. The result of this dynamic calc will be leveraged within a confirmation rule.  Do you have any suggestion on how to effectively filter this?  Thank you in advance.

Dear community, Using the SQL table editor, it is possible to define the "allowupdates" as true for each column. Right now I have a requirement which is to have a cell with a column which should be editable depending on another row: on a specific row, if column 2 is set as "true", then column 3 should be editable.   What would be the most apprioriate way to achieve that ?   Regards,

Hi,Does anybody know what is the "ColumnDisplayType" parameter under the Column Format, part of the SQL Table Editor ?I am keen to know how to use it, as I can't find any information on this.Screenshot of the mentioned field below : Regards, 

Hello,I would like to know if it is possible to format only one word or part of a word in a dashboard label :- How can we make only one word in bold in a label, and not just the complete sentence ?- Could we use conditional formating in order to format only a specific word (for instance, a user login) ? Many thanks,

Hi all, EDIT : I was able to sort this out with some more SQL 🙂I wanted to confirm one point regarding data adapter using SQL statement.Right now, I am using a data adapter with SQL command type, which is using a "join" statement to 2 other tables. When I test this data adapter, it is working as expected and I can see the columns coming from the other tables.However, when I use this data adapter in a Grid View components, then the columns that are supposed to be from the joined tables do not appear. Are there any SQL restrictions when it comes to using SQL commande data adapter in gris view components ? Many thanks,

Wondering if anyone has encountered the issue? It's a simple PDF report book with straight forward column set, but there are slight misalignments between numbers. Ideally, looking for right side justification. Thank you

Hi Experts,   I have the following rule to translate my opening balance adjustment (entered manually in the current year) at an opening rate.   If (api.Cons.IsCurrency() And Not api.Cons.IsLocalCurrencyforEntity()) Then 'Only run for foreign currency Dim timeId As Integer = api.Pov.Time.MemberPk.MemberId Dim prioryearid As Integer = api.Time.GetLastPeriodInPriorYear(timeid) Dim rateTypeClo As FxRateType = api.FxRates.GetFxRateTypeForAssetLiability() ' get closing rate from prior year Dim pycloRate As Decimal = api.FxRates.GetCalculatedFxRate(rateTypeClo,prioryearid) 'use closing rate from PY to translate this member api.Data.calculate("F#ObalAdj = C#Local:F#ObalAdj*" & pyclorate,"A#Bs.Base") End If   While this works perfectly for data entered via Forms, it doesn't work for adjustments entered via journals. When a journal is posted against ObalAdj member, I see  2 things happening:   1. The AdjInput member translates at opening rate ba

Dear community,   EDIT: seems like the column name "SEL" was messing up the behiavor of the column. I changed it to another specific column name and now the drop-down list saves saved & reported accordingly.   I am using a SQL table editor in order for a user to provide some informations. In one of the columns, I want  the user to select yes or no based on a drop down list. I was able to achieve this using a delimited list parameter type, which has been defined as a parameter in the expected column : However, when I save it, the "is selected" appears blank. When I look in the SQL table itself, the value is there.   Table after I save it:   SQL table in SQL server:   Colum configuration:   So what is the configuration so that I can see in the columns what the user have been selecting ? Am I missing something?   Regards,

Good morning,I have a pdf report that varies in page length, however my department requires it to be all on one page. I was successful in getting everything one page using CV Extender function. But since the font size is static, it minimizes the text regardless of pages.  Wondering if there is way to write a rule that can switch between font sizes. For e.g. IF Page Number > 1, then font size 9. Else, run font size 12.  Any idea will be appreciated. 

Has anyone experienced Excel taking a long time to open when the onestream plug-in is installed?  Our users see a 10-30 second delay opening excel when the plug-in is enabled.

  The items below detail the specific list of tasks that are executed for each data unit during the calculation process. Data Unit Calculation Sequence (DUCS) Clear previously calculated data  If Using Hybrid Scenarios  - the copy will run here Run Scenario Member Formula Run reverse translations by calculating Flow members from other Alt Cur. Input Flow members Execute Finance Business Rules (1 & 2) Run Formula Passes (1 – 4 ) Account, Flow, UD1, UD2, … UD8 (Member Formula Execution) Execute Finance Business Rules (3 & 4) Run Formula Passes (5 – 😎 Account, Flow, UD1, UD2, … UD8 (Member Formula Execution) Execute Finance Business Rules  (5 and 6) Run Formula Passes (9 – 12) Account, Flow, UD1, UD2, … UD8 (Member Formula Execution) Execute Finance Business Rules  (7 and 8 ) Run Formula Passes (13 – 16) Account, Flow, UD1, UD2, … UD8 (Member Formula Execution)

Originally posted by Eric Osmanski 4/13/2020 I want to create a SQL Select Statement but I need to check whether the table in BI Blend exists first.

When creating a Copy Data (Data Management) job, I find that I have to have the import nodes of the Workflows set to True (Active) in order to have the Data Management job work, otherwise I get an error. I do not want the end users doing anything on the Import node and would rather they were set to False. Is there any way around this?

Customer has intercompany transactions in local currency. They want to eliminate sales and cost of sales and have the remaining margin (in local currency) at the Sales entity - not in an elimination entity - and be able to view in local currency.  For the entity purchasing the goods, it should be zero. Is it possible to do this in rules? Or some other way?    thank you

I would like to use the Cloud Administration Tools > Manage Applications to copy our Production application to Development (refresh Development).  I have reviewed the documentation and OneStream Academy video for how to do this but have a few questions. 1) Does it copy all the data in addition to the artifacts and metadata? 2) I see an option to have it reset IIS when completed but do you know if it stops IIS in both apps before doing the copy?  If not then do I just need to make sure I do not initiate the Copy when users may be in the applications? Thank you Denise

Existing customer is using Guided Reporting and has multiple Drop Down Boxes.They would like to select the first Dimension's Drop Down Box (Entity) and only See valid choices for the second one. In their example, if they choose a Philadelphia Entity they only want to see the Departments (Ud2) that are valid for Philadelphia.Is there tagging or another method where this can be done dynamically? Or worst case scenario, a hard coded list of what are valid combinations? Thanks very much. 

Example:On the workflow France I have the choice between 3 entitiesI choose to input the package of the entity FR0200. I select a first time the entity FR0200 (1)When I go on a second form, I lose the entity and fall back on the first entity FR0220 (2)The entity viewpoint is set from a parameter as below:Parameter type : Bound ListResult format string type : DefaultMethod type : WorkflowProfileAndDescendantEntities thank you for your return

We are looking for ways to reduce the data unit size in one of our cubes in order to increase reporting performance without having to do a redesign.  We currently have +20k UD1's and +10k accounts in this cube and 16 years of historical data.  Would updating the "In use" tag to false for inactive accounts and UD1's reduce the data unit size and help improve data pulls and reporting performance for current years?  We aren't able to completely remove these accounts/UD1's because we are going back 16 years for historical purposes.

I want to create a button on my excel spreadsheet that will execute a BR or a DM is this possible?  I see that there are OS functions called XFGetCellUsingScript and also a XFPut but I can not find any documentation on all for any function except the basic XFGet, XFPut and GetMemberPropertyetc.   Is there documentation somewhere that I am missing?

SOURCE: ONESTREAM CHAMPIONS We have two security groups we use to manage journals, one with access to Post journals and one to Create journals (and Submit them). We’re seeing issues where the person with the access to post journals isn’t able to post auto-reversing journal types. They can post standard journal type fine though. Has anyone come across this before or have any insight? For the Workflow Profile, it seems to be the Journal Process Group security driving this, but we don’t want people who post to be able to create journals as well.

The attached file will help plan rules from HFM to OneStream

Hi, Is it possible to have headers for the Dimensions inside the cubeview ( Row Member expansion)?   Thanks & Regards, Madesh K

Hi All,   I'm trying to display prior 6 months in my cube view. For e.g. if my WF time is 2021, I want the CV to show last six months in 2020 (Jun - Dec) and so on. I tried using half year member filter, but it didn't work as it should. Any suggestions will be appreciated.   Thank you, Mustafa