Turn off suppression of repeated member names in a Cube View
I am well aware of the "Suppress Repeating Member Names" True/False box on a Quick View. I am looking for the exact same toggle on a Cube View. I could have sworn this was a very easy thing but I don't see it. In the below Cube View example below, the first row member expansion is the Actual scenario and the second is a TreeDescendants on the Account dimension. I want the "Actual" scenario to repeat all the way down on each row. Am I missing something easy here?2.6KViews5likes1CommentEnhance your OneStream experience with Emojis!
Integrating emojis into OneStream workflows, like :memo: for forms and :crystal_ball: for forecasts, enhances clarity and user engagement. Simple to set up, just copy and paste your chosen emoji into workflow titles for an instant visual upgrade. Interested in setting this up in OneStream? Dive into the world of emojis and elevate your interface today! :rocket:635Views3likes0CommentsOptimize CubeView performance in Excel
I have Cubeview which takes ~50 secs to refresh in OS. When I insert same Cubeview in excel and refresh in excel (OS Excel-Addin); it takes over 2 mins. It is simple insert and refresh i.e. I do not have anything additional like VBA code etc in Excel. Is it normal for CV to take to take longer to refresh in excel? Any suggestion to optimize the Cube view refresh in Excel? Many Thanks.3.4KViews3likes4CommentsUse XFMemberProperty to get year from time parameter
Hi I'm looking to get the year from a time parameter to use in a cube view header. Is it possible to use the XFMemberProperty rule if possible? I've tried :Name(XFMemberProperty(DimType=Time, Member=|!TimeParameter!|, Property=Year)) but the system doesn't like it. Note, the following works to get the time description, but I'm looking to just get the year i.e. 2023 XFMemberProperty(DimType=Time, Member=|!TimeParameter!|, Property=Description) Thanks, MarkSolved2.6KViews3likes4CommentsCV format total line different from row expansion details
Hi all, Is it possible to format the top row of an expansion different from the expansion details in a cube view if they are the same line on the CV set up? For example, I would like the formatting to have the Total Product line bold with the details under it not bold and with only one expansion at Total Product. It seems the only way I can do that is to have one row in the CV set up for Total Product formatted one way and a separate line below for the details formatted another way (result in screenshot above). The problem is then my expansion isn't really where it should be and the first detail line (Branded Pharm) will always show. I can't figure out a way to do this but if it's possible, please let me know!Solved1.9KViews3likes2CommentsCube View - Excel Column Headings
Is there a way to have nested column headings centered and merged when exporting a cube view to excel? I have nested columns and want the top column header to be centered and merged over the bottom columns. It does this automatically for a pdf export but the excel export repeats the top header for each column. Excel vs. pdfSolved2.8KViews3likes3CommentsExcel Formatting for spreadsheet component having a cube view
Hi All, We have some cube views which dynamically pull columns as per the cycle being planned. Cycle1 : 4 quarters Cycle2: 3 quarters Cycle3: 6 quarters Cycle4: 5 quarters These cube views have column separators, highlighted rows and columns. Cube views are included inside spreadsheet component which are then embedded inside the dashboards. ISSUE: Formatting is different for every cycle due to varying number of quarters. We have had to manually update the spreadsheet components for every cycle due to formatting going off. Would anyone have a dynamic solution for this?2.1KViews2likes2CommentsBridge Origin Import to BeforeElim/Top with journal entry details
Hello! A user has requested a CV/report that starts with imported data and layers on journal entry details by each specific JE. High level it would look something like this with the pink highlights representing the detailed balances of each individual journal entry: Have any of you built something similar? Is there an easy way to get the journal entry name details into a CV? I’m guessing I can get them from the JournalHeader and JournalLineItem database tables but wondering if you’ve ever worked on a request like this. I've also submitted a support ticket so we'll see. Thanks!1.3KViews2likes2Comments