Discuss the features and functionality of OneStream.
Recently active
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  
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.
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.
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
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 everyone, When we run a confirmation step, we have a DB to show all confirmation passed or failed and when it failed we have Information 1, 2, 3, but with this DB we can only see confirmation rule by confirmation rule. This point is very inconvenient if you have more than 10 entities in your WF I have a another DB to show all confirmation rule by entity, this is very helpful for the user but I would like to add Information 1,2,3 from table 1 to the table 2 (as image) Do you have any idea with which table I can take these column ? maybe I can joint 2 tables of sql and create a new one with all information Table 1: I dont know where I can find it Table 2: this table is native in Onestream Thank you for your help Have a nice weekend 🙂 Hoa PHAN
Source: OneStream ChampionsHi all!Do any of you run allocations in OS? Would you be able to share how you accomplish this?Currently we manually reallocate data that comes into our income statement accounts under one UD2 to two UD2s based on the percentage split of units (which is a stat account in OS). This is loaded as a balanced journal entry every month but I’m wondering if there’s a more efficient, less manual way to accomplish it.I tried reviewing OS academy, the design doc and golfstream and can’t find a good example of an allocation being run. Would any of you have a suggestion? For a simple allocation like this, would you recommend a CV form to allocate or would the Allocation journal entry type work better? Or maybe it’s a formula on the UD2 member itself that triggers the allocation?I’ve also submitted a support ticket but was thinking that maybe some customer experience would be useful too.
We are trying to set up a fixed matrix data source that has account values in multiple columns (mix of numeric and text). Is it possible to convert the text value for an account to a numeric value in the data source set up? e.g. Account text value is regular and we would like to convert it to a numeric value of 1.
Hello How does one write an aggregation business rule? I know Accounts aggregate automatically, but a business rule is needed for Entities, correct? In Essbase we could have something like: FIX ("2025","Jan":"Dec","Actual") Calc DIM ("Account","Source","Product","ResponsibilityCenter","Interco","Entity","Location"); ENDFIX;
This seems like an extremely simple question ... I'm barely just learning OneStream, and I must be overlooking something obvious.I copied our production application to an application named Debug so I can try to investigate a problem without affecting our production app. But after I log off of the application and try to log on into the newly created application, what steps are needed to add the new application to the pulldown list of applications?When I review the Task Activity report, I can confirm that the task to create a new application named Debug completed, and there are no errors associated with that task. And if I open the page for History Detail, the line shows that I successfully created the new application named Debug.I've completely quit OneStream (I'm running the Windows version of the app) and re-run it to try to refresh the pulldown list. If I log back on to the Production instance, I can return to the cloud administration tools and select the option to Manage Appli
Is there a way to use multi-line expressions in the definition of my cubeview rows? I would like to break down some of my expressions that are growing too long. But my fear is that when I use multi-line expressions (assuming that is possible), then other onestream developers won't know about that - since the cubeview doesn't give any visual cue to show that multiple lines are being used. Here is an example of a really long expression that I'd like to break apart. E#AllBranches.Base:Name("{BranchCode = XFMemberProperty(DimType=Entity,Member=|MFEntity|,Property=Name)},{BranchCurrency = XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Currency)},{BranchText2 = XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Text2)},{BranchText6 = XFMemberProperty(DimType=Entity, Member=|MFEntity|, Property=Text6)}, XFMemberProperty(DimType=Entity,Member=|MFEntity|,Property=Description)")
is there a way in Onestream to prevent S.C# as a valid scenario on XFD form uploads?We are attempting to prevent users from using an older XFD upload form that have been set up with the scenario as S.C#. We can then control future form submissions with transformation rules.Thanks
Hi, I'm trying to set up some new Cash Flow accounts, and as usual I'm looking at the existing CF accounts to see how they've been set up. However, I'm pretty new to OneStream, and I'm struggling to make sense of some of the Syntax. I've had a look in the 'OneStream XF Reference Guide.pdf' but there isn't much info there. Where can I find more info on Member Formula Syntax? Is there another document that I'm missing?
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.