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 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
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.
Conditional 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 only
Unable 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!Derived Values Consolidating
I'm having an issue in which derived YTD values are consolidating in their period and it is throwing off our results. In the example below which shows expenses by department for a site, there are no longer expenses for the Mfg_Selling dept in M2. OneStream calculates the derived YTD values of -37905 (0 - the prior period expense of 37905). This I understand. What I don't understand is why that value is consolidating up the hierarchy when the view is set to periodic. NOTE: I know how to hide the derived value in Mfg_Selling/M2, it is shown here for illustrative purposes.Troubleshooting FlipSign
Hi all, I'm trying to build a trial balance that shows line items in their natural debit/credit balances (e.g. - revenue, liabilities, and equity showing up as negative, and all else showing up as positive to arrive at a balanced ($0) report). However, we have some contra-accounts within our Accrued Expenses roll up that should show up as debits instead of credits. The accounts all begin with JDE_1 so I thought I could use the IF statement below to change the formatting for them, but the IF doesn't change anything (everything shows up as a negative, rather than accounts beginning JDE_1 being positive). Does anyone have any ideas as to what may be going awry? This IF statement has worked in other cube views that I've built, so I'm at my wit's end as to why it wouldn't be working here! If (RowE1MemberName StartsWith 'JDE_1') Then FlipSign = False Else FlipSign = True End IfFormat 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!
