Reporting

Hi,I have a report book with Report item which contains a Dashboard Report. The Dashboard component is a Grid View with a BI Blend Data Adapter.I get the following error when the report book is opened from FileShare.I am using Dashboard Report type in Report Book, and per Design and Reference Guide: The chart and report items are application dashboard chart components, rather than dashboard components.Does it mean I cannot use the Grid View Component in Report Book? I have the BI Blend data in a Dashboard Grid View component, and I need to get this into the book.Please let me know if you are aware of any workaround to achieve this. Thanks in advance.AK

Trying to do a QTD Average during the second month of the quarter.  Using the v#QuarterAvg did not work as it includes all months in the calculation.    

We can create books that contain Excel Export Items but when using parcel service to send them, they are attached as pdf files. We need to send them as excel files. 

Hello, Is there a simple way to apply multiple data sources into one BI Blend Dashboard Graph? For example, a bar graph that compares Actual sales to PY.  I am running a SQL script to return data for my data adapters. I've added them as components to my BI Viewer, and can select one or the other under the "Data Source" drop down. I just can't manage to get both sets of data into one chart. I know this is feasible but think I am missing something. Thanks!

There is different time zone between System - Security Logon time show 3.32pm (UTC+8) and in User Overview Dashboard show 7.32am (UTC). Possible synchronize showing same time zone which follow System - Security Logon time show 3.32pm into dashboard. Please advise how to update in dashboard. The rule is  Select Name, Description, Email,LogonTime --CONVERT(nvarchar, LogonTime, 110) as 'Logon Day' --DATEDIFF(dd,LogonTime,GetUTCDATE()) AS 'Days since last Log on' from secuser    

Hello,  I am wondering if there is a way to save cube view parameters for individual users?  For example if a user has a cubeview they run often and always have to select through several parameters, is there a way to set this up so they options are always saved and they can just updated the date? Or would this be something a book would be created for?   Thank you for your help!

Hi all, I'm trying to create a CV with: - row1 Account.base and UD1.base - column1 Dynamic Annotation that return the Account description  - column2 Entity the output with this structure is:                                  Ent Acc UD1 DescAcc   10   Do you know if there is a way to have the following output Acc DescAcc UD1 ? so put the description near the account code (I use the Annotation since I would like to have the account description in a specific column) without move the UD1 before the Account in row?   Thank You!

Hello Community, I have an issue, hopefully someone has a solution. I started with this article: https://blackdiamondadvisory.com/library/breaking-up-is-easy/ to try to get a grid/chart that some users want. My problem is I’m trying to get it set up for so for the current year it shows two rows, one for Actual and one for Forecast, but only shows data for actual up to a selected period and only shows forecast for the periods after the selected cut off.  I’m trying to do that by selecting the U8# of “data” or “None”   Here’s what my rows look like:     Here’s my column as it pertains to these two rows (using overrides for the prior year rows, which work fine) Here’s the function which I think is working,   The issue is trying to pass the scenario in my XFBR.  Everything I tried is passing “Actual”.  I tried CVScenario, PovScenario, MFScenario (this one failed).  How do pass the specific cell or row’s scenario for consideration in a column Cube

Is there a way to achieve a 90 degree vertical orientation for text within a report header?  See example screenshot where the right most 8 column headers are vertically oriented. Looking to achieve this within OneStream reports. Haven't found anything within the standard formatting available.  Thanks

I'm using the action setting on the buttons parameter to pass a value, but nothing is happening. This button is used as a link to open a dashboard, that parameter is the id of the dashboard.

Hello, I am trying to add scroll bars to a dialog box that has 6 components.   Tried changing the layout to Horizonal and vertical stack with other settings.  This did not work and also asked the one stream experts . my team and appears there is no sure way of accomplishing this.  Is this possible in OneStream ?     Thank you, Sharon

Hi, we recently migrate to OS 8.2.2 and we are facing a strange issue with the cube view connection in Excel. When we refresh them excel takes a lot of tie to show them and it looks like it's building them slowly on the screen. Example:  Frist came the color of the column headers; Second the color of the row headers; -Third the text somewhere; and so on.  It's like that excel is building lively the cube view and calculating each cell including setting the style of each cell.  Any one with the same issue? We tried to open the same connection in the spreadsheet inside of OneStream and the performance was great.  Kind regards

Hi, I need to extract the Task Activity from 01/01/2024 until today for audit purposes. Do you know if there is a report or the best way to extract this data instead of extracting it page by page under the below Task Activity option? Thanks in advance!    

Hi all, Has anyone else experienced the following issue with "Save Offline Copy" feature in excel? If the user has "retain all formatting" set to TRUE in preferences, the file takes an unreasonably long time to save.  During my testing of the file (only 684 bytes in size), I waited over 10 minutes for save to complete and it never did so I had to kill Excel and relaunch every time. If that retain formatting option is set to FALSE, the file saves immediately. Interestingly it also saves with all the formatting as well - except for any 'superscript' font settings. Same behavior seen whether using Excel 32 or 64 bit.   Same behavior seen whether saving to local folder or onedrive folder This makes no sense.  Really all the save offline process should be doing is replacing all cells containing XF() functions, with the resulting values. Right?  And If I set retain formatting to FALSE, shouldn't it save without any formatting at all?  This setting doesn't seem t

Hey there,We have created a BI Viewer and we want to extract the BI viewer to excel but through a button in a different dashboard. Is there way to get the data in the Bi Viewer through a Business Rule, create an excel workbook and save it to File Explorer>Application Database>users>(userName) ?I know how to create a workbook from a dataTable or a dataset in the BR and save it, but I am having a hard time getting data from the Bi Viewer to the business rule.Thanks

Hi, Is there a way through cube views member formulas or any other means to combine two scenarios? For example when reporting Actuals vs. Plan we now have a Plan_1.0 and Plan_2.0.  Rather than creating a new scenario to combine the two - is there a way to report on Actuals vs. (Plan_1.0+Plan_2.0)?  Thank you!

Hi! I have this cubeview with the filter member below When I export to Excel, I would like have the columns header filled with the dimension name "Entity" and "Consolidation" Someone can help me?  

Hi Team, I  am building a cube view  with 8 columns and need to set up the color formatting to it which is yellow color for total values in first 4 rows/columns and red for negative numbers , green for positive numbers in the next 4 rows/columns , can anyone suggest.   Thanks in advance.

Is it possible to create a report that shows all of the Business Rules within an application and where in that application each business rule is being used? 

How to enabling tree expansions (+) in columns? This functionality works on rows when using the member filter (.tree), but it does not work on columns.   Any solution? Please.

Hi All, We have variance calculated column working fine for account members for all account types except for Dynamic account type members when we use the below formula. Do we need to do something different for Dynamic calc members to calculate variance correctly? Return api.Data.GetDataCell("BWDiff(U8#None, U8#None:T#PovPrior1)") Thank you

Dear community,   Is there a way to name (:Name("test")) a column when the columns in a CubeView is set by a parameter (Application dashboard) which is referencing to a business rule?   I want the last member to be renamed from description "2024 Q2" to a name I choose "2024Q2 YTD"   Public Function GetFCTCVColumnSet(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As String Try Dim CurrentScen As String = args.NameValuePairs.XFGetValue("SelectedScenario").ToString.Replace("'","") Dim CheckFct As String = CurrentScen.Substring(0,8) Dim CheckFctSubstring As String = CurrentScen.Substring(0,12) Dim TimePeriods As String = ""   Dim CurrentScenYear As String = CurrentScen.Substring(CurrentScen.Length - 4) Dim CurrentScenNextYear = CurrentScenYear + 1 Dim CurrentScenNextNextYear = CurrentScenNextYear + 1   TimePeriods = "T#" & CurrentScenYear & "Q2:V#Periodic:U3#Top:U4#Top:U5#Top,T#"

Hi Team,   I am building a cube view with account in rows. In columns i need entity and UD2 dimension members but the columns  names should change as entity members and UD2 members based on choosing the parameters. I have tried  Primary dimension type as entity  and nested member expansion primary dimension type as UD2 but i am unable to achieve my requirement, can anyone please suggest .   Let me know if any questions.   Thanks in Advance.

Using this function: 'Get Workflow YearDim myWorkflowUnitPk As WorkflowUnitPk = BRApi.Workflow.General.GetWorkflowUnitPk(si)Dim wfYear As Integer = BRApi.Finance.Time.GetYearFromId(si, myWorkflowUnitPk.TimeKey)Dim dt As New DataTabledt.Columns.Add("Display")dt.Columns.Add("Value")dt.Rows.Add("Jan", "1/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("Feb", "2/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("Mar", "3/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("Apr", "4/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("May", "5/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("Jun", "6/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("Jul", "7/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("Aug", "8/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("Sep", "9/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("Oct", "10/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("Nov", "11/1/" & wfYear & " 12:00:00 AM")dt.Rows.Add("Dec", "12/1/" & wfYear & " 12:00:00

Hi Team, I have a cubeview in which i am passing Entity parameter in Rows based upon Workflow selection, and it brings me all entities which as value in Text4 property, but i need to have one base member value to be picked up in column. ex: if i select Top entity in rows, then my cubeview will bring all entities which as Text4 property and that same time i want to bring values for only one base member in one of the column (which as different POV), for respective Text4 entity members. can anyone help on this kind of requirement please.   Thanks Satish P