Reporting

Hello - I am working on a cube view where I would want the resulting values (variance amount) to sort with the highest value first. The complication is, my users are used to reports from Hyperion that enabled expansion drilldowns on these members. The Hyperion reports retained the sorting even when using expansion. I can't seem to figure out how to do this in OS - or if it is even possible - when selecting a member expansion (.Tree or .Base).  Wondering if anyone else has attempted this.  Thanks,Cody 

Does anyone know how to add more than 2 custom titles on a row?  Below is the view of 4 headers.  I can change the name on 2 but not 3 of these titles.Member filters are below.  I have custom name at the end of my Time and Scenario member filters.  I want one more on my View dimension.This does not work...    

Hi all -I am creating a cubeview that seems basic at first glance, but have ran into some walls as I am still new to using cube views on my own. What I have is an entity, net sales, profit, profit margin, months, and a changing scenario.I want to see net sales, profit, and profit margin for the current year. This part is simple enough and will not move.However, I want to compare these same metrics to various other scenarios, one scenario at a time. I want to be able to select something like prior year actuals, budget, or any forecast and see the figures come in for it in the second/lower half of this cube so I can then make a comparison between current year and whatever selected scenario I have. Is the best way to do this to create a parameter for the scenario and then write in that parameter name in the necessary rows for the scenario?Additionally, if I wanted to create a better/worse row, would I be able to easily do that even though one of the two scenarios could change at

Has anyone used conditional formatting with the IsRowVisible row header format property before?  I am developing a cube view form that is driven by an account input parameter where the user selects an account to run the cube view. Depending on the account they select and a predefined condition, a given row should be suppressed/hidden (e.g. contains 611000). I am using the IsRowVisible row header format to try and accomplish this. However, it does not appear to be working properly. If we update the format property to something other than IsRowVisible (Bold = True), then the results are as expected. So I'm not sure why it's not working for this IsRowVisible format property.  Perhaps I am missing something here?  Thank you in advance for any tips you can provide! Following is the condition set for example above.  Account parameter is defined on Member Expansion 1. If (RowE1MemberName Contains 611000) Then  IsRowVisible = FalseElse  IsRowVisible = TrueEnd If

I'm trying to do a dynamic calc to determine lesser value of an account or 500,000. I have very little experience with vb.net so this was as far as I got but it doesn't work.If api.Data.GetDataCell("A#RPT_Cash") > "500000" Then  Return "500000"Else If api.Data.GetDataCell("A#RPT_Cash") < "500000" Then  Return api.Data.GetDataCell("A#RPT_Cash")End If 

I have a dashboard with graphs and on the side a series of buttons opening input forms for key assumptions.  The forms are usually cube views and sometimes a combo box.  I would like the pop up dashboards with the input forms to auto size to the content.  I can hard code the height and width but the number of rows/columns in the cube view can change.  Is there a good way to auto size these pop up dashboards to their contents?  Thanks.  

Currently, there is an option to change the "hover color" on button components. Is there an option to change the color once the button is selected? In my current dashboard, we have multiple buttons and it would be nice if the button a user selects would change colors, then it is apparent they are on that button.

SOURCE: ONESTREAM CHAMPIONSHi everyone,Has anyone used the Dashboards for advanced line charts to show a few years of actuals and the current year of budget? I am trying to show actuals for 2019, 2020, and 2021 and 2021 budget by month and cannot figure out how to get this to come through. I set up a cube view with my account in the POV and the Time in the column and a combination of scenario and time in the rows since i don’t want to see budgets for every one of these years.Thanks,Cindy

I am trying to create a quickview that would require the data presented to consider some account configuration that only appears on the decendents set up.   ex i have a parent member P that has multiple children and would like use a where clause to exclude IsIC data. i tried to do A#P.Base(IsIC False) but this results in multiple lines where i would want to only have one line presented that is removing the data associated with the children that are IC. is there a function that would let me create a summary line while still checking the descendent configuration?

We are trying to format numeric columns in a Table View but haven't been successful. The numeric columns are currently appearing as 999999.99 instead of the desired 99,999.99. Are Table View currently looks like this:The Spreadsheet Table View rule is defining the numeric columns here:sql.AppendLine( ",FORMAT(SUM(ISNULL([V4],'0')),'N2','en-us') As [Gross Revenue]")Thanks

I am building a Rolling Forecast scenario (eg. name is RFC 2+10) using the below formula snippet which takes the current month actuals, and adds the future Budget scenario. It works well so far, however when I use the scenario in a cube view, I'd like to use the headers based on the source data. So in RFC 2+10, columns 1 and 2 are actuals, and 3 to 12 are Budget. But for each column it just shows RFC 2+10 - is there a way I am able to write something or use some conditional formatting so that show Actuals/Budget based columns?Thanks   

Hi all - I am trying to format a cubeview a specific way. Then the rows are like follows: Entity1 Title row Entity1 net sales Entity1 Profit Entity1 Margin % Blank row for spacing   Entity2 Title row Entity2 net sales Entity2 Profit Entity2 Margin % Blank row for spacing   This continues on for a bit in the exact layout. What I want to do is hide the entity name in all the rows except for the title row. Then in the blank rows I am currently seeing "none", I would like that to be gone as well.   What is the best way to stop the entity name from repeating and removing the word "none" from my blank spacing rows? TIA!

Hi, there is a way to get the sum of the values of all the members that I filter with the text3? for example text3='Austria'In this case in Row1, I have E#Entity.Base.Where(Text3 = 'Austria'), which identify two entities, and in Row2 GetDataCell(CVR(Row1)):Name(Total Austria), but it doesn't work.  

HiIs it possible to show a message box in excel?I am currently writing a SpreadsheetFunctionType.SaveTableView rule and I would like to display a message box to the user with any data validation errors when trying to save.I have tried :Throw New XFUserMsgException(si, Nothing, Nothing, "My error message")However, this doesn't seem to work. Regards,Mark

Hi all,I have an issue with table view number formatting. On my SQL query, I'm introducing the format: Select FORMAT (Sum(Year_01), 'N2', 'es-es') as Year_01 ")After that, I populate the table view applying the true option in "UseDataTypes"tv.PopulateFromDataTable(dt, True, True)My issue is the next one: the format seems correct but, after openning or refreshing the tableview, it introduces the value as Text. I must enter on a cell and click the enter button to be able to recognize it as number.  Does anyone have the same issue? Thanks,Albert  

Hi I'm trying to link this form to an Headcount correction form but when I navigated to this linked form, It shows me in the Group adj column green cells. How can I make them imputable? 

Hi,I have set one Time Profile in one cube from Oct 2018 to Sep 2019 (first fiscal year) and another Time Profile in different cube from Jan 2019 to Dec 2019 (second fiscal year). I need to present Consolidated Report of both periods from beginning of both fiscal years simultaneously in one dashboard. Can anyone help ? 

Hi,I want to have a consolidated report from Oct to Sep of any year. In order to achieve this, one time profile is created and attached to a cube and the same cube is used in cube view. What should I write in T# for cube view column ? Thanks in advance.    

Is it possible to add already existing parameters to a report that is being created through the report designer tool in dashboards?On that note, is there any type of user guide for this report designer tool?

 Hello Experts,I have simple SQL editor component in a DB. as Admins we can use the toolbar to Insert/Delete/Save in the SQL table behind the scene. for end users it is disabled is there any other setting that needs to turned on? Appreciate the help.  

Hi there, After having loaded data through the Corporate Finance Data Review workflow step to the 2023Bud1 Scenario for the full year 2023, I was hoping to use the OS provided Application Reports dashboard to get an overview of, e.g., All Stage Source and Target Data (from the Data Validation dashboard report group), or Import Detail (Imported Data)(from the Import Detail dashboard report group), but the reports return no results. At a point in the process I was able to run the Data Validation - Intersection Errors report successfully, but none of the reports seem to pull any data now. My Workflow POV is set on that which was used when I imported the data and I don't believe the Cube POV has an impact. If anyone has come across this and have guidance to get these reports pointed at the right underlying data in OS it would be much appreciated. We're on OS 7.0.1 and I'm running Windows 11 Pro.Many thanks,Adriaan 

I'm creating a quickview to list all of our customers (UD2) over 24 months - is there a way to set a rule to exclude that customer if there's no value or if it's all 0? Thanks, Trish

Is it possible to report on workflow  detail that was loaded into the import step of a workflow. Our company loads in several attributes in the import step that do not make it into the cube. Is it possible to create a report or a data adaptor that can display that higher level of detail.

Hello, I'm currently trying to build a CV for my team. In the column filter I have time as the first member filter and account as the second member filter, but when I put as my account name A#None:Name(" ") it still gives a the WF Time. Is there a way to make it show as blank? Sort of like the account? I have a parameter created where it makes the background and text to be the same color and I would think it would also make everything show as blank, but it doesn. This is the parameter for the blank row Thanks, Will

Hi All,similar to this post: https://community.onestreamsoftware.com/t5/Reporting/BI-Viewer-Creating-a-clustered-column-line-chart/m-p/6355#M1099 I have created a chart with bars and a line on a secondary y-axis. I also used the method to form the secondary y-axis: Iif(StartsWith([Account]), 'Sales'), [Amount], 0)The problem now is that the bars are getting thinner by drawing in the 0 values and also the legend is overloaded by the 0 values. So I wanted to ask if there is a way to filter out these 0 values and not display them?Thanks for any help!