OneStream Platform Forums

Can I use Attribute dimension to write composite mapping with other dimension?Context- I am reading extra column from a TB load to drive the mapping.I want store this additional information in Attribute dimension (and not using any free UD)  and use that to do composite mapping.Is it possible?

Hello,We’re trying to display the date and time in the footer of our cube views in the following format:"Wednesday, April 16, 2025 - 16:27:13" (or "Mercredi 16 avril - 16:27:13" for a user with French culture settings).We are currently using the |DateTimeHHMMSS| variable, but it shows the server time (e.g., 14:27:13 instead of the user’s local time: 16:27:13).The native option via Application Properties > Show Date doesn’t meet our needs, as it displays the date in the format "4/16/2025" or "16/4/2025".We’re looking for a more readable format depending on user culture:"Wednesday, April 16, 2025" (EN culture)"Mercredi 16 avril" (FR culture)Does anyone know how to achieve this — displaying both the user’s local time and a culture-based, readable date format in the footer?Thanks a lot ! 

I am running some data loads using Batch Harvest. I want to be able to capture the Validate Transformation and Validate Intersections errors to include in an email.  I am able to get the Validate Intersections errors from the application table.  Does anyone know how I would get the Validate Transformation errors?   If I run the entire job within a BR then I can get the Transformation Errors, but I would rather run it through the Batch Harvest.  I appreciate any input.Thank you.Scott

I have a daily report in bi viewer. This works by selecting the Week from a combo box and then it displays the days within that week (based on a sql table). I want to have the prior weeks show up as totals. Can't figure out how to do this within BI viewer or if I'll have to create a more defined sql query. Below are the screenshots from current setup. In this example I want to also see W1-4 but at their totals.  Select Week combo box: 

Hi team, my client was excited to upgrade to 8.2 to center headers. After turning on this functionality, what we have found is below. Can you tell me if I'm missing a setting here to make it work like we want it to? Finding: It only works if it is the top row AND it is a single member repeating. Notice how the months aren't centered, also notice that even though the scenario is merged and in the center cell, it is not centered WITHIN the cell.    

Is there a way with the :Name(description1) parameter to make cubeviews stack the headers so instead of the header being like "Description1 Description2", the header is "Description1" over "Description2" in the Column Header?  Particularly in a pdf report.

Hi Everyone,  I have a source file which contains multiple accounts in the columns for one month. These accounts are not there in the cube. I do not have a ud4 dimension in the source file. Each source account should be mapped to an account and Ud4 member. for ex: Account a001 has to be mapped to account A#a1 and Ud4#cost. Similarly Account b001 has to be mapped to account b#b1 and Ud4#sale. A#[a001]=A#[a1]:UD4#[cost] A#[b001]=A#[b1]:UD4#[sale] How can this be achieved in the transformation rule. Also, the data source needs to have ud4 or not. Thanks, Jeevan

Hi,  We have several excel sheets with XLOOKUP formula. In application-spreadsheet (v6.8 and V8.4) this is not working. Whereas it is working in MS-excel. Is this possible in OS-spreadsheet? Working around with match/index/vlookups etc is not a solution. Thanks, Rutger

HI Guys,  Is there anyway via a method query or rule in a data adaptor that I can specify parameters to give me all file names related to a workflow. I preferably want all file names in a specific workflow for all years in a data table of columns: (Workflow,Year,Filename). Presumably doable with a dashboard data set rule but Ive never played with the staging engine before!  Guessing also that its probably a case of looping years and appending tables.  Thanks,   Tom

I have a need to read a cell value from a Spreadsheet object (Cell D3 to be specific) that will change the color of a button object in a dashboard. The cell converts color parameters to ARGB style, and I want to use this to show an example of the color in another object. Thoughts? I want the cell vale to set a literal parameter which will refresh the object

hello  we've a excel addin based report (XFGETCELL). this report has macros as well. the data is used for recon process on another server that doesnt have excel addin. Is there a way to run this though DM/ business rule? or can this be automated through onestream spreadsheet and save as offline?  i separated macros in different file and tried running this report as xfdoc,xlsx. getting #Logon error on server (calc is automatic, cant change on server) is there a way to save as offline? i tried running through DM but facing #Logon issue. the server where we want to run recon does not have excel addin and we dont want to install. any ideas, please suggest.  in longer run, cube view might be a better option but is there a better way to achieve this? pls suggest. thank you in advance

Hello Integration Experts,I would like to know what are the alternatives we have to Integrate Netsuite with OneStream and which is best among RESTAPI and ODBC. Thanks

Hi! If we have a workflow scenario like forecast month 1, forecast month 2, etc. How do I change the # of days that fall into each month? I know there is a specific way to do it because I recall a colleague of mine literally typing out say 30 or 31. I've tried going to application, time profile, in the time periods tab, if I go to 2025M1, it only has the ability to change the first day of the month. I've also changed what days week 1 start and end in but these workarounds are not what I'm looking  for. Help please!

Hi,Are there any updates on merge and center on headers for cube views? It was informed that the enhancement is expected in one of the quarter releases in 2020. Do we have it available?https://community.onestreamsoftware.com/t5/Office-Hours/Question-Are-there-any-updates-on-merge-and-center-on-headers/ta-p/1503Thanks

Dear OneStreamers,I'm looking for a solution to have the headers displayed in a cubeview, even if it is repeating (so same header on next row for a dimension member.  I could not find an option to use in the formatting or general / common options.  Do you know how to achieve it ?Thanks,Hilde

I am well aware of the "Suppress Repeating Member Names" True/False box on a Quick View.   I am looking for the exact same toggle on a Cube View. I could have sworn this was a very easy thing but I don't see it. In the below Cube View example below, the first row member expansion is the Actual scenario and the second is a TreeDescendants on the Account dimension. I want the "Actual" scenario to repeat all the way down on each row. Am I missing something easy here?      

HiI'm using Guided Reporting to generate a Cube View. Within the Cube View, a parameter (delimited list) is used to show / hide columns. This is working fine.My problem is that in the Selector List, Guided Reporting is showing the Value Item (of the Delimited List) instead of the Display Item. For example, an end-user will select 'Collapsed' (Display Item) but Guided Reporting will show 'IsColumnVisible = CVMathOnly' as the Display Item.This isn't impacting report functionality, however it looks messy.    

I figured this out recently by chance and it's been so helpful I had to share...Did you know you can split the OneStream desktop to view multiple tabs at once?   If you have a large, high resolution monitor, why not be able to work in multiple tabs at once?Panes can be arranged side-by-side or stacked, whatever combination helps you see all the things you want to see at all at the same time, without having to switch back and forth between tabs.Here's how:1. Grab the tab you want to place in a different part of the desktop, click the tab and drag down and to the right.2. The Panes widget will appear.  3. Bring your mouse so the cursor is over the part of the widget where you want the tab you're dragging to appear.  If you drop it on the right, it will slide in on the right, next to the other open tab.  Drop it on the bottom part and your tab will be a bottom pane under the other open tabs.Here we're dropping on the right pane: Viola! Side by Side:Here we ar

Is there a way to load to multiple scenarios from one Workflow? Example, from the below Workflow POV, I want to load to the Actual_PP scenario, but also to the Forecast_PP scenario. I don't want to create a new workflow for forecast because I want to use the values from People Planning that have been calculated for Actual_PP to populate both scenarios.  I don't what to load the People Planning register twice and calculate it twice.

Good afternoon,After one of our calculations started to behave slowly, we have been advised that we should reduce our data unit size.Consultant explanation "Real Cell Count is relatively low, at 5 million cells. But to aggregate those 5 million cells, the system will have to request every monthly value for all of those 2.6 million rows from the database, hold in memory which ones have data and keep track of the ones that don't"In this sense, reading the forum, seems the solutions are any (or all) of the following:Leverage BI Blend to aggregate large data sets for reportingLoad into Cube at summarized levelAlways use RemoveZeros() in api.Data.Calculate and api.Data.GetDataBuffer functionsConsider different Entity dimensionVertical extensibility (not horizontal)Consider storing some data outside Cube (stage)Just wanted to check if you have applied any other solutions into your projects? as first time we need to reduce data unit size.Thank you,  

Pls share how to use one Button to launch several Data Mgmt Sequences in parallel.- Not several Data Mgmt Steps in one Sequence.TY.

Hi,I have an admin dashboard where I show all parameter values and information I need before I start my Data mgmt jobs. There is one value I dont figure out how to show in my dashboard. I have a Conditional input rule on the Cube. Can I create a parameter or Data Adapter or something to be able to pull the value and show in my dashboard? I only need to retrieve the Scenario value.  

Hi, does anyone know how to get the dimension descriptions (other then default) into PowerBI via the OneStream PowerBI Connector? In the OneStream PowerBI Connector, there is the "Get Dimension" part with an "include descriptions" option but it only loads the default description (which is english in our setup). We have also a German culture setting and all descriptions are setup in English and German but I cannot find a possibility to get the German descriptions in PowerBI. RegardsMartin  

I am having difficulty writing an amount to a prior month via a Finance business rule.  Specifically, for forecasting purposes in the last month of a quarter we calculate an excess amount and then want to spread that amount to the last two months in the quarter.  I can successfully calculate and write to the last month but cannot seem to write to the prior month.  For example, in Q2 as of June calculate the excess amount and then write 50% in May and 50% in June.  Has anyone been able to accomplish something like this?  Thanks in advance. 

Hello,Is there a way to sort accounts in numerical order using the member filter builder?Need to see trial balance in numerical order based on account name (i.e. A#12345, A#98765, etc) using the hierarchy. It would help as well if we could apply alphabetical sorting as well for the accounts which start with names. (i.e. Investment Other, Autos, etc).Thank you in advance,