OneStream Platform Forums

HiIs it possible to treat a dash/hyphen as a zero during a data import from a file?Thanks,Mark

Is there a way to make a column smaller then 1? I have a blank column to separate days out as like a border for data explorer but this seems to be to wide. I know another option is to highlight the last column in that section but we have hidden cells that may appear and I was trying to avoid writing a code for what should be simple formatting issue  

Is it possible to suppress/hide rows based on the cell amount? I have tried to use the isrowvisible on the cell format on the row but it doesn't seem to work. It looks like you can only hide rows/columns based on header format?

Hi Community, Do we have a method for adding Finance Business Rule for Cube view Report.Any solution to this would be very helpful and appreciated.Thank you.

In a DM Sequence with multiple DM steps (Data Import or consolidations) does the memory that each DM step consume will be released at the completion of each DM step OR it will be on hold till the completion of the DM sequence it is part of? 

Hi,I have a user requirement to drill back to NetSuite Web URL from OS Cubeviews.In the NetSuite Web Page there are selection drop downs to select the Account, Customs and Time Periods. Based on the selection, detailed data will be retrieved from NetSuite and displayed in the NetSuite Webpage.They would like to auto populate the NetSuite drop downs (Account, Customs and time) from the OS Stage data (Drill down data) and display the detailed data from NetSuite in the Webpage.I understand we can drill back to the Web URL, however is it possible to auto populate the NetSuite drop downs from OS Drill Back option? 

Hello everyone,I have 2 scenarios in my application: Stat and Management. There is this one entity is not getting consolidated in the stat whereas it's getting consolidated in the management structure like any other entity.I realized the system eliminates receivables against this entity in the stat hierarchy even though the entity itself is not getting consolidated.1. Is it possible to make the entity behave differently in 2 scenarios using the ownership types? Design and ref doc basically does not say anything about the behavior of the methods.2. I don't want to map the amounts to IC None for Stat because the data is common between two scenarios.Any help is appreciated

I have a Dashboard with 2 Cube views that have the same columns and when they are on set to a grid on  a dashboard, you have to scroll on them separately to go see data on the right. When I put them in a vertical stack panel, they have one scroll bar but when you scroll to right you lose the row names. When trying to put them in one Cube View, if you scroll down you lose the top part which is basically the totals summary. Is there any way to freeze pane data explorer in  a cube view or freeze pane on a vertical stack panel so when you scroll right the row names stay on the page?

We want to make some forecast periods read only ( Data seeded periods from Actuals) in a Data submission cube view by referencing the period count submitted in another Cube View. Basically, this is to deal forecast data submission.Trying to achieve this by Dashboard XFBR string and that string is referenced into the Form template -> CubeView to make certain periods as readonly, so that they cannot submit the forecast data for those periods.Below is the script that we are using the get the Period count submitted in a specific POV( to start with, hard coded all the POV members)----------------------------------------------------Dim strActMonths As String = api.data.GetDataCell("E#FC_Seed_Entry:P#:C#Local:S#FC11:T#2023M12:V#Periodic:A#FC_Seeding:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#Text3:U6#None:U7#None:U8#None").CellAmountDim iActMonths As Decimal = 0iActMonths = strActMonths.XFConvertToInt----------------------------------------------------We have called this into

Anyone have something they use? Seems like OS has never provided a nice little reference like this. Thanks in advance for anything anyone wants to share.

How to sort members from smallest to largest and vice versa based on amount using business rules??

can cube view display with dash (-) instead of empty for No data cells in Excel

I have a grid view with a list of items on my home page and I would like the user to be able to select an item. This will then open a new page. Everything on that new page will be related to that selection made (tables, labels, etc.). I could then go back to my home page, leave the first selected page open, and then open another page for a different item.Any suggestions on how to get this to work?Tried solutions:- Fix the session state of the newly open page with the parameter value --> Once you do a full refresh of the page then the parameter will update to the latest selection made- Supplied parameters --> This is a good solution for a dialog screen, but when you open the dashboard as a new page the connection seems to drop here and it actually pops-up a dialog box again to make a selection on the new page. 

We recently upgraded to version 7.3.3 and did a push for the Excel Addin upgrade.  Does anyone know if there is a report to show which users have installed the upgrade (outside of our IT Department).  

Hello,I was curious if anyone knows a way to get their Quick View in Excel to breakout the hierarchies on the row dimension so that it would separate the parent and children by column and not just have it indented?Instead of this:I want this: Thank you.  

hi,I have created the custom table and loaded the records into it using the Finance BR. Finance BR is called by the DM step and now i have to read the custom table records and render  into the import step of the workflow on clicking the load and transform button . Any steps on this is appreciated. Thanks  

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 

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

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,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  

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?