Reporting

HiI am using a simple dynamic calc to hide an derived data. See below:The code itself works fine. However, in cases where the cell status was previously 'Invalid=True' is no showing as 'Invalid=False' which is impacting the suppress invalid rows setting on my cube view.Any thoughts? Or does this sound like a bug in the system?Mark

Hi, I am importing from the ERP i go the error intersection is read-only due to conditional input settings.when i click on load and transform i have this error. the transaction is related to IC account. when i changed the mapping to another IC account is works well.  The issue is only for one IC account.(IC trade receivables)  is there any fix for this?Regards,  

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   

Hello there,I am wondering how to use the 'Action' section in a GridView's configuration ... I tried something as simple as opening a Dialog (image below) but I cannot seem to trigger the event. Is there a specific place on the GridView where we need to click or it's not even possible ?Any kind of help would be much appreciated !

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 I'm looking to get the year from a time parameter to use in a cube view header. Is it possible to use the XFMemberProperty rule if possible?I've tried :Name(XFMemberProperty(DimType=Time, Member=|!TimeParameter!|, Property=Year)) but the system doesn't like it.Note, the following works to get the time description, but I'm looking to just get the year i.e. 2023XFMemberProperty(DimType=Time, Member=|!TimeParameter!|, Property=Description)Thanks,Mark

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

Hi all. So I have a book set up that creates an excel workbook based on a loop of entities. It works absolutely fine, however, the book is 300 worksheets or so. Therefore its pretty handy to have an Index page. Is there anyway to splice a worksheet not generated from the CV into this export? Also, books seem to forego the handy auto freeze pane on headers that excel exports do on execution. Does anyone have a BR that will do this?Thanks in advance! Tom

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 have a report that has a specific formatting request. The report uses two Member Expansions in the columns. The client requests that the 1st member expansion have no formatting, but the 2nd member expansion be in bold. Is it possible to apply different formatting to each member expansion? E.g Member expansion 1 is U1#Top. Member expansion 2 is the S#Actual. Client requests U1#Top be in plain text, while S#Actual be in bold.   Thank you

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()

How to migrate Report-Books from one Env to another in One Stream? Book is not available in the list of objects to export. Is it a different process as it comes to File Explorer?

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.