Recent Discussions
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 G
Cube 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 another
XFGetMemberProperty
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!
Quickview: Exclude entity if it does not contain a Text1
Hi All. Is there a way to exclude entities that do not have a Text1 from the following? E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1).Base or E#XFMemberProperty(DimType=Entity, Member=|!PerformPnL_Entity!|, Property=Text1) Since I have that in my data management and it shows an error if it does not find Text1, I need to exclude those that do not have Text1
Trend Report showing Periodic negative balance for following month
Hi, I am building out a Trend report by year and by product, so I have Jan-Dec along the columns, and then 2022-2025 for each product type by row. My problem is that because i'm viewing this in V#Periodic, when I run the report for March 2025, April's balance shows up as the negative YTD balance for 2025. Is there any kind of conditional formatting I can use that says something like "If the intersection of month and year in the cube view (in this case, April 2025) is larger than the Time POV parameter selected when you run the report (March 2025), then change the text color to White so it doesn't show up?
