Reporting

Hello, I have a blank line on the left in this Cube View, under Total OpEx. I’d like for this line to be completely blank, is there a way to make the highlighted icon disappear? Thank you for your time.     Thank you in advance for your input!

I have a cube view where some of the mathematical operations in the last two columns on the right ( Difference and Percent Difference) are not working. The formula that I have in these last columns is as follows:GetDataCell(BWDiff(CVC(OP) ,CVC(Actual))):Name(Difference) GetDataCell((CVC(Difference) / CVC(OP)*100)):Name(Percent Difference)   The yellow highlighted cells in the right hand columns are the ones where the math is not working and they are not populating with results.   Below is the structure of the cube view I have:   I have noticed that the cells on the right columns where the math is not working and not populating are the ones where the corresponding row has accounts that are in the form of a sum of two or more accounts, as an example for my Row1 I have: GetDataCell("A#60100+A#60900"):Name(Salaries & Benefits)   It is apparent that the issue in the cells that are not populating is due to the accounts in those rows being the sum of two or more acco

This is a basic question related to cubeviews. When I open cubeview_1, it closes cubeview_2.  When I open cubeview_2, it closes cubeview_1. Is there a way to keep both my cubeviews open in the desktop?  This seems like a silly U/I constraint to restrict users from working with more than one cubeview at a time.  We are using Desktop v.6.5.0.12623. Any help would be appreciated. Thanks, David PS. I have lots of peeves about the U/I but this is a major one.  Others include No standard ribbons, like every other windows app Navigation tabs that are shown across the BOTTOM of the Window!?  Mousing around the top, left, and bottom of my screen is just bad. Very low support for keyboard shortcuts. (even basic things like Ctrl+N, Ctrl+S, etc) Virtually no right click (context) menus etc.  None of these are rocket science, and hopefully I'm not the only one who is complaining...  

Cube views are the main building block for reporting Question Credit: Nick Hymes   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

We'd like to calculate CAGR in cube views, is there a formula to use in the cube views? If there are formulas that only work for dimension members and business rules I'm also happy to hear, then link to the cube views. I already tried "POWER(x,y)" and "x^(1/y)" and they don't work. Thank you in advance!

is it possible to add a blank row in the account field?  i found that you can use A#None and it will make the numbers blank. is there something else you could use to make the numbers blank and make it say something besides None or something else? 

I'm working on a cube view that displays reporting data in a quarterly trend. The end user would select which quarter they want displayed and the CV would display that quarter along with the 4 previous quarters.  Ex. User selects 2022Q1 and then CV displays the following columns 2021Q1, 2021Q2, 2021Q3, 2021Q4, 2022Q1. Data would be displayed quarterly in each column. Any suggestions on how to write columns based on this criteria? Thanks.

Ad Hoc Analysis is a way to use a spreadsheet environment to report on data loaded into the Cube. Question Credit: Becca Speese   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Is there a way of setting the selected cell in a cube view when this is refreshed. As far as I can see this defaults to the top left data cell. It would be useful if this could be set using a business rule or a parameter.

Originally posted by Colin ONeillI would like to add an Excel "cube view run time" time-stamp to a cube view report. But I have been unable to find a way to do that. I can't be the first person with this question.

Hi, Is there a way to audit (in a report...) for all cube views, which one refers to a column or row cube view template ?    Thanks.   Regards, Harry

Hello,Has anyone experienced partial uploads when using the XFSET formula? Does anyone know if there is a way to set XFSET uploads to only upload data if there aren't any errors? Regards,Ronnie

Is it possible to pull up a linked dashboard by using a button component instead of having to right click on a cell.  I want the user to be able to click on a cell in a cube view, then click a button that pulls up another cube view showing the detail.  I am using two bound parameters for account and department within the dashboard.    

This seems very standard, so I have to be missing something.  I have the row filter on a Cubeview "A#6020.TreeDescendantsInclusiveR".  6020 is the total line for all the single level descendants.  How do I get only the last descendant to be underlined in the report before the Total line of 6020?

Hi, Is being able to Right click and choose Consolidate in a cube view an admin only function? We have a report where "Can Consolidate" is set to True but users are not able to consolidate from the cube view...they can from a data mgt job. Thanks, Haaris

Team   Is there a way we can add long text like comments to the cells through Forms?  Am trying to build a cube view with data and comments to it which is visible on view rather than adding it as "note" or "attachments". Please see the sample image below on the requirement.      

Statement: You can do a direct cash flow in OneStream. Question Credit:  Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week.   * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Is there any way to do a GetDataCell in a Cube View or Quick View where the members are dynamic/based on some criteria?  The formula below doesn't work, but hopefully give you an idea of what I wish did work.   GetDataCell(SUM(E#TopEntityMember.Base.Where(Text5 = 'Germany'))):Name(GermanySum)   I know you can add specific members together in the GetDataCell, but I'd like to be able to have one row that shows the sum, which is based on a property value that can be changed or be able to use it as a member filter and not have to display it in the grid.

Hi, I am building cube views that should be accessible by several users based on the workflow they are affected to.   These cube views are the same, but each workflow has its own entity. Therefore, the same cube view will be available through several workflow, and the entity (or entity selection) should change based on entity affected to each workflow profile.   I'm probably missing something, but the problem is that there are no (known) parameters that would simply give me the list of entities attached to the current workflow profile... what would be the best way to achieve this ?   Regards,

I'm working with a BI Viewer and working out how to sort the dates within the Time data set. Is their an API that allows to call the data adapter used within a dashboard? Currently the dates on the X-Axis are disorganized and are being sorted based on M1x, M2x which causes October (M10) to precede after January (M1). 

I am creating a dashboard that compares two different scenarios (one of which is the prompted scenario). I want the header of the chart to display the description of the member instead of the name (i.e., "Forecast 3+9" instead of "FORECAST_3_9." If I input the prompt name into the description field ("|!Prompt_Scenario!|") it will return the name. Is there any way to update this to populate the description instead?

I am trying to build a dashboard with a button that opens a scenario dimension page so that super users can easily set up and use a gaming hybrid scenarios.  Is there an XFPage option to open a dimension page?

Hello, Backstory: We have some forecast cube views we embed in our Forecast workflows. These cube views also display under the cube view folder. The cube views are set to the workflow POV and I realized this means users can open the cube view in the cube view folder and if their  POV is Actuals, they can then load to Actuals. I want to prevent this.  I updated the cube view folder security to Admins and then no one could access the forms.  Question: Is there a way to remove specific cube views from the cube views folder, but still allow users to access them in a workflow?  Regards, Ronnie

Originally posted by Kris Waggoner I have a cube view that has a nested dimension in the rows.  By default, the nested dimension is collapsed and the user has to expand it.  Is there a way to have the nested dimensions expanded by default?  There is a setting for this in the pivot table in BI Viewer, but I don't see how to do this in cube view

Statement: You can copy and paste dashboard components within a dashboard maintenance unit or to a completely different dashboard maintenance unit Question Credit: Chris Bielinski   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases   Want more Fact or Fiction? We’ll be hosting a LIVE game show at SPLASH San Antonio! You can volunteer to participate or you’re welcome to attend. Secure you spot today by contacting Press@OneStreamSoftware.com. We hope to see you there!