OneStream Platform Forums

Hi I linked several cube views into Excel with the settings below (Version 8.4.0). I then created some basic formulae within the cube views. E.g. = C25. The Excel formula is retained by the first cube view but in the other cube views it is moving up 4 rows on each refresh. The Cube View Connection options are the same in each one. I have tried selecting/deselecting the insert/delete rows & columns and including/excluding the header. The cube views all have some rows with a specific account and at least 1 row that uses “.Base”. Has anyone come across this before? Thanks. Robert

Hello,I need to create a pie chart in a report component (under dashboard). So i created a very simple cube view with 2 elements of the UD1 dimension, and 1 column showing up an account. With this cube view, I created a data adaptor, with Command Type = Cube View and Data Table Per Cube View Row = False; when I open the data adaptor then I can see the correct data, with 2 rows and 2 amounts then.Now, when I create a report component and add a pie chart on it, the pie chart appears properly and as expected (2 pieces in the pie, for each UD1) but it appears twice ! And twice the exact same pie! Any idea from where/which setting this is coming from please? I am struggling in finding it.. Thanks in advance,Florence

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!  

Add a lock-in challenge to the application close "X" button in top right of window. This would prevent a nuisance situation where I've mistakenly closed the application when trying to open the POV pane. 

Hi,I have a classique cubeview that uses !prm_entity! as Entity POV.When using classic Dashboards, everything works as expected.When converting the dashboard from "Embedded" to "Embedded Dynamic" and using a simple Factory service to add the template cubeview stored component, nothing more: then the !prm_entity! POV of the cubeviews seems not interpreted at run time, no prompt showup and this cubeview displays a blank page. When checking cube POV we can see parameter is handled like a string in the POV.Any idea what basic setting i am missing to do in the Dynamic Dashboard way to let OS prompt for the prm_entity parameter value?Thanks in advance,

I have informational account created to store some Include/Exclude value by Entity. Now, I dont want this account to be translated and consolidated so, I have tagged AccountType to "Non Financial" while Aggregation to False. However when I turn on false its become invalid while True makes it Valid for input. Any idea what causing the issue? Based on the OS doc any informational account can be set to False.    

Hi, I want the hierarchy illustrated below. Entity B owns 90% of entity C, and in the consolidation of entity B we calculate minority interests of 10%. At this step, I have no doubts. However, entity A owns entity B 100% and also owns entity C 100% (90% direct + 10% indirect). So, in the consolidation of entity A, we need to eliminate the calculation of minority interests done previously in the consolidation of entity B.I don't know how to set the properties to do this. Can someone help me?  

Hi, I was wondering if we can write a dynamic calc in the scenario dimension? I see the field for writing the formula but somehow it is not returning anything. How can I enable the type to dynamic calc so that it works as how we use it in account or UDs?  

We wish to disable Native Authentication once we go live on V8.  If Native authentication is enabled, all users must enter their username and then the authentication occurs.  In V7, that wasn't required.  In V7,  we utilize several native accounts for testing - i.e. TestUser1, TestUser2 - that the admins can leverage when working with security.  They use their SSO account to launch one window of OS and login natively with the test user on another instance of OS, enabling them to make a change in their admin window, refresh, and test the change in their other instance.With disabling Native Authentication, our IT department suggested we create Azure test accounts that can authenticate  like our normal user account through the shift/right click and "run as other user" function to login as that t-account.  However, this doesn't seem to work - nothing happens after clicking on the shortcut and entering the t-account credentials.  Is it safe

Hi All, Finished the installation of the databases and webserver on the machine, following the installation guide it reached a point where it told me to test the application and login for the first time using preset credentials.I tried inserting the standard credentials but I would get the error message "Unable to log on user 'Administrator'.  The password was reset and needs to be changed." and it does not allow me to change the password (see screenshot below).This is a fresh installation and the standard credentials were never used before, did some error occur during the installation or is there something I have to do to make it work correctly?Any help would be greatly appreciated,Alberto

Hi, Is there a way to open a dashboard within the same page of a dashboard by clicking a button in OneStream? Thanks

Hi Everyone. I would like to know how I can remove zero values in my GetDataBufferUsingFormula. Dim DatabufferCalc As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(E#" & strParentEntity & ".Base,E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base:S#[" & strScenario & "]:T#" & strPeriod & ":O#Top:I#None:U1#ALL_DEPARTMENTS:U2#ALL_PRODUCTS:U3#CORP_RPT:U4#ALL_PROJECTS:U5#None:U6#None:U7#None:U8#None,A#411000)") And from the result, I would like to obtain the entity, and from that entity, know its Text1, Text2, and Text3. However, for now, I see that I can only obtain the account and the rest of the properties such as the UD Dim DatabufferCalc As DataBuffer = api.Data.GetDataBufferUsingFormula("FilterMembers(E#" & strParentEntity & ".Base,E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base:S#[" & strScenario & "]:T#" & strPeriod & ":O#Top:I#None:U1#ALL_DEPART

Hi Team, Generally, In Scenario settings will updated the "Workflow Start Time & Workflow End Time". so here we want to get these workflow time rang in Cube View. (Eg: Work Flow Start Time: 2025M6 & Work Flow End Time: 2026M5). Based on scenario selection in  the report, we should get the (12 periods) time range in report.  Please help us to get the solution. Thank you, Shiva Prasad

Pls share how to run1. a traditional BR via a member formula2. an assembly BR via a member formulaThank you - OS SME.

Is it possible to get this setting in a business rule?Thanks,Scott

Hi, wondering if anyone has created something like an "Administrator-lite" role that gives the user an ability to do 90% of actions in the tool, but stay away from things like fx, mapping changes, and data loads.  I really just want these users to create cube views and reports only without giving them keys to everything else. Would this be solved by adding a new group, or any other recommendations on how to solve?  Thank you!  

Two part question. Comparing Actuals as other Rates to remove currency flux We want to take our Actuals and view at PYE, PYP & budget FX rates to take out flux in currency.  Is there a feature (outside of creating BR's or Alt Rate types) to do this. We currently have built 3 scenario for the above rates and it works as expected for base level members.  Where we run into issues is with converting to Reporting currency at parent members.  Ex is converting our EMEA entity (currency - EUR) to USD.  The BR seems to store the USD value at the base entity but is converting from EUR to USD at parent level using OS logic (ie current defined rate for Actual scenario).  It is not consolidating up the USD value but converting from EUR at parent member. This BR was created almost 6 years ago when we implemented so hoping there is something out-of-the-box now that will do this. I am exploring creating 3 new Rate Types: PY Budget, PYE Actual & PYP Actual.  I wo

Hi, I notice that with dashboards, when allowed to prompt the user for values for their parameters, save the  user's last used value in said dashboard and populate that as the default value when prompted. By comparison, cube views don't store that information, and populate whatever is in the default value for the parameter when prompted. Is it possible to change what behaviour is used when parameters are requested from the user from a dashboard, and how would I do so? Thanks! Alex

Hello! I need to split an entity into three separate entities using transformation rules and percentages. For example, I need to split E#50 into E#50B - 33%, E#50D - 33%, and E#50L - 33%. I've read that derivative transformation rules can be used for this purpose, but I'm unsure how to implement them. Additionally, I need to divide the amount of E#50B into two UD1s U1#2345 -50% and U1#2346 - 50%. Here's what I've attempted so far: What would be the proper way to do it? Ideally, we would like to store the percentages in UD4, so users can update them in a form. Is that possible? Thanks,   

Dear Community, Is there any way to delete the workflow channels in bulk? Currently we are in the process of deleting the unused UD7 members in the application and the workflow channels are setup based on the UD7 members. Since the UD7 members and the channels are in huge volume. Just wanted to understand if there is any rule or a marketplace solution which can be used to delete the WF channels in bulk? Any solution would help. Thank you so much.

Hello - I'm using Parcel Service to generate/ship a Book. The book is an Excel export file of a Cube View. Very simple.I can get the Excel file to email properly through Parcel Service. But, I also want to save a copy of the Excel file in the OneStream file system. Does anyone know the syntax for the OS file share path? I've tried everything I can think of. Thanks,Bil 

Hi,We are currently attempting to load data into the OneStream Workflow Profile using a CSV file. However, we are encountering the following error during the process:We checked many videos and the training courses but couldn't identify where the issues is, Could you please assist us in identifying and resolving the issue?Regards

Hello, I am trying to query a local app which have 200k rows on SQL server using SIC (Smart Integration Cloud). However, I get the message : "Received an unexpected EOF or 0 bytes from the transport stream." There is an online troubleshooting which I added below. It seems this is a memory issue. However, there's no mention on how to add memory (on the server ? on my local machine ? how to do it ?). --> could you please help me sorting this out ? Regards, EDIT : I get the same error message when querying a table of only 1 row, 1 column. Memory Issues If you receive any of the following errors, increase the memory in your Smart Integration Connector Local Gateway Server. For queries returning over 1 million records, 32 GB or more RAM is recommended. "Error while copying content to a stream. Received an unexpected EOF or 0 bytes from the transport stream." "An error occurred while sending the request. The response ended prematu

I have the code below in an Extender BR.  It runs fine if I run it manually in the BR or manually through a DM job.  But when it runs in the Task Scheduler it fails, and I get the "Object reference not set to an instance of an object." error.  Any thoughts?  Dim wfUnitClusterPk As WorkflowUnitClusterPk = BRApi.Workflow.General.GetWorkflowUnitClusterPk(si, wfProfileName, wfScenarioName, wfTimeName) Dim ImportInfo As New LoadTransformProcessInfo Try ImportInfo = BRApi.Import.Process.ExecuteParseAndTransform(si, wfUnitClusterPk, "", Nothing, TransformLoadMethodTypes.Replace, SourceDataOriginTypes.FromDirectConnection, False) Catch ex As Exception log.AppendLine("Import Done - Status: " & ImportInfo.Status & " - RowCount: " & FormatNumber(ImportInfo.RowCount, 0,,,-1)) log.AppendLine(ImportInfo.ErrorMessage) log.AppendLine("------------------------------") log.AppendLine(ex.GetBaseException.Message.ToString.Trim) End Try  

How can I schedule reports to run overnight during the close so we have a snapshot of financials at specific times?  There are no reports in the Data Management Groups for the Task Scheduler to pick up.