OneStream Platform Forums

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!

Dear all, Could you please advise is it possible to show Account Name and Description in cube view in two separate columns instead of single column?

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

Hello everyone! I am very new to the industry and OneStream and I really need some help to kick start my application building journey!Currently, I am trying to test out the capabilities of OneStream using the scenario stated below:I have one central division that will split into two 'teams'. For example, Division_1 and Division_2, both teams have handle their own projects. For example, for D_2, under Project 50A there are mini projects like 50A001 and 50A002. For D_1, under the same project 50A, they handle other projects like M0001 and M0002.So what I am trying to achieve is: Tracking their expenses, so they will roll up to the central Division. E.g. Division 1, project 50A, spent $1,000, Division 2, project 50A spent $1,500. So the rolled up amount would be $2,500 and the ability to breakdown to the specific items.If possible (which it is) Division 1 handle projects that are "Approved" so the expenses are actual. Division 2 handle projects that are "Awaiting Approval" so the exp

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,I'm trying to figure how to stack 3 cube views on the same page and add that to a book. I know you can create a stacked report in a dashboard. But I don't know if you can add dashboards to a book or not.Thanks,Will

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?

Hey Folks, I am looking to map all validation errors that might occur during an automated load to a placeholder member in the UD1 dimension, but i am running into issues as the mask rule approach is not working. Does anyone else have any other way to make this work? Below is what i have tried but i still get kickouts in the validation step of the load process.    

Hello, Our transformationeventhandler rule adds missing UD1 members to an unmapped parent.The rule works and has been for a few months. A couple of weeks ago I built a business rule which leverages the utitlity "ExecuteFileHarvestBatch".I have the relevant settings as True. Dim valTransform As Boolean = TrueDim valInterest As Boolean = TrueDim loadCube As Boolean = TrueDim processCube As Boolean = True The batch rule was built so I could schedule the data load.What I am noticing, is when the scheduled job (which calls a DM job with the rule) runs there are failures because of missing UD1 members.If I, then run the import/validate/Load and Process steps manually there are no errors and the missing UD1 members get added. It is as if the TransformationEventHandler is not being executed when the import process runs via the scheduler/dm job/rule. Any ideas for suggestions of where to look?

Hi, I am working on extracting data from a Cube view to a flat file. I am using FDXExecuteCubeView query to extract. The extract file is executed to run for one year. I am seeing for each Entity, Scenario, Time (DU) a log entry is created in Task Activity. The Task Activity is getting flooded with cube view log entries. Is there a way to stop the Cube view entries for each Page (Entity, Scenario, Time).? On the Cube view I have the log setting set to False and also in the FDXExecuteCubeView setting I have the logStatistics setting set to False. Is there a way to not log the entry for each time cube view is run for (Entity, Scenario, Period)?  Appreciate your inputs!

We have a client who wishes certain workflows (Input Child) to only be visible at specific periods during the year (6 and 12) The only way I could conceive of this based on my knowledge of OneStream to date is through managing security profiles somehow (Access Group) But everything I have seen indicates a very binary process, you have access or you don't.   

I'm having an issue in which derived YTD values are consolidating in their period and it is throwing off our results.  In the example below which shows expenses by department for a site, there are no longer expenses for the Mfg_Selling dept in M2.  OneStream calculates the derived YTD values of -37905 (0 - the prior period expense of 37905).  This I understand.  What I don't understand is why that value is consolidating up the hierarchy when the view is set to periodic.  NOTE: I know how to hide the derived value in Mfg_Selling/M2, it is shown here for illustrative purposes.  

Hi allit seems that OS 8.4 notification settings by default only send emails to 50 users. Could this setting this changed / amended and if so in which part of the application?Thank you Nou

Hi all,I'm trying to figure out how to leverage on Report Scripts using OneStream objects. Is it possible to leverage on BRApi inside scripts events ? A direct call to BRApi class results in an error, I'm wondering if there's some workaround or trick to reach the object.Best RegardsFabioG

Hello,I am trying to execute this assembly at load time for this specific dashboard.The rule executes as expected, but I cannot seem to get the parameter to function properly. Here is how it is returning in the log:It's as if it is not reading it as a parameter at all. Any suggestions? 

Hi all, I'm trying to build a trial balance that shows line items in their natural debit/credit balances (e.g. - revenue, liabilities, and equity showing up as negative, and all else showing up as positive to arrive at a balanced ($0) report). However, we have some contra-accounts within our Accrued Expenses roll up that should show up as debits instead of credits. The accounts all begin with JDE_1 so I thought I could use the IF statement below to change the formatting for them, but the IF doesn't change anything (everything shows up as a negative, rather than accounts beginning JDE_1 being positive). Does anyone have any ideas as to what may be going awry? This IF statement has worked in other cube views that I've built, so I'm at my wit's end as to why it wouldn't be working here! If (RowE1MemberName StartsWith 'JDE_1') Then FlipSign = False Else FlipSign = True End If