Recent Discussions
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! -NicoleNicoleBruno6 hours agoValued Contributor85Views0likes6CommentsNR - Cubeview Parameter
Currently i am working on NR reporting, i have created extensible documents with cube views, those cube views has parameters Is there a way where we can supply the cube view parameters, in doc variable? i have tried to apply parameters in book and document section in NR but that is not working. Thanks for your help and support.Sudhakar17 hours agoNew Contributor II3Views0likes0CommentsXFgetcell pulls in future months as YTD negative
How can I get xfgetcell formula to not pull in the next month as a negative? i am making a YTD file and currently have Jan and Feb number but march pulls in the YTD amount but negative and causes the ytd amount to be $0.RustyShacklefor17 hours agoNew Contributor III5.3KViews1like11CommentsHow to Dynamically Report on Extended Members from the Top Consolidation Cube?
Depending on the circumstances, you could find yourself into a situation where you need to report numbers on Extended dimension Members from the Top Consolidation Cube. In a Vertical Extensibility Cube set up this gets tricky since the data is only available at the lower cube levels. To work-around this challenge (considering the limitations exposed below), I have created a dynamic calculation Business Rule that allows you to achieve that by leveraging a specific UD8 Dynamic calculation Member. Following it is an overview of the Solution: Problem Statement: When using Cube Vertical Extensibility, reporting from Tot Group cube is not possible for those dimensions that have been extended. In the example, UD1 is only available at Summary Level for Tot Group: Solution Overview: UD8 Dynamic Calculation to derive the Extended members from the Base Entities consolidating to the Parent Entity Level (E#Tot Group). Data is dynamically retrieved from the base entities and translated on the fly based on the Parent/Child Entity relationships: Works with any extended Account Type Dimension (A#, F#, U1#-U7#) without having to modify the Business Rule. Dynamic Calculation driven from the UD8 Text1 field: Considerations: Solution aggregates and translates on the fly the base data without: Eliminations % of Consolidation (It could potentially be incorporated into the solution) Suitable for reporting/analysis being done at O#BeforeElim. When used in large Cube View/Quick Views queries could create slow retrieval performance. Technical Set Up: Create the UD8 Member and Define the Text 1 property referencing the Dimension Tag you’d like to report on (Ie: DimTag=[U1#]). Add the following Member Formula within the UD8 Member: Dim referenceBR As New OneStream.BusinessRule.Finance.XF_DynamicExtensibilityReporting.MainClass 'Return referenceBR.DynamicProductReporting(si, globals, api) Dim Value As Decimal = referenceBR.DynamicExtensibilityReporting(si, globals, api) If Not Value.Equals(0) Return Value Else Return Nothing End If Create a new Finance Business Rule, make sure that the Business Rule is set to Global:aformenti21 hours agoContributor II1.2KViews5likes2CommentsStacked Cube View Reports into Report Book
Hello, I'm trying to figure how to stack 3 cube views on the same page and add that to a book. I know you can create a stacked report in a dashboard. But I don't know if you can add dashboards to a book or not. Thanks, WillSolvedWillVitale2 days agoContributor2.5KViews0likes5CommentsHow to pull Workflow Parent in CV or QV
Hello Team, Generally, User will open a form through workflow and input data and certify that. i need pull a data Like, which user has certified the form for respective site. and in which table those User certified details will be store. Can you please help us on this.ShivaPrasad2 days agoNew Contributor II17Views0likes2CommentsConditional Formatting in Cube view on Annotation members
HI, I am looking for an option to highlight text value in the cube view based on some condition. I have combo box which has parameter which pulling value from one of the DIM Member 1 = United States Member 2 = Canada Member 2 = Not filled If its not filled then I want to highlight red. Is there any option. I tried using XFBR but seems like it run on specific data unit onlypranav462 days agoContributor II11Views0likes0CommentsUnable to open shared Cube View
Hello, We are trying to use row and column templates in a Cube View but are using parameters to populate the names of those row and column template cube views. We get the below error and are curious what else could be issue as we have checked values of parameters and they are pulling in values expected (names of templates). Thanks!robertk3 days agoNew Contributor5.9KViews1like10CommentsNarrative Reporting Parameters
I'm currently using the Narrative Reporting MarketPlace Solution on OS version 8.4 and have successfully integrated Cube Views, Content, and other artifacts using QuickParts. However, I'm facing several challenges: Member Prompts on Report Checkout/Edits: Despite configuring parameters at both the report and report group levels, I continue to receive member prompts from the cube view every time I check out or modify a report. This differs from the expected behavior in guided reporting and dashboards, where parameters are supplied automatically. Is this expected, or is there a workaround to prevent these prompts?Sudhakar5 days agoNew Contributor II52Views1like1Comment