OneStream Platform Forums

Hello - I'm working on a cube view that will be used to add variance commentary. The rows have accounts and subtotals, the first column will have a specific entity that will not change, then the next set of columns will be dynamic. I have it set to pull base entities based on specific text values. The entities that do have the first text value (called "DP_2023Q4") are appearing as intended, however there are no entities that have the text value (AQ_2023Q4) in the member filter of the next column, so when I run the CV it just repeats the first column to the right of the columns with the DP_2023Q4 entities. I have several questions for this: 1. How can I set the cube view to return a blank column if there are no base members that have a particular text value? I added a column override with a UD8 dynamic calc set to return nothing if there's no data, and that didn't work. 2. Right now the member filters are set to look for text values that have "DP_|WFYear|Q4" and "AQ_|WFYear|Q4". This sh

Hello,   I am trying to set up a business rule that seeds the forecast from actuals to the forecast. This works easily when I am not using all entities to seed. However, I need to somehow take the actual data from each base entity and copy it all into 1 entity for the forecast. The client only needs to forecast at 1 entity but wants to include the actuals from every base. Is this possible to do in 1 rule? I know you can't have the entity on the left side of the calculation so I'm not sure how to solve.   Thanks!

Hi, I know I could create a custom member list of an XFBR rule for the scope, but is there an easier option to get the cube view rows ordered alphabetically based on member names? Eg. currently, if I have E#Ent1000.Children in row, the cube view is by default showing the members children of Ent1000 in the order with which they appear in the Entity hierarchy. I would like them to be ordered based on their name. Thank you

Hi,   I have a WF where I dont want to have user load data through import. Only Forms and Adj. I could turn the profile Active to False.but the problem is  I have a historic WF where is an import level for this entity. I tried doing the  optional data load to True. when i am complete the Workflow for the Import step - I get a error saying import step doesnt have a datasource assigned- which is expected as I am not having a active TB load.   Any suggestion where I can complete the WF - Import step without really loading data?    

Good morning all! I'm hoping somebody can put me on the right path...! I'm writing a rule with a data buffer. I want to filter the data buffer so it only runs where needed. I put in the following filter relating to the Text6 field. This syntax works in a cube view (I've tested this) but it doesn't seem to work in the vb.net rule. Can anyone tell me what I should use here instead to return only when text 6 is not blank? Many thanks,Richard

I have an Import Profile Type that includes a Workspace, Import, Validate, Process Workflow Name. The Workspace step uses a Dashboard that contains a SQL Table Editor component.  The table does not allow updates. When I run the same Dashboard from the Dashboards editor it allows updates.  I've also tried using a Forms Profile Type instead of an Import Profile Type and that allows updates too.   It must be something with the Import Profile Typet that is preventing the updates.  Is there a setting that I can change to allow updates in the Import Profile type?  

Hi ,   I am trying to create a offline package but getting the below error.(snapshot attached) '',hexadecimal value 0x03 is an invalid character What is the easy solution?    

Hi All, I have created a cube view and added an empty column, I am able to see blank at base member rows but here I am getting value in the rows of calculated member in the empty column, can anyone suggest how to get complete empty column in the cube view. Please find the below snap for your reference.   Thanks in Advance.  

Hi Experts,  Can you please help me how EVA calculated in OneStream? and how EVA Analysis report should be created? 

Hi,  I am using Derivative Rules in order to generate additional records in Stage. In this example, I have two derivative rules per I/C transaction. The account mappings will bypass the original source value and one condition will be met and therefore loaded to the cube. If the value is greater than 0, then the value will go to 40L1CA.001A_DER. If the value is less than 0, then it will go to 40L1CA.001L_DER. Derivative Rules: Account Mappings: IC Mapping:   The value shown below is $224,469.18 therefore the rule is correct. However, the IC is this case is mapping to None. I was expecting IC to map to IC partner 170 based on the IC mapping shown above. How can I ensure that the IC partner is mapped correctly to the cube? I want to ultimately tie out IC matching report.

Hi, We're trying to allow all users (Everyone) write access to a specific dimension V#Annotation for all entities that they have read access to. Example: UserA is part of a security group that has only read access to Entity1. We would like them to be able to write only to V#Annotation on Entity1 as well. We've tried using Data Cell Access Security but I can't get it to increase / decrease security where we want it to. Is it possible to increase access to users who don't already have write access to a specific entity? If so, what would be the best way to accomplish this?

Hi all - This is probably pretty basic, but I keep getting stumped. Ultimately I have two monthly metrics I want to look at for each month for current year and prior year. I can get the current year rows set and working, but for some reason for the prior year rows, it shows me the full year data instead of the periodic, even when the cell POV shows "periodic" it fails to grab the month with the year. set up like this:   The months are tied to the columns and the year is tied to the row. Any idea why my PY rows cannot recognize the month while the current year can?

Hi there  I need to write a composite UD1 composite mapping rule based on a another dimension (Entity)  Example :  looks to see if the Entity is a base of Parent A , then map it to UD1 X , otherwise if the entity is a Base member of Parent B, then map it to UD1 = Y Please help    

Hello, I am trying to seed data from Actual to Forecast scenario. I am running the Business Rule through a DM step, whose data unit contains the forecast scenario, so that it picks this forecast scenario in the destination string. My Actual (Detail level accounts) are on more granular level and extend my planning accounts (plan and forecast accounts). The planning accounts are on top level.  Now, when i try to seed the data, it picks the Planning Accounts (since i have Forecast Account in my DM step), due to which my  Actual accounts are not picked up by the process. and the data copy is partial. I am trying this by using DataBuffer. Please let me know if there are any suggestions or solution to this. Thanks

Hi everyone. I have the issue that when clicking on a row in an SQL table editor, it doesn't open the view with the correct value, but instead, it displays the value from another table. I have 4 tables that use the same view to edit information, and each one has a different bound parameter, and that value is assigned in the SQL table editor section. Example: As you can see, it's set up in the same way, but where the DItemID value is assigned is where I'm having issues. ¿Any solution to this?  

Hi . Does someone know what is the maximum number of members allowed for a product dimension?, we are assessing implementing the SKU reporting level and we manage around 13k products, I am wondering if the application can manage this volume of data. Regards.

I am building a balance sheet report where accounts will show on the rows. Under accounts receivable, we'd also like to show its payor breakdown which we use UD3 for the payor data. Is there a way to apply UD3 into the rows but only show for the accounts receivable section?

Is there a way to add a blank row/column within Cube View? I know it can be done, but can't seem to remember the code. I believe it was "|!Blank|"....   Thank you!

Dear community, we have requirement of pulling level 2 parent for a member in writing UD8 Dynamic calc, do we have any method of pulling it in writing business rule. Any solution to this will be very helpful and appreciated.    

HiCan anyone advice how to push OS data back to SQL server by using SIC gateway?We setup the SIC to import data from SQL servers to OS successfully in SIC business rule, but no idea how to push back data from OS to SQL by the SIC.Business rules created in Extensibility do not work like BRApi.Database.SaveCustomDataTable function.Thanks 

Hi Everyone.I have a DataCell that ends with a comma, and I wanted to know how I can remove it. Example Etc. UD6Id: -999, UD7Id: -999, UD8Id: -999, My issue is similar to the example, where after the UD8Id there is a comma with nothing following.  

Hi Is it possible to configure default group settings for a grid view? E.g. I've got a table here, and I'd like to configure the table so that it is grouped by the message column: Regards, Mark

When a comment is added to a cell or file is attached to a cell, there is not mark on that cell for other users to know about the comment or attachment. Is there a way to highlight the cell with tick mark or anything else for the user to realize there is a comment? When view annotation is used to add the comment, it is not obvious to the user that there is a comment on a specific cell as there is not red tick on the cell. Appreciate your help!

I have a BI Viewer grid using 4 accounts. When I use these numbers in a grid or pivot chart, they can only be sorted alphabetically, or ascending/descending by the data. I would like to manually sort these numbers. E.g. My accounts are Automotive Expenses, Operating Expenses, Non-Operating Expenses and Total Expenses. I would like to sort it as: Operating Expenses, Non-Operating Expenses, Automotive expenses, and Total Expenses.  Is this possible? Thank you in advance.

Hi All,  We are using FdxExecuteDataUnit to export data to SQL tables for consumption by downstream systems. Is it safe to run FDX queries while consolidation/Data Loads is in progress ? Regards Sridhar