OneStream Platform Forums

Dear Community, Whenever we use the drill down in OneStream, there is a call called "Calculation Script" at the very end, which in my case is never populated. How is it used ? Are there any way to access it / populate this cell ? Regards,

G'day ONE members, There are blanks for some rows in certain Dimensions in our source data files.1. In DS w/o using a Logical Operator, pls share how to map those blanks to new values, and/or2. In TR, please share how to map those blanks to new values. Thank you.

In my cube view, I need a column (% of net sales) to calculate each row/divided by net sales. In the selected column I am trying to only solve for actual. For example actual gross sales/actual net sales, and then actual sales rebates/actual net sales, and so on down my P&L. There must be a way but I have not found anything useful. I'd greatly appreciate any help.  

I am using BIViewer within the dashboard. This BIViewer uses a data adapter of Cube View type. Now, every time the dashboard refreshes, the Cube View runs and the task activity shows a Cube View entry. How can i avoid the task activity entry?

I am trying to extract a static cube view data but getting an error. The CubeView has all static members except the time dimension |WFTime| but I made it static in my code just to be sure. To begin with I only need the data table. But I am getting below error  

When adding a new member to my dimension I received the following error message when I tried to save it.  "Error saving member.  "B4632' already exists.   I did a search on that dimension and hierarchy and got the result "no items were found".   How can I determine why it will not let me save this member?  How can I find it?

Hi everyone, I'm having trouble logging a databuffer to the error log. I want to be able to do this to debug some code I've written. I got this concept from the Finance Rules and Calculation Handbook so I believe it's possible but I can't get it to work for me! In the first screenshot is the code. The red box shows the logdatabuffer script that I've written. I know there is data in the databuffer because it produces sensible results  (ie. the green box) albeit not quite right, hence why I want to visualise it. The second screenshot shows what I see in the error log. I believe I should be seeing the databuffer results in the orange box area but I just see a blank. Do I need to "switch on" this functionality somehow? What am I doing wrong?!!! Thanks in advance,Richard  

Hi there! I am trying to use Postman to run a DM job sequence. I test the DM job locally and it works fine with no parameter.I am using Azure SSO to log on the server.I can retrieve a token from microsoft for my tenant ID using : https://login.microsoftonline.com/bec456-my-t3n4nt-id-e2aba/oauth2/v2.0/token (In green in the printscreen) On my second RestApi call, I use the token I retrieved and I drop the token under Authorization > Bearer Token in Postman.Because I need to run a sequence the URL is : https://aiqos.io:50001/onestreamapi/api/DataManagement/ExecuteSequence?api-version=5.2.0 and the body is : { "BaseWebServerUrl": "https://aiqos.io:50001/onestreamweb", "ApplicationName": "GolfStreamV65", "SequenceName": "RestApi", "CustomSubstVarsAsCommaSeparatedPairs": "" } I also created an admin user in OneStream that matches the Application (client) ID found in Azure. (In red in the printscreen)The on the back end in the server config, I added the OS Werb Api Cli

I've got a Tableview embedded in an Excel workbook and would like to be able to prompt the user to select an entity and period that is then used to filter records. Is this possible?

I'm running a SQL query to display the data as if it were a QView, but I realized that the table I was using didn't contain the values it should. SELECT EntityId, UD1Id, UD4Id, TimeId, ICId, Amount, FlowId, ConsId FROM DataEntryAuditCell WHERE ScenarioId = ( SELECT MemberId FROM Member WHERE Name = '|WFScenario|' ) AND CubeId = 4 AND ICId != -999 AND AccountId = 17826015 AND Amount != 0 AND FlowId IN (1048639,-999) AND UD1Id != -999 AND UD4Id != -999 The reason for using SQL is to facilitate user access to that specific information, as a QView wouldn't display everything according to the required permissions, which in this case doesn't apply as

Originally posted by Srikanth Arasada Hi, Can any one suggest a best automation tools that fits for Onestream to streamline some of the QA/Test project maintenance activities like regression testing and load testing? I have tried few available in the market like and ended up with no luck as the tools unable to recognize the objects in Onestream very effectively. Most of the times tools fail to capture the mouse location or an object/Item in the product page. Appreciate if you could share our experiences and any feed back if some one tried something before and worked for them. 

Hi OS Community,  Was wondering if anyone has visibility into or can point me in the direction to update the Environment Color in an application?   I know it can be done, thinking it might be the Config Utility or SNOW request, just having trouble finding documentation on the process to update.  The guide says all you need is admin access:  But I'm finding that not to be the case in multiple environments Any help would be greatly appreciated!      

Hey all - does anyone know the best practice to securitize the drill back functionality based on Entity (or other group) access?  My use case is that we have users who can see entire company financials (actuals and planning) but should not be able to drill back to the People Planning registers unless they meet a certain criteria (in a specific security group and have a specific entity group access).  Thanks for any assistance!

I'd like assistance with utilizing a formula within the UD1 dimension section of the attached POV Cube view. Specifically, I am trying to subtract one cost center from another. So the formula I'm hoping for is something like  "GPPPFI - GPPPAccounting" but thats not working.

Hello,  If anyone needs to sort a specific account group by ascending. This is the codes it worked. Sub RemoveandSortAccounts(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardExtenderArgs) Dim ParentGroup As String = args.NameValuePairs.XFGetValue("ParentGroup") Dim osAccountMember As Member = BRApi.Finance.Members.GetMember(si, dimtypeid.Account, ParentGroup) Dim actDimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si, "ST_Accounts") Dim osBaseList As list(Of Member) = BRApi.Finance.Members.GetChildren(si, actDimPk, osAccountMember.MemberId) Dim osBaseList2 As list(Of Member) = BRApi.Finance.Members.GetChildren(si, actDimPk, osAccountMember.MemberId) osBaseList2.Sort(Function(x, y) x.Name.CompareTo(y.Name)) If osBaseList.Count > 0 Then For Each baseMember As Member In osBaseList 'osBaseList '===Remove first==== Dim PId As Integer = BRApi.Finance.Members.GetMemberId(si, dimTypeId.Account, osAccountMember.Name) Dim myId

Dear community, I am working on a graph that shows the daily FX rates.  I am bringing the data in through an SQL Data Adapter and have set up the following settings in regard to the data and what is shown on the x-axis: Data is shown in days, but the x-axis name are 'summed' to the months.  This works great except for the fact that it writes the month as full. I think it's based on the Time Dimension Description because the date format in the data table is: MM/DD/YYY As you can see the graph is quite small and the naming takes up a big part.  Does anyone know if it's possible to adjust the sourcing of this naming/description? Maybe to a UD8 TimeDescription member or adjust the description of Time in the graph itself, or maybe through the data table or data adapter?    Thanks in advance!      

Dear community,  We encountered a reporting issue: when exporting a cube view to Excel, one line of data will flip the signage.  In cube view, we have the Budget amount of (10,763), and the delta is calculated with GetDataCell(CVC(Actual column) - CVC(Budget column)), which should be 700, but the delta is showing (20,825) instead.  When exporting this cube view to Excel, the Budget amount becomes 10,763 (which is incorrect), but the delta is calculating correctly as 700. For delta, the temporary solution is to calculate with GetDataCell(S#ACTUAL - S#BUDGET); however, the Budget amount would still flip the sign when exporting to Excel.  We use the Text1 property in the cube view to determine the expansion, TreeDescendantsInclusiveR.  For the formatting, we use the below parameters in the cube view: BackgroundColor = White, NumberFormat = [#,###,0 ;(#,###,0);"0 "], Scale = 3, ExcelNumberFormat = [#,##0,], ExcelUseScale = False This happens in Budget for EntityA

Hi there, I have a dimension with 10 000 members under a TOP member.I can delete all of the relationships below TOP running :  BRApi.Finance.MemberAdmin.RemoveRelationshipsHowever, it is extremely slow as it does it one by one, so it takes hours.The same thing with the XML load is a load faster.  <relationship parent="TOPTOP" child="XXXX" action="Delete" /> Any BR to upload the XML or other clever ideas? Thanks One Team ! 

Hey guys! Just a reminder: if you're going to post code in this forum, please make it easier to read by using the "Insert/Edit Code Sample"  button on the expanded formatting toolbar. Here's a short video showing how it works. If you need to edit code after you created the block, just double-click on it. Ideally you'd also indent it first, either in an editor or with something like DotNetFiddle. Remember: the easier it is for others to read your code, the more likely that they'll be able to solve your problem! Cheers!Your friendly neighborhood Spider-Mod

I would like to set a transformation rule that particular account can be map to 2 accounts with condition +/- amount. Example, if positive go asset account, if negative go liability account. I had tried derivative rule is seem not working. After validate it become go to both accounts. Is there any missing caused the rule not work properly?        

Hi, All Just wanted to share a SQL query I wrote to retrieve base members and parent of a given hierarchy from within a dashboard grid.  (Note that the parameter supplies the member ID of the top member in the chosen hierarchy.) Any thoughts on how to improve are welcome! With TEST AS (SELECT childid, parentID, dimtypeid, 0 AS level FROM relationship WHERE parentid = |!SelectDimension!| UNION ALL SELECT ft.childid, ft.parentID, ft.dimtypeID, level + 1 FROM relationship ft JOIN TEST d ON ft.parentid = d.childid ) SELECT m.name As Child_Name, m.description as Child_Description, P.name AS Parent_Name, Description as Parent_Description FROM TEST d JOIN relationship a ON d.parentid = a.parentid JOIN member AS M ON a.childID = m.memberid JOIN member as P on d.parentid = p.memberid where NOT EXISTS ( SELECT NULL FROM TES

Looking for function in the business rules to derive prior quarter based on the year and month value passed from parameter?

I am trying to create a conditional formatting code to convert a large percentage result in a percent variance column to replace it with text ("nm").  Can anyone provide the conditional formatting text that would replace the actual % variance with text?

SOURCE: ONESTREAM CHAMPIONS Company has a hard carriage return in their file for a couple of description fields. They are struggling to fix it on their side. Is there code that can be written for the data source to remove this hard return and get everything on one line? Appreciate any guidance or snippet of cod

Hi Community,  does anyone have a list of special characters that OneStream does not allow to be used in passwords for service accounts used for direct connections?    Thank you