Recent Discussions
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?rsacco2 hours agoNew Contributor47Views0likes3CommentsBI Viewer Dashboard not displaying for Specific User
Hi Community, We are encountering an issue where the BI Viewer dashboard is not displaying for a specific user, while it works perfectly for all other users. Interestingly, when we add the data adapter used in the BI Viewer to a grid view, the dashboard displays correctly. However, it fails to display when using the BI Viewer component. Can anyone provide any insights into what might be causing this issue? ThanksSolvedRithik_Prem18 hours agoNew Contributor III276Views0likes3Commentsbook 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 GMarioGV2 days agoNew Contributor III78Views0likes1CommentCube 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 anothernupur3 days agoNew Contributor33Views0likes1CommentXFGetMemberProperty
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 ?pratyaydas3 days agoNew Contributor39Views0likes1CommentHow 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?JérémyRenard3 days agoNew Contributor38Views0likes1CommentCube 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!anna_oleksy3 days agoNew Contributor18Views0likes1CommentCube View Column that contains aggregate of the last 12 months
Hi all, I'm trying to create a Cube View with a single column that aggregates data for the past 12 months, rather than showing each month separately. Instead of this: Month May 2024 Jun 2024 Jul 2024 Aug 2024 Sep 2024 Oct 2024 Nov 2024 Dec 2024 Jan 2025 Feb 2025 Mar 2025 Apr 2025 Sales 10 20 30 10 20 30 10 20 30 10 20 30 I'd like this: Time Period Last 12 Months Aggregate Sales 240 To do this, I created an XFBR business rule that returns a time range like T#2024M5:T#2025M4 Here’s the relevant part of my XFBR: If args.FunctionName.XFEqualsIgnoreCase("Trailing12Months") Then Dim baseYear As Integer = args.NameValuePairs("year") Dim baseMonth As Integer = args.NameValuePairs("month") Dim endDate As New DateTime(baseYear, baseMonth, 1) Dim startDate As DateTime = endDate.AddMonths(-11) Dim startMember As String = String.Format("T#{0}M{1}", startDate.Year, startDate.Month) Dim endMember As String = String.Format("T#{0}M{1}", endDate.Year, endDate.Month) Return String.Format("{0}:{1}", startMember, endMember) End If I confirmed the XFBR returns the correct string, and I’m using it in the Member Filter of the Time column in the Cube View. However, the Cube View only shows data for the last month instead of aggregating all 12 months. My Question: Is T#YYYYMn:T#YYYYMn a valid range for Cube View member filters? Is there a way to achieve what I'm trying to do? Thanks in advance for any advice!Solvedmireles3 days agoNew Contributor III13Views0likes2CommentsQuickview: 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 Text1Marco3 days agoContributor II16Views0likes1Comment