Application Build

I have the request to automate FX rates upload. Rates are stored in DWH (Data warehouse) and that would be easy if I could simply connect there. Unfortunately DWH team doesn't allow it, instead of it they can push their FX rates into my database. Any idea how can I get them such access? Thanks!

Hello !   As stated in the OneStream V8.0 the release note document : Cube View Shortcuts: Cube views have been enhanced for scaling, shortcuts, andhotkeys. See Shortcuts, Scaling, and HotKeys for more information. (PF8-57) But this paragraph is nowhere to be found... does someone know what are the new shortcuts, scaling and hotkeys that we could use in Cube View starting release 8.0 ?   Many thanks !

In v9.0, I have created all my cube views in a named Workspace (i.e. Not Default). I need to attach a single Cube View to a workflow task. In the past, I would create a Form Template Profile which I would then assign to a workflow Form Input task. In v9.0, when I select the Workflow task, I get the message (Unable to open Cube View "mycubeview"). Is this possible, or do I need to create them under the Default workspace or under Application->Presenatation->Cube Views? Thanks

Hi All, I am trying to use getSessionDataTable and SetSessionDataTable for loading data from a file placed in harvest folder and then using the table to store it in cube with direct approach. Can anyone provide more insight on these functions? How is it work and if there are any challenge of using these functions?

Hi Team,In guided reporting, I've attached cube views that contain parameters. Defined global options in guided reporting setting.When I discover parameters, it does not work. Can't see the parameter list.

Hi All, I am trying to explore and use Dynamic cube services for one of the requirements however not sure where to start on this. Could you please help me with some inputs around this if anyone has implemented this ? Thank you.   

Hi All,Any idea why the formula below won't work in CV?GetDataCell(T#|!Par_Time!| - T#|!Par_Time!|.Prior1)The first column contains the formula, and the second one contains this: T#|!Par_Time!|.Prior1. Regards, 

I am currently working on a SQL Table Editor component in Workspaces and would like to know if it is possible to dynamically change the background color of a cell after a user edits its content (e.g. highlight the updated cell in a different color). Is this functionality supported in the SQL Table Editor? If so, please share how to implement this behavior - either through a business rule, parameter or any available UI configuration. Any guidance or examples would be greatly appreciated.

Hi all,We have a situation where an Entity was created and incorrectly set up and contains data for period 2024M12 and 2025M3.We decided to create a new Entity and updated the transformation rules to ensure that the data loaded goes to the newly created member and not the old one.We have set the consolidation and ownership percentage of the old entity to 0 as added measure.We are now faced with the challenge of not deleting the member as it contains data.Kindly asking if it is advisable to set the In Use feature in this scenario and is there any impact that would cause.Thanks in advance.

Hi everyone, I'm having problems in writing data to one scenario through a cubeview. I have 2 scenarios available. If in the cubeview I use one of them, it allows me to manually input data. If I change the scenario, I cannot input data anymore. All the other dimensions are base members and they are unchanged.In addition, I cannot find the setting to allow data input on one specific scenario. I checked the settings of both scenarios and they are identical.Does anyone have any idea how to do it?Thanks!

Hello,we need to turn on the "Logon Activity Threshold" on our OneStream cloud instance. I have looked at the documentation and I believe the information there regarding this is for on-prem installations (it involves editing configuration files).I do see this on the cloud application:Is this where you set this on cloud?If so, is this enough to prevent the users from accessing the instance if they don't log on in the required interval? (I ask this because of this post: Automated process to disable users based on Inactivity Threshold / Remaining Allowed Inactivity | OneStream Community)Thanks in advance.

I need to be able to visualize a cube view in english and in spanish.The description of the account member is set in spanish, and if I put something in the 'English' line, because the user security only has the English option in culture, the cube view would come out in english. So i need to be able to add another option for culture in the user security. ¿How can I accomplish this?Thanks!  

Hi,Out of Curiosity, Is it possible to update Task Activity.

Hi All, For the folks that upgraded to v8 (preferably 8.4 or 8.5), I have few quick questions. How long it took for the whole process? Did you see the performance improvement? Did you require an extensive end-user testing? How was your overall experience with upgrade. Any lessons learned that you can pass on? Thank you in advance for your time. Cheers PM

hello everyone, do you have any idea if its possible to create a home page button that will link to Application Cube> FX Rates? Thank you

Hi all,While getting into OS, I'm trying to figure out how to leverage on its framework... And I have a question related to secrets management.Let's say that - at application (workspace?) level - I need to access to a remote service that requires an OAuth token (or user/pass tuple, or whatever I need to keep away from user's eyes - and fingers).The above mentioned secrets should be (visually?) managed by an administrator. Does OS offer something out-of-the-box to accomplish this task ? And, in case, can we leverage on some API to retrieve secret data ?Thanks for Your answers.FabioG

Hi Team,   I have a question around the orphan members. I know that when we remove the relationship, the member gets moved under the Orphan section. After moving to the Orphan section, can we load data into the member through the Workflows? Thanks in advance AK  

I am trying to record an additional Depr Exp in December 2024.   Db Depr Exp (P&L) Cr AD Machine &Equip. (BS) However, when I roll into January 2025, the effect of the December entry has been calculated into the BOP Retained Earnings, but my balance sheet does not balance.  I can tell the AD Machine & Equip account does not reflect the additional amount recorded in the journal entry.  I need to enter this JE into January of the following year, am I supposed to enter this as an unbalanced journal entry, hitting only AD Machine & Equip?  

 Hi,  I'm trying to display a time-variant text property of the UD1 dimension member in a report. The challenge is that the text value can exist in any period of the member, so I currently loop through the forecast periods (spanning two years) to retrieve the values. While the code works, its performance is not good.Is there a way to fetch or look up the text properties by time (possibly from a specific table) without iterating through all periods? Any command or optimized approach to achieve this efficiently would be highly appreciated.Dim Date As String = $"{year}M{month}"   Dim timeID As Integer = timedimhelper.getidfromname("Date")Dim myVaryByTimeId As Integer = BRApi.Finance.Members.GetMemberId(si,DimType.Time.Id, Date)Dim mbrText As String = BRApi.Finance.UD.Text(si, 9, mbrId, 1, -1, myVaryByTimeId)

We are in the process of changing our chart of accounts and department structure (for us, UD3 and UD1, respectively).  Further complicating things is that some of the old UD3/1 members will likely be consolidated into one UD3/1 member, and vice versa.  We will need to keep the existing data in its original intersections (e.g if UD3#ABC changes to UD3#123, we need the historical data to stay in UD3#ABC).  Or do we? We currently map each of our 3 different GLs* in UD3 to accounts in the A# dim which is at the P&L/BS level.  Has anybody out there done this before?  What approach did you take?  Can we simply create new transformation rules and somehow reference the old ones for historical data?  Do we simply create a new hierarchy in UD3 for the new members (bloat?)? If so, how do we reference them in dashboards and cube views that compare past and present data?  I have so many questions as to the best or simplest way to do this.  Bonus poin

Hi all,I'm in trouble in using an XFBR from an Assembly, inside a Data Adapter.I've just discovered that it's possible to use the XFBR function as part of a SQL Command, like this:SELECT * FROM MyTable WHERE MyField = 'XFBR(MyBR, MyFunction, Param1=|!prm_Whatever!|)'I was surprised to see it working, but this is not the point.When MyBR is defined as a Business Rule, everything isworking fine.Then I moved the Business Rule into a Service XFBR. Since the Factory is defined at Workspace level, I converted the query as:SELECT * FROM MyTable WHERE MyField = 'XFBR(WS, MyFunction, Param1=|!prm_Whatever!|)'Directly testing the Data Adapter everything works fine, I can see the converted query and also the results.Now, the problems:The above mentioned Data Adapter is used by a Report. When the XFBR is defined under the Business Rules area, everything is ok.When I launch the report (from a Dashboard), i get the following error:Error processing XFBR String 'MyFunction'. Unable to find the Wor

Hello everyone! I am very new to the industry and OneStream and I really need some help to kick start my application building journey!Currently, I am trying to test out the capabilities of OneStream using the scenario stated below:I have one central division that will split into two 'teams'. For example, Division_1 and Division_2, both teams have handle their own projects. For example, for D_2, under Project 50A there are mini projects like 50A001 and 50A002. For D_1, under the same project 50A, they handle other projects like M0001 and M0002.So what I am trying to achieve is: Tracking their expenses, so they will roll up to the central Division. E.g. Division 1, project 50A, spent $1,000, Division 2, project 50A spent $1,500. So the rolled up amount would be $2,500 and the ability to breakdown to the specific items.If possible (which it is) Division 1 handle projects that are "Approved" so the expenses are actual. Division 2 handle projects that are "Awaiting Approval" so the exp

Hello, Our transformationeventhandler rule adds missing UD1 members to an unmapped parent.The rule works and has been for a few months. A couple of weeks ago I built a business rule which leverages the utitlity "ExecuteFileHarvestBatch".I have the relevant settings as True. Dim valTransform As Boolean = TrueDim valInterest As Boolean = TrueDim loadCube As Boolean = TrueDim processCube As Boolean = True The batch rule was built so I could schedule the data load.What I am noticing, is when the scheduled job (which calls a DM job with the rule) runs there are failures because of missing UD1 members.If I, then run the import/validate/Load and Process steps manually there are no errors and the missing UD1 members get added. It is as if the TransformationEventHandler is not being executed when the import process runs via the scheduler/dm job/rule. Any ideas for suggestions of where to look?

Has anyone been able to get an extensibility rule to work in the workspace assemblies? I've looked and I haven't seen much of any documentation on this. I'm working in 8.4 and have the rule working when I have it using the regular extensibility business rule which is attached to a DM job to run. When I try to move it to a workspace assembly and put it on a DM job it doesn't work. I've created a new file as the Extensibility Business rule source code and have the same code with no errors. I don't see an option in the Ws Assembly Factory to specifically call out extensibility rules either. So far I've been successful with getting an XFBR, Extender Rule and Custom calculate rule to work in assemblies but extensibility doesn't seem to work. Below is the error I am getting.  

Hello,I am working in an 8.5 application and want to utilize Finance Custom Calculate services within a dashboard. My service factory is enabled at the Dashboard Maintenance Unit level of detail. I am trying to launch the custom calculate function via a dashboard button.Does anyone have example syntax for this? I figured OneStream would release documentation externally for this but was unable to locate any. Thanks!