Reporting

Hi everyone, Thanks in advance. I am building a CV report where the Scenario filter is a Delimited List Parameter, the value chosen there going to be the Scenario Filter Member for an speceific Account defined as Dynamic Calc. The issue appears when I try to ask for the POV Scenario name because I need that Parameter chosen value instead of the Actual Scenario. This is my formula: And the result of that is from Actuals.   Thanks a lot if anyone has a differente way to do solve this. Just keep in mind that I need the Chosen Value in that specific Parameter

Hello! Looking for guidance on how to formatting issues in Guided Reporting.  - How to fix rounding issues - How to fix spacing between Parent and Children - Is there a way to freeze the headers in guided reporting so the user can scroll down during review?  - When exporting to Excel, the time stamp in the bottom left corner reflects the universal time zone.  Is there a way to get the local time and zone (CT) for the user performing the export?   Thank you in advance for the help!! Gabby       

Is there a table that stores the history of data intersections (imports, calculations, journals, form entry) beyond the DataEntryAudit tables?

Is there a way to pull into XFGets a time stamp of the most recent GL import by entity? We have multiple GL imports and would like to add the import time stamp to Excel based reporting Example: Entity1  3/2/2023 9:05AM Entity2 3/1/2023 1:15PM Entity3 3/1/2023 10:00PM

Hello, Is there a way to determine where the freeze panes will be placed in a cubeview upon the export to excel?  It looks to default wherever the headers end, but I have a view where I'm calling a naming convention using UD8 (data grid).  Also, I noticed no panes are frozen when a same cubeview is called in a report book using the excel export item.  Is there a way to customize these settings anywhere? Thanks, Sean

Hi, I am new to Onestream, and have finally gotten used to the cube views.   My question is if there is somewhere that I can be pointed to for any sample dashboards or tutorial on how to create dashboards.   I have used the guided reporting, which is good for cube views, but cannot figure out the dasboarding.

Hi, We are having a requirement to pull the cubeview in excel. While pulling the cubeview the coulmns are not autofit. Is there a way or workaround for doing the autofit while opening cubeview in excel?     Regards, Madesh K

Hello Team, I have a user who, when opening certain specific reports, gets the following error:   but with another user that has the same permissions this error does not appear.To do a test, I created another native user, added exactly the same permissions as my user, and the error does not appear, it only appears to her (the problem user):: ---------------------------------------- Exception Type: XFException Thread Id: 175 Source code: DataWcf.cs, line 137, method GetDataCellsUsingMultipleThreadsWithTimeout   Stack Trace:    at OneStream.Shared.Wcf.DataWcf.GetDataCellsUsingMultipleThreadsWithTimeout(SessionInfo si, ExternalWcfClient externalWcfClient, WorkflowUnitClusterPk wfClusterPk, DataCellPk povDataCellPk, List`1 dataCellPkAndCalcScripts, CubeViewGrid cubeViewGridOrNull, String cubeViewName, Dictionary`2 customSubstVars, DataCellDisplayOptions options, Int32 numSecondsBeforeLoggingGetDataCells) in C:\agent\_work\298\s\Source\Shared\Wcf\OneStreamWcfService\Imp

I have a report book that loops through over 200 members and creates a new cube view for each member. The cube view is relatively short and I could definitely fit 2 on one page. Does anyone know of a way to get multiple cube views to fit on one page of a report book?

Can anyone offer any help when using View = Quarter Average on for example January 2023 data when the quarter being referenced is not yet complete?  It seems that the View will not work until the quarter is fully populated.

Hi,I need the excel add-in. Can you please help me with the same.Thanks  

It is possible to create a multi-grid report where two grids are displayed in one page. Question Credit: Andrea Tout Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi Community, I am trying to refresh on a quick view sent from another user.  The file will not refresh though it looks like it is connected to the quick views.  I am sure I am missing a setting or something but can't seem to figure it out.  Any suggestions would be great. Thank You

Hello All, Looking for a way to supress rows where there is 0s  (drilldown has some +/- which nets to zeor for the row in CV). I have supression on and it works for the rows where there is no data and 0 as expcted. now in my below screnshot you can see whole rows seems like it is 0s or No data. there are few columns where it will be net 0 but has data on detial level. is there a way to supress these rows somehow? Looking for a an example or some pointers to explore the solution.      

SOURCE: CHAMPIONS Does anyone know if we can call the Refresh Workbook function using VBA? I’m looking to introduce a button on worksheets that performs the Refresh Workbook option that’s located on the OneStream XF ribbon.  

Hello, I have a Book in OneStream that generates the following: The book generates the following excel with data in each tab (without the index tab), I add the index tab manually with the Hyperlink code   In the Index tab, I have manually created a code to put some hyperlinks from the Excel frame.     I would like to know if it is possible when generating the Book from OneStream I can create a code so that the Hyperlinks are made at the same time that OneStream generates the Excel from the Book and not manually create a macro from Excel after generating the books.   Thank you a lot team

Hi all, We have a requirement to run IC Matching report including journal that may have been posted as parent adjustment. In this way we are also excluding form IC MAtching deconsolidated entities and considering the amount based on the consolidation % as well as not considering equity method entities.  This should mean running IC MAtching report specifying Parent/Entity relationship in C#Elimination.O#Elimination, compared to the default setting which poitn to C#Local or any other currency. is there a way to run an ICMAtching report or having a data adpater which pulls data, from a consolidation different than local?

Hello,   I'm trying to format No Data cells as dashes on some cube views. Currently, the number format for the cube view is as follows: [#,##0;(#,##0);-]. This is formats zeros as dashes, but not No Data cells. Is anyone aware of a special formatting to change No Data cells?

Is there something that can be used as a wildcard in OS? I have multiple accounts like 524000, 564000, 544000, etc. can I just plug something into the X for a wild card get all those accounts? "5X4034"

Hello, We have a use case that makes extensive use of dashboards. The BI viewer component seems like an attractive solution for this. However, we have been struggling to fully adapt it to our needs. One problem is the (seemingly) fixed font size for table content and axes. A particularly surprising effect is that there is no change in font size when maximizing a specific component. This could be a very smart feature, e.g. during a beamer presentation. Unfortunately it only increases the white spaces, while the fonts are identical. This seems almost like a bug - or am I missing something? (screenshots are original scale!) Thanks, Frank.  

I am trying to pull the value of a parameter, =XFGetDashboardParameterValue("SourceScenario","Test") but it just shows the default value I put in.  I've tried every variation for the parameter name I can think of but only get the default value.  Anyone have this working? 

Are there any issues with using the OS Database "Member" table to generate a view? The solution requires a dynamic list of account members for a SQL View query and the member table seems like the perfect source table. Just to clarify, nothing is being written to this table. 

BI Designer shows description labels correctly for each one of the 3 cards, Total Actual, Total Budget and Actual vs Budget, this is the view   Actual dashboard omits the Label of the cards, All 3 cards have no description,  they show blank, I do not know what am I might be missing.     

I have a parameter called IntigrityScaling with parameter type "Delimited List" as belowMy cube view uses this delimited list twice.1. As USD in |!!IntigrityScaling!!|   -> it is used to display the description of the value2. Under formatting -> I am using Scale = |!IntigrityScaling!|Cube view runs fine and prompt me to enter value for Scaling and and display both 1 and 2.The issue is when i pass this parameter in a book , it doesnt take the value and prompts me to enter the delimited list parameter. How do i pass a value to the delimited parameter without prompting me to enter ?I dont want this prompt to pop up after i run the book.NOTE= Liter paramter works fine when passing from books 

Hello - we'd like the ability for a Combobox to run an XFBR to generate the default visible value every time the dashboard is opened/refreshed.  We want to provide the user with a 'suggested' value that can differ depending on Workflow, Scenario, Time, etc., and then let them select an alternate choice if applicable. Does anyone know if this functionality on Comboboxes/Dashboards is possible within OneStream Dashboarding today?