Reporting

Hi All,is there any way to clear the added comments in V#VarianceExplanation/V#Footnote using rule or any other method. I tried using rule but it's not working as expected. we are storing our comments at parent entity and mostly Top members in UD dimension , please let me know if any other information required.our intersection where we are storing the comments:E#ParentEntity:P#?:C#USD:S#ActualComment:T#2023M9:V#Footnote:A#acc:F#EndBal:O#Top:I#Top:U1#TotOPU:U2#Top:U3#Top:U4#Top:U5#None:U6#None:U7#Top:U8#Top

Need to burst out a file (ie multiple tabs) in excel to non-licensed users (ie preview of dept expenses for Fcst to managers).  I have done this with output being pdf (CV's and FXGets via Books), just not sure how to do with output being excel.  Right now I have it all working (bursting, passing parameters,...) and delivering an excel doc, just can't figure out how to convert the FXGet formula's to values.  File is getting delivered but still with the formula's.  This is when I am just using a direct link to the excel file on my App Doc's folder.  I have tried to insert the excel doc in a book but that just delivers an empty excel file.  Not sure what I am missing there.  Direct link to Excel allows the Supplied Parameters to be found and populated so I am thinking I am missing something on the Book setup. Anyway - Anybody been able to send excel FXGet report converted to static values via Parcel Service?  Can you let me know what I have missed.

Hi! We are exploring using Parcel Services for mass reporting. We would like the flexibility to create reports in Excel using XFGet formulas (as opposed to created Cube Views in the desktop) and then burst them into individual reports for different users. Is this possible, or has anyone come up with another solution for mass reporting with the excel add-in? Beth

Hi everyone,I would like to create a table with an overview of the answers given to the certification questions in the certify steps per entity.Does anybody have experience with this? I think this data is stored in one of the application tables. I was wondering if this is the 'CertifyQuestionInstances' table. Would there then be a way to translate the keys into readable data? Any help would be appreciated.Thanks a lot.Floris

Hi  I have a problem with dril Down in BI Viewer.  Part of our UD1 is as follows:   BU1000 - EGMONT GROUP           BU1500 - Other Business line                     BU6000 - HOLDING AND SERVICE         BU6100 - HOLDING COMPANIES                           I have done the following: 1: Cubeview       Cubeview exportet to excel gives this     Please notice that top level BU1500 do not aggregate the data. And this is correct, totally 1.7.   2: Dataadapter:   Pivot in  BI Viewer looks like this:       My drill down in Charts i BI viewer  looks as follows: Start: Total 5.1     Drill first level: Total 5.1     Drill second level: Total 3.4   The red box should not be there   Drill third l

Is it possible to change the color or format the header of a column of a SQL table editor component??  

Hi, I'm trying to run a cube view, but after running it I'm getting this error message "Error processing dimension. The item was not found. Dim, OneStream.Shared.Common.DimPk, 0, -1.". Other admin/super users are able to run it successfully without this error, but myself and others can't. Anyone have any idea?  

hi all, I hope you are doing well. I've a cube view with 2 columns and need to add another dimension, is his a bug to have only 2 dimensions? Thanks in advance. Regards Mario Guerrero

I am stopping users from running forced calculate/translate/consolidate with the following in "WcfEventHandler".  If args.IsBeforeEvent AndAlso (args.WcfServiceType = WcfServiceType.Calculate) AndAlso (args.OperationName="CalculateChartLogic" OrElse args.OperationName= "StartConsolidation" OrElse args.OperationName= "StartProcessCube" OrElse args.OperationName= "Translate" ) Then Dim isForced As Boolean = args.inputs(2) If isForced = "True" Then args.Cancel = True Throw New XFException(si, New Exception("You do not have access to Force Calculate/Translate/Consolidate.")) End If End If How do I stop users from running these functions in a report in excel? 

Looking for some sample code to help me get started with adding in a new row through the SQL Table Editor, where a few of the columns are prepopulated on row addition through Dashboard Extender BR Code

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

Dear all, We have a case in which the client needs several copies of the same CV in excel, but having different parameters (selecting an account node) for each CV. Is it possible?We know that defining the parameter internally in an excel file helps to avoid asking for that parameter again.We tried to put 1 CV connection per sheet and one parameter per sheet, but it seems that only the 1st parameter is read and then updates all CV connections following this 1st set parameter. Do you have any idea how to deal with this in order to keep different parameters for each CV connection?Thank you for the help.Best regards,Carlos

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

  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