Reporting

When using the minimum range value in  a waterfall chart, e.g. (10) that excludes all series values that are lower than 10. Is there a way to keep those values under (10) while using the minimum and max ranges to make the chart show the small value variations with a decent scale for the eye? thanks!

Hi everyone, Is there a way to use more than the 4 offered Row/Column Overrides? Here is my problem:For a customer I have to create a report, in which among other things the sales figures of different business units (UD1) are to be seen later on an Excel sheet. Since, as far as I know, it is not possible to loop on an Excel sheet in a report, I wanted to create a cube view and list the different UD1s under each other. However, a dynamic calculation with the following formula is included: GetDataCell(Divide(CVC(ColA, 1), CVRC(RowA0, 1, ColA, 1))):Name(%) The value A0 should then be changed to B0 for the next BU. However, since there are a total of 12 BUs and 12 columns for each month, the 4 overrides are not enough. Is there a way to increase them? Or another way to get the calculation right for all BUs?

Hi everybody,Below you can see a graph created for a client.A question coming from them is that they want to align the 0 points (highlighted) of both the primary (left) axis and the secondary (right) axis. I've tried (amongst others) to change the visual and whole range, scaling options but it doesn't seem to change anything.  Does anybody know if it is possible to align the 0 points? Thanks!Floris

I am trying to see the last changes were made to an intersection. Currently I am using a UD8 to join a couple tables together and can see the last time a section was changed but my issue is run time. It will run in about 2 seconds for one account but times out if I try to run it on all accounts. It is being used in combination with an XFBR that pulls a rolling list to select days after a date is selected from a date selector. Is there an easier way to see if changes were made to a certain intersection that would run quicker?

Hi, I have an Advanced Chart where I am displaying dates.  The values, however, are stored as ticks(Long).  This is great for the bars and points, however, I need the Axis labels to be displayed as date (not Long see below).  I've tried a few versions of {V:MMM-yyyy} however, that doesn't seem to work.  I do have a business rule to work with as I'm using a secondary axis, but not sure how to target the data labels in the rule.  Any suggestions? thanks,Greg

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.