Application Build

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

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  

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?

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, Can we export a hierarchy/hierarchies into a relational table? For an instance if I want to export the complete hierarchy of any Dimension into a table view format whether it will be possible?  I could see we have a Load/Extract to extract the metadata for a hierarchy, is there any other way to showcase or export into it in the form of tables?