Reporting

When I ran the report book, the Default value of Parameters is not showing instead it is taking recent selected value.Please provide any suggestions.

Is there any better way of getting rid of these default TOP other then explicitly adding them in each row with Name tag?  

I have a Reporting component that uses a rich Text sub componentand i want to bind multiple variables into  it :Does anyone know what the correct syntax is  syntax is ?Regards,

Hello,I'm working in the excel add-in and creating a some reports for my company and was wondering if you can use Column Better/Worse in the add-in. I know you can with cube views or quick views, but those limit the formatting we want. The reason I want this is to be able to differentiate between account types when it's doing the comparison like it does in Spreadsheets or in Cubeviews.Thanks,Will

Hello there,I am wondering if there is any possible method to link a dashboard to a GridView. Upon clicking on a specific row on the gridview, I want to retrieve all row values (similar to bound param in Cube Views) & then display my dashboard based on those valuesAlso, is it possible to horizontally center columns in a GridView ? Thanks in advance 

We are trying to Override account member in Column.we have 2 accounts being called in a single column, her we need to Override only 1 account member from the list of 2 accounts.Below is the reference CV.In the below screenshot we are having 2 accounts "A#100 and A#200" in Col2, here we need to Override only A#100 Account member with "A#300"Currently problem which we are facing is it overrides both "A#100" and "A#200" with A#300.Please let me know if we can overcome this by using some Business rules? Thanks in advance!Nidhi   

Is there any clear coverage for audit purposes over Marketplace solutions such as the Excel Add-In or Application Reports? I don't see it clearly covered in the SOC1 or SOC2 reports and our auditors are questioning how we know the interfaces and reports are complete and accurate, etc.

I have some power Excel users that want to dig deep into automation within Excel and are asking for any documentation there might be.  Anybody know of anything other than what you can see in the Addin itself?  Is there a full list of all the calls that are available? 

Hi Team, I am getting an error message while clicking the open icon under spreadsheet option, could somebody help on the below.

Dear community, We encountered an issue with clients' display screens in OneStream.  In the cube view formatting, we use the font family Geomanist Regular, and we have defined the text for certain rows as bold or italic. When we run the cube views, the formatting is correct on the consultants' view, but the clients do not see the differences between bold vs. non-bold or italic vs. non-italic text. The text font appears to be different as well. Please see the screenshot below for references. Consultant's displayClient's display Currently, all project team members (consultants and clients) have administrator rights, and we do not have any other culture setting in the application. Can anyone suggest what we can check to resolve this?If there are any similar experiences, kindly share them with us. Thanks in advance!   

When viewing the results of a cube view and using the Export to Excel button, the filename generated replaces spaces with "+" and adds "_Export" and the sheet/tab name of the file appears to be the cube view name. Is there a way to define these while still using the Export to Excel button? Perhaps a business rule attached in the cube view that defines them? 

I have Delimited list parameter for scale in Cube views, when added the Cube views to Books and given the value to parameter using change parameters option but it's still prompting for it when I ran the book. Any suggestions, without updating the Cube views and get with Books only.  

We are trying to pull WD HR data into OneStream.  At this point, we are just trying to prove we can do it.  I'm trying to setup a data adapter to pull the data using an SIC Direct Connection, but I don't know how to start with the data connector.  What type of data connector?  How do I tell the da to grab the data from the SIC?  Searching the OneStream documentation for these yields nothing and the Foundation Guidebook doesn't speak to the particulars either.0 Kudos Reply  

Hi there. I am new to the community but am wondering if any of the users are using Workday as the general ledger / ERP and Onestream for Reporting, etc. Posted by Andrea at Ensign Services Migrated from ONECommunity

Hi , wonder if someone can help me, I have a dynamic account % = Dynamic calc Return api.Data.GetDataCell("Divide((A#Account ), (A#Account2 * 1060))") which works great in the CV , but in the graph it does not bring the calculation correctly, BI pulls the "average" of the YTD of the CV (orange cell)value I am looking for is the YTD calc.  should be %75.1 it does work if I bring the Time in the filter for the YTD graphs,   my CV is bringing T#WFTime, so the filter wont work as dynamic dashboard. Same issue with QTD, amounts in the CV in yellow are the correct values, BI Viewer is has the average of the yearif I hard key the WFTime it will only display one QTRI think my problem in the value, what condition rule do I need to have? the closest to actuals is average, but is not correctHopefully is something simple, I just cannot figure it out. thank youLC      

I set the cubeview date to the prior year from the current month input.  I can't get the report title date to show the prior year date, it actually shows the user cubeview date June 2021.  My user input date is 2023M1, and report date is 2022M1 based on the formula T#YearPrior1(|!Param_Time_Select!|)Period(|!Param_Time_Select!|) in the Column formula.  If I put |CVTimeDesc| in the title setting I get June 2021.  How do I get the prior year to show of Jan 2022?

I have 2 rows named row1 and row2.1.  Row1 has two members namely A and B.2. Row2 has three members namely C,D and E.Now, I want to add row1 and row2 so that it sum all A,B,C,D and E.Will this work or will it just take first 2 members(i.e A and C)  of each row? GetDataCell(CVR(Row1) + CVR(Row2)):Name(TotalSum)

Hi,Can we someone disable/hide these button from the dashboards?There are few dashboards which are accessed by multiple users to input data. Accidentally , if any user clicks complete form after updating the numbers then it locks the dashboard and restrict users to input again.Its a hustle to explain the same thing again to the users to avoid clicking "Complete Form" button after every inputs.Is there any way where we can hide it so that they cannot mark the form completed? 

Hello everyone,  we are building an excel based report to get the account hireachy , entity hirerachy. any one having any examples please provide me. =XFGetRelationshipProperty() =XFGetHierarchyProperty()

Wondering if anyone can help with this one.  This happens like 1 out of every 3 times logging into OS where when I click external service provider it just pulls this blank screen and won’t let me log in upon repeated attempts unless I fully shut down and restart excel.

Hello - I have a cube view that I created a connection to in Excel. The cube view has an O#Forms POV with a column configured to enter comments - can modify data is set to True, it has a V#VarianceCommentary member, etc. During testing I am able to submit comments through this Excel sheet, since I also see the comments within the application as well (I have a dashboard that calls a similar one set for commentary). However the users I built the CVs for are only able to submit comments through the application - when they attempt to add them through Excel, either they simply can't add text or when they click Submit Sheet at the top the comment disappears. I made sure the settings, cell formats, etc. for commentary are the same for both the application and Excel connection cube views. Are there any Excel specific settings that I need to check for these users?

Hello, I was wondering if anyone has been able to get a table view to refresh using VBA.  I have tried the below code with no luck. Sub RefreshXFFunctions() Set XFAddIn = Application.COMAddIns("OneStreamExcelAddIn")If Not XFAddIn Is Nothing ThenIf Not XFAddIn.Object Is Nothing ThenCall XFAddIn.Object.RefreshXFFunctionsEnd IfEnd IfEnd Sub   Thanks!

Hi all,I am designing a dashboard home page whereby users can navigate directly to the different Workflows for Statutory reporting and Management Reporting, via a button.I am utilising the Change Workflow action in the button settings to set the scenario, however I have an issue as it is not picking up the correct Cube Root Workflow Profile.As you can see in the screenshot below, Act_Stat and Act_Mgmt both sit under MGMT_ACT Cube Root WF Profile (and they both sit under STAT_ACT as well). So when my workflow is set to MGMT_ACT, and I run the button, it doesn’t open the scenario in the correct CRWP. I had a go at adding CubeRoot to the button POV Action, but it didn’t do anything.Does anyone have any idea how I can change the Cube Root Workflow Profile by using this button below, if at all possible?The less pop-up menus and clicks the better for the accountants!ThanksAndrew  

When end users utilize the excel add in functionality, they are only able to calculate 1 year at a time using the calculate button.  Is there a solution to allow users to calculate all (multiple) years shown on the cube view with a click of 1 button in the excel add in?

Hi all, I've col A and col B.I want to show a dynamically calculated col C which should be based on below logic: If col A has no data then display col B Else display col A Please suggest the best options to achieve this. Can it be handled in cube views or requires dynamic calc member formula. Thanks in advance