Reporting

How are parameters organized within a DMU? I refuse to believe they're placed in a random order once created. They're not sorted in alphabetical order or by Parameter Type—then how?

Hi We are creating a book that loops over an excel export item to create multiple tabs (see below):Is there any way to add a named range around each exported cube view?Thanks,Mark

Hi all,I am trying to find a way to set up a member filter where the member's text 1 field contains the name of an entity.My CV row setup is as follows:E#MyParent.base     U1#MyU1Parent.base.where(Text1 contains xxxxxxx)in the above example, xxxxxxx should be the name of the current entity.So basically this CV should go through all the base entities and for each Entity, the U1 member(s) that display should only be those whose Text1 field contains the name of the particular entity.There must be a way to do this.  The concept is simple.  We use a lot of where() clauses here in our CVs but no matter what I try (i.e. where(Text1 contains |MFEntity|), where(Text1 contains |CVEntity|)); nothing seems to give that result.  It either completely ignores the where clause and just returns all of the U1 member regardless or it defaults to the total U1 parent.This CV works perfectly if I select a single entity and ask for all of the U1 base members whose text1 field co

The Formula for Calculation Drill Down will impact consolidation performance. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi, is it possible to give someone access to the FileShare folder in OnePlace, without giving access to the System tab (from where, using File Explorer, it is possible to browse to the FileShare folder)?Thank you 

how can you add calculations into a quickview.  how can you add the input fields also? I seen both at splash so i know its possible 

Hi dear contributors / members,I am trying to format the Cube View cells to final value divided by 1000.I have setup Scale = 3 for all rows and all columns, however the divided value appears only for the first column.Any suggestions please?    Thanks in advance.Kind regards,Irina

Hi,Report Title is hidden in CV Extender but can it be collapsed?Using above code it is hiding Report Title, But it is consuming too much space, Is there any way to Remove / Collapse / Eliminate CubeView Report Title using CubeView Extender Rules. Any solutions would be Helpful.Thank you

Hi all,  We have data coming into Import/stage that subtotals to zero when it validates/maps into the cube. We need to review this data in import/stage before the validation and the easiest way would be a QV or CV instead of having the user manually go into the workflow and export the data. I thought accessing stage data in a QV/CV was possible but I can't find specifics. Any direction would be useful - thanks! 

Hey all,We are trying to creating a toggle button so that the dashboard will render based on the selection. We have 4 Scenarios and we want to compare those but the scenarios will be selected by the end user at run time and s/he can change the selection as many number s/he wants.I have tried to achieve this via Checkbox but that is not working as expected for multiple users as the literal parameter gets updated every time.I tried radio button as well but it looks like so many option (buttons) on the dashboard. Do anyone have any other suggestions on this? Below are layout images on both tries we done. Radio button (first image) looks best but as mentioned above not working as we want too.   

I have a dashboard with a button component in which I have a XFBR String which alternates between two colors for the button's image background when clicked. Similary, I would like to be able to alternate between two images for my button when clicked. Is this possible with a XFBR String at all ? I thought I could return the image's file name with a XFBR String under Image URL Or Full File Name   or can XFBR Strings only be used under Display Format ?

Is there any way to get the cube view profile and Group Name of the CubeView using Business Rules?Thanks.

I am trying to create a dashboard with GridView as the component. In Gridview am using Dataadapter (SQL Query). I want to pass parameter to the GridView when displaying the data in the dashboard. Can someone help me on this.   Thanks & Regards, Madesh K

We have made the latest upgrade to 7.2.1. When I use the Excel Add and use the keep and delete buttons it suppresses all data in that field opposed to only keeping or removing the items that I selected. Anyone else have this issue. The other members of the team don't have this issue and we have the same settings in place.

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

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 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  

 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.  

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

You can have three or more cubes linked in OneStream Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

We have some CubeView reports that are driven by parameters.  They are all working.   But it would be nice if the default value could be derived from the users POV - workflow or otherwise.  Can this be done?