Reporting

Hello, I used to work on v7.4. When we worked on cube views, changes were saved in Cube Views. It worked perfectly. Recently I began to work on v8.0.0, I noticed that when changing a Cube View, OS opens a second window for the same Cube View under CV Groups of Workspaces. If we make changes in one of the windows without refreshing, and then we modify in the other window, it doesn't take previous changes into account. It's just like the issue when two persons work in the same business rule. Do you have a solution for this issue apart from updating OS version ? Many thanks in advance.

We have a client with a custom font that they would like to apply to reports that are exported to PDF. Has anyone come across this as an option? Thank you

Hi all, does this 2021 OS community post by OneStream still hold true? I would like the cells from the FTE row to be formatted in a certain way (for example set the background to red) when the FTE check cell amount is not zero. Is there a way other than the XFBR they suggest (which looks like an overkill for what I need to do)?Thank you

Hey everyone! Wanted to reach out and see if there was a simple way to include banded rows (every other row highlighted a different shade) into CV formatting within the application. Thanks for the help!

Hello, I was wondering if it is at all possible to add a type-ahead functionality in the SQL Table Editor. I have tried to assign a Bound-list (via SQL query) parameter to the column but nothing is returned.  Reason to use this is that I have a large list of values to look up from, so fitting those in a delimited list instead would really hinder the performance of my dashboard as it would take very long to open. Thanks, Miguel

Hi,  I am trying to create a column in cube view, and that column must average based on columns (out of the 4) that have data and ignore the column with 0 or no data. Denominator will be based on number of columns with data e.g. if columns 1 and 2 have data, then 2/4 will be the denominator. Numerator will be data that exist in those 2 columns.  Any idea how I can achieve this as Onestream doesn't support such requirement on prebuilt settings.   

Is there a way to have a nested parameter with different dimensions? Example: If I select Year = 2020, the next prompt will ask me to select a Scenario The example I saw in the Design & Reference Guide used the same dimension, so I'm not sure if this is possible. 

I am trying to get prior year actuals in the same column as current year actuals.  The code i am using in the CV is above.  This result pulling back in YTD prior year but I want monthly value for prior year.  

Hi, We are facing a strange issue with Excel QuickViews.  When a non-admin user tries simple quick view, user is getting below message. But when admin tries, he is getting all of the data in single page. We have tried changing all the settings on Max rows, Max seconds, almost 100s of combinations (from 1000 to Billion) but no luck.  Any thoughts on why this is happening? We are using slice security for users. Page 1. Use row paging buttons in Task Pane.

I have a number of column definitions that will use the same Row Range in the Row Overrides.  I would like to use a parameter or XFBR for this, but neither seem to work for this specific field in the Row Overrides. i.e. I can only specify row names. Below is an example of what I am trying to do. Has anyone accomplished this?  

We are trying to create an advanced chart using a secondary y axis and are running into issues.  We referenced https://community.onestreamsoftware.com/t5/Implementation-Q-A-Archive/Question-In-Advanced-Chart-component-of-a-Dashboard-can-you-show/ta-p/1551 blog which explains how to code the business rule.  However, there is no place within the chart to reference the cubeview and when we run the dashboard, we get an error message stating the data adapter type does not match the chart type.  Any solutions or if there's any document we can refer to which would show end to end flow around the cubeview, data adapter, business rule, and chart?  Below are screenshots of our data adapter, chart, and dashboard error.  

Hello, I am using a cube view that has the same rows, but it needs different columns based on the UD8 member. I built multiple template columns cube views, and created a parameter for UD8 members. I want to retrieve the column template CV based on the selection of UD8. I created the following XFBR: I then attached it to the main Cube View: When I run it, and select UD8, nothing appears: If I put directly the template name, the cube view runs with no issues, showing data as well. Any idea why it is not working? Thanks, Ioana    

How can I change the Row name on a cube view so it populates differently in my dashboard? Example in CV is "ESG Total", on the dashboard is "Total ESG"  but want the dashboard to say "Environmental Social and Governance Total" cube view: dashboard      

Hello,   I have a Dashboard that has an attachment button, setup as "File Upload" to the Application Database. We want the client to be able to attach files (this part is working). Due to the number of attachments, every file that is attached, will have to be tagged to a Text field for a specific Member. We'd like to tag multiple files on a single text line, separated by commas. Has anyone done something similar? How did you go about this?  Thank you for your time.

Hello,  Need some help to introduce an extra header on top of the Dimension header that shows up on the cubeview. I can get the count and the $ but am not sure of how to introduce the Operating Plan.  Any help would be appreciated. Thank You, Indu

We have summary dashboards with a lot of information. I'm trying to find a way for users to filter down on that information and have created 2 combo-boxes. However, none of the data pulls through. How do I make those combo- boxes (parameter values) dependent on each other? The idea is when a user selects the first "Resort" box only that resort's projects will be shown in the dashboard. Secondly, the second combo-box "Entity" would only return the entities from within that resort selected (step 1). Currently, no data pulls in when either parameter is selected. If I remove either of the combo-boxes, leaving only one, it works properly. 

We have files that utitlize vlookups or sumif formulas  when we save an offline copy the formulas do not work after. I have found many times that if I change the value I am referring to in the formula to a text format, it saves them, but sometimes it is not always the case. Has anyone else had this issue and what is the work around? 

We want to use a dashboard to run our books using a data management job so that they can continue to run in the background while the user works in OneStream.Using a button on the dashboard triggers an Export File data management step from a data management sequence. When the sequence is run by itself the book dialogue window opens. But from the dashboard the dialogue window does not open and instead the POV members are passed from the cube POV. Dialogue Window when hard coded and run directly from the Sequence. Similarly when a parameter is entered for the Url or Full File name, the dialogue window does not open, but does when the Full File Name is hard coded. No dialogue window. Dialogue window appears. How can we get the dialogue window to appear while keeping the dashboard dynamic to be able to run any book. Thank you.    

Dear community, With 7.4 onward, we have the concept of "Workspaces", which usually works well. For one of my requirement, I need to embed a dashboard which is on another Workspace. The problem I am facing, is that the parameters that are currently in combo boxes are not recognized when I do so. When I open the dashboard as usual (ie not embedded but as a regular dashboard), then I don't have this issue. How to solve this situation ? My parameters are delimited lists and bound lists. When I open the "main" dashboard that embed the targeted dashboard in Design Mode, it recognize these parameters but these are shown as empty. EDIT : oddly, a similar issue apply to the "Refresh", as my embedded dashboard are getting refereshed as expected when open as standalone, but not refreshed when the dashboard from another workspace is embedded... Regards,

Hi All,   I have created one cube view and made it as forms so that user can update their data but i also need the user updated data into another cube view. Once user updates in forms it should also able to bring in another cube view. Can anyone help how to achieve that ?   Thanks in Advance.

I would like the use one of the T#Global function and create a dynamic time list for the last 24 months.  For example, I had the time as 2023M12, the list would show me all the months of 2023 and 2022.  Anyone has any tips on how this can be acoomplished? Trung

Hello,    I have a dimension (UD5), the base embers of which I tag  with a certain text "TEST1". I am trying to create a dynamic hierarchy in UD8 by reading those texts as Text1.  I would like to use this dynamic hierarchy as  a report filter.  For some reason this is not working. I have no formula or BR to do any processing. Am I doing something wrong? Any help would be appreciated. Thank You, Indu

Dear Community, We have requirement to for reporting in which when we run the report its huge and we want to reduce the size of data and we want to apply sparse row suppression but since we have used dynamic calc in our column set which is throwing error when we apply sparse row setting.  Please let me know if you have any idea or solutions which would be very helpful. Thank You!

Hi everyone, I have the current Entity hierarchy: I created a cubeview that allows the user to initially select a base entity from a dropdown list to be used as Entity member within the cubeview. In some of the rows, though, I'd like to consider the Legal Entity code rather than the base member code (for example, assuming the user initially selects 1010TRW, I want two rows to use 1010 as Entity member whereas the rest of the rows will use 1010TRW). Is there a straightforward way to consider the first 4 characters of the parameter in one of the rows of the CV?  I tried to search for functions to be used in the Member filter builder window but I did not find any.Thanks in advance for any help!            

Is it possible to assign more than one security group to a Dashboard without having to create a new security group?  We have a Dashboard that our SuperUsers currently have access to, and they want the Supervisors to be able to see that Dashboard as well. We don't want to create a combined security group to include both SuperUsers and Supervisors to maintain separation of duties for auditing purposes and we don't want everyone in the application to have access to the dashboard.  Is this possible?