Announcement
ABC
Recent Activity
Button Parameter Not Resolving in 8.4.4
Our two environments are currently on different OneStream versions. DEV is on 9.1.1 and PROD is 8.4.4. We have an upgrade scheduled to get them in sync soon. However, currently facing a parameter resolving and passing issue while trying to migrate some functionality from DEV to PROD. All setups are now equal between the two applications for the workspace that I moved over to PROD. However, I believe version 8.4.4 is having some trouble resolving parameters being passed to a button click that I have on the same dashboard. I have a button whose "Selection Changed Server Task" is set to "Execute Data Management Sequence" and "Selection Changed Server Task Arguments" is set to "{FilteredForecastRollforward_ButtonRan}{SelectedContracts=[|!param_SelectContracts!|]}". Within 9.1.1 DEV this data management sequence runs no problem an receives the value of "Contract1" upon logging. However, in 8.4.4 PROD this parameter is not resolving properly and comes as "|!SelectedContracts!|" in the error log even though the setups are identical. Upon checking the 9.1.1 release notes I noticed that there was a fixed issue number "PF7-9772" under "Dashboard Components" that states "Button Component: The Button dashboard component respects the Selection Changed Server Task value, ensuring that Business Rules are run on the designated servers as configured. (PF7-9772)". Could that fix number be related to my problem? Does version 8.4.4 have a known issue with resolving these parameters. And if so, is there a workaround or do I need to wait until our upgrade for this to be resolved? Button: DM Sequence:
ReportBackgroundColor not filling the entire cell when viewing the report as a PDF
Hi, I am encountering an issue with the header format of the 'Total' row below where the ReportBackgroundColor is not filling the entire cell when viewing the report as a PDF. There is no issue when viewing view the cube view or Excel. Below is the header formatting we're suing: ELSE IF (RowName Contains ':Total:') THEN ExcelBottomBorderColor = Black, ExcelTopBorderColor = Black, ExcelTopBorderLineStyle = Thin, Italic = True, ReportBackgroundColor = Gray, ReportUseBottomLine1 = True, ReportUseTopLine1 = True I'm using the same formatting for Header and Cell Format but as you can see from the screenshot below, there is a blank space below Total. Has anyone encountered this?
The OneStream Podcast: Partner Spotlight - Nova Advisory available now!
1 MIN READ With CPM Express, OneStream has provided customers with an accelerated implementation that packages decades of experience and best-practices into a rapid-deployment (8-12 weeks) that’s quick to configure, providing predictable cost and time to value to streamline your finance processes. On this episode of The OneStream Podcast, Liz Weir and Matt DeCarlo from Nova Advisory join Peter Fugere to discuss their experiences and successes implementing CPMx for their clients.
Parameters not working in cube views
Hi all, I'm having a strange problem with cubeviews. I created some parameters to apply a standard formatting to my cube views: when I use them into the cubeview and I launch it, though, they appear in the initial popup without any value, as if they were user input params: am I missing something? is there anything I need to configure to make them work automatically? Any help is appreciated!
Systems Diagnostics - Database Sizes math?
Does anyone know how Used (GB) and Unused is derived? Maybe I'm wrong, going to assume it's looking at total_size, total_used, reserved_pages, ect.. Trying to figure out the math, and questioning if it's correct. This is what I have so far, any feedback is appreciated! Dim sql As String = "SELECT " & " DB_NAME() AS DatabaseName, " & " CAST(f.total_size * 8.0 / 1048576 AS DECIMAL(10,2)) AS TotalSizeGB, " & " CAST(f.total_used * 8.0 / 1048576 AS DECIMAL(10,2)) AS UsedByFilesGB, " & " CAST((f.total_size - f.total_used) " & " * 8.0 / 1048576 AS DECIMAL(10,2)) AS UnallocatedGB, " & " CAST(s.reserved_pages * 8.0 / 1048576 AS DECIMAL(10,2)) AS ReservedGB, " & " CAST(s.data_pages * 8.0 / 1048576 AS DECIMAL(10,2)) AS DataGB, " & " CAST(s.index_pages * 8.0 / 1048576 AS DECIMAL(10,2)) AS IndexSizeGB, " & " CAST((s.reserved_pages - s.data_pages - s.index_pages) " & " * 8.0 / 1048576 AS DECIMAL(10,2)) AS UnusedGB " & "FROM ( " & " SELECT " & " SUM(size) AS total_size, " & " SUM(FILEPROPERTY(name, 'SpaceUsed')) AS total_used " & " FROM sys.database_files " & ") f " & "CROSS JOIN ( " & " SELECT " & " SUM(a.total_pages) AS reserved_pages, " & " SUM(CASE WHEN p.index_id IN (0,1) " & " THEN a.used_pages " & " ELSE 0 END) AS data_pages, " & " SUM(CASE WHEN p.index_id > 1 " & " THEN a.used_pages " & " ELSE 0 END) AS index_pages " & " FROM sys.partitions p " & " JOIN sys.allocation_units a " & " ON p.partition_id = a.container_id " & ") s" Here's the output --- Level 1 (Total) --- TotalSize: 1394.27 GB UsedByFiles: 228.51 GB Unallocated: 1165.75 GB (83.6% of Total) LogFile: 1.67 GB (0.1% of Total) --- Level 2 (Reserved) --- Reserved: 226.85 GB (16.3% of Total) UsedGB (Data+Index): 221.60 GB (15.9% of Total) Unused: 5.25 GB (0.4% of Total) --- Level 3 (Used) --- Data: 129.73 GB (9.3% of Total) IndexSize: 91.87 GB (6.6% of Total) --- Math Checks --- Total=Reserved+Unalloc+Log: 1394.27 = 1394.27 → True Reserved=Used+Unused: 226.85 = 226.85 → True Used=Data+Index: 221.60 = 221.60 → True
Passing Entity in a Cube View Row to an XFBR in a Cube View Column
Hi all, I have an XFBR that I would like to take the entity member in any given row in a cube view. I've tried |MFEntity| but that doesn't work. |CVEntity| and |POVEntity| don't work either since they can only pass a single entity for a given cube view. Is there a way to get what I need outside of manually doing a column override for every single row in my cube view and hard coding the entity that I need to pass to the XFBR?CPM Express GAAP PV920-SV100 is now available on Solution Exchange!
1 MIN READ The Express Development team is excited to share that CPMx GAAP (PV920 SV100) was released on March 25th! Whats new in GAAP? This latest release focuses on introducing new planning calculation settings, enhanced What-If Analysis, alias functionality, and Workforce Planning Express integration, along with various backend updates. Want to learn more? Read: Review of the release notes and product documentation on the Solution Exchange. Want to get involved? If you are a customer and are interested in how CPM Express is used, please contact your implementation partner or Customer Success Manager. If you are a partner and would like to learn more about CPM Express, please contact your Partner Alliances Manager. Looking for Training? Instructor-led training is now available and coming late this spring. Check out the details in Navigator. Have feedback? If you have feedback or receive it from customers or prospects, please share it with the team via this link so we can continue improving the solution.
