Reporting

Requirement : Business wants to have super script in annual reports for the accounts dynamically based on selected entity. Is there any way to achieve this in OneStream. Please let us know if you need any further details.

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

Hi, Please advise if we can add sub headers in CV columns, For example below the main CV Col header has Opening Balance and Cash Invested in Col1 and Col2. But for section 2 below I need the Col header to be Closing Balance and Opening Balance and for Section 3 I need the col header to be Disposal and Sale. Please advise if any user has managed to add sub headers in columns in CubeViews. Any suggestions will be much appreciated. Please note I need the header in Col/Row intersection cell and not in the Row Header. Thanks Sam Opening balance Cash invested Joint venture equity Corporate Group 82,763,441 8250000 Corporate Group 6,000 XYZ Group Limited 132,000,000 Joint venture equity 1,322,873,882 8250,000 -------------------------------------------------------------------------------------- Closing Balance Opening Balance BAA0400400 1,384,034,25, 316,131,428 BAA0400500 -74,503,772 -128,015,962 BAA0400601 518,818,000 518,818,000 Total Cost 1,828,348,482 706,933,466 ------------------------

We had an issue this month where an admin opened a prior period and allowed an import to be loaded, without proper approval.  We discovered this during our quarter end procedures because our quarterly results didn't round properly; however, we would like to be able to run a report that would show us the last time periods were opened or closed to ensure we remain SOX compliant.  Is there a report available that would give us this information?  

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

can you keep a QV POV separate from the main POV so I can look at 2 things with 2 different POV's at once? 

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

Looking to use a Sparkline or Chart in Reporting Studio.   It has to show the trend of the first 6 column in my CV.   For Sparklines, you can only supply a single column.  How am I am able to show the trend of the first 6 columns for each row?

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? 

Is there a way to get the value of the cell that is 1 row above and 1 column to the left of the cell?I have a cube view with 2 columns, one is for actuals and the other is for estimate months. The actual column is going to pull the account value directly, but the estimate column needs to pull in the starting balance and then make adjustments. Below is an example of the data: The 'Last Month Ending Balance' row is where I am having an issue and tried to use variables such as |CVSubPeriodPrior| but I get the same value for all of the estimate months. Is there a better variable to use or could I use a simple offset formula to pull in the value of the cell 1 row above and 1 column to the left?

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.

hello! Is it possible to bookmark reports generated through books? 

When I try to run reports for certain entities, I get the error "Value was either too large or too small for a Decimal" . Does anyone know why this is showing and how to resolve this issue?

Hello, I have a question in regards to cube views - I have multiple rows in the report, some of them including member extensions, and I am gonna write here an example: Row 1: A#Rent Row 2: A#Penalties.Children Row 3: A#OPEX Check that I want to make: GetDataCell(CVR(Rent) + CVR(Penalties) - CVR(OPEX)):name(Check) Instead of getting 0 on the check row, I get to have a difference due to tha fact that the formula only takes into consideration the first child of Penalties, ignoring the rest of the children. How to accomodate/change the formula in order to have all the children into consideration?   Thank you, Ioana

can you add totals to all the columns in a quickview?  not with excel formulas

can you link the T# to a cell in a spreadsheet to pull in the date and refresh on its own without having to go into the member filter builder every time? 

is there generic template available to load journal via csv template?

Does anyone know if it is possible to display commas within numeric columns in the table view feature?  I have attempted to make this work both through the business rule and using formatting within the spreadsheet tool, but every time the spreadsheet is refreshed, the commas are removed.  Any advice in this area would be greatly appreciated.

Hi, We have combo boxes in a dashboard that use an XFBR to define a UD1 (Cost Centre) list based on the text 2 field from the users current workflow. For example, if a user is in the North America workflow the combo box will only display North America & below. When a user changes their workflow & returns to the dashboard if their last selection isn't present in the new hierarchy the combo box will display a blank result. Is there a way to prevent this? We also have a similar issue where a combo box contains 2 parameters, 1 that defines the prior month & another for prior year. If the workflow time is changed these also return blank when the dashboard is opened. Thanks,

It appears that my chart only changes when I "refresh" the Dashboard it is contained on, and the Parameter prompts do not prompt when I "redraw" the dashboards.   How can I get the chart to Refresh w/o the CV parameters prompting the user? Thank you, Stephen

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

Hello,   I created a Grid View to export data from database by SQL query. Some columns should be in number format and others in date format. I defined date format in both SQL query and in Grid View. But when I export data by right click from grid view -> Export To Excel XML, all columns are in text. How can I change default setting of XML Export so that columns will have correct formats ? Thanks in advance. Summer   Format in SQL Query: FORMAT(ActiveDate, 'dd/MM/yyyy') as BuildingDate,   Format in Grid View: ColumnName = BuildingDate, DataFormatString = dd/MM/yyyy,   Export XML file:      

I am looking for a way to download a dashboard with multiple tabs to excel and making sure each tab is downloaded to a tab in excel workbook. Is there a way to do that easily?

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.