Reporting

Is there a formula (for use in Excel/Spreadsheet) to retrieve the Global Time setting from Application Properties?

Happy Monday Y'all, How do I call a cube view extender BR in a cube view. I'm using it to increase the report sub-header font. I'm using a code that was described in OneStream XF manual.  \ Here is the code: Select Case args.FunctionType Case Is = CVExtenderFunctionType.FormatReportUIItem Dim uiItem As CVExtenderReportUIItem = args.Report.CurrentUIItem If uiItem.UIItemType = XFReportUIItemType.PageHeaderLabelCenter1 Then uiItem.FontSize = 14 uiItem.Bold = True End If End Select Thank you, Mustafa A

Hi All, Is there a way to visually see in a Cube View that a cell has a document attached to it? The purpose is to attached supporting documents to some Cube Views. Thanks  

Hi All,I'm creating this report which uses a custom formula, that takes SUM/AVG of past six months, and calculates the Pct value. I tried using Rolling6MonthTotal and Rolling6MonthAvg  view dimension in Denominator/Numerator, but it doesn't work as it should. Any ideas on how I can make SUM/AVG the prior 6 month, and run this calculation (highlighted). Thank you for your help.Best, Mustafa A  

SOURCE: OneStream Champions I have a cubeview in onestream. If I launch one of them via the api it runs in 45 seconds. If I start two of them at the same time, they both finish in about 1:20 (a little over a minute, which is almost double the 45 seconds).     https://discourse-static.influitive.net/uploads/db_8467a788_7b9e_45b8_8b6c_d37e1967220d/original/1X/fdaa8e3ec877c251814ffe035f4895e65ba2dbc7.png image.png2140×180 24.7 KB   What is the reason for the extra amount of time that is spent per report when two are running concurrently? IE. what internal resource is being protected against concurrency? From a technical standpoint, it seems very unexpected that two readers would block each other in this way. You can see in the screenshot that there is plenty of CPU available. I’m assuming this topic isn’t specific to our environment or to this cubeview. Nothing we are doing seems exceptional or unusual in any way.

Hello & Happy Friday.How do I over-ride a cube view cell amount? For example: IF an account (for e.g. Fleet Revenue %) is less than a certain number (for e.g. 45%), then run a custom calculation in all those cell. Else, show the original number. The excel-sheet uses an IF statement as shown below. I'm thinking that I have to write a BR (with nested IF) to run this. Will be great if there is a existing BR or method somewhere else, that I can reference. Any ideas/suggestions will be appreciated. Thank you!   

On a couple occasions the users of the OneStream Add-in have unintentionally reported partial results from a onestream cube.  This has happened when data extends beyond the allowable page size ("Maximum Number of Rows").   It can sometimes come up by surprise.  For example, a user may pull in all the YTD activity from a cube and it will fit within the page size for much of the year but towards the end of the year some of the data will go missing.  If the Onestream data is retrieved on one of several sheets, and the data is used indirectly for calculations that are displayed elsewhere in the workbook, then the problem can be easy to miss.    In fact, this type of a problem can even be overlooked when you are staring right at the add-in itself, since the only indication of a problem is way down at the bottom of the results.  That is where you can see the "Page 1" annotation (see image below)     This brings me to my question.  Is there a

I'm having trouble figuring out how to organize the layout of my cubeview.    I'd like a tabular layout where dimension levels will occupy their own columns.  Below is an example where I am retrieving data from my cube by week.  But I want to display the parent month and quarter in their own columns, next to the weeks.       I am able to build the layout shown in the first image above.  This is accomplished using TreeDescendants for the year.   But I can't find a way to organize my quickview in a tabular layout (see the second image). Any help would be much appreciated!  Sorry for the basic question.  (I haven't yet found a good source of training material for Excel quickviews.)  

Hi All, Happy Friday, I am building a form and in my cube view I am giving option of selecting Entity, Based on entity I need to show two Dimensions  in the detail, we don't have any connection between these dimension. I can not update the Text field of entity because there are many to many relationship, One entity can have multiple project and ICP, so based on selected entity I need to show all related projects and ICPs so user can adjust the data. Selection - Entity Projects   -     ICP    $$$$

Hi, We are storing project plan data in a custom table in OneStream and loaded the data into a cube. We are having a requirement that a single project may last 2 to 3 years and if the user wants to see the project plan of a particular project from the start date till the current year, how to get it in a cubeview.   Thanks & Regards, Madesh K

Is there a best practice to get the report headers to be a consistent size regardless of the Rows and Columns in the report?  We have the Standard Reports under Application Properties setup to drive consistency, however it appears the columns/rows formatting of a particular report is driving the size of the report header. In the example image, we have identical report headers with different column sets.  The top report has more columns which is resulting in a smaller report header.  It seems that should not be impacted by anything within the actual body of the report. Second report formatting question: Is this functionality available?  The answer says it was expected back in 2020, but I can't seem to find where this feature would be.   Question: Are there any updates on merge and cent... - OneStream Community (onestreamsoftware.com)   Thank you, Aric Gresko OneStream Administrator | EverCommerce 

I have created a cube view that I am having issues with some of the rows not totaling correctly. The cube view is designed to display an income statement. Some background on the cube view. It has 2 columns. 1 column has the member filter set as "T#|!ML_Year!|.TreeDescendantsR:U8#DerivedData:Name(|MFTimeDesc|)" so that each month and quarter can be displayed for the year chosen. The 2nd column displays the YTD amount for the year chosen and is written as "T#|!ML_Year!|:U8#None."   The issue I am having is that I have 1-3 rows that are not adding correctly for each quarter. As an example, Month 1 has $500, Month 2 has $500, Month 3 has $500.00 and the total for Q1 is being displayed as $1,000 instead of $1,500. I am only experiencing this issue when I use a different scenario other than actual. I have run a consolidation on each scenario and still experiencing this issue. Does anyone have any suggestions?

Hello - I have a SQL data adapter that connects to an external database for data loads, dashboards, etc. Is it possible in the query to join these external tables to tables in the Application database? The server name in the error is the OneStream database server.   Thanks,Bil

Has anyone experienced an extensible finance message stating "stream was too long" while using a quickview? I received the message after using UD4 as a column dimension and selecting more than 1 member. I set the maximum rows and columns to 50,000

We are trying to format the point label text in a chart for the dashboard. We are able to format the value with the syntax  "{V:0,0}". We also want it to have the font color black. We have tried several options, but whatever we punt in format or back of the syntax it will print that text. In Excel you can format numbers like [Red]#,##0 and it will display the value in Red. In the OS chart the result will be [Red] 10 for example.  Does Anyone know the syntax to use to be able to control the font color of the labels in a chart?

Hi, I changed all font family and font size settings to Arial and 10 in OS under Application Properties/Standard Reports. It looks like all cells that were “written” by OneStream came through as Arial 10, but the cells that were not edited are still Calibri 11. I even tried to change my Excel settings to Arial 10 to see if that would work after exporting and had no luck. Any idea? Thanks, Hadi 

Originally posted by Ashok AmreshWe are looking for a way to refresh excel workbook with the add-in in automated fashion.  did anyone do it with okta sso authentication? basically looking for VBA version of below power-shell code. has anyone ever done it? Appreciate any help.   $ssoToken = $xfApi.Authentication.ProcessSSOAuthenticationAndCreateToken("<server address>", "Username", "Password", [OneStream.Shared.Wcf.XFClientAuthenticationType]::ClearTextPW) $xfLogonInfo = $xfApi.Authentication.LogonAndOpenApplication("<server address>", "username", "$ssoToken", "appname", [OneStream.Shared.Wcf.XFClientAuthenticationType]::ClearTextPW)

Hello All, I have two elements, let' say for example "KPI before 2020" and "KPI after 2020". I would like to create a cube view that's shows>>> only "KPI before 2020" when my POV time is <=2019M12>>> only "KPI after 2020" when my POV time is >=2020M01 Currently my cube view result looks like: My desired outcome: Any ideas how to create such cube view? Best regardsJarek  

Is there a way to display the report header for a cube view in the Excel Add-in? I have the Report Header section of the cube view designer filled out in the application, but when adding a cube view connection in Excel, it does not display.

I'm curious to know what others have seen during an external audit.  We've been asked to provide change request or service request ticket evidence for any change made to our OneStream production app.  This includes metadata, transformation rules, cube views, etc. We're being asked to provide ticket information in addition to screenshot evidence of what was done for any change of any object.  Has anyone else seen the same?       

I have a Stage Attribute of text type attached to my source records.  As expected, this drops off when I push data from Stage to the Cube.   When I run a query in the Excel Add-In and do a drill-down back to source at the base level intersections, I can see all dimensional values except the Stage Attribute #1. Is there any way to enable this?   Thanks

When I look in GolfStream demo app, we retrieve a OS dashboard on a ppt doc using a dedicated chart component. Is it the only way we can use in order to call an OS DB from a XF doc?

Hi,How do I attach another CV (i.e base scenarios) under a flux analysis report?  This is how my flux report looks: I understand their a row/column sharing feature, will that work? If yes, can someone please share how to set it up? Thanks!  

Can we add these expansion to a parameter, and have the user select on their own?  I was able to build a entity selection parameter, however when I run it, it pulls in everything (branches, regions, district) because I have used "Tree Descendent" expansion. But it would be preferred if I could add a expansion parameter (Children, Base, Tree Des, Member etc) and have it prompt the user to select. This is how my dialog prompt looks. Looking to add that parameter in their.   Let me know if this can be done? any example will be appreciated. Thanks 

My dept wants the ability to search data across region, district, and branches. I was wondering what would be the best way to build that functionality. Currently, I have build a Select Region Parameter, which has a BR rule running these cases (member filters). And it only shows region level data.    This is how our report looks like. (Data is omitted)    However, I'm looking add an option to select districts and branches, Maybe the QV can have a button to add additional rows, by clicking "+" and selecting those specific branches from a dialog box. Or maybe a dialog box, which prompts the user to build their own entity member filter. Hope that gives an idea of where I'm heading. Any suggestions or ideas will be appreciated. Thank you!