OneStream Platform Forums

Hello everyone,Is it possible using a business rule to make a quick certification for a Certify Workflow?I was abel to complete the Certify Workflow task using business rule but the certification status remains rejected.Thank you in advance for your help.Regards,Antony

Hi,Out of Curiosity, Is it possible to update Task Activity.

One user has to access one entity and all products which means they can view all the products belongs to the one entity. what type of security want to use. can someone guide me.

Hi,I have a CubeView with indentation applied on row members. When exporting to PDF, I need all columns to fit on a single page. To do that, some column headers wrap onto two lines. The problem is that the indentation works only on the first line of the header. When the header text wraps, the second line is not indented, which creates a misalignment.Has anyone faced this? Is there a way to apply indentation on all lines of a wrapped header in PDF export? Thanks in advance

Hi everyone,I have an issue when exporting a CubeView to PDF.In the web view, column headers do not wrap. All rows have the same height and everything is aligned properly.When exporting to PDF, I need all columns to fit on one page. To do that, some column headers wrap onto multiple lines. The problem is that the row cells under these wrapped headers do not adjust their height accordingly, which causes a misalignment between headers and data cells.Is there a way to force the row cells to align with the wrapped headers in PDF? Or any workaround to keep the layout consistent while making sure all columns fit on one page?Thanks a lot for your help

We are looking to have a cube view that uses a parameter or CV Extender to possibly control the primary dimension selection. This is used in a dashboard to show metadata selections with the dimension in the rows and ud8 dynamic formulas across the columns. Looking to see if anyone has any ideas on doing the dimension selection dynamically to use one CV only for display

Hello, I am trying to update a business rule that is currently set to WFYear to the Global Time. We use the SAP Selector Solution, but I am new to it. Currently the WFYear of the user who schedules a trial balance import impacts what data is being loaded. For example, if the user's WF POV is 2024, then data is pulling from the source for 2024. I appreciate any suggestions.  Original Rule This is one idea I had, I am not sure T#|Global| will work since it is not a local variable. I also don't know if I need to change the "Dim wfYear As String = timeStr.Substring(0,4)" script. Thanks, Ronnie

Hi All, For the folks that upgraded to v8 (preferably 8.4 or 8.5), I have few quick questions. How long it took for the whole process? Did you see the performance improvement? Did you require an extensive end-user testing? How was your overall experience with upgrade. Any lessons learned that you can pass on? Thank you in advance for your time. Cheers PM

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.

hello everyone, do you have any idea if its possible to create a home page button that will link to Application Cube> FX Rates? Thank you

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!

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

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.    

Hi all,it is pretty straight forward in an dashboard extender rule to return a message box to be displayed to the user in the dashboard (like the picture below).The question I have is: is it possible to prompt the user with what I would call an interactive prompt, a prompt having a Yes and No buttons for example, and for the dashboard extender rule code to store the result of the selection for use in the rule code itself? This would be useful when displaying a warning for example. We could prompt the user with the warning and then ask if they still want to proceed or not. Thank you