Reporting

Hi, I'm trying to understand the best way to add annotations and comments in OneStream to explain variances. Last week at splash I was advised to use V#Annotation or V#VarianceExplanation.  But what I'm confused about is how do you actually get it connected to the calculated variance (red box), versus only being able to connect it so the actual reported number (yellow box).  Right now I'm using a get data formula in my quick view to calculate the variance (GetDataCell(S#Actual-S#AOP):Name(Variance)).What are other people doing when trying to provide commentary on variances?  Whats the best way to use this view?  

We have a large flat hierarchy, members starting with Px_1000 to Px_9999. For example, P1_1000_27 Project 1, P5_1001 Project Yellow.... P7_9999 Project Bob. The numbers are unique (no two same number). We want a report that allows users to enter a "From" - "To" to pull back members in that range. For instance, only pull back members in the range "From" 500 To "532". Have an XFBR where I'm parsing the string, that's working, looping through and but only returning the number. The issue is that I need the entire string and description of the member. That's where I'm stuck. If anyone has done this before, would very much like know how you coded the XFBR. Thank you!

Hi all,Do you know how to get the member description in a scpecific language using the Excell add-in? I suppose that it can be done using the "XFGetMemberProperty" but I can't find an example.Thank you. XFGetMemberPropertyThis function retrieves any Dimension Member property from the Member Properties tab in the Dimension Library. Note there are no spaces used when defining property name.XFGetMemberProperty(“DimTypeName”,“MemberName or Script”,“PropertyName”, “VaryByCubeTypeName”,“VaryByScenarioTypeName”,“VaryByTimeName”) As a reference when using BR: Get member description in user's culture code | OneStream CommunityBest regards,Carlos

I am using a Cube View (IS) within a dashboard. The client does not want users to be prompted with parameters for selecting Entity, Time, or View. Instead, they expect these dimensions to be driven automatically by the Workflow Point of View While I’ve successfully applied WF  Time and View dimensions in the CV to align with the Workflow POV, I’m encountering an issue with the Entity dimension. It does not respond to the Workflow POV such sd WF, WFProfile, etc..  I either have to hardcode it, or use the Parmeter. Can I create a parameter that does not prompt a user make a selection?

I have some users who can't see the Map Transformation Report under the Application Reports.   I have check their POV (looks correct), can't find anything under Dashboard security.  Anyone have any suggestions as to why they can view some but not all the application reports?  The POV appears to be set properly and they can view the transformation rules other ways, so I don't think it's a security setting.  At a lost, has anyone encountered this?

I am trying to build a quick view where the Member Filter refers to a parameter but E#|!prm_Entity!| produces this error in Excel: #ERROR - The member filter contains unresolved parameters.    

Is it possible to create a dynamic calc UD8 dimension, that then filters down the members on the Account dimension at a base level? (and if so, how?) For example, within the Account dimension, I have Member A, Member B, Member C and Member D.Can I create UD8 dimensions of "Group 1" and "Group 2" where if Group 1 is selected, it filters down Account to only show Member A and Member B. And if I choose Group 2, it filters Account to only include Member C and Member D. I know this can be accomplished with an alternate hierarchy on the Account dimension but just checking to see if this can be done alternatively.  Thanks in advance!

Hi Team,I have scenario where the data is already loaded to system and now i just want to upload comments for that data. How we can achieve this to upload the comments only not entire data again with comments.Thank you..!!

Hello, I created a dashboard with 3 different embedded dashboards. 2 are non-cube views and 1 is a cube view. I would like my parameter to only prompt and be able to be changed when I select the third tab.  Is there a way possible to accomplish my idea or am I stuck with the prompt happening when I select the dashboard? I've tried changing the dashboard types thinking it would default to what the other dashboards are but it still gives the parameter prompt on the first dashboard tab. Thanks, Will

Hello,Is it possible to add dynamic calcs (UD8 member) into an XF doc powerpoint? I am trying to create an XFCELL that uses a variance member in UD8. However, I keep getting 0 as the value.Also, is there a way for a user to see the settings/parameters once an XFdoc is downloaded from OS? I saw an example in GolfStream, but it's only the final document (or appears to be).Thank you!

HowdyI want to apply a Zero Suppression Threshold (of 1,000) in a Cube View for a specific column.However, the Account in my column is a Dynamic Calc. The suppression isn't working at all, can someone confirm if Zero Suppression Threshold is only available for Stored Data?If it is only available for Stored Data, is my best option to use a Member Formula instead of a Dynamic Calc? I've tried using Cube View Math as well but I get the same result as using a Dynamic Calc.Thanks in advance

Hi everyone!I am working with a Pivot Grid dashboard item in the BI Viewer. I am investigating about the possibility of formatting the Excel export of this component. Currently, the exported file does not retain the formatting applied within the BI Viewer, resulting in a very non-user-friendly layout, with fixed column widths. Are there any options available?Any insights will be highly appreciated! :) Thank you!Have a nice day,Andra

Hi,we would like to show the periods based on on the "Number Of No Input Periods Per Workflow Unit" Scenario setting. Suppress if "No Input"Is that possible?Roland Weiss  

Hi,Is there a keyboard shortcut (like CTRL + R) to refresh the page in data explorer?We have reports which runs with parameter and we would like to know if there is any keyboard short cut to call parameter pop pup or refresh page?  

Hi all,  I am implementing Guided Reporting into our workflows. The entity parameter I have is a member list looking up E#Root.WFProfileEntities.  The cube view is a pretty standard balance sheet, with row and column sets. I have embedded it into the workflow, so that users can come in and use their reporting for the specific entities.  The issue I have is that whenever I open the balance sheet and set the rows and columns, the cube view always defaults to the Group Parent entity, even if the WF profile has different assigned entities. I change workflow, and it still shows the parent entity. It's only when I change the entity manually from the GR parameter button that it refreshes.  Any idea how to link the entity button to set the cube view upon first run? Maybe I'm missing something, or maybe there is a BR that I can build? Thanks!

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? 

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?Thanks

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 include

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 2025I 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 ?

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 indiv

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!        

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: MonthMay 2024Jun 2024Jul 2024Aug 2024Sep 2024Oct 2024Nov 2024Dec 2024Jan 2025Feb 2025Mar 2025Apr 2025Sales102030102030102030102030   I'd like this: Time PeriodLast 12 MonthsAggregate Sales240 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,

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

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?   

Hello,On version 8.5 (could be earlier, but didn't have a need to try) I am trying to create an embedded cube view that retains excel formatting. When I check mark the preserve excel format this works, BUT when I save the report, close it, and reopen it the cube view itself stays a light font vs black. Once I uncheck preserve excel format it reverts back to the expected black font cube view.....Is this a known issue or a way around it?