Application Build

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  

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? 

Hi All,Ive got a problem with transformation/load cube workflow steps in our build, It has been in our applications for over six months (an older dev application has the same problem). This error doesn't seem to cause a problem in our data although may affect a dimension we put into our application for future use, I want to isolate it regardless. The error is an "Object reference not set to an instance of an object error" and doesn't actually stop the workflow step from completing, making it difficult to track exactly what is going wrong. It also doesn't flag when compiling all business rules being only apparent whilst running the rule. This error occurs on all the load/retransform steps I have tested although that doesn't help much as a lot of our transformation rules overlap.Id really like to know if there is a way of viewing which business rule is failing on running these processes but cannot fathom how, is there a way to do this? Thanks,Tom 

I have been trying to give a couple of our users access to the Database Page in the System Pane. I created a new security group named DatabasePageAccess (and SystemPaneAccess) and add another security group and 2 specific users to this new group. I then changed the security group on the System Security Roles for the DatabasePage System User Interface Role to "DatabasePageAccess" and SystemPane to SystemPaneAccess. Asked the 2 users to test it out. They were able to see the System Pane now but cannot see the Database page still. I have been going in circles and cannot reason why they cannot see the database page when I seem to have done it all correctly. Has anyone else ever seen this?System Security Roles Screenshot from User (does not show the Database page as an option)  

I set up a Hybrid Scenario with a Data Binding Type of "Copy Input Data from Source Scenario." I tried following the example in the Design and Reference Guide (below) for the Origin dimension, where the properties are as follows:      - Member Filters to Exclude: O#Top.DescendantsInclusive      - Pre-aggregated Members: O#Top=O#Import     When force consolidating, I get data in both O#Import and O#Elimination, but O#Top for my source scenario and hybrid scenario agree. Is there any way to only copy data into O#Import? As a side note, if I change Pre-aggregated Members to O#Top=O#Elimination, I only get data in O#Elimination. Thanks! Molly  

Dear Team,I'm trying to check if value of a specific column is <> 0, if isn't I would like to inform user by some kind of Message Box.I was trying to use SaveDataEventHandler, but the issue is this value is not inputted by user - it's calculated by UD8.Do you think there's any another possibility? Thanks a lot! 

I am going through the process of making an application multi-language. There is one area that I cannot work out and it is an important element: Certification Questions. I am using XFStrings to hold the translated text and this is then used on Cube Views, Dashboards, Confirmation Rules etc. Certification Questions do not execute the XFString function and there is no event I can find for building the Certification Questions form. Does anyone have any ideas?

Requesting OneStream to add a DateTime component for easy use by developers, at present textbox has been used everywhere to capture date from users in custom applications.

Is there a way to report first Value for Each Time Period similar to TB First setting in Essbase? M1 .. M12 M1 Value to be shown for FY

Originally posted by Erin Nielsen Hello, Is there a way to easily copy over our Budget Scenario and all of the data in it, into a Budget V2 Scenario, so that i can add data to the Budget v2 Scenario? Essentially allowing the app to have two versions of the budget?   Thanks, Erin

 Seeking to improve efficiency for user management and security/audit review processes. The OneStream application is accurately showing the user assignments but it's only available in the OneStream application itself and the GUI is not very flexible in viewing the out of the box forms. We have already installed the marketplace solution "Security Audit Reports" which improved our capabilities through a user dashboard and different reports with user details, but it is also only in the OneStream application GUI. As a workaround we have been using the Load/Extract option to pull an XML file and manipulate in Excel.