Reporting

Hey all, So i'm trying to solve the display name of a view member in a cubeview column. I manage to change the display name by using Delimited List by changeing display name in parameter dropdown to "TTD" in this case. However the membername in the cubeview column is still the original membername in the dimension (Trailing4Months). I tried Member List as shown on prontscreen below. I did also try the condition rules in the cubeview but did not find any returning input of display name. I think I could solve this with XFBR but wanted to check here first to see if there are any "Built in" solution to handle this? Thanks in advance     

Hi,   I am trying to use the XFGetHierarchyProperty Spreadsheet function to return the "Parent member name" property of a member.   I tested the function by returning the HasChildren property and that is working fine.   However, how do I return the "Parent member name" property? Is that possible and what should I use as property string in the function? (the one below is not working and returns an error as you can see)   Thank you

Hi All Is there a way to set default date to Now() in the Date Selector component of the Dashboard? Thanks,

Hello, I have created a Workspace with is Shareable Workspace set to True (workspace 1). From another workspace/ cubeview group/ cubeview I would like use the row from a cube view in workspace 1. I am not using parameters in the cubeviews (yet). If I run the main cubeview I get the error message What can cause this is? Do I need to reference in row sharing to a specific workspace? Regards, Arjen

Hi,I'm trying to set the number format in the Cube Views for negative numbers with gaps instead of a minus.The User culture is in Spanish because I need the decimals with the comma.I don't find how can I customize the format for that because N1 is not an option because the negative numbers appear with a minus.Thanks,

Testing

Hi, Is there a way to format the options in a member list parameter to only display the member description? I've tried using :Name(|MFUD1Desc|) but this doesn't change the outcome visible to the end users. Thanks,

Hi Team, Can any one help on this. I have text in the cells, so based on my text have to apply the conditional formatting. if my cell has "YES" text then should be Green color, if my cell has "NO" text then should be in RED color.  Can any one please help us to get the result.

I have a UD8 dynamic calculation that returns different results based on the UD2 member value. E.g. If UD2 = Houston, return "A#:Total_Expenses:S#Plan...." This works well using api.pov.UD2.Name for normal member intersections, but it's not applying correctly for GetDataCell calculations. By using the Cell POV button on the cube view, I can see that the GetDataCell rows have a POV set to the cube view POV. How can I have my Dynamic Calc read the UD2 value inside the GetDataCell?There is only one UD2 member referenced inside the GetDataCell. The GetDataCell format is as follows: GetDataCell(A#Total_Expenses:S#Actual:U2#Texas - A#Operating_Expenses:S#Actual:U2#Texas):name(Net Texas)

Hello All, I have a case where I need to show workflow assigned entities into dashboard using Data Adapter method query. For example: Base Input WF Entity assignment Workflow1 Site1, site2 Workflow2 Site3 Workflow3 Site4, Site5, Site6 So, whenever I am selecting workflow1, the entities assigned to this workflow should list and come as output. Kindly help to advise some options here. Thank you.

Anyway to display text value in Cubeview without creating UD8 member.I was able to filter using text in row but I want to display what does it mean to make it more presentable.    

We use the REST api to retrieve balances from our accounting consolidations in onestream.   I've noticed that for the current year, these account balances can be retrieved quickly. But for prior years, it takes a lot longer to retrieve them.  For example, I can run cubeviews against the 2024 data and get ten branches in about 80 seconds.  But if I run the exact same cubeviews against 2023 or 2022, then it gets increasingly slower (160 seconds for the same ten branches in 2022). Is there some reason on principal why the balance data would take so much longer to retrieve in past fiscal years?  Is the cubeview doing some sort of dynamic calculation to retrieve balances?  (maybe it is incrementally subtracting activity from balances in 2024, and that dynamic calculation takes longer as we report further back in time)? We are running OS 8.2.2.16127. The difference in execution time seems specific to G/L balances.  For G/L activity (the movement of the acco

Hello, I currently have a dynamic formula that pulls the max value, but was asked to use that formula to get the absolute value that is also a negative the highest amount to pull that value as well instead of being 0.  Here is the current formula I'm using Dim dAmount_1 As Decimal = api.Data.GetDataCell("T#Pov:U8#None").CellAmount Dim dAmount_2 As Decimal = api.Data.GetDataCell("T#PovPrior1:U8#None").CellAmount Dim dAmount_3 As Decimal = api.Data.GetDataCell("T#PovPrior2:U8#None").CellAmount Dim dAmount_4 As Decimal = api.Data.GetDataCell("T#PovPrior3:U8#None").CellAmount Dim dAmount_5 As Decimal = api.Data.GetDataCell("T#PovPrior4:U8#None").CellAmount Dim dAmount_6 As Decimal = api.Data.GetDataCell("T#PovPrior5:U8#None").CellAmount Dim dAmount_7 As Decimal = api.Data.GetDataCell("T#PovPrior6:U8#None").CellAmount Dim dAmount_8 As Decimal = api.Data.GetDataCell("T#PovPrior7:U8#None").CellAmount Dim dAmount_9 As Decimal = api.Data.GetDataCell("T#PovPrior8:U8#None").CellAmount Dim dA

Originally posted by Karen LiauHow do retrieve Account member description when using Spreadsheet XFGet info formula?

  I tried to refresh cube view using macro, the cubeview connection parameter is not refreshing based on macro buttion is there any code to refresh delimited list parameter pop up after clicking the macro buttion So i can change the combination in the parameter and run. currently i am using the below code.    Set xfAddin = Application.COMAddIns("OneStreamExcelAddIn")If Not xfAddin Is Nothing ThenIf Not xfAddin.Object Is Nothing ThenCall xfAddin.Object.RefreshXFFunctionsCall xfAddin.Object.RefreshCubeViewsCall xfAddin.Object.RefreshXFFunctionsCall xfAddin.Object.RefreshQuickViews'Call xfAddIn.Object.SubmitXFFuntions'Call xfAddIn.Object.RefreshXFFunctionsForActiveWorksheetEnd IfEnd If

How can I change my dates(month,year) in my reports based on cube views. I want to modify directly on the reports. Could someone please help me with that? Or how to create to POV bar (screenshots in where is located)

Hi,  I have been working on creating reports for some time and after trying different options I have some questions: Mainly: how are the reports created by default? How did you solve (usually) the problem of the comments?  I had originally planned to work with Books but they have (IMHO) limitations in the format or the comments are not displayed well, so I have ended up in Excel where the CVs are retrieved and commented. However, I have many reports that often only change in the query (MTD, YTD, segments) and I would have to create a CV for each report (I have also done this but it is getting confusing, therefore I would need to save some of them). How should I most efficiently create reports where I explain deviations in the products, deviations in the P&L at monthly and annual level (and this for several UNITS) and deviations in the balance sheet? BTW What is the best way to upload the comments in Onestream from Excel? Is there a good PDF manual with all of this informa

Hi I'm currently reviewing the functionality of the Narrative Reporting and need some guidance with it. Per the option to insert content within a document, I have managed to get a Cube View to be active within the doc but cannot get a report component to generate?  I also managed to get the XFCell reference to work. The following is what I have used for a CV generation, which works fine: However, the actual syntax provided does not match what actually needs to be applied for it to work in the doc (i.e. see below provided syntax): Is there a list of what full syntax should be used for each of the categories listed in the Insert Content option? I've tried to use the same as the CV generation for a Report Component but that doesn't appear to work (as follows): {DOCVARIABLE "{XF}{Application}{Report}{rpt_FSR_BS_8_8_1}" "" ""}   Any help with this would be much appreciated?   Thanks

Hello, A client recently asked if it’s possible to create an 'exception cube view' based on an existing main one. The main cube view includes both positive and negative amounts across rows and columns. The client specifically wants the exception report to display only the negative values. To address this, I created a UD8 dynamic calc member that returns the U8#None value if it's negative and returns nothing if U8#None is positive. I then applied this new UD8 member to a copy of the main cube view, ensuring suppression is enabled. While this works well for smaller reports, the performance suffers with larger reports due to the nature of dynamic calculations. I also applied the classic formatting where positive amounts are transparent but it leaves the report with a lot of rows and columns that have the text transparent. Any other ideas on how this can be achieved?

Is there a non-admin role in onestream for health/performance monitoring, without any admin rights? Else is there a REST API to auto-export the "tasks" and "errors" logs on a recurring basis?     FYI, Since our recent v8 upgrade, my REST api calls to the onestream service are failing with intermittent and unexplainable issues.  The api never returns anything helpful in the way of an error message.  I only get 5xx codes with no content bodies.  I'm assuming that any information that may be relevant is found only by digging into the nullreferenceexception's (in the adminstrative tools found in the front-end U/I below)       ... while software developers should not be able to administer a production environment, we should be able to at least investigate these random and unpredictable errors (internal server errors).  I'm hoping there is some sort of read-only role for that, or at least an API to export the information that would otherwise be f

Hi Team, Please help us if any possible way for below requirement. I have multiple rows and columns. here, If my three columns "Time 3(D2), Time 4(E2) & Time 5(F2) are have zero data, then Row "Entity 1(A2)" should get hide. i have tried CV suppression setting but it is suppressing the row when the entire row have zero or No data. Kindly let me know if any other setting needs to apply.    

How to create a financial report? What tools do i need to create one in the platform

Hi everyone, We have a cube view with three rows structured as follows: Row1: E#Parent1.Children:U1#Member1 Row2: E#Parent1.Children:U1#Member2 Row3: Variance between two columns. To handle this, I created an XFBR that dynamically generates a string based on the number of children for the user-selected parent (Parent1 as a parameter). The generated string will look something like this: GetDataCell(CVR(Row1,1) - CVR(Row2,1)), GetDataCell(CVR(Row1,2) - CVR(Row2,2)), and so on. We have three columns in the same cube view: two data columns and one text column. The text column uses the U8 member as a dynamic calc member, which returns a string. In the variance row for the text column, I'm getting a blank instead of a string. I’ve tried different row override methods using XFBR and XFCell, but haven’t had any success. I suspect that GetDataCell might be causing the issue, but I wanted to ask for some guidance. Has anyone encountered this problem, or does anyone have any suggestions? Your inp

delete button/icon is greyed out to delete assemblies. how can an assembly be deleted?

I am building a UD8 dynamic calc to bypass the limit of 4 cube view overrides. The calculation will read the referenced member (e.g. A#Net_Income:S#Actual) and return a different member intersection (A#Net_Income:S#Plan2024) In order to return the correct plan scenario, The UD8 member must read the time parameter used in the cube view. This functionality exists, but is throwing an unexpected error. My parameter exists in the default workspace. To pull my literal parameter value, I have the following code: TimeParameter = "Param_Time_LitValue" Dim TimeMbr As String = BRApi.Dashboards.Parameters.GetLiteralParameterValue(Si, False, Guid.Empty, TimeParameter) TimeMbr returns the value "Unknown". From my research, this error occurs when you reference a parameter that is defined in a different workspace, which is not the case here. I would appreciate advice on what I am doing wrong. The sample code I am following is found within BRAPI>Dashboards>Parameters. The sample says that the Tim