Discuss the features and functionality of OneStream.
Recently active
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?
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.
Hi All,similar to this post: https://community.onestream.com/topic/show?tid=7354&fid=7 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!
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
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
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
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!
Hello all,After entering the data in excel add in, unable to refresh the data, excel page showing blank only, please help me on this issue.
We are using Datalake as a centralized repository for raw data coming from D365, the goal is to integrate Datalake with Onestream directly but we are running into a "NO_BROWSETTABLE set to OFF" error. Our DEV team can stand up an azure sql server and write the data to that server....Doable but not ideal. How are you all setting up Integrations with non-odbc connections?
Hi All,I am currently facing a challenge with my SQL code in dashboards and would greatly appreciate your help in finding a solution. The issue at hand is that I have hardcoded the code to pull data from tables, but now I need to modify it so that when a user selects a specific month (e.g., 2023M1), the dashboard displays data for the selected month as well as the 12 months prior to it.To provide more context, here is the query I am currently using:SELECT ISNULL(Name, 'Total |!SelectAcc!|') AS Name, SUM(CASE WHEN Period = '2022M12' THEN |!SelectAcc!| END) AS '2022M12', SUM(CASE WHEN Period = '2022M11' THEN |!SelectAcc!| END) AS '2022M11', SUM(CASE WHEN Period = '2022M10' THEN |!SelectAcc!| END) AS '2022M10', SUM(CASE WHEN Period = '2022M9' THEN |!SelectAcc!| END) AS '2022M9', SUM
Dear Community,we have requirement to remove the zero from empty row when it is displayed in excel format. As shown in the picture for empty row "0" should not present. Any solutions to this will be much helpful.Thank You.
Is there any way to format a number for the FORMULA DRILL DOWN to show as more than two decimal places or format the output as a percentage? I have some factors that are applied against another account that need 4 or more decimal places to look like they calculate correctly. In the example below, the number should be .0588.
I am building a data adaptor for journal entry information using command type: Methodmethod type:journalforworkflowunit query:{Cons}{Actual}{2022M9}{All}{JournalStatus='Posted' and UD7name='CONS_ADJ'} i would like to be able to pull multiple months of journal but it seems that the query only accepts single month values as the third filter. it there a way to pull all months prior to and including my filter) like 2022M9.allpriorinyear
Originally posted by Andrea Tout7/2/2019 Has anyone ever had a data source that is two columns for the amount and they have to be added together in the file *-1?
We seed actuals into the monthly forecast, but headcount isn’t pulling over and we’d like it to for reporting. I found where the business rule is for this process and can see it is currently set up to just pull Income Statement accounts. I just don’t know how to update/change it to include headcount (our headcount is a statistical account).
Hi Has anyone used a data adapter using the WorkflowStatus method type? It generates a field called TotalStepCount. The number of steps usually equates to the number of steps in the Workflow Name, but not always: I understand that this is because a single step in the workflow name can actually represet multiple steps (which are included in the TotalStepCount), but I think this is context dependant - i.e. varies depeding on the other steps in the workflow. Does anybody have a way of seeing exactly which workflow(name) steps are being counted in the TotalStepCount field?
Hi, I'm building a Forecast template which brings in Actuals for the YTD periods, and the future periods are form inputs. The actuals are based on all stat entities, rolling up to a Parent (let's call it M_GROUP). They are all tagged with a UD1 Region code, "MEA" for example. To input Forecast, users post by Region so regional entities have been created, such as M_MEA. The issue I have is that the Group Total columns do not update to include the base entity data once a user has submitted their input. I can Force Consolidate, and this works, however I would have thought a simple consolidate would also update this? Where it is highlighted green, this has been force consolidated. Red highlight, I just used the consolidation button. My preference is to have it as user friendly for basic bookkeepers to see their totals without having to force a consolidation. The form looks like below:Does anyone have a better method to input forecast data using the spreadsheet me
Hello Team,We are in planning of upgrade from lower version to higher version and looking for best and stable version with out any issues.Also could you please guide us best planning approach to implement this activity.Thank you.
Hello - we recently updated the stored values in the Percent Consolidation property in several large entity hierarchies, so there are 3 stored items with different time periods for each child. We found today that when we pull data using a YTD view, whether in the Excel add on or a cube view within the Windows application, the consolidated numbers on the parent do not match the children when the latest stored value is applied to the child data. However, we did find when the view is changed to Periodic the consolidated parent data matches the product of the child data and the current Percent Consolidation. Is this issue related to the Consolidation View on our Actual scenario? Its currently set to Periodic. If this helps, our Consolidation Algorithm Type is Standard.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.