Reporting

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.

Hi OSAdmin, We have an external database connection setup with OneStream and the external database has both detailed(transactional) and Summary data table/views We have a requirement from Business to get the detailed data dump within OneStream as a report which the users can download for further analysis and restrict the user based on their OneStream Workflow/Entity access  To achieve and restrict the detailed (transactional) data duplication at OneStream end, we have created a data adaptor that fetches the detailed data based on Parameter selected by user from External Database and the data adaptor was used in to dashboard through grid view, pivot grid and BI Viewer components, for low volume retrieval are working as expected, as soon as the volume goes beyond 95K records we get "Stream was too Long" error. Any insights from Admin and OS Community would be helpful   Thanks Vishal Pai    

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

Hello,  Does anyone have experience linking a dashboard chart built with BI Viewer in Powerpoint via alt text? We tried including it as a BI Viewer or Chart component, but the chart does not appear in the Powerpoint.  {XF}{Application}{BI Viewer}{MyComponentName}/{XF}{Application}{Chart}{MyComponentName} PageNumber=1, CropLeft=0, CropTop=0, CropWidth=0, CropHeight=0, Zoom=100, MaintainAspectRatio=True, FillMode=Width, Anchor=TopLeft, IncludeBorders=False   Much appreciate it if anyone could share some tips!    

Originally posted by Graham HogginsI have created a Tabbed Dashboard consisting of a number of BiViewer reports.  Whilst I can export these manually one by one, I would like to be able to run and export all into a single PDF.   When creating a Book, the BIViewer components are selectable under the report Type:Dashboard Report/Component Name however when I try to preview the book, the PDF doesn't render anything and displays a blank page. Is there a different approach I need to take to accomplish this?    

Hi, Does anyone know if it is possible to have a BI viewer chart publish to a book?I have a dashboard where users can select an entity to view charts and can export to a PDF but trying to create a book that loops through entities and publishes a page for each one.When I try to connect to the BI Viewer Component I am just getting blank output. Any thoughts would be appreciated! Thanks! Posted by Ryann Hristovsky Migrated from Champions

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

Hi We have setup Auto Translation Currencies on a USD Entity (AUD, JPY, GBP) Using XF Functions how can I display the Currency label i.e. AUD? XFGetCell returns the the data in AUD how can I display AUD in a cell as XFGetMemberInfo only shows me the currency attribute of the Entity (USD) Thanks Guy

Hi, i have request to pass the Entity filter in rows in cubeview but it should bring members which as text property. for ex: i am using text4 property for few entities and i want to bring only those entities in the cubeview. is there any way please. Please suggest if anyone as came across this requirement. Thanks in Advance

Hi Onestreamer's,                            i am building a report on cube view where i have 2 columns. In the first column there will be all month of the budget year. Now, i have to do custom calculation on second column(YTD). I have created parameter in runtime where the user gives input like 1,2,3,4....... upto 12. if the user gives 3 then the rule should take and sum the first three months value in the first column and it should store the total in the second column.                       if you know the solution for this requirement, then please share the solution here.Here is the image which is marked by red boxes is my requirement and that yellow box is the manual input data. Marked by red boxes Thank you.

I am trying to figure out conditional formatting in a cube view to show base level members as different color. For example, in a cube view- I have a row A#NETINC_INT.Tree,   I would like to display Net Income base members and their data in different color.

Does guided reporting support when the fiscal year differs from the calendar year? I know it did not previously and am wondering if it has been changed.

There is a report that we use in Application reports "Import Detail (Account Mapping)" this report has a dropdown to select the time period. Previously the weeks and months were available for selection e.g. 2024M10  However now only weeks are available for selection and the months are no longer visible, any ideas on where this change could have been effected?  

Hi all,We built Cube Views with suppressed members to improve Cube View performance, as there would be too many rows visible in the Cube View without suppression. We use the "Allow Insert Suppressed Member" to insert suppressed members. In our case, intercompany data should be able to be added here. Our row suppression settings are as sown below: When an entity does not contain any data yet (a newly acquired entity), it is impossible to add a suppressed member, as all rows are suppressed.Is there a way to tackle this, so we are able to still suppress rows, but with the possibility to add suppressed rows, even when there is no data yet?Kind regards,Joris Klein Hulsecpmview

I have a parameter for time that acts as the default for all reports. I'm trying to store in it the year. I want the parameter to take the GlobalYear so that I don't have to change the value manually every year.  Basically, I'm attempting this:  But it's not working

Hi there - Im looking to add a formula to my columns located in the cube view. I need it to pull global time + remaining target months. This involves two scenarios, so S#Actual and S#Target_FY24.    So If my POV global time is July, I need the formula to take (7 months of actuals using S#Actual) + (5 remaining months of target using S#target_FY24). I also need it to be dynamic so I dont have to touch each month, so when the POV gets switched to August, it would be (8 months of actuals + 4 months of target)

Hi all,  We are building cube views which require the expansion of three dimensions in the rows.  We use the "Allow Insert Suppressed Member" function to insert suppressed members in two dimensions. Since the expansion would generate a very long list of combinations, we want to use the function "Allow Sparse Row Suppression" to improve the cube view performance. But when a period doesn't contain any data, the allow sparse row suppression function would suppress all the rows, and we won't be able to insert suppressed members.  In the cube view rows, we have the suppression setting as in below. Can anyone give us some advice on how we can tackle this? Thanks in advance!

In Application tab > Dimensions > Entity Dimensions > Member Properties, I have something configured in Text 4 and Text 5  field in Vary By Scenario Type And Time section. The goal is to display these 2 field values in a dashboard.   Questions are 1. How can I retrieve the data in SQL in data adapter? I input test data in Text 4 and find the value in both RelationshipProperty and MemberProperty tables. Which table and column should I use? What filters are needed to get the expected value? 2. Any data dictionary for OneStream application database? For this type of requirement, use SQL and data adapter to get the value for specific fields in the front end, how can I find the respective table / column / filter. Much Appreciated!      

If these are my parameters: (delimited list and input value) what would my columns be? This is ultimately what the report should look like:  

Hi, I'm wondering if anyone else has had a similar issue when creating DynamicCalc accounts that include a non-financial account member and a financial account member? I'm trying to create a revenue per day account that will use our A#SalesTot account and our A#IscSalDays account.  My formula is below: Return api.Data.GetDataCell("Divide(A#SALESTOT, E#DRIVER:C#Local:S#Plan:A#ISCSALDAYS:F#EndBal:O#Top:I#None:U1#None:U2#Top_UD2)") When I populate a cube view with each of these accounts separately, I get the correct data, but I can't figure out why the calculated account returns blank green cells.  Since I want to use the result in a dashboard chart, I can't use a column row math expression, which is how I calculate revenue per day in our other reports.

HI Can someone help on connecting a Dashboard report into Books, am trying to connect it to Books and then use the parcel service to publish the report to distribution list via email Regards Nara2757

It would be helpful if there was a way to toggle the "Include Cell Attachment Status" setting for Cube View Connections rendered in the Spreadsheet tool.