OneStream Platform Forums

Hello OS Community,   I noticed there was a variable for suppressing no data records when using the FdxExecuteDataUnit function.  Is there a way to bypass zero data records?   Thanks in advance for your help! Clifton

Originally posted by Colin ONeillI would like to add an Excel "cube view run time" time-stamp to a cube view report. But I have been unable to find a way to do that. I can't be the first person with this question.

Hi, Is there a way to audit (in a report...) for all cube views, which one refers to a column or row cube view template ?    Thanks.   Regards, Harry

Is it possible to create a custom header on a cube view when viewing the report in Excel?  I was able to create my custom header for the Report view but I can not find any options available to change the header font and size on the Excel view.  I do see in the Application Properties where the Headers can be formatted, but I am looking to only modify one header for one customer and not all of the headers. Is that possible? 

Good afternoon, How can I pass a parameter selection from a Button/Combo Box to a URL within a text editor component. The client would like to select the UD4 and have it retrieve a Word doc / Text Editor for that selected UD4. I have the current URL in the text editor as this: Documents/Public/DashboardFiles/|!Fin_Dept_Select_ColSet!|.docx   Thank you, Stephen

Within the scenario dimension does the workflow tracking frequency / Start Time / Finish time affect the forms templates form frequency? We had scenarios that run for 4 months with the start month and workflow month being the same, the quarterly/half year forms worked as expected. We have since changed the work flow start and end times to be the full calendar year (all 12 months), but this has caused the the quarterly/half yearly forms to no longer appear in the workflow. They only appear if the frequency is set to monthly. Can anyone explain before i raise a ticket? Thanks      

Hey everyone! I've added a new department to my application and just realized it's not showing up as an option when I'm adding a new headcount-- see screenshot below. Has anyone seen this? I added 7 other departments together and none of them have this issue. I don't know where else to look for errors so any tips would be greatly appreciated.    

Hi all,I'm having an issue whereby I'm importing profit and loss actual's data via a csv file into one of the data upload workflow steps we have set up.However some of the data is being loaded into months it shouldn't be, even though on the in the csv file the data is pointing to the correct time period.So for example in the upload file, data is put against time periods such as 2023M1, 2023M2 etc. Having imported the data, validated it and loaded it to the reporting cube we have, some of the data is being loaded into 2023M1 and also 2023M2, when on the upload file it's only on there once against 2023M1.I've checked the transformation rules and everything is set up correctly in terms of translating the import file, so I was wondering if anyone has come across this type of issue before or if anyone has any advice as to where I could look next?I'm pretty new to OneStream so any help would be much appreciated.Thanks,Ged

Hi, My client has asked me to build a report with all subsidiaries and associated companies with respective Percent Ownership. I am aware that I can retrieve this through XFGetRelationshipProperty in Excel add-in but I wonder if there is any way to retrieve it in a cube view?

I have a set of Controller level users for Audit reasons don't have access to load or modify data.  I am wanting them to be able to enter Variance Comments.  The answer maybe obvious, but I wanted to be sure.  Do I have to grant them access to load data to these data points to be able to also enter their comments?

Originally posted by Jacqueline McBrideI tried running a CubeView I just created and received the following error message: "Error processing shared Cube Views. The maximum number of Cube View references has been exceeded." The application I am working in shares many row sets and column sets for various CubeViews. Does this error message means there is a limitation to the amount of times you can share rows/column sets? Thanks in advance! -Jackie

  In order to see data, are all 18 dimensions used Question Credit: Nick Hymes   Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hi , I was wondering if anyone who has implemented OneStream has come up against issues from their IT Security people with OneStream decision not to empoly a Web Applcation Firewall (WAF) as standard. This seems to be a common requirement of most IT Security governance approvals so I'd be interested in seeing if anyone has had this issue and how they resolved/accomodated it.   many thanks   Steve

Hello, Does anyone know how to turn off the Quickpost function for journal entries?  Regards, Ronnie Karpinski

Hi, I noticed that when exporting a workflow/cubeview to excel the default save location of that file is C:\Users\xxxx\AppData\Local\Temp\OneStream. The local IT group policy is to empty that folder upon rebooting the computer. This path is not setup in my own/local excel options. Is there a way to change this folder location to for example 'downloads'? 

Originally posted by Priya GnanabhaskarWe have created a department level report which shows all expenses pertaining to a department in our actuals cube. This report consolidates the balances across all our legal entities for each department [e.g. IT].  The expectation is to create a drill through report that shows all the data loaded from the GL across all entities.  In the current drill through the user has to drill through each entity to see the transactions loaded from GL. Is there any way to achieve this drill through?

Originally posted by Cheryl Nasta Has anyone successfully created an external data connection to a database on an AS400?

Hello,Has anyone experienced partial uploads when using the XFSET formula? Does anyone know if there is a way to set XFSET uploads to only upload data if there aren't any errors? Regards,Ronnie

Hi, Can anybody help with this error? what we need to check for this in business rule.       

Is it possible to change the Fiscal Year Month Type in the time profile after an application has had data loaded to it? For example from Fixed Weeks 4-4-5 to Calendar Month?   

Our team has been working through an Infrastructure project, which requires pulling task activity from the Framework Database.  When pulled directly from the database, we see task activity type in numeric format.  To get the descriptions I ran an comparison by extracting the Task Activity dashboard tool and was able to identify the below descriptions:  (CASEWHEN a.TaskActivityType= -1 THEN 'Unknown'WHEN a.TaskActivityType=10 THEN 'Recycle Application Server'WHEN a.TaskActivityType=100 THEN 'Get Data Cells'WHEN a.TaskActivityType=101 THEN 'Get Data Cells Using Script'WHEN a.TaskActivityType=110 THEN 'Cube View'WHEN a.TaskActivityType=111 THEN 'Cube View Report'WHEN a.TaskActivityType=112 THEN 'Export Cube View To Excel'WHEN a.TaskActivityType=120 THEN 'Quick View'WHEN a.TaskActivityType=200 THEN 'Book'WHEN a.TaskActivityType=1000 THEN 'Data Management'WHEN a.TaskActivityType=1100 THEN 'Data Management Scheduled Task'WHEN a.TaskActivityType=2000 THEN 'Load And Transform'WH

Currently when we open excel the context pane automatically opens. Is there a way to disable so that it does not appear automatically?

Hi all,I have an issue whereby I'm loading our company actuals into OneStream, but if a General Ledger code has no data in it but had data in previous months, I think OneStream assumes the YTD value to be zero and so the opposite total of the previous months is being loaded.So for example the YTD total of repairs & maintenance may be £100 at Apr-22, and in May-22 there are no further transactions so the YTD position is still £100. However as no transactions occurred in May, when the data is loaded      -£100 appears in May.I've checked the DateSource and TransformationRules we have set up, I cant see a reason why this would be happening as it's all set up as 'Periodic', and so only the data from the initial load should be include.Does anyone have any ideas as to where the problem my lie, or where I could look to try and see why this is happening?Many thanks,Ged

Is it possible to pull up a linked dashboard by using a button component instead of having to right click on a cell.  I want the user to be able to click on a cell in a cube view, then click a button that pulls up another cube view showing the detail.  I am using two bound parameters for account and department within the dashboard.    

This seems very standard, so I have to be missing something.  I have the row filter on a Cubeview "A#6020.TreeDescendantsInclusiveR".  6020 is the total line for all the single level descendants.  How do I get only the last descendant to be underlined in the report before the Total line of 6020?