OneStream Platform Forums

Hi,The request is that when showing base level members, every other row should have a dashed underline. However, there are two issues why we can't achieve this via the formatting editor:1. The bottom line won't render when it has the condition (is rowNumberEven).2. Don't have the option to select a dashed under line (how you can for the excel formatting settings) Can we achieve this through Cube View Extender Rules?? Thank You.

Hi everyone,I have created a waterfall as below using the advanced chart component. Is there a way to change the font size/color for the data labels within the waterfall bars? I cannot seem to find this option. The request is to make the text more readible.Any help is highly appreciated!BR,Floris 

Hi All,  I have a combo box that is in the main dashboard called cb_OnMaindash. The combo box has a parameter linked to it (i.e., a bound parameter) this is delimited list parameter called dl_ComboBox_param. The display items (dash1, dash2, dash3, dash4) and value item (Dashboard_1, Dashboard_2, Dashboard_3, Dashboard_4).  These value items are actual dashboard that I am trying to pull when ever a user selects a specific item from the combo box. Parametername: dl_ComboBox_paramparameter type: delimited listdisplay items: dash1, dash2, dash3, dash4value items: Dashboard_1, Dashboard_2, Dashboard_3, Dashboard_4Combo BoxName: cb_OnMaindash   The issue is when i am testing this and select dash1 the dashboard is loaded but the item displayed on the combo box is wrong for example it would display Dash3 instead of Dash1. same thing if I were to select Dash2 and it will either display Dash1 or Dash3. it will only update the selected item if I click

Is there any way to stipulate the Cube whilst building a Quick View without selecting that Cube on the user's default POV? I've tried typing Cb#CubeName in the cell in Excel but when I create the Quick View it ignores this and uses the default POV Cube. In the example I have tried to create QuickView for RETLWRK cube but POV default of MAINREP has been used to I need to change the Quick View cube in the Context Pane after creating the Quick View.  

Hello Everyone ,We have requirement to keep  the indentation level to specific number using cube view extender rule for Pdf report.It looks like : CV Extender rule  that checks, if Col Header Name StartsWith 'ABC' or 'XYZ' then,Set Row Indent to 'Some number 'Any Answers for the above issue would be of great help .Thank you

how can you add calculations into a quickview.  how can you add the input fields also? I seen both at splash so i know its possible 

Hi All,  I have a combo box that is in the main dashboard called cb_OnMaindash. The combo box has a parameter linked to it (i.e., a bound parameter) this is delimited list parameter called dl_ComboBox_param. The display items (dash1, dash2, dash3, dash4) and value item (Dashboard_1, Dashboard_2, Dashboard_3, Dashboard_4).  These value items are actual dashboard that I am trying to pull when ever a user selects a specific item from the combo box. Parametername: dl_ComboBox_paramparameter type: delimited listdisplay items: dash1, dash2, dash3, dash4value items: Dashboard_1, Dashboard_2, Dashboard_3, Dashboard_4Combo BoxName: cb_OnMaindash  The issue is when i am testing this and select dash1 the dashboard is loaded but the item displayed on the combo box is wrong for example it would display Dash3 instead of Dash1. same thing if I were to select Dash2 and it will either display Dash1 or Dash3. it will only update the selected item if I click the se

Can a Connection String for an external database server connection be modified directly in the OneStream UI to an existing OS Cloud implementation  -- without creating a Support Request to have it changed?  Likewise, can a new External Database Server connection string be created through the OneStream UI in an existing OS Cloud implementation?  Or does that also require a ticket?  I seem to remember that this ability to edit Cloud settings was added recently -- through a Solution? Or am I thinking of SIC?

Hi dear contributors / members,I am trying to format the Cube View cells to final value divided by 1000.I have setup Scale = 3 for all rows and all columns, however the divided value appears only for the first column.Any suggestions please?    Thanks in advance.Kind regards,Irina

I was curious to find out if there is a way to have Grammarly work with OneStream XF in order to get real time spellcheck and grammar check for narratives and annotations.

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