Reporting

Hi, Can someone point me to a syntax cheat sheet for formatting cube views and reports in Excel? I'm trying to get this number to show in thousands and have my negative numbers be in red with parentheses, and I'm super close, but I have this odd space at the end I can't seem to solve.  ChatGPT got me here:  ExcelNumberFormat = [#,##0,_);[Red](#,##0,_))] But it's stuck there. 

I am trying to configure a data adapter through the service factory. The assembly containing the services factory is on another maintenance unit. The assembly is WsasFactory and when attempting to bring the data set into an adapter it can't seem to find that object reference to the assembly. The assembly and service factory are configured on each maintenance unit and workspace as shown: MyAssembly.WsasFactoryWhen attempting to bring it into the data adapter I have tried using...{WSMU}{MyDataSet}{}{WS}{MyDataSet}{}{Workspace.Current.WS}{MyDataSet}Yet, I keep getting this error for each reference shown above - Error processing DataSet 'MenuNavPM'. Unable to find the Workspace Assembly Service Factory class for name 'WSMU' in Workspace Is there a reference special for using the service factory between maintenance units I am missing? 

Hello, Would it be possible for me to generate a CubeView using multiple cubes? I know it would be possible using an XFGETCELL since we have to point to the specific cube in the formula. We are currently utilizing a single cube with all the parent and base level members in our dimensions and are transitioning into 2 Cubes (1 for the summary/parent level and 1 for all base level members). Our existing reports for example A#NET_INCOME.treedescendantsinclusive would work fine in our single cube, but it may not work when we move the parent & base level members to separate cubes.

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

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

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 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 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,

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? 

Hi everyone, I am creating a graph in a report. This report is a component in a dashboard maintenance unit and is using a simple data adapter linked to a cube view to retrieve the data.  The graph is working. However, I would like to only show a data label based on a time selection parameter that is part of the data adapter. For instance, if I select 2022M11, I only want to see the data label for November 2022. Please see the screenshot for clarification. So, if I select November 2022 (or any other year) I would only like to see the data label for November (I still need to work on the number formatting). Is there anyone with experience in this and can help me? I have checked all the options but couldn't find anything. I was thinking to work with the scripts part of the report components.  Any help is much appreciated. Thanks! Floris van der Poel

  I have the following cube view in Oneplace and I would like to know if it is possible to create subgroups below the Main group.  For example I would like to create a subgroup of Income Statement report, Revenue reports etc.  They are currently in separate groups in the cube view set up but that does not seem to translate to Oneplace.  We are currently on 7.3.3 and moving to 8.5 in the next month.    

Hi Team, Generally, In Scenario settings will updated the "Workflow Start Time & Workflow End Time". so here we want to get these workflow time rang in Cube View. (Eg: Work Flow Start Time: 2025M6 & Work Flow End Time: 2026M5). Based on scenario selection in  the report, we should get the (12 periods) time range in report.  Please help us to get the solution. Thank you, Shiva Prasad

We are looking to have a cube view that uses a parameter or CV Extender to possibly control the primary dimension selection. This is used in a dashboard to show metadata selections with the dimension in the rows and ud8 dynamic formulas across the columns. Looking to see if anyone has any ideas on doing the dimension selection dynamically to use one CV only for display

Hi all, I would like to set up a short description of a member so that I can apply different conditional formatting in the cube views. But I don't see such configuration in the metadata, may I know where I can setup this configuration? Thank you.  

Hi All, I'm looking for assistance to add a column title in my current BS report. Please refer to the screenshot. I have a requirement to add a Title 1 and Title 2(Highlighted in Red) in my report. TIA  

Dear all, Could you please advise is it possible to show Account Name and Description in cube view in two separate columns instead of single column?

Dear colleagues, Could you please advise why error Pov occurred in cube view calculated columns (I use formula GetDataCell in member filter in these columns) when I click save button in order to save text comments in column VarianceExplanation (this column contains member V#VarianceExplanation). When I reload this cube view again this error removes, and I also see that text was saved. See below error:  

Hi all,   Here's the situation: There are several CV with the same accounts as rows (CV1, CV2, CV3, etc.) that have slightly different columns. For each main CV, it's needed to drill down until arriving to the base. Would it be possible to set a navigation CV to a common CV with dynamic columns so that the CV can adapt to each main CV? I would like to avoid creating a CV set for each main CV.   Thank you

Where do I find documentation for the function "XFMemberProperty"? The best I've found is the Design and Reference guide. But it just asks you to refer to the "Samples tab in the Member Filter Builder."    I spend a lot of time poking around by trial-and-error,  before I am able to figure out what property names are valid.  In the cubeview editor experience, the property names aren't easily "discoverable".  Nor does it validate your expressions until you execute the cubeview.  So every time you make an invalid guess at a property name, it can cost you a significant amount of time, (depending on how quickly you can fill in the report prompts, and how long it takes for the cubeview to be rendered.)  

I have a custum tree hierarchy with multiselection,  It looks like this  Is there a way to format this component to open like this:  

I have a cubeview with 1 Row = A#NetIncome.TreedescendantsInclusiveR. I would like to have the accounts collapsed, so that the report doesn't have all the accounts/rows expanded.I have set RowExpansionMode = CollapseAll, but it did not change anything and all rows are still expanded. Am I missing some other configurations?

I have an issue that I have seen before I never figured out so want to see if others have encountered this and figure out what I am doing wrong.  I have a data adapter that calls a Dashboard Dataset BR to get populated.  I pass in a parameter like "Parameter1=|!SomeOtherParam!|".  When I use "args.NameValuePairs.XFGetValue" to get the Parameter1 value is returns "|!SomeOtherParam!|".  I expect to see the actual value of SomeOtherParam or nothing but not the literal param with pipe and exclamation mark.  Has anything encountered something like this before?

I am trying to create a label which needs to display the gross profit in my dashboard. I have created a data adapter (when running the adapter, it's showing the relevant data) and attached the same in the label. But I am not getting any data in label. Can someone help/suggest what I am missing?