OneStream Platform Forums

I have a parameter for time that acts as the default for all reports. I'm trying to store in it the year. I want the parameter to take the GlobalYear so that I don't have to change the value manually every year.  Basically, I'm attempting this:  But it's not working

Hi - I am trying to call the DM job using RESTAPI call from Powershell using Basic Authentication . It is an On-Premise Environment and Version is 6.6. I know I can use the task scheduler but I requirement is to use the API. I have a PS Script but it failing and also failing in Postman with 404. The below is the script $User = ""$Token = ""$base64AuthInfo = [Convert]::ToBase64String([Text.Encoding]::ASCII.GetBytes("$($User):$($Token)"))$Header = @{Authorization = "Basic $base64AuthInfo"ACCEPT="application/json"}$ContentType = "application/json"$Url = "http://Host:Port/api/DataManagement/ExecuteStep"$Body = @{SequenceName="Sample"BaseWebServerUrl="http://Host:Port/OneStream"ApplicationName="Sample"}$json = $body | Convertto-JSONInvoke-RestMethod -Method 'Post' -Uri $url -Headers $Header -Body $json Any help would be appreciated. ThanksKrishna  

  Hi All In the below example value is displayed on every single combination of UDs.  This should only be calculated and written to each UD7 separately but calculated on Tops and displayed only on “NotDefined” for all other UDs. For any other POV combination- the result returned should be zero. Can we do something like this?   Dim Tops_NoUD7 As String = ":O#Top:I#Top:F#Top:U1#Top:U2#Top:U3#Top:U4#Top:U5#Top:U6#Top:U8#Top"Dim dEbit As Decimal = api.Data.GetDataCell("A#EBIT" & Tops_NoUD7).CellAmountDim dSalesProd As Decimal = api.Data.GetDataCell("A#SALESPROD" & Tops_NoUD7).CellAmountDim sEbitProd As Decimal = (dEbit/dSalesProd)*100Return sEbitProd

Hi there - Im looking to add a formula to my columns located in the cube view. I need it to pull global time + remaining target months. This involves two scenarios, so S#Actual and S#Target_FY24.    So If my POV global time is July, I need the formula to take (7 months of actuals using S#Actual) + (5 remaining months of target using S#target_FY24). I also need it to be dynamic so I dont have to touch each month, so when the POV gets switched to August, it would be (8 months of actuals + 4 months of target)

Hi all,  We are building cube views which require the expansion of three dimensions in the rows.  We use the "Allow Insert Suppressed Member" function to insert suppressed members in two dimensions. Since the expansion would generate a very long list of combinations, we want to use the function "Allow Sparse Row Suppression" to improve the cube view performance. But when a period doesn't contain any data, the allow sparse row suppression function would suppress all the rows, and we won't be able to insert suppressed members.  In the cube view rows, we have the suppression setting as in below. Can anyone give us some advice on how we can tackle this? Thanks in advance!

I have recently had the request of creating a Dimensions CSV Export File with Parent/Child Relationships including some member properties. I realised this wasn’t straightforward when Extensibility is used across the dimensionality. Specially with the requirement of presenting the hierarchy with the correct Sort Order. See Example Below: With the following set up: The CSV Out Put should be: I am sharing the solution we have implemented in case to help anyone with the same type of request/requirement. The attached Extender Business rule could be used in a Data Management Step as follows: It will create CSV file within the User Temp Folder with all the Parent Child Relationships including some properties: Currency (Only For Entity Type Dim), Text1-Text8. The solution will extract All Dimensions Type, including system dimensions. The code could be easily adapted to work of a Dimension Type List instead. Also, additional properties could be extracted as needed by modifying the Sub Routin

Hi all,   I came across a very helpful post that shows how to automate extracting metadata for backup. (original code at the bottom of post) https://community.onestreamsoftware.com/t5/Accepted-Code-Samples/Extender-Automate-Application-Metadata-Backup/ta-p/6914    I tried this business rule and it works perfectly, however I am looking for something a little more specific since this returns a massive dump of data. Basically, I am looking to automate a metadata xml extract of specific dimensions and their members / relationships separately into different files and combine them into a zip package. Is there any documentation that shows how to edit this xmlOptions syntax below to include specified return xml values instead of just extracting all items?  'Set the extract options Dim xmlOptions As New XmlExtractOptions xmlOptions.ExtractAllItems = True   Ideally in the package, each dimension would have two files. I would have two files as such: - TopU4 Members - TopU

In Application tab > Dimensions > Entity Dimensions > Member Properties, I have something configured in Text 4 and Text 5  field in Vary By Scenario Type And Time section. The goal is to display these 2 field values in a dashboard.   Questions are 1. How can I retrieve the data in SQL in data adapter? I input test data in Text 4 and find the value in both RelationshipProperty and MemberProperty tables. Which table and column should I use? What filters are needed to get the expected value? 2. Any data dictionary for OneStream application database? For this type of requirement, use SQL and data adapter to get the value for specific fields in the front end, how can I find the respective table / column / filter. Much Appreciated!      

I have an issue I would be very interested in getting community's take on and I would greatly appreciate any direction: I am trying to deal with the case of a nested ownership: one  of our 100% owned subs owns a minority stake in the other sub, At the top consolidated level there should be no Minority Interest , but at intermediary consolidated level there should be. I created an intercompany account that is calculated at that intermediary consolidated level. Calculation seem to work fine. However, when consolidation reaches the first common parent between the 2 subs, elimination of this new account is not being triggered, even though correct partner is assigned (IC Matching report matches the relevant amounts) Here is the calculation: If (api.Cons.IsRelationshipLevel And api.Entity.OwnershipType().ToString = "Custom1") Dim entityID As Integer = api.POV.Entity.Memberpk.Memberid Dim parentID As Integer = api.POV.Parent.Memberpk.Memberid Dim pOwn As Decimal = api.Entity.Percent

If these are my parameters: (delimited list and input value) what would my columns be? This is ultimately what the report should look like:  

Hi, I'm wondering if anyone else has had a similar issue when creating DynamicCalc accounts that include a non-financial account member and a financial account member? I'm trying to create a revenue per day account that will use our A#SalesTot account and our A#IscSalDays account.  My formula is below: Return api.Data.GetDataCell("Divide(A#SALESTOT, E#DRIVER:C#Local:S#Plan:A#ISCSALDAYS:F#EndBal:O#Top:I#None:U1#None:U2#Top_UD2)") When I populate a cube view with each of these accounts separately, I get the correct data, but I can't figure out why the calculated account returns blank green cells.  Since I want to use the result in a dashboard chart, I can't use a column row math expression, which is how I calculate revenue per day in our other reports.

Hello OneStream community, I have an SQL table editor component current in one of my dashboard. My dashboard is defined by 2 embedded dashboard. for the sake of this example, the first one only has the SQL table editor, the second one hold a single button. Right now, when I click on the button, it should update something on the selected row of the SQL table editor. By doing so, it also refresh the dashboard. However, refreshing the dashboard will cause the row to be unselected. My question is : is there a way to refresh the SQL table editor without resetting the row selection ? Regards,

Using this prompt, what 6 transformation rules need to be built? Currently I have: 1. View YTD to YTD on a one-to-one 2. Account * mask 3. Entities * mask 4. UD 3 * mask Huron Energy Services (HES) is a global energy services company. Their User-Defined 3 dimension in OneStream is used for their Function code. The Function code represents the job function that a value falls under. For example, Function 62 is associated with Human Resources. So, salaries for employees in the Human Resources department will be coded to Function 62 (FCT_62). When loading data to OneStream, the project team has encountered a difficulty. For every expense account in their source system, there are two accounts in OneStream. These accounts are suffixed with "C" or "G", for Cost of Goods Sold (COGS) or Selling, General & Administrative (SG&A) expenses. For example, in their source system they have account 56789, but in OneStream they have accounts 56789C, which is part of the COGS rollup, and 56789G wh

Hi team, I was trying to run a reset scenario for a particular time period and encountered the following error:   Has anyone else experienced this issue or have any insights on how to resolve it? Any thoughts or suggestions would be greatly appreciated. Thanks!

HI Can someone help on connecting a Dashboard report into Books, am trying to connect it to Books and then use the parcel service to publish the report to distribution list via email Regards Nara2757

Hello, we need to setup Data Cell Access Security based on our UD1 structure. UD1 defines our Business Unit structure and we need so setup security security on this. I spent days on this but I don´t get it to work the way we need it. We have consolidation users on different levels in the UD1 hierarchy: So some users are on to (group level - they need access on all data) some on divisional level (they should see all data within their division, so divisional level and all business units below) but the need to be restricted to their own division and are not allowed to see data of another dvision or business units which are not part of their division.   some on business unit level (they need so see all data within their business unit but not from other business units) and finally entity users: the only should have access to data on their entity/entities. How can I setup this so that it´sconvenient to maintain and all security need get met?   Regards Martin

It would be helpful if there was a way to toggle the "Include Cell Attachment Status" setting for Cube View Connections rendered in the Spreadsheet tool. 

Each member from entities hierachy has a value for Text1 member.   In the report, I use this member to get the columns needed. It looks like this    Is there a way to make that Text1 (SSC) into an aggregator, from wich I could expand, or collapse, the columns, like a tree?

Hello ! I'm facing an issue where I want to change the value in one of the cell of an SQL table editor. The row is already there (generated via business rule), but I just want to edit a cell of this row. When I hit save, I get the message "Database update error. The wrong number of database rows were processed". It only happens with this row that has been inserted by a business rule. I am able to change the value of all rows except this one. Also, I don't have any business rule running when I save my datatable. Strangely, I get the same error message if I try to delete the row ...   How to solve this situation ?   Regards,

Hi, We are facing a new challenge, as we want to rebuild the entire hierarchy, which has about 6000 members and about 150 parents. In this case we need to rebuild whole workflow hierarchy, is there any way to dynamically create a workflow hierarchy based on entity dimension? Regards, Michal

Hi, what is the best way to change the colour of the Onestream background from blue to another colour. We have separate environments  for actual and test, so wanted to differentiate through the use of different colours. Thank you.

I have built the "Compiste" transformation rule, the Rule is below. while executing through workflow and I am getting the below error message. any insights how to make this work out? Error: Dimension: Account, Rule Type: TransformComposite, Rule Name: ., Input Expression: A#[??????????1910], Output Expression: A169140.Syntax error: Missing operand before 'And' operator.  

Here I have my income and balance sheet. I need RE to equal account number 29500 plus Net income under the balance sheet. I also only have data for Jan 22. Do I create a stored calc, dynamic calc, formula pass, or something else? How would I do this? Thank you!  

Can someone please guide me on passing parameter from dashboard button to DM seq. I followed couple close forum question but still it did not work. Basically trying to call DM seq which has extensibility rule from button. Some how it not able to read value from the parameter. Could you guide me what I am doing wrong. Trying to capture value here. It work if I just execute DM but does not from button.  Dim DimTypeStr As String = args.NameValuePairs.XFGetValue("EnterDimensionType", String.Empty)  

Does anyone know why the first row is basically locked and I can pull the rest of the data out like this in an Excel Report? Anyone know a fix?