OneStream Platform Forums

Hi all,I'm having a strange problem with cubeviews. I created some parameters to apply a standard formatting to my cube views:when I use them into the cubeview and I launch it, though, they appear in the initial popup without any value, as if they were user input params:am I missing something? is there anything I need to configure to make them work automatically?Any help is appreciated!

Does anyone know how Used (GB) and Unused is derived? Maybe I'm wrong, going to assume it's looking at total_size, total_used, reserved_pages, ect.. Trying to figure out the math, and questioning if it's correct. This is what I have so far, any feedback is appreciated! Dim sql As String =        "SELECT " &        "    DB_NAME()                                                                   AS DatabaseName, " &        "    CAST(f.total_size      * 8.0 / 1048576 AS DECIMAL(10,2))                    AS TotalSizeGB, " &        "    CAST(f.total_used      * 8.0 / 1048576 AS DECIMAL(10,2))           &nb

Hi all, I have an XFBR that I would like to take the entity member in any given row in a cube view. I've tried |MFEntity| but that doesn't work. |CVEntity| and |POVEntity| don't work either since they can only pass a single entity for a given cube view. Is there a way to get what I need outside of manually doing a column override for every single row in my cube view and hard coding the entity that I need to pass to the XFBR?

Hi All,I'm working with Line Item Modelling to implement workforce solution and trying Lookup drivers for one of the calculations. Lookup drivers doesn't seem to work at all. Has anyone tried and whether its working? The lookup driver that i defined doesn't fetch & return anything while using in calculation (formula) though it returns data while i preview it under Lookup drivers. Any help on this would be much appreciated. Thanks in advance.Cheers - Ramesh.

Hi guys!I would like to know if there is a way to get a more detailed view of what is consuming disk space for each application within my environment.I understand that the System Diagnostics dashboard provides a report indicating how much space is allocated and how much is being used per application; however, I would like to know if there is a way to obtain a more detailed breakdown per application. Thanks!

Hi all,I've found a different behavior between 8 and 9 releases of OneStream, related to the "Change Workflow" POV Action on a ComboBox component.In a Dashboard I have 2 combo boxes with the ebove mentioned Action:Select Scenario => Set WFScenarioSelect Time => Set WFTimeIn rel 8, when I select values in the combo, things works as expected: the WF variables changes and I DON'T exit from my dashboard.In rel 9 (9.2.0.18004), whenever I change one of the combos, the current dashboard lose the focus and I get redirected to the Workflow page. Why this behavior has changed ? Is there any workaround ? TIAFabioG

We recently upgraded from V7.4 to V9.1 and we’re seeing an issue with the Excel Add-In. A small group of users (about five) are unable to use the Drilldown feature (the option is completely greyed out), while the rest of our users can access it without any issues. All users have been upgraded to the 9.1 Excel Add-In and every other function appears to be working correctly. Has anyone else run into this? Any ideas on how to fix it?

Hi everyone,Quick View new user here, and for some reason I cannot create a new Quick View in a different Excel workbook. Is there a setting or feature I need to have active?  I have an active Quick View in another workbook, and want to create a different one in a new book. I am logged in, and I click the icon, but receive this message: Unable to create Excel Named Range 'QuickView_QuickView1' using '=[workbook name]$B$2'Any insight is appreciated and thank you in advance! 

Hi Team, I’m looking for guidance on the best approach to clear data in OneStream. My requirement is twofold: Clear all data from the Stage areaFor a selected set of entities, clear both Stage and Cube data I’m particularly interested in understanding the most efficient and recommended way to handle this, while ensuring data integrity and minimizing any unintended impact. Specifically, I would appreciate insights on: Recommended methods to clear Stage data globally (e.g., via Data Management steps, Business Rules, or utilities)The best approach to selectively clear Cube data for specific entitiesAny considerations around workflow locks, data unit locking, or audit/history implicationsPerformance best practices and recommended sequence of operations If anyone has implemented a similar requirement, I’d love to hear your approach or any lessons learned. Thanks in advance for your help!

We are having an issue with many of our Data Adapters. The Results Table Name continues to return as "SICResults".  They are using a DataSet BR.  Not all of them have this issue, even though others are using the same DBConn Connection.This does not happen when using the External SQL ConnectionThis is an issue when we try using 2 adapters on the same Report Component.We cannot have 2 data sources with the same name. Of the 4 ways to change this name:1) Place the table name in the call of a New DataTable()2) Use the TableName property after a new DataTable is made3) Name the query result "Select .......... AS TableName"4) Use the Results Table Name within the data adapter. Our code has no reference to "SICResults" anywhere.  None of our code does.   We just upgrade to 9.2

Hello, Since when are Form templates no longer allowed to include a dot (.) or a hyphen (-)? We built our naming convention using dots, and it is now unusable under these restrictions. Please confirm when this change was introduced and what alternative naming format you recommend. Best regards,  

Does anyone know if we can assign an Input Mask to Text Box components? Using version 8.5.4, I have a few dashboards that make use of Text boxes for data collection and I don't see a way to assign an input mask to the text box. An input mask is a string expression that constrains input to support valid input values. If the text box is expecting a dollar amount, the input mask would format the entry as number format #,###.00.  For capturing a telephone number (North America format), the mask would be (000)000-0000. If this doesn't exist, can the dev team add this to future releases? Thanks, Cosimo

Hi, is there syntax similar to forms to load journals into multiple wf periods?My WF is 1 period, 12 months:I tried using similar syntax to form loads:Template set up as monthly:And I return no messages when I load. Confirmed xfj range is set up on file and all dimensions match. Thinking maybe its my "Time" thats preventing the journal from getting into the system and want to confirm I have valid syntax.Maybe the other option is to set Workflow Time to 2026M1 and make individual journals for each period:Is it possible to do all months in 1 journal?

Hi,I'm trying to create dynamic members within a dimension using api.ReadDynamicDimensionInfo.I created a custom table within application database. When the service runs, it creates members under the root member even when I pass the "Parent" member's name. Also, the aggregation weight is being set to 0 even when I've passed numerical values.Table:Dimension Library: I want the members to be created under "All_Customers"Code:It works when I use - CreateAndAddrelationships but not with the api mentioned above. Am I doing something incorrect?

Is there a way to change the color font in the Quickview POV pane?  User is saying the grey font in column/row dimensions is too faint to read, see below screenshot:    

Hi all,I'm using ImpactCalcStatus to impact an entity based on another entity that has the Sibling consolidation pass set to 2. I can see the status changing during processing, but at the end of the consolidation, it remains CA/CN. Only after running it again does the status change to OK. What am I missing here?api.CalcStatus.ImpactCalcStatus(cubeId, Children.MemberId, Parent.MemberId, consId, scenarioId, timeId);Thanks.

Hi,I was trying to go back to one of the two Genesis pages (we have two instances in our app) using a button but seems like the following navigation action is not working.XFPage=Dashboard:[container_bag_(App)_(Main)_EU]I've tried using parameters in embedded dashboards to refresh the content and there is no way to go back to the home page.It appears that Genesis assigns the same names for all objects so it's a problem when trying to refer a home page dashboard only related to a specific instance. This is the reason why i renamed the home page Genesis dashboard with a suffix.For now i just opening the dashbaord i want in a new page using OpenInNewXFPage=True, but i prefer to make the back button working.   

We have added a power user who has the ability to manage some dimensions, however they cannot access the hierarchy validation tool and receive the error Security Access Error.  User XXXX is not authorized to access object 'OneStream Database Server'. I tried changing the access in the workspace but this did not resolve the error. What areas need to be changed to allow access?      

Is there an ability to calculate HC expenses that account for when in the month an employee starts and prorate accordingly? As an example, if the employee starts on the 15th then their monthly salary would be Salary / 12 * (15/30). The syntax available in the blocks don't clearly identify if this can be done. 

Hi, We have moved to v9, and the previously used IC matching methods are giving us issues. For this we have a ticket open with support, and they have pointed us towards ONC. We use something very similar to the intercompany all plugs, but then supressing any combinations that are matching. Is there a way to filter the IntercompanyDetailAllPlugAccountsGridView_ONC to suppress the matches? It seems to be working in our development environment, but would be great if we can supress the matches as this is something that will be required. We have tried this:  {WS}{GetIntercompanyDetailAllPlugAccountsGridView}{View = |!Members_View_Numeric_ONC!|, SuppressMatches=True} But that does not seem to work. With kind regards, Tim

Hello,Is there a way to pass a combo box paramater into a cube view service? I think would be through the Service Factory.Since the cube view service runs when the cube view is executed and there is no call as XFBRs or Dashboard extenders, Is there a way to pass parameter values into the cube view service business rule? 

Hi, I would like to know if any major changes need to be carried over from 9.1 to 9.2 version upgrade. As we had some changes performed when we moved from 8.5.1 version to 9.1.0: Winscp to SSH.net Marketplace solutions to be upgraded to latest versions also Navigation center replaced applications reports, security audit reports. so, we had to remove the existing AR, SAR solutions. We had .vb in the extension wherever the xfbr has been referenced that extensions were no longer supported in 9 version. Thanks in Advance!

Hello everyone, Thanks to this discussion: https://community.onestreamsoftware.com/discussions/WorkflowDI/forms-by-entity/13417 I can now show or hide the input cube views based on whether or not the group entity has been released, as stored in Entity Text6. However, by doing this, I lose the ability to display cube views only for the quarter, half-year or full year. Currently, I display the cube views every month if the entity is present in the group, so this does not apply to cube views that should be displayed quarterly. I would therefore like to retrieve the name of the form displaying each data entry cube view, so that I can define in the Business Rules whether each form should be displayed monthly, quarterly, half-yearly or only in December. This would allow me to use the settings provided natively by OneStream, which I have previously bypassed. But I am unable to do so. Is this feasible? The ultimate aim is to prevent accidental data entry into workflows that should no longer b

Hi everyone, I need to set up a few transformations to normalize a delimited file that will be uploaded by the users, before feeding it to the datasource.I previously worked with FTP folders, and used a Connector BR to retrieve data and normalize it before the datasource step.I have never worked with delimited files loaded directly by clicking Import. It's not clear to me if I can still use a connector BR or if I need to use something else (a Parser BR?).Can anyone help me understand what is the best practice in this case?Thank you for the support!

Hi Community :)We are currently in development with regard to loading sub-ledger data into OneStream, but the balance specifications are so granular that we currently have them split into about 10 distinct loads. Because of this setup, our end users are being forced to manually click "Load and Transform" 10+ times to get a complete sub-ledger balance loaded for the period. Obviously, this is tedious, creates a poor user experience, and introduces a lot of room for human error. We want to streamline this. What is best practice to do this?