Dashboard - Time Parameter for Specific Cube Views
Hello - I have a dashboard with 6 buttons across the top - each one is set to display a different cube view. The time dimension for 4 of the CVs are set to workflow time, where the other 2 I want the users to be able to select a period from a list, because these 2 are designed to show historical variance commentary. I set up a member list parameter with the time periods and added it to the two cube views. Now when I open the dashboard, the prompt automatically appears for every CV. I checked and couldn't find a way to only have this prompt appear for the two cube views. What settings do I need to enable or disable for my dashboard so 4 out of the 6 run off workflow time, but when a user clicks a button for one of the 2 others, the time period prompt appears?
Double Line Formatting
Hello, We currently print out a book to our general managers every quarter and our reports formatting seemingly changed without us changing. We use double underlines as our totals and previously it worked fine, but this quarter it looks like a solid line, but when you zoom in, you can see it's a double line. Is there any way I can fix this? I've tried changing the ReportBottomLine1Thickness and ReportBottomLine2Thickness size, but with no luck. Any suggestions? Thanks, Will
Cube View Connection Issue with Preserve Excel Format
Hello, On version 8.5 (could be earlier, but didn't have a need to try) I am trying to create an embedded cube view that retains excel formatting. When I check mark the preserve excel format this works, BUT when I save the report, close it, and reopen it the cube view itself stays a light font vs black. Once I uncheck preserve excel format it reverts back to the expected black font cube view.....Is this a known issue or a way around it?
Conditional Formatting based on 2 different columns in cube view
Hello all, Is there any way to set a conditional formatting in a cube view column based on 2 different columns? I have 2 variance columns (one on dollar amount and another with a % variance) that should have a red color if 2 conditions are met. For example if the variances are higher than 200k and 20%. Any input is appreciated. Thank you! Adina
Sum of accounts at base levels
I would like to return a sum of all rows in my cube view but using the 'sum of rows' is only returning the first result for every account under the main hierarchies I'm calling. This is the literal statement I would like to sum - GetDataCell(A#BALANCE_SHEET.Base.Remove(A#32000).Where(AccountType DoesNotContain 'Liability') - A#BALANCE_SHEET.Base.Remove(A#32000).Where(AccountType = 'Liability') - A#32000:F#BegBal - A#INCOME_STATEMENT.Base.Where(AccountType = 'Revenue') + A#INCOME_STATEMENT.Base.Where(AccountType DoesNotContain 'Revenue')) Has anyone done something similar through an XFBR string?Trying to pull data from cube view using label component
I am trying to create a label which needs to display the gross profit in my dashboard. I have created a data adapter (when running the adapter, it's showing the relevant data) and attached the same in the label. But I am not getting any data in label. Can someone help/suggest what I am missing?CV 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!
How can I wrap V#Annotation text in a column?
Hi all! How can I wrap V#Annotation text in a column? Right now the reporting is not the most user friendly so we're wondering how to show it better. It looks like there were some suggestions from three years (Maximum characters for Annotation | OneStream Community) ago but wondering if we've made any progress on this issue since then :) Thank you! -Nicole
