OneStream Platform Forums

Hello everyone -    As the title mentions. How do I grab a list of entity members which contains the word "district" within its name/description? 

Hi, We would like to have account instructions in one place like a manual on how each account in the Balance Sheet and Income Statement etc. should be used. Are there anyone that has tried to incorporate that into Onetream? Like below: All suggestions highly appreciated   

Hosted by Azure/Managed by OS, so never spent anytime learning how to monitor our environment other than at the very high level (System-Environment-Refresh). Hoping someone can point me in the right direction.  Really looking to see how long Excel queries take, steps within consolidations and just general overhead.  I seem to remember something provided within Azure to monitor but not sure if that is still around or not.  We are heavy for 8 days and adding more functionality so need to make sure we can still run acceptable during that time.

Originally posted by Ashok AmreshWe are loading data using SQL connector business rule and it works fine manually. looking for a way to load it automatically using a extender business rule and then calling from DM step. has any one done this? can you share sample code if possible?

I have a report that uses it's own conditions to calculate a value. Is their a way to over-ride the blank/data cell in cube view, and have it run a simple IF conditional calculation? Most of these conditional calculation are for KPI's (basically forecasting for 2023 and on..). One of the condition within excel I'm referencing.      Would appreciate your suggestions. Thank you!   Best, Mustafa    

Hi OneStream Gurus, I have a workflow profile with multiple rows (assigned entities, parent node....). One calculation definition executes a data management sequence. I am using the WF text to pass the entities to the DM sequence and this works fine.. But I was wondering if there is a way to pass the entity from the calculation definition row to the DM calculate sequence or the data quality event handler business rule. As expected if I use the E#Root.WFCalculationEntities in the DM calculate it runs for all entities defined in all rows. Thanks Maja

Is it possible to have a number formatting to show a dash "-" rather than a zero "0"? Thanks

Hi, I am (again) trying to use parameters in a SQL table editor. My parameter is set in order to get a column from an SQL table. When I test the parameter, this is working fine. However, when I add this parameter (which is a bound parameter) to the column of my SQL table editor, I do have the set of value from my parameter, but when I save the selected element, it appears blank. When I check the SQL table itself, I can see the value. This is probably silly, what am I missing ? 😓   Parameter definition : SQL statement : SQL table editor for the selected column : AllowUpdates = True, ColumnName = INDEX_CSR_CAT03, DefaultValue = |!P_CSR_QUESTION_LIST!|, Description = [Question code], ParameterName = P_CSR_QUESTION_LIST   State of the SQL table editor before save ; State after save : SQL table :      

We have cubeviews were we have enabled "Include Cell Attachment Status" and we want all comments printed on the PDF report at the end with reference to the POV, is that possible and if yes how do we do it? We have used Annotation Detail as we what our users to be able to have answers questions in a new Annotation Detail. Any advice highly appreciated! // Katarina

Hi OS gurus. Hoping to get a little help on converting a Hyperion line of codethat is using SUMRANGE to OneStream. Here is the Essbase line I am trying to convert: IF(@ISMBR("Assoc Ex Elim"))@SUMRANGE("Cash - Asset",@CHILDREN("Assoc Ex Elim"));ENDIF This piece of code is going to reside in a Flow member that has already been setup as a DynamicCalcTextInput member. It already has codewhere it is calculating account "A29970 - Assoc Ex Elim" based on if a Cash account is positive or negative. It works good but is doing it for all UD1 members, we want UD1 member named"Assoc Ex Elim" to not use this Cash account formula but rather just consolidate what it's children have. This is what the Hyperion code is doing. I have tried the following but no data comes back for it:If api.Pov.Account.Name = "A29970"Dim UD1NAME As String = api.Pov.UD1.Name   If api.Pov.UD1.Name = "Assoc Ex Elim"    api.Data.Calculate("F#ENDBALCALC=F#ENDBALCALC","A#A29970",,,,"UD1#[Assoc Ex Elim].Childr

Hi, Is there a way to set up dependant parameters, ie. Paramater value that depend on another parameter?The idea is that the user select a value  among a list in parameter A (which is not a dimension element), then the list in parameter B will be filtered based on what has been selected in Parameter A ( not dimension elements as well). Regards,

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

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