OneStream Community

benmac360 · 01-04-2024

Hello - I'm working on a cube view that will be used to add variance commentary. The rows have accounts and subtotals, the first column will have a specific entity that will not change, then the next set of columns will be dynamic. I have it set to p...

benmac360 · 12-04-2023

Hello - I created a dynamic UD8 calc for a cube view that shows 12 months of actual, forecast and budget periodic amounts. The calc is designed to show zeroes in the actual scenario column for a period if its POV time is greater than than the global ...

benmac360 · 10-05-2023

Hello - I have a cube view that I created a connection to in Excel. The cube view has an O#Forms POV with a column configured to enter comments - can modify data is set to True, it has a V#VarianceCommentary member, etc. During testing I am able to s...

benmac360 · 08-07-2023

Hello - I have a cube view that currently has two columns. The first is just base members of an account hierarchy, and the second is a dynamic calc UD8 that retrieves the text 5 value for each account stored by scenario type. The UD8 is working and p...

benmac360 · 05-11-2023

Hello - we recently updated the stored values in the Percent Consolidation property in several large entity hierarchies, so there are 3 stored items with different time periods for each child. We found today that when we pull data using a YTD view, w...

benmac360 · 01-04-2024

Hi db Yes - the member filter I have for the first dynamic column is E#TopEntity.base.Where (Text8 Contains [DP_|WFYear|Q4]), and for the second its the same syntax, except the Text8 is AQ_|WFYear|Q4. The second dynamic column is being suppressed sin...

benmac360 · 12-05-2023

I added a couple error log message functions and found the issue was with pvTime - it was returning zero. I made an adjustment to the code by using api.Time.GetPeriodNumFromId for the POV time instead and it now returns the correct month. I reran the...

benmac360 · 08-08-2023

Hi Mike - the only column definition I currently have is the dynamic calc UD8 member, along with an Annotation View dimension to display the text. The Text 5 values stored in each account are workflow profile names that all have the following format ...

benmac360 · 05-24-2023

Yes, that's correct, its a question of why are we seeing these amounts in future months just for these 3 structures. I'll have our business rules reviewed, see if any recent changes were made. Thanks for your help!

benmac360 · 05-17-2023

Here's another screenshot of 2 quick views for the detail - the first shows the periodic amounts and a sum of these amounts in the next column. The second quick view shows the YTD amounts which tie to our hierarchy validation. You'll notice there's n...

OneStream Community

User Statistics

User Activity

Cube View - Return Blank Columns Where No Members Have a Specific Text Value

UD8 Dynamic Calc - Show Zeroes in Cube View column based on time period comparison

Excel - Connection with Cube View that has Column for Variance Commentary

Cube View - Split Delimited Stored Item Text into Separate Columns

Incorrect Consolidated Data

Re: Cube View - Return Blank Columns Where No Members Have a Specific Text Value

Re: UD8 Dynamic Calc - Show Zeroes in Cube View column based on time period comparison

Re: Cube View - Split Delimited Stored Item Text into Separate Columns

Re: Incorrect Consolidated Data

Re: Incorrect Consolidated Data