OneStream Platform Forums

Hello, I'm trying to calculate an External and Internal Gross Profit calculation based off a few conditions. To calculate External/Internal GP, I need to allocate the ExtCGSOther group + OpExp using our UD1 MFGResale between External/Internal using an allocation basis of ExtMLBS and IntMLBS (with the exception of account 6123 which is 100% External). I need this calculation to be on a dept by dept basis. I'm not really sure where to start and I tried looking at Golfstream but couldn't find anything that fits what my company is asking me to build. Thanks, Will

HelloWe are using the BRApi.Utilities.SaveFileBytesToUserTempFolder command in a dashboard extender rule to open a file generated by IFS.  It will create PDF or Excel files based on the extension of the file.When the user tries to open either file type they get one of the following errors.I am able to locate the generated file in my Temp folder but it won't let me open from there either.Has anyone see this or know of a solution?  I am aware it is a MS issue probably not OS, but was just thinking there may be a new way to generate these files so MS doesn't think they are corrupted.The client is currently on 7.4.2.  They had previously been on 6.8.1 but apparently have not used this dashboard since then.Thank youCR 

Hello, I'm trying to create a cube view that grabs actuals from People Planning and populates the future periods with the latest month of actuals. e.g. in M3, M1=M1 Actuals, M2=M2 Actuals, M3=M3 Actuals, M4-12=M3 Actuals.  I need this in a cube view because we need to be able to show the data in both local currency and USD.  People Planning is currency agnostic.  I tried this directly querying XFW_PLP_Plan with SQL and a biViewer, but ran into the problem of not being able to bring in FX rates.  I can only show local currency.Has anybody done this or have any ideas?  Perhaps something with UD8?  Perhaps there is something simpler I'm overlooking?  There is SO much to learn with OneStream and I know I'm only scratching the surface.

I recently discovered that data from deleted Scenarios is not removed from many of the application data tables (XFW_PLP_Plan, XFW_PLP_Register, ...)   Does anyone know why it remains and is it safe to remove as the scenario no longer exists.   I would think removing the old data would improve performance and reduce db size.    Or am I unaware of the tools to perform such maintenance?

Hi,We are using the capital planning module. There is a requirement from clientFor a few lines, users should not be allowed to change, modify, or delete anything.However, if he adds additional lines, he should be able to edit, add new line or remove.Example:In the budget scenario, data is copied from Actual, and it also has its own budget data.So, for data that comes from Actual, end users should not be allowed to modify or remove.However, for budget data, he should be able to update, change, and remove lines from the Capital Planning Register.Is it possible?

Hello,I'm working on a rule that drills back into source stage data from the target summary table. I'm receiving an error on the ReadSourceDataForSummaryRow line that the method or operation is not implemented. I've verified that the parameters I'm passing are correct and in the correct format.Dim importTable As List(Of TargetDataInfo) = BRApi.Import.Data.ReadSummaryTargetData(si, si.WorkflowClusterPk, Nothing) If importTable.Count > 0 For Each importLine As TargetDataInfo In importTable Dim summaryRowID As Guid = importLine.SummaryRowID api.LogMessage("before, summaryRowID: " & summaryRowID.ToString) Dim sourceLinesForSummaryID As List(Of SourceDataInfo) = BRApi.Import.Data.ReadSourceDataForSummaryRow(si, summaryRowId) api.LogMessage("after") Next End IfHas anyone else encountered this issue before? I'm working in OS version 8.2.3, but didn't see anything relevant in subsequent release notes.Thank you!

Hello OneStream experts: Thank you for the helps in the past. I have a quick question about place UD1 members in Account dimension UD1 constraint For example: In my account metadata dimension: I have 2 accounts 4001-Sale_IceCream 4002-Sale_Donut In my UD1 product dimension: I have 4 products all under one parent product Product_1,Product_2,Product_3,Product_4 I want to place Product_1, and Product_3 to the UD1 constraint in account 4001-Sale_IceCream's UD1 constraint field. But OneStream only allow me enter one product member in that filed. I can only enter Product_1 but cannot enter both Product_1  and Product_3 in the field.  Thank you so much in advance to help me get through this issue.  

Any ideas what attributes this message might be referring to? There are no errors in the error log and the Task activity shows reconciliation discovery was completed, yet New = (0). Thank you for any leads in advance!  

Hi all,while building new classes inside a Workspace's Assembly, I'd like to get Strings in specific languages.On components, we use "XFString(<stringName>)" to get the localized string, in the User's language.How can I accomplish the same thing inside a method ? I mean, which is the equivalent for XFString inside - let's say - BRApi ? Or should I really get the localizations from the DB Table ? Thanks for Your helpRegardsFabioG

Workspaces & Assemblies | OneStream CommunityCurrently James' webinar is posted in the reserved area.Please post it also to the general area to help everyone migrate to PV8+.Thank you.

Currently i am working on NR reporting, i have created extensible documents with cube views, those cube views has parameters Is there a way where we can supply the cube view parameters, in doc variable? i have tried to apply parameters in book and document section in NR but that is not working. Thanks for your help and support.

Hi. Is it possible to make annotations in the UD1 dimension and have them roll up to the respective legal entity (at consolidated level)?A challenge I'm facing is that only specific base members under the UD1 dimension reference the legal entity in the text field. How can I manage this so that only the relevant regions (that reference legal entities) contribute to the commentary at the consolidated level?

Is it possible to have a Scenario Type with a 5 year input frequency?I need to be able to load 5 years at once instead of having to change the wf year 5 times.is it possible?

I created a detail account dimension without creating a summary account dimension first.  When I attempt to create a summary account dimension now, I get an error message indicating the member already exists.  I tried to delete the detailed dimension and start over but there is already data saved.  How can I correct this?

Hi! Is there a way to extract the entity structure without constraints? In the current entity structure, every entity has a different UD1 constraint, but I need this to be set to Root for all entities when loading it in the other application. I know in Notepad++ you can use find/replace to modify this, but because every entity has a different UD1 constraint, it is still quite a manual process. Wondering if there is a more efficient way. Thanks in advance!

Hi all! How can I wrap V#Annotation text in a column? Right now the reporting is not the most user friendly so we're wondering how to show it better. It looks like there were some suggestions from three years (Maximum characters for Annotation | OneStream Community) ago but wondering if we've made any progress on this issue since then :)  Thank you! -Nicole

Depending on the circumstances, you could find yourself into a situation where you need to report numbers on Extended dimension Members from the Top Consolidation Cube. In a Vertical Extensibility Cube set up this gets tricky since the data is only available at the lower cube levels. To work-around this challenge (considering the limitations exposed below), I have created a dynamic calculation Business Rule that allows you to achieve that by leveraging a specific UD8 Dynamic calculation Member.    Following it is an overview of the Solution:  Problem Statement: When using Cube Vertical Extensibility, reporting from Tot Group cube is not possible for those dimensions that have been extended. In the example, UD1 is only available at Summary Level for  Tot Group: Solution Overview: UD8 Dynamic Calculation to derive the Extended members from the Base Entities consolidating to the Parent Entity Level (E#Tot Group). Data is dynamically retrieved from the base entities

Hello Team, Generally, User will open a form through workflow and input data and certify that. i need pull a data Like, which user has certified the form for respective site. and in which table those User certified details will be store. Can you please help us on this.

HI, I am looking for an option to highlight text value in the cube view based on some condition. I have combo box which has parameter which pulling value from one of the DIMMember 1 = United States Member 2 = Canada Member 2 = Not filled If its not filled then I want to highlight red. Is there any option. I tried using XFBR but seems like it run on specific data unit only

When we take an XML extract of an application with Cube Views built within Workspaces and load into a fresh application there are Cube View groups for each of the Workspace groups on the main Cube View screen/in the Default Cube Views. It is essentially making a second copy of all the Workspace Cube Views in Default. Some Data Adapters are then linking to the new Cube Views copies in Default that did not exist in the original application the XML was taken from. Has anyone else seen this behavior? Is this a known bug - doesn't seem like expected behavior?   

Hello, I have a weird behaviour when defining dynamically the dashboard layout. If I define dynamically the dashboard layout to be either a vertical stack panel, horizontal stack panel, or uniform, then all of my components render as expected. However, if I want to define them as grid (3 rows, 2 columns), then nothing is rendered. I did use (in that order, if that has any consequences) : contant DashboardLayoutType.Grid property GridLayoutDefinition.RowDefinitions as a list of xfgridlayoutrowdefinition property GridLayoutDefinition.ColumnDefinitions as a list of xfgridlayoutcolumndefinition The logs are telling me that the dashboard indeed is now a grid with 3 rows and 2 columns, however all of my components are not rendered in the dashboard. Being a grid : Being a vertical stack panel, horizontal stack panel, or uniform :   I do know that a grid is intepreted differently as a XAML grid class but I have no clue why it wouldn't be rendered with my components in it. Any help or

Hi everyone; we have an application using standard elimination, we have been used eliminations between balance account and P&L accounts, I created a new account in Balance sheet accounts with plug account as Assets, create another P&L account (Revenue) using the same plug Asset account; now when runs the consolidation & Eliminations, there is a difference with balance, is unbalancing. Is there an specific configuration that I need to setup into the accounts? Thanks in advance and best Regards. Mario GV

Hello, I can find no documentations about the "GetDynamicAdaptersForDynamicComponent" that is under the dynamic dashboard services. How to use it ? How to define a dynamic adapter ? My goal is to create dynamically a label component (which is done), but I would like to add a data adapter to it. Unfortunately, I haven't been succesful in dynamically linking a data adapter to my label :   Regards,

Hello there,  can someone please share a sample transformation event handler code to map an unknown dimension member to a "placeholder" in the same dimension when validation step fails? Appreciate it!  

I'm currently using the Narrative Reporting MarketPlace Solution on OS version 8.4 and have successfully integrated Cube Views, Content, and other artifacts using QuickParts. However, I'm facing several challenges:Member Prompts on Report Checkout/Edits: Despite configuring parameters at both the report and report group levels, I continue to receive member prompts from the cube view every time I check out or modify a report. This differs from the expected behavior in guided reporting and dashboards, where parameters are supplied automatically. Is this expected, or is there a workaround to prevent these prompts?