Application Build

Hi All,We are using a spreadsheet component to capture some drivers from end users in our application, how do we customize the ribbon of the spreadsheet component to show only OneStream option in the ribbon?If I do right click, "Customize ribbon", it lets me display only OneStream in the ribbon , but the customization is lost on refreshing the page. Any guidance on how to retain this customization would be helpful.   

Hi,I have created some new balance sheet accounts relating to Right Of Use Assets, I have copied the structural dimensions from my existing fixed assets, so that every member property field matches. I use a generic cubeview for recording opening balance adjustments, when I key into all my other balance sheet accounts, then the derived value flows through the remainder of the year. This happens regardless of which is the first month I key into. However, for my new ROU accounts, it does not do it. The values just show as 0 and I have to key in the actual value manually each month thereafter. Here is some sample data to show what is/is not happening. Also, it does not matter which month is the first month.So what have I missed in creating these ROU account codes in the member properties ? They use the same flow constraint as my other fixed assets, so it's not that.Where else do I need to look ?CheersMark

Hi AllI am updating the Admin Consolidations Dashboard (ADM) so that only some users can execute a Force Consolidate. I can hide the radio button group if the user does not have access but I am struggling to update the radio button group (Consolidate/Force Consolidate) so that the correct option is selected. The list of values for the radio button is controlled by a parameter (pm_ConsolType_ADM). In the LoadDashboard event I have updated this parameter using SetLiteralParameterValue (using v6.8). I am assuming that this is how the radio button selection is controlled as I can't find anywhere else where it can be set. If I click on the 'Reset parameter selections' it works.I have tried unsuccessfully to Redraw the dashboard like this:Dim selectionChangedTaskResult As XFSelectionChangedTaskResult = New XFSelectionChangedTaskResult()selectionChangedTaskResult.ModifiedSelectionChangedUIActionInfo.DashboardsToRedraw = "2_1_AutomationTasks_ADM"Any help you can give me is much appreciate

When I use the Pre-Aggregated Member settings, it is copying the data twice.  I've tried multiple settings and multiple scenarios.For example, I have tried just O#Top=O#Forms.  After I run the consolidation, there is data in both O#Import and O#Forms, doubled. It also happens with multiple Dimensions.  I've tried O#Top=O#Forms,U5#Top=U5#PlanningLoad and the data is doubled in both Dimensions 

Hello OneStream Admin Certified experts, I would like to perform the certification on OCA and need your experience on how to prepare and what are the documents to refer and minimum duration to prepare on self training. Thanks Sreenu

Hi,Copy pasting data from excel into CV forms generally work, but the exception seems to be for date values (CV Cell Type - Date). Does anyone have experience with this and know if it's possible?  

Hi All,I wish to change the property 'Show Manipulation button' of my SQL table editor to hide manipulation buttons if the workflow selected is a parent but show if the workflow selected is a base. Is this possible?Regards,Mark

Hello, I've deleted several on prem databases from both SSMS and the Database Configuration Utility, however, when I access System > Tools > Environment the deleted databases are still listed under OneStream Database Server with a message "((Database Not Found #))".  There doesn't appear to be a way to remove these via the front end. Is there any other way to remove these?

All Scenarios belonging to the same Scenario Type must have the same Formula assigned Question Credit: Janice Kirkbride 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 AllI am trying to build BR (Finance or Extender (General Server), activated by Dashboard button) to calculate Journal (based on two different Cubes) and post to Dt or Ct ('if' statement to define where exactly)?I thought it would be possible with 'api.Data.Calculate' by just having simple equation TargetCube = 1stCube - 2ndCube; but cannot get to the place where I could define whether it should be posted as DebitAmount or  CreditAmount.Thanks!

Hi, I am getting many metadata errors when loading a version 6.8 extract in a version 7.4 application. Are there differences in the xml structure between versions? Thanks

Hello, is there someone who knows how to get more information on this error?The next 2 messages refer to a scenario member, for which I run the calculation, but I don't see any "=" that has a wrong statement behind it, could of course be a small typo, but it's a large scenario formula. thanks in advanceBen

Hi all, I'm trying to figure out if there is a dashboard, marketplace solution, or custom report where I can view security groups/users and references where they are assigned to objects. Preferably with the ability to sort.For example:Security Group Name:"Security Group" Object:Application -> Workflow -> Workflow Profiles -> "Cube" -> "WorkflowProfile" -> Profile Properties -> Security -> Access GroupApplication -> Tools -> Business Rules -> Connector -> "Business Rule" -> Properties -> Security -> Maintenance Group   Thank you!

Hi Team,Under UD4 I have an XFBR string, which returns Jurisdiction - the case is I can't include there hierarchy.Base, as it needs a single entity to work. Is there any parameter like |CurrentEntity| which I can include in XFBR or do you have any idea how to solve it? 

Dear Colleagues,Did you build the XFSetCell feature to import text fields from a spreadsheet into an Annotation view? Any assistance on this matter would be greatly appreciated.Regards

Is there any option for the users to see the Recent Pages they opened in the application? 'Navigate Recent Pages' allows the users to select and go back to a recent page, but this information gets removed when the session is closed. Please let me know if there is an option which persists between sessions? Thank you. 

Creating a post for custom coloring in dashboards.   For example, Onestream's dashboard selections give the option for custom color, however, it does not let you select it in the formatting. It only shows the option for #FF00000 (at least from what I have seen).   The above format is HTML coloring codes that can be manually updated in the display format Typically when matching client colors I am given RGB color codes, So I use the below converter to get the HTML code and add #FF to the beginning of the provided hex code.   https://www.w3schools.com/colors/colors_converter.asp  

  Scenarios always must utilize the FX rates on the Cube Question Credit: Parker Laabs 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

One of the new features in the 6.6 release is the introduction of Hybrid Source Scenarios.  I've watched the 6.6 release and read through the abbreviated examples in the admin guide. Both have good high level content, but they seem to be missing details around the Options section within the Hybrid Source Data of Scenario properties.Does anyone have any additional details around what options are available and a description of each? Or more content around Hybrid Source scenarios in general?Thanks,Added screenshot to provide context. 

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!

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.

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!

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

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