OneStream Platform Forums

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?

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

Hi all, new OneStream consultant and developer here. I am trying to build out a cube view for a client and I think I need to use CV math for one of the columns, but I am not sure... I need my 'Var%' column to show the difference of Actual and Budget scenarios, which I assume should be very simple, but I do not know how to do it.  Here is a partial screenshot of the Excel report I am re-creating: The row this intersects with is using the following: a gross profit account and a U8 calculation for percent of rev. The current data is showing the percent of rev for the Actual column. Do I need to use CV math within an override to get the desired result?  Thanks in advance!!!

My requirement is i need to provide few users(Admins) only oneplace and system tab access, and few users(Admin) i need to provide only oneplace and application tab access.Please any one give me detail steps on this, Thank you.

How do we delete the seeding data for a specific entity and month without an import workflow or resetting the whole scenario?

This post is to illustrate how to call a public function of a Finance Rule from within XFBR rule. The Finance Rule has a function called EntityText8 splitter, and I need to call it from within a XFBR rule. To make it work, first need to make the Finance Rule "True" - Contains Global Functions for Formulas (in Rule Properties) and refer to the specific rule assembly in XFBR rule properties (screenshot2). The XFBR rule reads: '-------------------------------------------------------------------------------------------------------------------------------- 'Returns the Entity in Text8 or emtpy '-------------------------------------------------------------------------------------------------------------------------------- 'BRString(SeedingXFBRStrings, Text8Entity, curEntity=|CVEntity|, curScenario=|CVScenario|) 'XFBR(SeedingXFBRStrings, Text8Entity, curEntity=|CVEntity|, curScenario=|CVScenario|)   If args.FunctionName.XFEqualsIgnoreCase("Text8Entity") Then   Dim curEntity

Hi! I just ran a parcel and didn't receive an email.  This has been working fine.  The log shows it was successful.  Email's not in junk folder either.  Do you know what else I can check? 

Hi All, I am building a roll forward form and I am able to get Beginning and ending balance through business rule. I am not able to input activity manually in activity roll forwards as the fields are disabled. Please see the attached picture. I have checked all POV and everything but could not solve the issue. I am attaching the picture of POV and flow member for your references.  

Dear Community, we have a requirement to add Pie chart (BI Viewer Component) to the dashboard reports. we were able to see the pie chart when we ran the BI Viewer component but when attached to the dashboard it does not show the pie-chart. Here are the properties we used for the dashboard. Any solutions to this will be helpful and appreciated.  

I have a cube view that utilizes a shared Row and Column set. The row set has roughly 300 rows. Is there a way to Supress NoData Rows across the entire cube view - as opposed to modifying the setting row-by-row? Thanks, Matt

Hello, We want to update the UD2 Text5 property from a workflow step (via a cube view or a dashboard, for example). Is it possible to do it? We don't find how to do it. Thanks.

Hi there - I'm looking to add a sparkline image at the end of my cube view / page. The cube view trends 13 months of actuals. How can I add this?