OneStream Platform Forums

I have the following column member filter. S#Actual, S#Budget3, S#Actual:T#YearPrior1(|!Param_Time_Select!|)Period(|!Param_Time_Select!|), GetDataCell(BWDiff(S#Actual, S#Budget3)):Name(BW Diff), GetDataCell(BWPercent(S#Actual, S#Budget3)):Name(BW %), GetDataCell("BWDiff(S#Actual,S#Actual:T#[YearPrior1(|!Param_Time_Select!|)Period(|!Param_Time_Select!|)])"):Name(BW Diff), GetDataCell("BWPercent(S#Actual,S#Actual:T#[YearPrior1(|!Param_Time_Select!|)Period(|!Param_Time_Select!|)])"):Name(BW %)I'm needing to Conditional format the BWPercent column with %'s, and I can't figure out how to refer to that column with a conditional format that works.   Any ideas?

Hi,sorry the basic question, I have noticed the Cube POV can be saved as a file (Save cube pov to favorites). However, I have not been able to do the opposite, to set the Cube POV from a file. How do I do that?Thank you

Does anyone know whether it's possible to modify the Excel journal upload template to force upload to multiple individual periods from that one file?If it's possible, can anyone provide a brief how-to for setting something like this up?  The request is to be able to upload this to a forecast scenario so it's really outside the normal parameters of a typical journal.I know one easier alternative is to create an _ADJ member and just load the data to that but that's not the ask from the team.Would be grateful for any advice.  Thanks

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,  

We are currently using something like this to pull in the Global Time on the email we send out after the automationDim gTime As String = BRApi.Workflow.General.GetGlobalTime(si) This works just fine, however we would like to also have the option to load by wf which works we just cant get the wf time to show up on the email. I cant find the syntax like I did Global TimeThoughts? Thanks!

Out of curiosity, are there any folks out there that have opted to have some "Generic" users/licenses versus specific named users in their environments? A couple of places where I think a generic would be relevant is when giving auditors view only access to the application. If there is a team of 3-4 auditors who need view only, would it not make sense to just create 1 generic user?On the flip side, what are big reasons people choose to go the named user route besides the obvious ones of audit trail for data loads and form completions and workflows?Just trying to get an idea of how popular generic users truly are when I personally have only seen the named user route. 

I need to be able to write a confirmation rule that checks for nodata vs a value of zero.   Can someone help with the syntax I have this - Dim cellstatus As DataCellStatus = api.Data.GetDataCell("Cb#CimpressConsol:P#TotCimpress:C#Local:S#Actual:V#YTD:A#BS_NoMap:F#EndBal:O#Top:I#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#None:U7#None:U8#None").cellstatusbut I dont know how to build the If to check on the result. 

Is there a way to make a WF Step only show up quarterly?  We want to create a form for the BS Flux but it should be completed at Day 10 vs all of our other forms need to be completed on Day 7 so we were thinking to seperate the 2.  We would only want this step to show up for the quarters.  I know I can make the form only show up on the quarters but I dont want to have the users have to complete the Form, Process, Confirm steps on the off months.   Willing to hear any alternative ideas on how to do this.  We use Task Manager also so we want to know that the Day 7 forms are complete vs the BS Flux.   My other thought is to create a dashboard and attach it to the Task and have them complete it but they are so focused on the workflow that we would have to be constantly reminding them.

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 !

Hi All,  Need assistance in posting a journal to eliminate the difference.  I tried posting a journal using reporting currency (ZAR) to eliminate the difference, but it's not going through. The translation should be periodic.    Anyone have any idea what I'm missing?  

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

Hi, we received the following error message in OneStream on some of our scheduled data management tasks; these tasks load workflows by pulling data from an Azure system."Summary: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.Operation cancelled by user. (SQL Error Number -2146232060, -2, 0). The wait operation timed out"My understanding is that the this indicates that OneStream cancelled the operation (and failed the task) as Azure took too long to respond. How would I go about preventing this issue for the future? 

Hi, looking for experience and OS counterparts for support to automate ( plugging it directly in OneStream from source) FX Data Feed. Concern currency is USD.Which source are used - OANDA, Eurpean central bank or other sources? How does this work to get actual closing Rate, YTD Rate and for information purpose monthly average rate in the system?Actually we are loading every month from ECB into csv, working in excel - convert from Euro into USD for each currency, closing, YTD and average and than loading - set cells - into OneStream.Thank youAngelika 

I am setting up a Workflow with a SQL connector data source. I need to be able select a range of periods (start and end period) within the SQL query to extract the balances for multiple periods and load the same to OS cube. Users should have a provision to select the start and end periods and the SQL query should run dynamically based on those periods. Workflow should be executed to import and load the data to the multi periods selected at one time (not needing to run one by one period).I am new to OS. Appreciate suggestions and recommendations to implement this requirement in OS.   

HiWe have a requirement where users need access to all entities in the organisation but only for a specific set of accounts.Currently we have a simple security model where users are restricted by Entity. I was hoping that I could create a Cell Data Access Security rule that will give them access to entities outside of their group for the specific set of accounts, but it feels as though the Entity access overrules the Cell Data Access Security?To be clear I have Group A and Group B, restrictions  defined below.Group A :- Full access to all Group A Entities- Additional access to Group B Entities (for specific set of accounts) Group B :- Full access to all Group B Entities- Additional access to Group A Entities (for specific set of accounts) 1. Is it possible to grant access as I have described and am I just doing something wrong?2. If the approach I am taking isn't the correct one, what is the best way to implement this kind of logic? Thanks,Mark

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 am trying to connect to a OneStream Cloud environment for which the REST API has been enabled and tested by OneStream Support.I am working in PostMan and following the REST API guide at System Guides > REST API Implementation > REST API Overview > Authentication, but i am hitting an error "One or more required parameters are missing."I can retrieve the AzureAD token fine, but when I then try and use it to authenticate with OneStream (expecting the SI to use later on), I get the above error message returned (along with a HTTP/400 Bad Request).As far as I can see I am not missing any Parameters as per that section of the REST API Guide.The POST request is to:https://xxxx.onestreamcloud.com/onestreamapi/api/authentication/logon?api-version=7.2.0Params: api-version=7.20Authorization: Bearer Token returned from Azure AD (via a PostMan variable)Content-Type: application/jsonBody: BaseWebServerURL: https://xxxx.onestreamcloud.com/onestre

Hi,We are using the following when we send out the automated email, and it works just fine. However is there a way to include the application name in the email? Reason being we would like the users (some who have access to Dev etc to be able to decipher from production application. BRApi.Utilities.SendMail(si, "OneStreamEmail", toEmail, "SAP Load Automation Errors in: " & gTime, "Please see the attachment for error details.", attachments)Thanks!

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?

 I have this button that is replacing the value of the WFProfile with one from a parameter (which are all WFProfiles), and what I want it to do is that when I select a value, it updates in the workflow, and that in a label, the newly selected value is displayed. What is happening now is that when I open my dashboard, the menu to select the value is displayed, but when I select it, it doesn't change. I have to press the button again to refresh the workflow, and the label also updates to the new value.      

Hi community,I am trying to pass a custom name function in the manner below:XFBR(XFBR_CubeViews, CustomTimeExpansion, timeExp=T#2020.Base, desc = :Name(|MFTimeShortDesc|))Somehow the XFBR is not able to append custom name function to the periods that are output in custom sort order. Its not reading the custom name function that i am passing to desc variable. Please help.

Hi,While exporting the Cube View to PDF and Excel we are getting the below error,Unable to process Cube View because of the Nested Member Expansions resulting in 167,125,564 rows and the maximum allowed is 1,000,000 rows. We have tried by enabling the Sparse Row Suppression still we are getting the same error. Is there any way to resolve this error?Thank you.

I'm having trouble setting up local OneStream Server in my system.