OneStream Platform Forums

Hi Everyone. I had a Business Rule that checked the Workflow table to see if a scenario was blocked, but it always showed WFProfiles as blocked. I don’t know where this information is coming from, as those WFProfiles were unblocked in the environment but appeared as blocked in the table. How can I verify this information?  

Hi Everyone. What I want to do is change the value of: si.WorkflowClusterPk.ProfileKey What I want to change is the ProfileKey of a Profile that can obtain the value by name. I need to make this change to modify a process that relies solely on the information from this attribute. Therefore, I would be grateful for your assistance.

Dear all, Could you please advise is it possible to combine several cube views into single Excel file and download it from the application? If so, could you please advise how to do that.

Hello All,I want to use application reports Market place solution to get the journals for all workflow profiles. How to achieve this. Currently I get journals for only one workflow profile as per your select WF POV. Is there a way to get the journals for all workflow profiles as a report in one go.Thanks

Hi All I am upgrading the MarketPlace app Reporting Compliance (TCR) so that it has its own separate Workspace (V8.1). I have added the Business Rules as assembly files and they all work. The current environment (V6.8) has a Data Management job to run calculations so I am now adding a Data Management job to the WorkSpace Data Management Groups. The only problem is that when I add a step (type Execute Business Rule) to the Workspace Data Management Step, the drop down list only shows Business Rules in the general Business Rules area and not the file assembly area. How do I get the Workspace specific Business Rules in the Workspace specific Data Management Groups? Thanks

Hi! New to Vb.Net here. Trying to write a UD8 formula which extracts the right 3 characters of an Entity member name, only when the member is a base member. Error message received says "'IsBase' is not a member of 'Member'."  Anyone know how to make this work? If api.View.IsAnnotationType() Then 'Check if the member is a base member If api.Pov.Entity.IsBase Then 'Return the last three characters of the member name     Dim membername As String =  api.Pov.Entity.Name Dim lastThreeChars As String = Right(membername, 3) Return lastThreeChars Else     'Return a NoData Datacell if not a base member     Return api.Data.CreateDataCellObject(0.0,True, False) End If Else     ' Return a NoData Datacell if not an annotation type     Return api.Data.CreateDataCellObject(0.0, True, False) End If  

Is there a way to disable excel functions/buttons within the excel add-in? For example turning off "submit workbook" in the top ribbon or calculate/translate when right clicking on a cell in a quick view/CV? 

Hi all,Can we schedule a task to run on a business day each month, for example, between the 1st and 7th? I know we can set it for specific days and weeks, but is there a way to make it more dynamic?Any suggestion would be appreciated. Thank you.Best,Jacky 

How I can clear data in Orphans members before Deleting them permanently

We have a requirement to create reporting that utilizes the number of months since a company was acquired to perform math on specific columns of data. We would like to attach the acquisition date in a text field of an entity, and create a member formula for a statistical account that calculates the number of months between that acquisition date and whatever month the Point of View is referencing (we could convert the POV month to a specific date if necessary). Is this type of calculation possible within stored member formulas?

Hi all,I'm quite new to OS integration pieces and being struglled with a request from my client to load dimension members using their data lake, so the memebers would be updated automatically or by a scheduled event.The database is already configured at SIC and working fantastically well, however, I can't figure how to use it's features to load the metadata members to one of our UD dimensions.I read a lot of topics here in the forum, but couldn't find anything that matches my case.I already tried to create a Extender BR, but I'm getting a "Object variable or With block variable not set" error message when running the "api.Parser.ProcessSQLQuery" function. Not sure if I'm doing something extremely wrong, so I"m assuming that this part of the api must be used only within Connector BR's.I also trie to create a connector rule to do the job, but when setting it up at the dimension property, nothing happened (not sure if I missed something here).Any help on this will be really appreciated!Re

Working with BI Designer and cannot get the Time order in place sequentially. The Cube View data source is pulling the correct time, data, alongside the POV for workflow. The WF filter builder is in order. However, cannot get the two months (Oct and Nov) in the appropriate place. Tried to sort and use Start/End Dates too in settings for WF Time Filter: T#WF, T#WFPrior1, T#WFPrior2, T#WFPrior3, T#WFPrior4, T#WFPrior5, T#WFPrior6, T#WFPrior7, T#WFPrior8, T#WFPrior9, T#WFPrior10, T#WFPrior11, T#WFPrior12, T#WFPrior13Has anyone experienced this before?   

Is it possible to make an attribute member run a comparison based on the stored text attribute for a specific Time Period ?Ex: - Text8 & 2023M1 =>  FO_SUPM      - Text8 & 2023M6 => FO_HYPMBased on the cell pov, is it possible to make the attribute member adapt to the context's Time Period instead of picking the stored Default Value for the Text 8 ?Thanks. 

I have some business rules that need to identify which environment the BR is running in. This is because they does different things in each environment. In one BR i want the process to run in Prod but not QA or Dev, in another i want to copy extract files to an external shared folder which is different for each environment.  I was thinking of using a dashboard parameter but if after a Prod to Dev/QA refresh i forget to change the value of the parameter, the BR will copy the files to the Prod external folder and i don't want that to happen. this is why i am trying to find a way to identify the environment without relying on the value in a parameter.  Any thoughts? Have a great day! Bill

In a quick view, I am using the syntax T#Pov:V#Periodic,T#POV,V#Trailing12MonthTotal in the 'Time' dimension. I have a specific requirement where I need column A to display as "2024M1 (or the short description) Periodic" and column B to display as "2024M1 (or the short description) Trailing12Month Total". I can see there are variables available to pull in the POV description, but I'm wondering if there's a way to get my desired outcome of providing all descriptions for all dimension members in my filter when they are not linked to the POV. 

HI All, Is there a way we can identify which cube views have not been used/opened for say last 6 months to a year?  

Hey Guys,I was writing a rule to update a member description and text 1 field of the same member. I was able to update the member description, but can anyone help me with the text 1 field?Please find the code below which I am using to update the description..Dim SelectUD4 As String = args.NameValuePairs.XFGetValue("Param1")Dim NewDescriptionUD4 As String = args.NameValuePairs.XFGetValue("Param2")Dim UD4TextField As String = args.NameValuePairs.XFGetValue("Param3")  BRApi.ErrorLog.LogMessage(si,UD4TextField) Dim member As Member = BRApi.Finance.Members.GetMember(Si,dimtype.UD4.Id,SelectUD4)If member Is Nothing Then Throw New Exception("Selected UD4 member not found")End IfDim newmember As New WritableMember(member)newmember.Description= NewDescriptionUD4newmemberbrapi.Finance.MemberAdmin.SaveMemberInfo(si, True, newmember, False, Nothing, False, Nothing, False)Any help would be appreciated.

I am unsuccessfully trying to write an expression to utilize a Text Field as a filter in a business rule:api.Data.Calculate("U4#Target = U4#Source*-1","A#IncomeStatement.Base",,,,,,"U3#UserDefined.Base.Where(Text1 = 'Filter')") Is this syntax possible, or is there another way that I can write this to ensure that it is only being written when Text Field 1 for UD3 is equal to "Filter?"Additionally, is it possible to attach this to a transformation rule as a complex expression as opposed to needing to run it through Data Management after loading data?

I'm trying to produce a report schedule for Miscellaneous Receivables to show the make up of the Account.  I'm looking at trying to use Cell Details if that will work, but didn't know if anyone had a better idea.  The setup is I have one Miscellaneous Receivables account and I want the users to enter the detail make up of that account.  The lines will change over time to different descriptions that can show up in dynamic report rows.  Like I said similar to cell details, but they don't seem that easy to use in a cubeview.

We are trying to temporarily disable the Write access on a scenario to Everyone during a long DM sequence. We were able to find the ManageDataGroup under Scenario Properties, however, we could not find anything for ReadWriteDataGroup, which is a XMLConstants based on the API reference. Any help appreciated!

Maybe I'm missing something easy, but I'm trying to get some rows to group in the Excel import, and I can't get it to work properly. I think the problem may be that the rows are GetDataCells, but I'm not sure. So my question is, will the ExcelOutlineLevel work for GetDataCells, or is it restricted to member trees?To illustrate visually, I'm trying to get a bunch of rows like this: To export into Excel grouped like this:

Dears,We have a requirement, where we need to write only into C#Elimination of  [Share of Profit from] A#NetIncome and Same to be written to A#Investment in Equity Account as a other side of entry for the Equity Account type of consolidation in OneStream [We do not need line by line consolidation for all other items/accounts]To achieve this, I setup a entity as follows:PCON = 0POWN = 50%Ownership Type = Equitywhen i put PCON as zero[0] and execute the consolidation, the results are not writing up to Elimination member. What  can be the reason for same?  

I'm unable to import from SAP, i have an error message Summary: Unable to execute Business Rule 'SAP_TB_ALL'. Cannot call classic RFC API. See help for details.Please put a recent 64-bit version of librfc32.dll in your System32 folder (typically C:\Windows\System32).See SAP note 413708. Please make sure you have installed Visual C++ 2005 SP1 ATL Security Update (x64). Unable to load DLL 'librfc32.dll': The specified module could not be found. (Exception from HRESULT: 0x8007007E) how to fix this issue?  

Hi all, I'm trying to build a CV with Entities on rows and Scenarios on columns that will show the status of the cell with the help of a Dynamic Calc. Here's the aspect of the CV (Scenario and UD8 on columns): TEST is my dynamic calc (also crossed with V#Annotation so it can display text). As you can see, I can write on U8#None and yet the dynamic calc returns READ. Here's my code: Dim sEntName As String = api.Pov.Entity.Name Dim sScnName As String = api.Pov.Scenario.Name Dim sStatus As String = Api.Data.GetDataCell("Cb#CORP:E#" & sEntName & ":C#Local:S#" & sScnName & ":T#2018M1:V#YTD:A#ADDUG:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None").CellStatus.ToString brapi.ErrorLog.LogMessage(si,"sStatus = " & sEntName & " - " & sScnName & " - " & sStatus) If sStatus.XFContainsIgnoreCase("WriteAccess: False") Then Return "READ" Else Return "WRITE" End If Here's the POV of the first cell (on E#3002:S#Actual): Cb#CO

Hi, has anyone figured out how to add files to Narrative Reporting. In the Admin area I have blanks in the Source File Name column for my documents. I cannot seem to figure out how to add word docs and cube views into the fields. Ideally, I would want the package to populate out a cover page which would be summary of MTD and YTD results followed by a page for both results in Income Statement format with a variance explanation page last. Thanks for any help in advance