OneStream Platform Forums

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 experts,How can we copy just data from an application to another?We have an on-premise setup and would like to copy data from prod environment to lower environment application.I know we can do simply do entire DB copy for that application, but it'll replace everything (like app artefacts).Is there a way we can just copy underlying data of an application? I noticed some data tables (BinaryData20xx, DataRecord20xx), but not sure if simply copying them will work. Thanks,Gaurav

Does anyone do regression testing when upgrading to a new version of OneStream or upgrading to a new version of a MarketPlace solution?  I'm looking for best practices, industry standards, etc. to more formalize this process for internal controls.  

Hello,we're trying to paralellize datamanagement jobs over years with this call QueueDataMgmtSequenceBut it seems the task called by this function is not running.Should we have missed something ?myTask1 = BRApi.Utilities.QueueDataMgmtSequence(si, sSequenceName,VarBR1)myTask2 = BRApi.Utilities.QueueDataMgmtSequence(si, sSequenceName,VarBR2)myTask3 = BRApi.Utilities.QueueDataMgmtSequence(si, sSequenceName,VarBR3)myTask4 = BRApi.Utilities.QueueDataMgmtSequence(si, sSequenceName,VarBR4)myTask5 = BRApi.Utilities.QueueDataMgmtSequence(si, sSequenceName,VarBR5)myTask6 = BRApi.Utilities.QueueDataMgmtSequence(si, sSequenceName,VarBR6)

Hi everyone-I am trying to create a reporting solution that can display data from two close calendar periods in a single cube. Is it possible to include two time profiles in a single cube?    

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.

How To Revert Completed Workflow and All Forms at a One-time for all workflow profiles.

Is it possible to report on workflow  detail that was loaded into the import step of a workflow. Our company loads in several attributes in the import step that do not make it into the cube. Is it possible to create a report or a data adaptor that can display that higher level of detail.

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!

Hi All,similar to this post: https://community.onestreamsoftware.com/t5/Reporting/BI-Viewer-Creating-a-clustered-column-line-chart/m-p/6355#M1099 I have created a chart with bars and a line on a secondary y-axis. I also used the method to form the secondary y-axis: Iif(StartsWith([Account]), 'Sales'), [Amount], 0)The problem now is that the bars are getting thinner by drawing in the 0 values and also the legend is overloaded by the 0 values. So I wanted to ask if there is a way to filter out these 0 values and not display them?Thanks for any help!

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?

Hi all.We have a spreadsheet rule that needs to pull a value from another database table.The lookup runs successfully in an existing Dashboard Extender, and I was initially requesting the amount by calling the Extender from the spreadsheet rule, but that only ever returned the default value, even though the lookup does have a valid value.Because that failed to return a value, I tried making the call directly, as shown:sOperational_Capacity = BRApi.Database.LookupRowFieldValue(si, "ExternalDB", "XFC_STEP3_DEV2_OperationalCapacity", objDbwheres, "Operational_Capacity", 9876).XFConvertToDecimalLocalNB: The 9876 is just a default value that is different to zero, so that I recognise it, and we use the ConvertToDecimalLocal to deal with French culture users.Basically, when I run the call from the spreadsheet rule (either directly or by calling the Extender rule), I receive the default value every time.This same code runs perfectly from the Extender BR, returning the correct value.I have also

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

Hello Everyone,I am setting up Azure SSO & getting below error when trying to login. Could someone point me to the configuration section that may be incorrect in this case?   IDX10214: Audience validation failed. Audiences: '<GUID>'. Did not match: validationParameters.ValidAudience: 'null' or validationParameters.ValidAudiences: 'api://<GUID>, <GUID>'.  Thanks,Hiren 

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?

Hello community,When creating a dashboard that requires user interaction, usually it is necessary to receive confirmation from the user to proceed or we just want to inform the user that something has happened in the background.In order to do so, one of the most efficient ways to do it is by displaying a dialog box from the code with the information that we want to share with the user and, if necessary, some buttons to catch the user response.  However, I still haven't found this way to do it while programming a Business Rule in OneStream. Since it uses VB seems that using the "MsgBox(<message>)" function should work, but the following error occurs:Summary: Showing a modal dialog box or form when the application is not running in UserInteractive mode is not a valid operation. Specify the ServiceNotification or DefaultDesktopOnly style to display a notification from a service application.When using MessageBox.Show() with the "ServiceNotification" option, then it doesn't

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  

Dear Community,we have requirement to display top and bottom lines in all the column headers in excel format.Here in this above image, a line should appear below the scenario and view columns. Here both of the columns are overridden. If I apply "ExcelBottomBorderLineStyle" in Cell formatting. It applies for both of the columns since both are overridden.Here, in this case I have created a blank row named it as "Row1" and given this condition below: If (RowName Contains 'Row1') ThenExcelTopBorderColor = Black, ExcelTopBorderLineStyle = ThickEnd IfAnyhow, this method works only if I create a blank row and applied this conditional formatting. Is there any other way/formatting setting that can be applied to achieve this? Any solutions to this will be really helpful.Thanks 

Is there a way to display alternate columns in different colors even if we apply expansion (e.g.   .tree , .children etc.)

Is there an easier way to move a cube view from one Cube View Group to another? I am currently trying to reorganize dozens of cube views into different Cube View Groups, but they are linked to other cube views via row/column sharing. Because of this, I have to touch not only the cubes I'm moving, but those that it is linked to: copying to new group, renaming associated row/column sharing link in other cubes, deleting original, renaming new. Thank you!

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.