Discuss the features and functionality of OneStream.
Recently active
Hey Experts, I am trying to read the Datacelldetail line items. thought of using Method query but not able to filter it based on UD filter criteris. does anyone know if it is possible? whats the systax to make it work. In below example I am trying to filter and get all the rows for UD1 DL014. when I run the query it gives me erything for that Entity,Scenario and Time. Appreciate the help.
Which CV format section or POV setting will allow me display account number and account description together? Currently only the account description is being displayed. Need to see: 10000 - Cash Current settings: Cash Thank you,
Hi All, I am facing an interesting issue (or a bug). Requirement: Capturing comments using a text box (linked with a literal parameter) and save it as annotation text so that it can be pulled in CV reports as well. Using literal parameter as I set it to stored comment using the BR when click on a cell in CV. I have a save button to save the comment if they want to change it and save it. when they save reading this text input in the textbox. so same textbox is used to display and write. I am passing this text as [|!Param!|] to rule. whole setup work great but found an issue when there is a unbalanced "[" or "]" then it throws this error. Error: Invalid comma separated values. Unmatched brackets wondering if anyone seen this or have a workaround to handle this? appreciate any help.
Is it possible to create a popup msg in a DM business rule like the msg below (created when 'Complete' is clicked). The Load button calls a DB business Rule and I need to first check if WF channel is locked or not. If locked I'd like to notify the user that the channel is locked and the BR is running
Hi All, I was wondering if anyone had experience adding cultures to an applicaiton after go-live. Considering this is a system wide change its difficult to test without applying across all applications. I'm wondering if the statement in the attached screenshot "impact overall environment or application performance" would be applicable to adding new cultures. Looking forward to hearing from you all. Cheers!
Hi All,I have been trying to understand the process to setup On-Prem Oracle DB connection in OneStream Cloud to export data from cube. Is there a document that you guys can point to? The doc I found didn't help much as it seems it is for On-Prem OneStream version. Thanks in advance,Mikki
Hi, my Entity dimension has a main hierarchy with TopMemberA being the top member, and an alternative hierarchy with TopMemberB as top member. It looks like this: TopMemberA - ParentA1 -- Entity1 -- Entity2 - ParentA2 -- Entity3 -- Entity4 TopMemberB - ParentB1 -- Entity1 -- Entity3 - ParentB2 -- Entity2 -- Entity4 The issue I have is that whenever I consolidate TopMemberA the status of TopMemberB changes to CN, and vice versa consolidation TopMemberB changes the status of TopMemberA changes to CN. I don't see why consolidating one branch of the hierarchy should change the status of an alternative hierarchy. Did anybody else notice this? How have you solved it? Thank you
Hi All- Can someone share how to hide the Instructions dashboard and show the TieOut Report dashboard when the Run Report button is pressed?
Please let me know what you have done to pass a dashboard parameter to a data unit filter e.g. Entity on a Data Management step. For example, if we have a dashboard parameter |!Selected_Entity!| which stores the entity member selected on the dashboard, using it on the Entity Filter in Data Management (E#|!Selected_Entity!| only works if the dashboard parameter type is a Literal Value with a Default Value set. The default value can then be changed with a business rule with the SetLiteralParameterValue function (this is also the setup in GolfStream). The problem with a literal value parameter type is: where user A selects the entity on the dashboard, but before user A kicks off the DM step from the dashboard via e.g. a button, if user B changes his/her entity selection, the default is changed for everyone, so user A will kick off the step for user B's entity. Trying an XFBR rule to set the default value of a Literal Value Type - it seems
Does anyone know the order that XFSetCells load in a spreadsheet? I have duplicate metadata key infomation, and I'm trying to handle it by doing some accumulating with some more generic formulas. I assumed it loaded top down, so the lower cell would be the last value loaded to overwrite preceding ones. Doesn't seem to be playing out in every case that it's submitting top to bottom.
I want to be able to drill to HR details in BIBlend from any users cube view, so I set up a linked Dashboard using Default NavLink parameters, and a SQL data adapter using these default parameters. It is working perfectly except for Account. The cube account mapping logic is concatenating 3 columns in the detail file to map to a headcount account (ex Full-Time - Exempt - Associate). I assume I will need to set up separate BRs to apply this logic. I am wondering if there is a better way to do this?
Hi, Is there a way to modify the OneStream banner at the very top of both the login screen and the application window where the OneStream Logo could be replaced with a customer logo or anything else? I know we can add text to the banner via the Application Config file, but I was wondering if there was a way to eliminate our logo in place of something else. One of our military customers is asking this question. Thanks, Ed Wright
I need some help building out the following two calculations on stored member formulas. They would need to run at every UD. 1) = MIN((A#Account1 - 4.5%), (A#Account2 - 6%), (A#Account3 - 8%)) 2) = MAX((A#Account1 - Account2 - Account3 - Account4),0) Thanks so much!
I have a cube view that I need to modify so that in the second column we are getting data that is driven by the selection that the user makes for the first column. For example if the user selects a forecast for February to be in the first column, then the second column of the cube view would have to be the previous month’s forecast. Do you have any suggestions on how to achieve this view? Thank you in advance for any help and suggestions! I am going to attach some views of what I have in here so far (The second column reads OP plan as I have copied this view from another similar Cube View).
Hi, I'm trying to pull in the descendants and the parent member of an account into a data buffer. e.g. something of the form FilterMembers(A#All, A#Gross_Sales.DescendantsInclusive). When I log the data buffer and examine my results, however, I'm only seeing the base member data and none of the parents. Could anyone provide me any suggestions on how to pull all of this data into a single data buffer? And can anyone tell me why my data buffer doesn't produce the results I'm expecting? Thanks!
Hello fellow OneStreamers, I have a burning question that I need to get insight for in regard to environment care. We have a cloud instance of OneStream and have multiple apps on our prod environment. We would like to have a good overview of the app sizes, perhaps in a nice dashboard, so that we can preempt our need to order more storage space and prepare our release schedule. Is anyone using or has developed anything like that? Currently we have to send a ticket to the help desk to know the app sizes and would prefer to have in in our-hands more on demand to plan. Thanks!
Hello! As a EssBase previous user, do you know if it's possible to navigate without data or at least positionning row and colums dimansions without a refresh and once all is done proceed to the refresh. Because sometimes when it makes 4 minutes to refresh a cubeview and I have to move at least 5 axis to column or row, it takes 5 x 4 minutes Thank you in advance.
It appears to be possible to set the SiblingID in RelationshipPositionOptions, so it exists as a property. How do I "read" it to see what it is for a member? Thank you in advance for any assistance.
All rules in business rules page must be written in Visual Basic.. Question Credit: Andrea Tout Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
Hello,I hope you're all doing well, this is my first time posting in the forum.I recently built a cubeview that contains one Row, I was wondering if there is a way to automatically generate blanks after each member - in my case after each Entity of the hierarchy - and considering that i have multiple member expansions.In order to clarify my request, please find below an overall of how do blanks should be automatically generated (1st Screenshot), you will also find a screenshot of the members used in my cubeview.Thanks in advance, wishing you all a blessed day
Hi, I have a CV Form where the input is a "Date" Cell Type. I need to use the date to translate to a OS Time Period. I am struggling with using the Date value in a Business Rule. It only returns an Integer and I can't seem to convert the integer to a Date in the BR so I can grab the Year (Dim strYear As String = Date.ToString("yyyy")). Any help with this? thanks, Greg
In looking at the dashboards page, the first item that needs to be created is the dashboard maintenance unit. Question Credit: Andrea Tout Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
When creating a loadable xml format for bulk user creation using internal authentication, we face issue while signing in using the created users (the password encryption and decryption might have caused it)Is there any way out to solve this?For eg. : We created a user TestOS with password as Welcome1 using xml, but when this user tries to log in using the same credential, the user faces sign-in issues.
Hi the community! Do you know the way to proceed to retriev in a cubeview a specific UD where the text of it is set on a specific value? For example I want at the finest level all my UD1 which contain as a Text4 "Long_Lines" I write this as a formula : U1#Shipping_Trade.Children.Where(Text4=Long_Lines) But nothing appears as a result. Did I missed something? Thank you.
Hello all, This one is a bit of a doozy, so bear with me. In this specific instance of an application, we have multiple cubes that share identical hierarchies, except one cube uses the Entity dimension, and one uses the UD2 dimension. Ex. below: Cube 1 = E#10001 Cube 2 = U2#10001 Our goal is to have a cube view that compares the actuals from Cube 1 to the Forecast of Cube 2. We have tried many ways to work around this, resulting in our most recent endeavor of using UD8 dynamic calculations to return a data cell value from a member script in Cube 2. Our issue is that while the UD8 shows the proper data, it does not allow end users to properly drill down from the data cell. It also does not allow a user to see the proper cell POV of the data being presented. Is there a better approach to this? Essentially, the goal is to have the row dynamically switch between the dimensions, UD2 and Entity, based on each column. Other constraints to note are that this cube view needs to be created using
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.