OneStream Platform Forums

I am displaying a list of members in a listbox on a dashboard. With the format IsMultiSelect=False, the members with an underscore display correctly. When the format IsMultiSelect=True is used, the underscore in the member name is not shown. The listbox knows there is an underscore because I display the selections on the dashboard and they display correctly.Before I raise a ticket with support, has anyone met this before and has a workaround? Or am I doing something stupid?Thanks

hi,I have an calculated form data stored in UD8 as shown below. Its not showing up in the quickview retrieval. Is that because of the status code . Below are the screenshots from database and quickview. Am expecting the Value 12 to be retrieved in the quickview. Data record Cell POV: Cb#*****:E#*****:C#CLP:S#Forecast_Working:T#2024:V#YTD:A#TOTAL_VENTAS_NETAS:F#None:O#Forms:I#None:U1#0082:U2#None:U3#Other_LMD_3P_Platform:U4#Base:U5#Comparable:U6#None:U7#None:U8#LRP_AllocatedAmount   Quick view POV: Cb#****:E#********:P#?:C#CLP:S#Forecast_Working:T#2024:V#YTD:A#TOTAL_VENTAS_NETAS:F#None:O#Forms:I#None:U1#0082:U2#None:U3#Other_LMD_3P_Platform:U4#Base:U5#Comparable:U6#None:U7#None:U8#LRP_AllocatedAmount  

Hi, I am loading periodic data and in some periods there are derived amounts (due to no periodic data for some periods).  The YTD values appear as derived data.  However, the parent entity isn't rolling up correctly because the parent is not including the derived amounts of the children. What is the most straightforward / best method to include the child's derived value in the parent value for the entity to correct this?  (I am ok with storing the children's derived values, but not sure of best method for that, either.)Thank you! 

I am using the BI Viewer to display bars for actual data and a line for the budget/target.My issue is when I split the values into two groups the items in my legend are doubling. So I see each one once for the budget line (even though all intersections are 0 but one) and once for actuals. I have tried using the filter through the graph as well as creating a calculated field to filter what I want out before I get to the graph but still the legend is doubling. Does anyone know how I can remove unwanted items from the legend? The graph is showing exactly how I want it to it is just the legend that is the problem.Thanks! 

I am creating a cube view to use for a form template. The first column brings in data from a set of account members using A#xxxx.Base as the member filter for the row. On the second column I want to allow input from the user. So, on that same row I am trying to use column overrides to achieve that but having issues:Using A#yyyy.Base as the member filter for the column override doesn't actually allow the cell to be editable. Using the base members in a list for the member filter allows input on each cell, but automatically fills in the rest of the column cells with the same number and upon checking a QV only sends data to the first member in the list. Can modify data is set to "True" for both the column and the row.My question is - do I need to break this out and create a line for each member with the corresponding column override member or is there another way to do this?  

Hey,We have a Pivot in the BI viewer with 3 rows say Row 1,Row 2,Row 3 and we want the sum of Row 1 and Row 2 as Grand total. Today when we try to do this, we get the sum off all 3 Rows.Is it possible to archive this in BI Viewer? 

Hi , Can I use 'AdjInput' when loading through the Import channel in a WF? If yes, what customization is required?  

Hi,Report Title is hidden in CV Extender but can it be collapsed?Using above code it is hiding Report Title, But it is consuming too much space, Is there any way to Remove / Collapse / Eliminate CubeView Report Title using CubeView Extender Rules. Any solutions would be Helpful.Thank you

Hello,We are having this below requirement, where we trying to achieve this using Cube View extender rules.Rule should vary margin depending if it's landscape or portrait.If Landscape, thenRight and Left should be 0.25, Top should be 0.75, and Bottom 0.5Else If Portrait, then Left should be 0.75, Right should be 0.25 with Top and Bottom 0.5  Any help or suggestion will be of great help!Thanks in advance.

Is there a way to move the company logo to the right header side of reports? I have applied a business rule to move the report title on the left but now it is hidden behind the company logo.  TYIA!

Hello, I have a problem with a couple business rules running at the wrong times from within a dashboard.  The background: I have a business rule that changes the formatting of the buttons on a dashboard to show which one was clicked last. The buttons function as "tabs," each linking to a report; the button linking to the currently selected report shows itself as highlighted. To do this, I have the name of the current active button stored in a literal parameter. When a button is clicked to launch a report, a business rule rewrites the value of this literal parameter. (An XFBR String rule then reads this parameter to determine how to format the buttons, and is output to button - formatting - display format). The problem: When I launch the dashboard from OnePlace, the highlighting works correctly, showing a set of buttons with the first button highlighted. When I click another button, the button works correctly by launching a report, but the first button remains highlighted. The li

hi, I  have  custom table created with records  using the finance BR. Second step is to send the data from the custom table to another applicaiton using the connector rule. Is there an option to call the above two rules in single datasource in the above order or it has to be two individual workflow steps.  Thanks

Hi all,  We have data coming into Import/stage that subtotals to zero when it validates/maps into the cube. We need to review this data in import/stage before the validation and the easiest way would be a QV or CV instead of having the user manually go into the workflow and export the data. I thought accessing stage data in a QV/CV was possible but I can't find specifics. Any direction would be useful - thanks! 

Hi all,Has anyone found a smart way of deleting unused / old cubeviews? Manually deteling one by one takes very long time.Thanks in advance.Buket Pedersen

Hi , We are trying to achieve the below format of Date ,Time and Time Zone in Cube View report footer 25/08/2023 5:00:00PM CT/IST/ET  Here, time zone should vary according to user's local timing.Any solutions on this are greatly appreciated.Thanks  

Dear community, I'm using a getdatacell formula to sum few range of rows. The formula is correct and I'm getting the correct/desired output in the data explorer. But, when I try rendering it in the report and excel. It throws an error with "#ERROR'rowname'". I'm not sure what causing this issue. Is it because of the column override I'm using or some settings are driving the issue. It throws error Any solution to this would be appreciated. Please find the attached 2 images of data explorer and report output. The values in the data explorer are displaying. And the in the report it's throwing #ERROR: Rowname. 

Hey all,We are trying to creating a toggle button so that the dashboard will render based on the selection. We have 4 Scenarios and we want to compare those but the scenarios will be selected by the end user at run time and s/he can change the selection as many number s/he wants.I have tried to achieve this via Checkbox but that is not working as expected for multiple users as the literal parameter gets updated every time.I tried radio button as well but it looks like so many option (buttons) on the dashboard. Do anyone have any other suggestions on this? Below are layout images on both tries we done. Radio button (first image) looks best but as mentioned above not working as we want too.   

Hi Community, Our financial auditors are asking for reports on onestream that they can use to sign of on our trial balance imported into onestream. so that would include movement reports etc. is there a standard set of reports that can be downloaded from Marketplace for this. I see there is something called standard application reports. We are on a cloud version

I have a dashboard with a button component in which I have a XFBR String which alternates between two colors for the button's image background when clicked. Similary, I would like to be able to alternate between two images for my button when clicked. Is this possible with a XFBR String at all ? I thought I could return the image's file name with a XFBR String under Image URL Or Full File Name   or can XFBR Strings only be used under Display Format ?

What are all the options to send data from OneStream to another system?  In my use case, we would be pushing People Planning data from OneStream to Workday.  Thanks for any assistance!  

Is there any way to get the cube view profile and Group Name of the CubeView using Business Rules?Thanks.

Hi,We are trying to automate the File-based Import data, Validate data, and Load data to the cube process using the business rule. So, could you please let me know how I can procced as I am new to the business rules in OneStream?Thanks

I have a DM job that imports data using WF.Even though there are intersection validation errors in the WF,Task activity status of the "Validate Intersection" task shows completed. It moves on to importing next period even with errors.Is this expected behavior and is there a setting to show intersection validation failures in Task activity status? 

Hi community, For one of my clients I need to do the following:In cube 1 data is entered on an extended account dimension and extended UD1 dimension. Account dimension         RootAccountDimension                DetailedAccounts (members :10100) linked to cube 2                       GLAccounts (members : 100001, 100002, 100003) linked to cube 1 UD1 Dimensions           RootUD1Dim                   SummaryUD1 (members :None) linked to cube 2                           DetailedUD1 (members :Prop1, Prop2, Prop3, Prop4) linked to cube 1 Account Example is 100001, 100002, 100003 roll up to 10010 which is therefor a parent in cube 1 and is a base account in cube 2. Same for UD1 which has deta

Hello, I am new to OneStream and would like to know if it is possible to attach a file in the Certification step.  If yes, please provide me with the steps.