Quick View POV - Dragging Blocked second screen
When using a second display monitor connected to my laptop the Drag and Drop of dimensions in Spreadsheet Quickviews does not work - when I place the Onestream applicatrion page on this second monitor. if i switch back to having the OneStream application QV on my laptop screen - i have full functonality on moving dimensions into columns or rows in Qv's Any similiar exeriences with this ? ( audio/visual setting on second displays)?) best regards Chris5Views0likes0CommentsCV report to show trailing 4 quarters and completed months of current quarter
My team has a requirement for a CV report to show the last 4 trailing quarters and all 3 months of the current quarter. I was able to achieve this, however when the time period is the first or second month of the quarter, I would like to show only those completed months. For example, if the period is July I would want my months columns to be June & July. Currently I am using T#Quarter(|POVTime|).MonthsInQuarter which is showing Jun-Jul-Aug. Is there any function that is able to do this? Thanks!6Views0likes0CommentsWord reporting automation
Dear all, Could you please advise if in OneStream there is a tool, which we can use to automate preparation of consolidated financial statements in Word format based on OneStream and outside of OneStream data (combination of OneStream numbers from cube views and texts that can be manually corrected)?Solved17Views0likes2CommentsNested parameters to return one value
I am building a report that uses a nested parameter. This report will run on a dashboard within Guided Reporting if it makes any difference. My parameters are Member List types. EntityParam1 uses a member filter of E#Corporate.ChildrenInclusive. This is controlled by a combo box on the dashboard. Let's pretend the user selects E#Legal as the value for the combo box, one of the children of E#Corporate. EntityParam2 has a member filter of |!EntityParam1!|.ChildrenInclusive.Children The member filter I want it to return is E#Legal.ChildrenInclusive.Children When I run this nested parameter, it runs E#Corporate.ChildrenInclusive.ChildrenInclusive.Children, which throws an error at some point. How can I use EntityParam1 to only return the E#Legal member for my nested filter? I would think the answer lies within a literal parameter but haven't found a method that automatically uses the selected value of my first parameter. Thanks in advance.485Views1like2CommentsHow to hide several columns in Cube View?
Hi, is it possible to hide 2 columns in a Cube View? I need them for calculation only, but hide from the report. If I set format IsColumnVisible to False or CVMathOnly for one column, it works. If I set it to two columns, I get no data on third data at all, while it should show data.24Views0likes2CommentsIs it possible to use spreadsheet component (Table View in it) in the Book ?
Hi All, I create a spreadsheet business rule to refresh the data from external table using Table Views, now our users wants to drop these files into OneStream file share on daily basis so external systems can consume. Is it possible to use parcel service to refresh these files (using table views with in the spreadsheet) and drop them into file share every time the job trigger ? Or Is there any alternate approaches to export data from custom table to excel files ? Thank you.Solved2.3KViews0likes6CommentsGuided Reporting Duplicate Param Dialogue Box Showing on Run or Param Change
Hi OneStreamers, I'm currently working with the Guided reporting solution in OS v8.4.0. When running the report in the GDR homepage a duplicate dialogue box appears after the Guided Reporting Dashboard is selected via the OnePlace menu item, once a report is selected, or after a Parameter is changed anytime the Parameter combo box is changed. Each Parameter is set up a Member list at the moment but were previously discovered as Member Dialogue, and now rediscovered as the updated Member list param. Any Idea what I could be missing?27Views0likes1CommentPage Numbers in Book Reports
I have a book report with multiple Cube views ,Excel ,Word and and PDFs. If all together the book has 100 pages, Is it possible to show the Page numbers 1 of 100, 2 of 100 in sequence? I have tried the Cube View Extender BR discussed in this forum previously and that does display Page numbers only within the Cube view where the rule is attached to and in the format of Page 1 0f 1 ,Page 2 of 2. Page Numbering Format for Books | OneStream Community Appreciate any help or guidance.16Views0likes0Comments