Discuss the features and functionality of OneStream.
Recently active
Hi, I found this post from a year ago. Has the solution mentioned been added to the product? I have this exact situation and looking for the easiest solution. thanks, Greg https://community.onestreamsoftware.com/t5/Office-Hours/How-do-you-clear-elimination-records-for-parent-members-that/ta-p/1224 Answer The data is stored in the intersection even when the parent is removed. To clear the data, you would need to put the children back under the parent, run a DM job to clear data that is for E#[YourTopParent].DescendantsInclusive and T#[YourApplicableYear].DescendantsInclusive and then force consolidate. This will clear the elimination data for the parent (but also the data for the children entities). Then, the parents can be deleted/removed as needed. Note: There is a pending update to the product to address this in a future release.
Hello, I have a question in regards to cube views - I have multiple rows in the report, some of them including member extensions, and I am gonna write here an example: Row 1: A#Rent Row 2: A#Penalties.Children Row 3: A#OPEX Check that I want to make: GetDataCell(CVR(Rent) + CVR(Penalties) - CVR(OPEX)):name(Check) Instead of getting 0 on the check row, I get to have a difference due to tha fact that the formula only takes into consideration the first child of Penalties, ignoring the rest of the children. How to accomodate/change the formula in order to have all the children into consideration? Thank you, Ioana
Hello,I haven't yet found how to extract at once, all the Workflow Profiles for all entities for a single task.For instance, I need to extract the "import XLS" task for all entities, and not select the WF Profiles task entity by entity.In the module Load/Extract, it does not seem possible.Do you know how to do it ?Thanks,Regards,Harry
can you add totals to all the columns in a quickview? not with excel formulas
Is there a way to apply security on the records inside a Register ? For example I have 10 Entities and 10 Workflow Profiles with distributed registers built, Now inside the Registers there is a column for CostCenters. There are around 10-15 CC's. Users specific to CC should only see their records in Plan Register table. Is that possible ?
can you link the T# to a cell in a spreadsheet to pull in the date and refresh on its own without having to go into the member filter builder every time?
Is there a way to reference the contents of a spreadsheet created in OneStream via a business rule? I am trying to build a logic that will reference cells on the created spreadsheet in my BR.
In our people planning when you hit Complete on the Workspace it automatically goes through the Import, validate, Load steps. Is there any way to do this when you start with Import, Forms or Journals and have it only stop if there is an error? It would be much nicer if the user could kick it off and go do something else and have it be done when they get back.
Hi I want my UD3 value to be None for all BS and Revenue Accounts and then only look to the department to the 1:1 mapping if it is an expense. I created composite rules that have for an example the expression A#[1*]:UD3#[*] with an order of zero and then the 1:1 mappings with the order of one but it still finds the 1:1 rule first. Does the order only work within the Type and they always trigger 1:1 types first? If that is the case an recommendations? PS we are currently doing this in the data source but we run into a problem when we have a new account that they have to reupload the file again so that it knows what the account mapping is. I figured if I put it in the UD3 transformation that the account transformation would have already happened.Thanks in advance!
is there generic template available to load journal via csv template?
Does anyone know if it is possible to display commas within numeric columns in the table view feature? I have attempted to make this work both through the business rule and using formatting within the spreadsheet tool, but every time the spreadsheet is refreshed, the commas are removed. Any advice in this area would be greatly appreciated.
Hi, We have combo boxes in a dashboard that use an XFBR to define a UD1 (Cost Centre) list based on the text 2 field from the users current workflow. For example, if a user is in the North America workflow the combo box will only display North America & below. When a user changes their workflow & returns to the dashboard if their last selection isn't present in the new hierarchy the combo box will display a blank result. Is there a way to prevent this? We also have a similar issue where a combo box contains 2 parameters, 1 that defines the prior month & another for prior year. If the workflow time is changed these also return blank when the dashboard is opened. Thanks,
All,New to OneStream but familiar with other tools in the space. One request recently from a user was for a functionality similar to that of the "Personal Sandbox" capability within IBM TM1 / Planning Analytics. This functionality allowed a user to easily create a new scenario that allowed them to perform what-if analysis and once complete, discard the scenario or (permissions permitting) push the new data back into an existing scenario.Any functionality or approaches like this available in OneStream?Thanks!
when down load excel add in 6.3 it shows as OneStream XF in tool bar. Once you open you excel workbook with data, the data will not show unless you disable the Excel add in from COM Add-ins. can some advise how to fix the issue?
It appears that my chart only changes when I "refresh" the Dashboard it is contained on, and the Parameter prompts do not prompt when I "redraw" the dashboards. How can I get the chart to Refresh w/o the CV parameters prompting the user? Thank you, Stephen
Hi Team, i am trying to import an attribute in stage using excel template but not able to make this work. Please suggest where i am going wrong. Following is my Excel template where using tags to import:Excel template tag for Attribute1Following i defined in my data source:But, when i am importing, the InvoiceNumber column always shows blank: Thank you,
Hello, I created a Grid View to export data from database by SQL query. Some columns should be in number format and others in date format. I defined date format in both SQL query and in Grid View. But when I export data by right click from grid view -> Export To Excel XML, all columns are in text. How can I change default setting of XML Export so that columns will have correct formats ? Thanks in advance. Summer Format in SQL Query: FORMAT(ActiveDate, 'dd/MM/yyyy') as BuildingDate, Format in Grid View: ColumnName = BuildingDate, DataFormatString = dd/MM/yyyy, Export XML file:
I am looking for a way to download a dashboard with multiple tabs to excel and making sure each tab is downloaded to a tab in excel workbook. Is there a way to do that easily?
Hello, Is there a way to apply the RowExpansionMode (e.g. - Collapse All) setting when a user select's "Show report"? The Report Viewer appears to default and expands all. Ideally, I would like to set it to open at a predefined level, which I know is capable in excel. Thanks, Sean
We have an issue where in an excel template when opened by few users the formulae doesn't work as expected They get _xlfn ._xlws prefix before the functions which is because workbook contains a function that is not supported in the version of Excel that they are currently running Excel version used on the users machine is 2016 and according to onestream this is a compatible version with 7.0.1 Error screenshot below, let me know if anyone ran into similar issue This is not an issue when the same template is opened using excel part of office 365
Is it possible to create a custom header on a cube view when viewing the report in Excel? I was able to create my custom header for the Report view but I can not find any options available to change the header font and size on the Excel view. I do see in the Application Properties where the Headers can be formatted, but I am looking to only modify one header for one customer and not all of the headers. Is that possible?
Good afternoon, How can I pass a parameter selection from a Button/Combo Box to a URL within a text editor component. The client would like to select the UD4 and have it retrieve a Word doc / Text Editor for that selected UD4. I have the current URL in the text editor as this: Documents/Public/DashboardFiles/|!Fin_Dept_Select_ColSet!|.docx Thank you, Stephen
Within the scenario dimension does the workflow tracking frequency / Start Time / Finish time affect the forms templates form frequency? We had scenarios that run for 4 months with the start month and workflow month being the same, the quarterly/half year forms worked as expected. We have since changed the work flow start and end times to be the full calendar year (all 12 months), but this has caused the the quarterly/half yearly forms to no longer appear in the workflow. They only appear if the frequency is set to monthly. Can anyone explain before i raise a ticket? Thanks
Hey everyone! I've added a new department to my application and just realized it's not showing up as an option when I'm adding a new headcount-- see screenshot below. Has anyone seen this? I added 7 other departments together and none of them have this issue. I don't know where else to look for errors so any tips would be greatly appreciated.
Hi all,I'm having an issue whereby I'm importing profit and loss actual's data via a csv file into one of the data upload workflow steps we have set up.However some of the data is being loaded into months it shouldn't be, even though on the in the csv file the data is pointing to the correct time period.So for example in the upload file, data is put against time periods such as 2023M1, 2023M2 etc. Having imported the data, validated it and loaded it to the reporting cube we have, some of the data is being loaded into 2023M1 and also 2023M2, when on the upload file it's only on there once against 2023M1.I've checked the transformation rules and everything is set up correctly in terms of translating the import file, so I was wondering if anyone has come across this type of issue before or if anyone has any advice as to where I could look next?I'm pretty new to OneStream so any help would be much appreciated.Thanks,Ged
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.