Recent Discussions
Top Ten and All Other
Hi. I have a cube view / customer sales report where I can get my top ten customer sales, and I have a row that has the total sales. How can I make a row to show 'All Others' so I can foot the lines to the total sales? I've tried a CVR calc but it pulls in the top customer only. Thanks, Brian
Guided Reporting Duplicate Param Dialogue Box Showing on Run or Param Change
Hi OneStreamers, I'm currently working with the Guided reporting solution in OS v8.4.0. When running the report in the GDR homepage a duplicate dialogue box appears after the Guided Reporting Dashboard is selected via the OnePlace menu item, once a report is selected, or after a Parameter is changed anytime the Parameter combo box is changed. Each Parameter is set up a Member list at the moment but were previously discovered as Member Dialogue, and now rediscovered as the updated Member list param. Any Idea what I could be missing?
book with PPT file donot run
hi team, I hope you are well. I'm creating a book with Word and PowerPoint files but the Powerpoint shows an error and the parameters are the same in both files: If I select the file on OnePlace is running opening PowerPoint application. here is the error: Value cannot be null. (Parameter 'buffer'). User Interface Stack Trace: at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc) at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout) at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(MethodInfo targetMethod, Object[] args) at generatedProxy_6.StartGetFile(SessionInfo, FileSystemLocation, String, Boolean, Boolean, Boolean, Dictionary`2) at OneStream.Client.Api.Wcf.FileExplorerServiceReference.FileExplorerServiceClient.StartGetFile(SessionInfo si, FileSystemLocation fileSystemLocation, String fileFullName, Boolean includeContentFileBytes, Boolean processExtensibleDocument, Boolean convertToPdf, Dictionary`2 customSubstVars) at OneStream.Client.SharedUI.FileLauncher.ProcessAndLaunchFileSystemFileUsingWPFClient(SessionInfo si, FileSystemLocation fileSystemLocation, String fileName, Boolean processExtensibleDocument, Boolean convertToPdf, Dictionary`2 customSubstVars, FileLaunchType fileLaunchType) Do I need some different for pptx file? Thanks in advance and Best regards. Mario GCube View formatting
Have a question regarding Cube view formatting. The client has a column for comments where large commentaries are written point wise which currently are seen as one line. They want to view the same like excel where comments are seen point wise one below another. How can the same be done. Also while exporting the report in excel the wrap text option in the Column cell format under excel only wraps the entire cell but it does not show the comment point wise one below anotherXFGetMemberProperty
Hi Team, How does XFGetMemberProperty works in Excel AddIn? The fields in the formula I have are - MemberNameorScript PropertyName VaryByCubeTypeName VaryByScenarioTypeName VaryByTimeorTimeDimProfileName I want to pull the properties for Text 1 to Text 8 from OneStream Production for Entity, for different Time Periods like Default, 2023, 2024 and 2025. Now the properties I pulled at Default are giving correct result. But when trying to pull at year level like 2023, 2024 and 2025, I am not getting the correct data. It is only showing the data present at Default. But in OneStream Prod, I do have data in 2023, 2024 and 2025 for the Text Tags. In my formula, I was setting VaryByTimeorTimeDimProfileName = "2023". And so on for 2024 and 2025 I am getting the same thing for XFGetMemberPropertyVolatile formula as well. In OneStream my year values are stored in 'Stored Property Value' Can someone please help me here ?
How to run calculations on all base members in a DynamicCalc
After having read a lot of this superb forum to discover OneStream, I'd like to ask you my first problem that I haven't managed to solve. I'd like to forecast sales for month M in relation to actual sales for month M-1 (if imported), or alternatively the M-1 budget, to which will be added management sales. If I perform this calculation in the view cube of the child entity, it replaces the actual M-1 with the budget when the actual M-1 does not exist (not imported). If I perform this calculation at parent entity level, entities with no M-1 actual are shown at €0 and not at the amount of their budget. I therefore end up with a sales figure that has been reduced by the number of companies that did not report sales in M-1. In my forecast calculation UD7, I was thinking of looping through each base member so that the condition calculation (if the actual is absent then takes the budget, otherwise takes the actual) so that the forecast sales figure displayed corresponds to the sum of the individual calculations, but I can't do it: Dim Entité As String = api.Pov.Entity.Name Dim EntitiesList As List(Of Member) = api.Members.GetBaseMembers(api.Pov.EntityDim.DimPk, api.Members.GetMemberId(dimtype.Entity.Id, Entité)) For Each Entity As Member In EntitiesList CA_M_Antérieur = api.Data.GetDataCell("E#" + Entity.Name + ":S#REEL_Gestion:T#POVFirstInMonthPrior1:A#R70600_020:U7#Conso:U8#PF_Restit").CellAmount The calculation works when I select the child entities, but not for the parent, which returns 0. Do you know how I can do this calculation for all the base children?
Cube View - Conditional Formatting
Hi everyone, I'm currently working on a Cube View and would love some help with setting up conditional formatting based on a comparison between two columns. Specifically, I’m trying to highlight in red any cell in the “Actuals” column (Actual CPK @ ACT 2024 rate, Jan 2024) where the value is greater than the corresponding value in the “Cost per kg” column. To give you a clearer picture, I’ve attached a screenshot showing the layout I’m working with. The "Cost per kg" values are budgeted figures, and I'm comparing them to actuals from 2024 to identify any overages. I’d like the Cube View to visually flag these instances, so they stand out during reviews. Of course, the numbers in both columns are exemplary. In the rows I have different Entities. Has anyone done something similar or can guide me on the best way to achieve this? Thanks so much in advance for your support!
