OneStream Platform Forums

Hi Just wondering if it's possible to format the page numbering when running books to ensure the output is based upon the page number and the total no of pages in the book.  For example if there were 30 pages in total in the book then I would need the format sequence as follows: page 1 of 30, page 2 of 30, page 3 of 30 etc........... up to and including page 30 of 30. With the current standard formula for suggested format : (i.e.) The output is currently as follows: page 1 of 1, page 2 of 2, page 3 of 3 etc............  (this isn't really useful for a book)   Thanks      

Hi All, I have UD1 and UD3 dimensions, here UD3 made as Is Attribute= True and linked to UD1 as Related Dimension Type=UD1, and i want to load and see the data in UD1,Account and UD3 combination, can anyone suggest how to achieve this scenario   Thanks in Advance.

Hi I am using a column override formula in my cube view and I have noticed that it doesn't work when I try override a column when the name has spaces in it, even if I surround it in square brackets. Am I doing something wrong? Regards, Mark

Hi,  I am trying to load a CSV file to OneStream through my Workflow. I have a few rows in my csv file where the IC column is empty. I am trying to map those IC lines to go in "None". How would you do this? I have tried through a one-to-one mapping; source: |null| and target: None, but it doesn't seem to be working. Thank you

We have an intercompany dividend we are trying to eliminate using a plug account. One entity is recording the expense the other entity is recording the dividend as an equity account. We are utilizing a plug account to match and have it appear on an intercompany statement.  Is it possible for the system to eliminate the amount using a balance sheet vs p&l account? I am seeing the consolidation top level hierarchy reporting out of balance in the balance sheet.   

Everyone, we are trying to create a data buffer using GetDataBufferUsingFormula where we would like to have the current entity or all the DU member's information included. Is there a way to do that? the idea is to get the buffer and then apply a filter based on the entity key. 

I currently have a cube view set up that allows the user to enter lines of text to serve as commentary on the overall dashboard. The issue I am having is that the cube view does not allow for multiple lines of text on the same row.  I have done some research to find using a grid view allows for multiple lines of text in the same row. But I am not sure how/if it is possible to configure the grid view to appear similarly to the cube view but allow for multiple lines of entry within the same row.  Is it possible to replicate the cube view shown below but using a grid view to account for the multiple line of text functionality? Any help is appreciated!

I showed it at Wave and share it with all of you: when you use JSON to log, you can log anything, not just strings, you can log a Dictionary, a list, a MemberInfo, even a Databuffer. First, you need to import JSON, add these 2 rows at the top of your rule: Imports Newtonsoft.JsonImports Newtonsoft.Json.Linq Second, when you want to log, use JSON! Dim stringobj As String = JsonConvert.SerializeObject(lCenterInfo,Formatting.Indented)api.logmessage(lCenterInfo.Member.Name & ", lCenterInfo: " & stringobj) When you use ,Formatting.Indented, your log will be correctly formatted. Thanks to Matt Ha for enlightening me with JSON and RobbSalzmann for sharing how to have the JSON string correctly formatted!

Hello Everyone,I am having issues retaining the previously selected parameter value in the dashboard, which is linked to a button component. I have a dashboard that has a parameter to pick an entity, and this parameter is attached to a button component in the dashboard. Let's say I run the dashboard and pick an entity X from the button for the first time. If I try to open the same dashboard again and again, the same entity X gets displayed by default, which is expected.Now the problem is when I attach this dashboard to a workflow. From WorkFLow, the entity that I picked for the first time in Dashboard is not getting retained when I open the same dashboard multiple times from through WorkFlow. Is this behavior expected, or am I missing something here? It would be great if anyone could help here.Thanks, Balaji V

Originally posted by Rich House4/22/2020 Hi, I have a query I'd like to solve. I have a data source where the Entity and UD5 are in general driven from the same column ""Profit Center"", column 6, in a delimited file. However there are instances when the ""Profit Center"" column is BLANK. Is it possible for those instances to use a different column i.e. use the ""Company Code"" column 1. If its possible, what is the best approach? Or perhaps, can I populate ""Profit Center"" with the ""company code""? I could then use 100 and 600 in my transformation rule

Hi All- we have a situation where we are receiving two separate ledgers, one in Local currency and one in USD. The USD ledger includes adjustment and revaluation effects on several accounts in addition to translation. For non-USD entities we are just utilizing the Flow dimension and a USD Override base member to store the USD value, with a business rule to override the USD translated value with the USD value from the second ledger. For USD entities this isn't working, and we get a formula error if we try to force C#Local to differ from C#USD. Is it possible to set the value of C#USD to a different value than C#Local for a USD entity?

Morning community,   A user is uploading information using the embedded spreadsheet, for some reason is getting the following error: "The size necessary to buffer the XML content exceeded the buffer quota" and we have no idea why is this happening. Adding a screenshot of the error.   Can someone please give me some light?   Thank you, Arion

Hello, does anyone know if we need to worry about this warning?  There aren't much details provided in the error log. Summary: SQL Blocking detected: Database Name: , Request Session ID: 72, Blocking Session ID: 12, Blocked Object Name: , Resource Type: FILE: 9:0, Requesting Text: , Blocking Text: , Request Mode: , Blocking Time: 12/2/2023 8:05:57 AM. Thank you,      

I didn't yet find a post about this anywhere so adding this here in case anyone else encounters the same problem. If a user has an Excel with a formula that references a cube and a scenario that is not valid for that cube (i.e. there is no CubeRoot profile for that cube/scenario combination), all cells in the Excel (not just the cell with the mistake) will show #REFRESH instead of the expected values. This will somehow corrupt the Excel so that the problem continues even after the cell is removed and the sheet is refreshed! The only way to get all the other cells to retrieve values correctly again seems to be to remove the cell with the mistake, restart Excel, and then refresh again.

Hello there, In an Import WF profile, I would like to duplicate all rows where the UD3 member is different than None. In the duplicated row, I need to change the UD3 POV to 'None' I know this can be done easily through 'Derivative Rules', however I am trying to do so in the Data Source through a 'Complex Expression' or 'Business Rule'. PS: This is bad practice since source data should NOT be altered to keep Audit trails, but in my case I am just exploring possible options  

Hello, We have a url stored in SQL server as a text. When we retrieve that we want it to appear as a hyperlink in SQl table editor. Could someone please help. Thank You, Indu

Hi team How do I create a border across rows and columns, essentially creating a box around them? The use case is for showing the detailed amounts for a subtotal in the AFS, contained within the box - as seen in the screenshot attached. When trying to add borders to a cell, it automatically applied the border selection to the rest of the rows as well.

Hi, We have a non-euro company that initially reported on input_level. That local amount has been translated to EUR. Later on in the process the local amount was removed, however the converted EUR amount remains in the system. i have done a force calculate, force translate, (force) consolidate. Nothing seems to remove the EUR amount!? Question: how to remove the EUR amount without touching the Local amounts. thanks!  

Hello! I have a user group who needs a specific set of data pulled just after close every month in order to populate other reporting tools they use. Here's the formatting they require: I'm struggling on my options because this results in about 16M+ rows of data. I get an error when trying to export the CV and a QV won't show all rows even with the max # of seconds set to the largest number (which I believe is 600). A DM extract will not show the right format but I don't think a QV can be auto run and sent via Parcel Service. What are my other options? Thanks for helping me brainstorm!

I am trying to incorporate patterns in the advanced charts and bi viewer bar charts. I don't see any option to select the color patterns. This is one of the examples of the pattern mentioned below -> Light Blue 48A6EA Dotted 90%  

I am working with two different Onestream clients and having login issue with one client. See attached picture of the error. I have tried clearing cache, restarting the machine multiple times. Any help to resolve this issue is appreciated.

Hi All,   I have created a cube view in which rows has data with ChildrenInclusive like parent with child members in a same row  and base members are aggregating to the parent. Here I need to change the format like bold, color, Text color to the parent member only. Can anyone suggest how to do that.   Thanks in Advance.

To be able to use them in Task Scheduler, you must organize your DataManagement Steps into Sequences. Question Credit: Jack Lacava Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in two weeks. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases

Hello, How can I see the signage from aggregation weights. For example I have these 2 account groups in a hierarchy: PL44000000 has aggregation weight 1 PL43700000 has aggregation weight -1 When I show these in a cube view with SG&A.Children.Base all numbers are showing as positive numbers, which makes it difficult to see how it adds up. This example is still straightforward, but I have some more complex use cases.  Is there a way to show the numbers based on the aggregation weight, or just show the value from the aggregation weight on the meta data member (-1, or 1 in this example)? Thanks in advance      

I am new to OneStream and I am trying to find out how you retire an entity.  I have gone into the entity and tried to change the vary by scenario type but cannot get to where you would change to False for "In Use".  Any suggestions