OneStream Platform Forums

I need to delete a single record in the Error Log but my Data Adapter won't let me, complaining about "unsafe SQL statements".In a rather bone-headed move, while developing a BR, I accidentally wrote an insanely large block of text to the Error Log -- like somewhere between 1.3 and 1.5 million characters -- in a single record via BRApi.ErrorLog.LogMessage.It's made the Error Log workspace page pretty much unusable because it's trying to read that record to display it. It takes 5 or 6 minutes to display the Error Log.After finding the UniqueID for the offending record in the ErrorLog table, I tried the following SQL in a Data Adapter to remove the record:DELETE TOP (1) from myOneStream_Framework.dbo.ErrorLog where UniqueID = 'bb5158a6-aae9-471c-b883-edddc8640a5e'Apparently, OneStream thinks I am a cyber-criminal and blocked my code execution with the following message: Database query error. The specified SQL statement is not safe.I also tried:UPDATE myOneStream_Framework.dbo.E

Hi Everyone. I am creating a CSV file with the information from a datatable. The problem is that it generates the file with the columns but without the datatable information. I wanted to know if there is another way to create a CSV file correctly. Dim strFilePathFull_AllocationDetails As String = strFilePath & "/" & strModelName & "_" & strScenarioName & "_" & strTimeName & "_" & dtAllocationDetails.TableName & ".csv" Dim xfeFile_AllocationDetails As XFFileEx = dtbSH.DataTableToFile(si, dtAllocationDetails, strFilePathFull_AllocationDetails, Nothing) And my function: Public Function DataTableToFile(ByVal si As SessionInfo, ByVal dt As DataTable, ByVal strFilePath As String, ByVal listColToSkip As List(Of String), ByVal Optional strSeparator As String = ",") As XFFileEx Dim strDt As String = Me.PrintDataTable(si, dt, strSeparator, 0, False, listColToSkip, """") Dim bytes() As Byte = System.Text.Encoding.UTF8.GetBytes(strDt) Dim fileinfo As New

Hi All,I am trying to run a business rule through Data Management step but getting attached error. Can anybody help me how to run the business rule from Data Management?I am also disclosing the error message belowError processing Data Management Step 'Data_Buffer_Practice'. User 'Muhammad Zubair' is not a member of the 'Actual' scenario's Manage Data Group. 

Hi,I have a Custom Calc rule called by a data management step and I am experiencing a weird behaviour. I know there is data in Actual 2023M6, and I can get that data when running the data management step from either Actual 2023M12 or MF7 (name of another scenario) 2023M6, changing the GetDataBufferUsingFormula appropriately, but not from MF7 2023M12. I'll post the details below. 

Dear community. I have a use case where I need to sul up data from 2 different entities and apply a ratio on it. For this, I would like to use a data buffer. However, the data buffer typically only run on a data unit hence 1 entity at a time. So I created a data management job dat would run on these 2 entites, and I wanted to use a Globals object along with this data buffer so that I could store data from these 2 entities into a single data buffer. However, I'm not sure if it's the right way to do it ? Is there a way for a data buffer to take data from 2 entities ? Or, if I use a globals object with a data management sequence, is the Globals object persisting when running on 2 different entities ? Many thanks for your anticipated feedbacks ! Regards,

I need to add a Form Channel (Workspace) to our WF's for informational purposes.  Is there a way to exclude this from from the Dependent Status check of the WF for certification purposes.  The channel is defined as a workspace so we can embed a SQL grid report.  I already have similar channels where I have added buttons that control certification/decertification, this just requires the user to select the channel and then click the button.  Trying to get around forcing them to have to select when they might not need to view the provided data.   Understand I could move to a Dashboard but want to keep it in the WF and visible to users. 

When i tried copying the data from one cube to another cube using Eval function with Buffer [Calculate(formula, onEvalDataBuffer, userState)], the data got copied at the base level but as soon as i consolidated it, the data got cleared from the same destination intersections.On checking the cell status of the destination cell (intersection), i found that the storage type is Calculation Whereas, if we use api.Data.Calculate(formula, isDurableCalculatedData), the storage type is DurableCalculation, and consolidation works fine after using this Calculate function.We do we have a boolean parameter to set the DurableCalc as True or False in the api.Data.Calculate(formula, isDurableCalculatedData) function, but i didn't see any such parameter or setting for Buffers [Calculate(formula, onEvalDataBuffer, userState)].How can i make the StorageType as Calculation to DurableCalculation for Buffers, so that the values doesn't disappear after consolidation ?   

Hello,Is it possible on the same quickview to cross both Time and Scenario Filter?For example I need the cross of  :Time "2022" with scenario "ESTIMATE"Time "2023" with scenario "Planning_2023M10"But I have some datas on 2023 cross ESTIMATE I don't want to see.Attached what I have and what I need.Thank you! 

Hi All,I am trying to extract data from cube view using FdxExecuteCubeView function and load the result back to cube through a connector. However, when I execute the workflow dataload, a "No valid DataKeys (Scenario / Time)" error occurred. I checked the log, it pointed out to be "Non-Numeric Amount ..................... 4" error On the log, I am able to see the data I extracted as this :4: Cube1, 568123, , Local, Budget, 2023, Periodic, 702151, None, BeforeAdj, None, 500100, None, None, None, None, None, None, None, 959.799999996It seems that the data was pulled right, but just the amount cannot be recognized as numeric dataOn Data Source, I did map "Amount" to the "Amount" column. I am not sure why 959.799999996 is not considered as an amount? Here is the mapping.   Here is the Rule itself. Case Is = ConnectorActionTypes.GetFieldList'Return Field Name ListDim timeMemfilter As String = "T#2023"Dim isTimePivot As Boolean = FalseDim useGenericTimeColNames A

Has anyone switched External Authentication from AzureSSO to OktaSSO?  How did that process go?  Was it seamless or were there user login issues? I'm trying to get ahead of this as my company is looking to convert all logins to OktaSSO.

Hi All,I  want to get Last month ending balance in my MTD column of cash flow and last year ending balance in my YTD column of cash flow as you can see in above picture.Can anybody share with me the business rule? I have tried following business rule but it is capturing only at the end of the year balance.Dim currView As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId) 'Current view member IDDim priorQtr As Integer = api.Time.GetLastPeriodInPriorQuarter(api.Pov.Time.MemberId) 'Prior QTR member IDDim priorQtrName As String = api.Time.GetNameFromId(priorQtr) 'Prior QTR name #End Region ' Bring in Beginning Cash and Ending Cash to the Cashflow hierarchy in FlowIf currView.Name = "YTD" Thenapi.data.calculate("F#CF_BegCash" & Target & " = RemoveZeros(F#EndBal:T#PovPriorYearM12" & Source &")","A#CashTot.Base")Else If currView.Name = "Periodic" Thenapi.data.calculate("F#CF_BegCash" & Target & " = RemoveZeros(F#EndBal:T#PovPrior1" & Sou

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?