Populating Future period in a Cube View
Hello, I'm trying to create a cube view that grabs actuals from People Planning and populates the future periods with the latest month of actuals. e.g. in M3, M1=M1 Actuals, M2=M2 Actuals, M3=M3 Actuals, M4-12=M3 Actuals. I need this in a cube view because we need to be able to show the data in both local currency and USD. People Planning is currency agnostic. I tried this directly querying XFW_PLP_Plan with SQL and a biViewer, but ran into the problem of not being able to bring in FX rates. I can only show local currency. Has anybody done this or have any ideas? Perhaps something with UD8? Perhaps there is something simpler I'm overlooking? There is SO much to learn with OneStream and I know I'm only scratching the surface.
How 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:
How 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.Narrative 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?
Format Cube View based on third Header Override expansion
I am using header overrides on my columns to create three column expansion levels. I need to add conditional formatting based upon the header display text of "HPU" in this third expansion so that only sections with "HPU" in the header are set to three decimal places. I do not want to build every HPU column separate from the others, as this would require the build of 108 columns, instead of 12 columns. The system will not let me call that third expansion level in my conditional formula. Any help would be greatly appreciated!
Excel reports with Macros in Books
I have several excel reports that use macros for sorting the data rows. The macros work when I am in excel and run after I refresh OneStream, however, when running the report in a book and generating to PDF the sorting macros are not running correctly. We have found that different preference settings within the excel add-in help with getting the macro to run in Excel, but I haven't been able to figure out why it's not working in the book. Any help or ideas appreciated!How do I return description to XFBR from a multiselect prompt?
We are using the multiselect tool to gather certain entities for reporting, which will show up in rows in a cube view. We're returning to the cube view the values from the multiselect via an XFBR. When the user chooses the entities, we can't get the resulting members in rows to show as description, only as member name. Anyone know how to return the description in a cube view/report?
