Reporting

Hi All, Is there a maximum with regard to the datasources used in the BI viewer. I am not able to add more then 3 datasources? I currently use 3 cubeview MD    

  Hi, All -  I’ve developed a dashboard that includes a text box, parameter components, and other elements. Users can input a date and click a trigger button to fetch the data, using inbound parameters in the data adapter. The dashboard is supposed to default to a date value upon loading, but it’s not pulling the expected default from the parameter. Ideally, the dashboard should open without any issues, but instead, it’s throwing the following SQL error: "Conversion failed when converting date and/or time from character string. (SQL Error Number -2146232060, 241)" Currently, the dashboard is not opening and displays the error above. The data adapter field value format for date is as shown below. I’ve tried various options for setting the default value in the dashboard parameter, but the issue persists.  Please let me know if you have any suggestions. thank you !        

Hi,  I am just wondering, is this a limitation of OneStream? Does the column member filter support only two levels? Are we unable to add additional levels beyond this? Thank you to those who will share their inputs.  

The dashboard visibility is set to "Always" and the security access group is set to "everyone". If I select the dashboard in Oneplace to open, it brings me this error. Could this be related to the workflow not being set accordingly (permissions, data, etc)?  

 Hello, has anyone come across this message using Report Viewer? The export function is not an option when selecting the "View Report" icon. 

Hi everyone, Good day. We are new to OneStream, and we are building a cube view wherein it outputs quarterly columns for a certain year. However, it only outputs the last period/month for the quarter. For example, under the Q1 Appliances, it shows 305,221,004. But, if I drill down on quarter 1, I can see that the amount per month when totaled, it is equivalent to 607,036,638. This also applies to the 2024 column, it only shows the Q4 value and not the sum of all quarters. I already tried to consolidate and calculate, but it is still the same.  Thank you for those who will share their inputs.   

We are on OS v7.4 and moving over to OS v8.5. We have both versions up and running as we move over. While running QVs using the Spreadsheet module within the app and setting the Data Style to "Comma [0]" in both, it appears correctly in v7.4 with negative numbers displaying as (100) but in v8.5 it shows as -100. Same thing if we pick "Currency [0]". (see screenshots below) Is there a chance that the default style didn't make it into OS v8? OR, is there a place/menu to modify this default style without creating a Custom style? We noticed this happening in version 8.4 as well, but we upgraded to 8.5 and it is still having this issue. Thanks!Currency [0] 

Hi Our YE reporting pack is based on a book which retrieves a Word document (table of contents etc.) followed by a number of CVs (financials). The page references in the table of contents is static. I would like to Supress Zeros in all the CV, which would place the CVs on different pages, depending on which entity runs the book. Therefore, I would like to explore if there is a way to use dynamic page references, e.g. by putting a reference to which page a certain CV would be placed. For reference, we are currently on v7.3 but upgrading to v8.5 within long. Thanks in advance!

Hello, I am new to building cubes in OS, I am attempting to build a calculated column based on data from two other columns, I have created a nested member which correctly brings in all the data. When I attempt do use GetDataCell I return errors that it cannot find my named Column. In the screenshot you can see the member filters (highlighted are the same rows) Here you can see the output when I run the cube view. Please let me know if I cannot reference in this way and how I may solve the problem

I would like to know more about this workaround. In our company, some users utilize the PDF view option to send their reports, not only within the company but also for SOX controls. Therefore, it is important for us to continue using the PDF view in OneStream 7.4v. Questions: Does this workaround impact only dashboards, or does it also affect Cube View reports? We have only been given the option to remove PDF. Is there a possibility of an upgrade to continue using PDF?   Thank you! Laura 

Hello, I am facing a problem in making dynamic names for BI-viewer. I have a data adapter with Command type as Cube view. I am using this adapter in BI-viewer. I want to make the column names similar in cube view.  For example, in my scenario I have columns changing according to the time.  but here it will show as Col0Value, Col1Value. As per cube view headers, Col0 is 2024M1 and Col1 is 2024M2 and this will change according to time updated for next periods. It will not be same every time. How to get the same names as per cube view into BI-viewer column list.     

Hi all, I am trying to divide 3 different rows in one Getdatacell formula and I am getting an error saying this: Is this even possible?  If not, is there another solution?

Hi,  Is the below comment possible in cube view?  

Good morning, I have an issue with my Balance sheet report. When I look at my Retained earning CY_NI it is not equal to my P&L for q4. Not sure what to do.    

Hello,Is there a way to remove the blank row between the title and subtitle when exporting to excel. Below are the settings I have and the outcome:Thank you!!

Hello, I am using a textbox to input a date, and its action property is linked to a parameter with the type set to "Input Type." When running the dashboard, the user wants today's date to be populated as the default value instead of manually entering a date. Has anyone tried using the Date function with the input parameter type for this purpose? thank you!  

Hi all, I am working on the 445 calendar and 2025 started on a Wednesday so into my Actual Data dashboard I do need to load the last 2 days of 2024. I have those days in the load file but they do not show up in the dashboard.  In the CV I am using this set up: T#2025.base.remove(2025W53).  Looking forward to any tips :)  

Hi there, We need to see cube view figures which are rounded to an integer. Could you please advise how to round figures in cube view?  

Trying to understand a little more about this instance. This message appears when trying to run a period that has no data. Some questions have emerged around:Can we customize this message? (Thinking no, it is standard OOB message describing what is happening).What is happening? Does the data require consolidating in order to be leveraged? Under what circumstances would you receive this message relating to dashboards?  

I have a dashboard with a cubeview in row one and a chart in row two.  I want the chart below to change based on what the user clicks in the cube view.  I was hoping when the user clicks a new cell in the cubeview it would trigger the "Selection Changed Server Task" action but I can not seem to get a rule to run there.   Does anyone know how a BR on a cube view dashboard compoent is triggered?  I was hoping on cell selection but maybe not.  Thanks.

Hello,I have parameter a specific POV on an Excel sheet and want to duplicate it on another Excel sheet.The QuickView Option to duplicate is only available in the same sheet.I tried to copy the file and then move the sheet to the previous file but it doesn't work.Is there a solution? Maybe to copy the POV to make it applied in the new one?(I know I can parameter the default POV to initialise it via the OS app but I need to keep the POV in 'black' to fix it whatever the POV initially parameter)Thank you

Is there a way, or a best practice recommended, to point an XFGetCell formula to one or multiple members of the same dimension without adding parent level members in the dimension hierarchy? As an example, if we have entities 1 through 5, I'd like to be able to change an input cell to any combination of those and have an XFGetCell function to pull in the sum of all the data points referenced. Currently I'm thinking this would require nested If functions, but that seems like it would quickly get to an unmanageable length as the number of members grows.

Hello, I am trying to use the new menu component within dashboards. I tried using method for command type and entering in the assembly file name for the business rule. However, when doing so it returns an error message that it is invalid. I am wondering what the correct syntax is for using an assembly file within a data adapter as well as the correct method type.I currently have it as follows{BusinessRule}{DataSet}or{Workspace.WorkspaceName.AssemblyName.FileName}{DataSet} 

Hi! Wondering if it possible to build a report book that loops through a list of members, but aggregates results for a parent? If this is possible, how would you setup your loop? Can't seem to get it to work! Example: report results show the total for BIP 1226, and output the same results in a separate report for B1226, B1344, B1489 and B1490 (ideally with these base entity names in the header).    

Is there a way to have the time POV reference a cell (A1) in a spreadsheet?  User wants to have multiple Quick Views and change time once in cell A1 and it update all Quick Views in the workbook.