Discuss the features and functionality of OneStream.
Recently active
Hey all, I'm struggling to figure out how to define a TableViewColumn to be of type Decimal instead of the default type being Text. I'm in the section where I create a TableViewRowHeader and adding TableViewColumns to it. I can create a new column: Dim myTableViewColumn As New TableViewColumn myTableViewColumn.Name = "Col1" But when I try to set the type to this column, I get an error " Input string was not in a correct format." when trying to retrieve the table: myTableViewColumn.DataType = XFDataType.Decimal Is this syntax correct? I'm assuming that it's in the column definition where I should be defining the datatype but now not so sure. Hopefully someone can point me in the right direction. As a side note, page 15 in the Table Views User Guide makes reference to a function called CreateTableViewColumn. Is this a custom function or part of the OS library. The compiler doesn't recognize this function.
Is there any way we can use the transformation profile one to one mappings in a data table. Preferable to use in a connecter Drill back code. Is there any Data base table for the same.If not, we have a create a custom XFC table in application DB to refer the same that replicates the transformation profile.
Hi all,the SetDataCell command I am trying to use is behaving in a strange way and I would like to check if that is a bug, if it is by design, or if I may be doing something wrong.I am trying to use the SetDataCell command to clear data on the Origin=Forms. The command looks like this (it is part of a custom calc rule):'Clear data on the Form memberapi.Data.SetDataCell("Cb#Main:E#" & MainPovEntity & ":S#" & MainPovScenario & ":A#AC410000:U1#None:U2#None:U3#" & UD3Name & ":U4#None:U5#Local_GAAP:U6#None:U7#None:U8#None:O#Forms", 0, True)Now, if the UD3 member which I am trying to clear has data on the Origin=Import member, the Forms member is correctly set to zero by the rule. However, if the UD3 member has no data on the Origin=Import member (on that specific Pov intersection defined by the rule above), the Forms member retains its value. Anyone else experienced this behavior? Thank you
Hello Experts,I have simple SQL editor component in a DB. as Admins we can use the toolbar to Insert/Delete/Save in the SQL table behind the scene. for end users it is disabled is there any other setting that needs to turned on? Appreciate the help.
Hello,I'm trying to create a confirmation rule that looks if these two accounts have a difference of 10k USD or more and if so it looks to see if it has a comment (annotation) made by our user and if it doesn't it will fail. So far I got the first part to see if the value is over 10k, but checking it to see if there's a comment also is confusing me. args.ConfirmationRuleArgs.DisplayValue = math.Round(api.Data.GetDataCell("A#Bad_Debt_Comp:U1#Top1:U2#Top2:U3#Top3:U4#Top4:U5#Top5:U6#Top6:U7#USGAAP:F#TopFlow:O#Top:I#Top:C#USD").cellAmount, 2) If System.Math.Abs(args.ConfirmationRuleArgs.DisplayValue) > 10000 Then args.ConfirmationRuleArgs.Info1 = "Bad Debt USD = " & String.Format("{0:#,##0}",math.Round(api.Data.GetDataCell("A#0319:U1#Top1:U2#Top2:U3#Top3:U4#Top4:U5#Top5:U6#Top6:U7#USGAAP:F#TopFlow:O#Top:I#Top:C#USD").cellAmount, 0)) args.ConfirmationRuleArgs.Info2 = "CCM Bad Debt USD = " & String.Format("{0:#,##0}",math.Round(api.Data.GetDataCell("A#CCMBadDebt:U1#Top1:U2
If I have data coming from a connector in OneStream, and then I submit a sheet having XfSetCell formulas, what values will remain in OneStream after consolidation (having the same dimensions intersection)? The data coming from the connector, or the data submitted via XfSetCell? Thanks!
Hi, I'd like to use the ClearStageData function within a business rule. I am already successfully using other similar functions like ExecuteParseAndTransform or LoadCube. This is the sample given within OneStream: Dim objLoadTransformProcessInfo As LoadTransformProcessInfo = BRApi.Import.Process.ClearStageData(si, wfClusterPk, sourceId) The issue I have with the ClearStageData function is that I don't understand what I should pass as sourceId. Can any of you clarify it or point me to any relevant documentation? Thank you
OS Version 7.4.2I have a SQL Table Editor in a dashboard. Three columns: Date, Amount, Descr. The user can edit Amount and Descr. No Inserts, no deletes.The table loads with a bunch of dates. The user fills in amounts in records where needed. The descr and amount columns both accept nulls.With the "Save Data Server Task" set to "No Task", when an amount is added to one record (or several), and save is clicked, the following error occurs:With the "Save Data Server Task" set to "Execute Dashboard Extender Business Rule", I specify a Rule and get the same "Wrong Number of database rows" error.If I use the SQL Table Editor code supplied by OneStream in the Rule, the error in the log is:I'm trying another version of this which omits the use of the Using block. Same "Wrong Number of database rows" error and the log just shows "Unknown Error" Public Class MainClass Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByV
Hello,We have received a question from a client's audit team and was hoping someone could point to any documentation regarding this as I've searched but couldn't find anything. Does anyone, OneStream or otherwise, have access to the default 'Administrator' account that is in OneStream applications? It seems like it is used to run the automated tasks like taking system diagnostic snapshots. Just need to know if anyone can access the account or if it is really just for system tasks. Thanks.
Hello, I'm currently trying to build a CV for my team. In the column filter I have time as the first member filter and account as the second member filter, but when I put as my account name A#None:Name(" ") it still gives a the WF Time. Is there a way to make it show as blank? Sort of like the account? I have a parameter created where it makes the background and text to be the same color and I would think it would also make everything show as blank, but it doesn. This is the parameter for the blank row Thanks, Will
Dear Team, I'm trying to use 2023 time member, to see all YTD values till today, but it seems to be empty.It doesn't make sense as we reported Jan-Apr figures. I have made a consolidation on T#2023 member, but it doesn't change anything. Am I missing something? Thanks!
I wanted to know if we have two or more Import sequence in a workflow(one for manual load ,other for direct Connect) and and we dont complete one of the import sequence - can we still lock the WF as a whole and have the green check mark?
Well, I actually have a question about this, but the subject starting with "Fict or Fiction" sounded cool to me. I'm pretty sure I read somewhere that in a future of OS, a limited web access will be restored, especially for those remote users inputting a small set of data in remote places in big organizations (e.g. accounting companies doing the book keeping for small remote subsidiaries of big organizations that are not really interested in installing and dealing with OS application for such a small task). But now I can't see anything about it. And I have the feeling I dreamed about it. Is this thing planned? By the way, I have some clients still running old versions where web access is possible. For me and few other people working there, navigation via web browser is incredibly much faster than with the OS windows application. Basically each click opens a page (e.g. dimensions or any standard page) nearly immediately, while at all other clients with OS applicaton, this takes from 1 s
Audit would like reports on activity regarding Business rule changes made by the administrator. The Task Activity reports give all activity in the system but since we have not made any changes to business rules yet, we don't know what to look for in the filtered details of the "Task Type". Is there somewhere we can get a list of all the possible activities that could be listed so that we can pick and choose the activity types the audit would like to focus on? And, if not intuitive, what is the type for changes to Business Rules?
You can have three or more cubes linked in OneStream Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Hi,Can we create a database table in OneStream Cloud that we can customize with our own data/columns and run report of? Any document that I can refer to?Thanks in advance,Mikki
We have some CubeView reports that are driven by parameters. They are all working. But it would be nice if the default value could be derived from the users POV - workflow or otherwise. Can this be done?
Hello All,We have created a weekly forecast dashboard for our users (weeks are mapped as scenario, e.g. Week1, Week2 etc.) and intend to restrict them to current week scenarios only to avoid posting to a wrong one.Currently we use parameter, where users select the current week from a drop down and input data, Is it possible to provide them access only to the relevant scenario (week) instead of giving them a drop down, without admins having to make changes every week?
Hello,We are currently building our workflows and don't understand the difference between pre-process and process. we have forms built out and we hit save to send the data through so I'm not understanding why they are needed and what is the difference? We have a process button at import as well so why would we have to pre-process in the review/form step of our workflow.
Hello everyone,I'm making a cubeview and want to put in a formula to show the inverse of our currency rates. Is there a formula I can do like using a get data cell or something similar that could work?Thanks,Will
Hi there,I'm testing out the capabilities of OneStream for a PoC. Is there any way for a front-end user to add new members to, e.g., an account dimension through a component of a dashboard? Ideally using a variable specified within the dashboard.In the example screenshot, I want to enter a name in the text box, press the green button, and have the specified name added to the dimension of the cube view below.Thanks!! 🙂
Dear Community, In the above image "Results Table Name" located in the Data Adapter for a SQL Query is accessible? The Data Adapter still runs even though if we aren't giving any table name in the alias. Is it only for the naming convention? Or whether it's accessible/stored in the Application Database Tables/System Database Tables under System tab? Any solution to this will be really helpful. Thanks.
The below code copy the Prior Period FX Rates from one Type to Another. This will read the currency from the application properties. I have hard coded the Period but you can use WF or Global or Param and call in the DM/Dashboard. 'Get the Period Dim CurrentPeriod As String = "2021M1" Dim PriorPeriod As String = "2020M12" 'Get Currency from properties Dim objAppProperties As AppProperties = BRApi.Utilities.GetApplicationProperties(si) Dim currency() As String = objAppProperties.CurrencyFilter.Split(",") 'Add FX rates For Each c As String In currency Dim fxRatePkUsingNames As New FxRatePkUsingNames("AverageRate", PriorPeriod, c.ToString, "USD") Dim objFxRateUsingNames As FxRateUsingNames = BRApi.Finance.Data.GetStoredFxRate(si, fxRatePkUsingNames) If objFxRateUsingNames.Amount > 0 Then Dim fxTargetRatePkUsingNames As New FxRatePkUsingNames("ActPriorMon", CurrentPeriod, c.ToString, "USD") Di
I have a combobox with a multiselect option enabled and it utilized by a data grid. I've set up the User Interface Action to refresh the grid and it works fine. However, it refreshes after each selection. If the user wants to select 3 options, it will refresh 3 times. Is there a way to only refresh once after all of the selections are done?
Hi All,I am trying to create a simple CV with one column set to T#POV.Prior12, T#POV (to get 13 rolling periods). For Rows I have 3. CurrentYear, Budget, and PriorYear. On PriorYear row I am trying to over-ride the column to show the rolling 13 periods of prior. I've been unable to get this to work. It keeps returning the current year rolling 13 period data.I'm fairly new to OneStream. Is there an easy way to complete this? CV Row template where I am trying to over-ride.CV Column:
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.