Discuss the features and functionality of OneStream.
Recently active
I built a cube view which contains blank cells (this is expected) as there is no data in the intersection. How can I forcibly show 0.0 in these cells (intersections) instead of blank cells? Thanks!
An account can exist in multiple account dimensions. Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
I have a dynamically calculated member formula. It is returning the wrong value for each Quarter, it should be the sum of the M1+M2+M2 ($1,614,441.60) and not be recalculated ($1,649,190.40). Is there a member property or formula examples that can help me resolve this issue. Thanks. Sample calc Drill down formula I tried setting a different formula on the quarter, but I get the error message “The Dynamic Calc Member Formula is recursively calling itself:. Thanks,
Hello All, For the Transformation Rules, 1-1, Composite, Range, List, and mask rules, what are order of operations in rule types? Do the rules that run later overwrite previous results or does it ignore later matches after a match is made? Where can I find documentation on this? Thanks!
Hi everyone, I am trying to retrieve a Chart (Advanced) in my PowerPoint presentation, making use of the Alt Text functionality and extensible documents. The chart component works perfectly fine in OneStream. I can see the chart and correct the data. However, when I open the PowerPoint containing a picture with the Alt Text, I get the following message: The message prompts that there are no parameters for the selected item. However, my data adapter is linked to a cube view, which has an entity selection parameter in the cube view POV. When I click 'OK', the PowerPoint opens, but the chart area is empty. When I hardcode the entity in the cube view that is used as a source for the data adapter, I get the exact same error message, but the chart area is populated with data. Therefore, I think I'm doing something wrong with the parameter settings of the Chart (advanced) component. However, I cannot figure out what I'm doing wrong. Any help would be very much appreciated. T
Hi everyone, I want to retrieve a report component into my PowerPoint, using the extensible documents and the Alt Text functionality of PowerPoint. I have created a graph within a report component. As you can see in the picture below, I have created the graph within the ReportHeader1 section of the report, and it shows data when it's run. However, when I open the extensible document PowerPoint, it just shows a black window. The picture has the following Alt Text: {XF}{Application}{Report}{Development} PageNumber=1, CropLeft=0, CropTop=0, CropWidth=0, CropHeight=0, Zoom=100, MaintainAspectRatio=False, FillMode=Height, Anchor=TopLeft, IncludeBorders=False, IncludeReportMargins=False, IncludeReportHeader=False, IncludeReportFooter=False, IncludePageHeader=False, IncludePageFooter=False. This is the outcome: Any help would be much appreciated. Thanks! Kind regards, Floris van der Poel
I have a bar and line chart (line being the 2nd Y-Axis). I want to sync the two scales; Anyone know how to do that? I did not see an option to sync and looking for guidance.
Hi, New user here. I have a report I'm building to show current year to date and prior year to date metrics, each with a variance column followed by a blank one as shown in the example screenshot below. I'd prefer to see 8/22 - 8/21 below each Variance column. If not, then just blanks for both Aug 2021 and YTD. Additionally, I'd like to see nothing in the blank columns where it currently shows None, Aug 2022, and YTD. Below are the settings I have for Headers and Columns, respectively. Thank you,
Hello! Can someone point me in the direction of the definitions for the status numbers on the Data Records table? I also submitted the question to OS support because I can't find the info anywhere. Here's where I mean: Thanks!
Hi everyone!I am Angel and I am new to OneStream implementation and currently facing an issue. I am trying to update the Cube Name in my Workflow Profile, but it returned an error message.This workflow profile is under Cube A which has been set as the 'Top-Level Cube for Workflow'. Under Cube A, we have several Sub-Cubes (Cube A1, A2, etc.) which have been set in the Cube References. I am trying to update the 'Cube Name' in my Workflow Profile from 'Cube A' to 'Cube A1' because we would like to load the data into that sub-cube (Cube A1), but it gave me the error message below (screenshots below). Could you please tell what the error message is about and what I can do/check to fix it? Any answer would be so much appreciated, thank you!! Cheers,Angel
Hi everyone, I would like to add a top and bottom border to a specific row in the report when I export the cube view. I know this is done by setting the GridLinesColor to a specific color and ReportUseTopBorder = True and ReportUseBottomBorder = False. Even though my client will not use the cube view but is only interested in the report view (which will be exported to PPT), I would like to know if I can have the top and bottom border in the report view but not show the grid lines when viewing the cube view. Thanks for any help in advance. Kind regards, Floris van der Poel
I am trying to get both columns (April 30, 2022 and April 30, 2021) to spread out a bit in the report shown above. I would also like to center ASSETS when my columns are not so close to the middle of the page.
Hello All, I need some Quick help . is it possible to create a Child under a Base member that has a value. for example in my UD2 dimension i have Book A1 it is the Base member and it has data in it. If i try to create a Child under this A1 , Child A1_C. i am losing view of the Data . Is it a Cube View issue i need to resolve . or its not possible to create a child under a base member that already has values in it ?
I can drill from a Confirmation rule. Question Credit: Peter Fugere Is this statement fact or fiction? Comment your best guess below! Answers will be revealed in one week. * This question is applicable to Platform 7.3.0 and may not be relevant to future releases
How can we get a system generated report for version compare for metadata and finance rule changes? The question is related to providing SOX audit documentation compares to auditors as this a finance tool. Earlier in HFM, we used spreadsheet compare. Please suggest.
Hello, I am attempting to build a simple line chart through BI Viewer with Cashflow amounts in Y axis and Time (month-year) in X axis. I cannot get it to sort properly so it display data to flow through time. In the X axis, I choose Time for Arguments and sort in ascending. But it sorted as 2021M1, 2021M11, 2021M12, then 2021M2. When I change Time display from Name to Description, it goes by April-2021, April 2021 etc. How do I set this up so Time dimension flow through chronologically?
Is there a functionality to populate headers when we open a cube view from Excel. Currently when I open Excel, connect to OneStream and open a cube view, the headers that we set in OS does not populate. Is there a fix to this?
Hi everyone, I am having some issues with the report dashboard component. I have created a report that consists of a graph linked to a specific data adapter. This data adapter is connected to a cube view. Everything is working fine, I am getting data in the graph, and it's doing the correct thing. However, the graph is printed 72 times on the report. These graphs are all identical, so it prints the same graph 72 times on the report. Is it a coincidence that when I test the data adapter, the 'total number of rows' is also 72? In addition, is there a setting where I can specify that the report should only be printed once? I hope someone can help me find a solution. I really appreciate any help you can provide. Floris van der Poel
T#PeriodPrior1(|!DRU_Year!|):Name(April 30, 2021) The member filter above is not dynamic since I am hard-coding 2021 in the second column. How can I make the second column be a prior period based on the first column?
Team Can you please help where will the Books be saved to export as .xml/zip file. Am trying to check that under "Application Load/Extract" RegardsVarun
We have several equity accounts with "USDOverride" entered for Text 1 in the "Vary by Scenario Type And Time" section of the member properties. Those accounts are not translating from local currency to USD. Any ideas why that would be? Thanks!
Hi, I have a process that would be run at the month end to lock the workflow. Once the workflow is locked, you need to refresh the application to see the lock icon on the period in the workflow. The icon doesn't change until you hit the refresh button. Is there a utility in the business rule to refresh the application (I would need to include this utility in the business rule) ? Ragav.
Is there a way to enable Account descriptions in other languages like Dutch?
Hi everyone, I am trying to add records to a table via an Excel Table View. Using the example in the Table Views documentation, I am able to update existing records; however, any new records added are cleared once I submit the sheet. Is there additional code I can add to allow the Table View to write new records to the table? Thanks! Molly
I need to move data between two mutually exclusive cubes. Cube1 (FinPlan) U3 dimension base level is ProductType, Cube2(SalesFcst) UD3 base level is SKU which rollup up to ProductType. SKU also has a Text6 field containing its ProductType Code. I also have separate Account dimensions: Cube1 uses FinAccounts for Forecasting, while Cube2 uses the SalesFcstAccts dimension To move the data from Cube2 to Cube1, I tried using a Business Rule using the api.Data.ConvertDataBufferExtendedMembers function Cube is an option: Dim summarySalesFcstData As DataBuffer = api.Data.ConvertDataBufferExtendedMembers("SalesFcst", "Fcast1", dbSalesFcstData) However, it didn’t replace the SKU with its ProductType. Does anyone know is this function will work between mutually exclusive cubes with different account dimensions. The second approach I would like to try is to extract the data from Cube2 including the SKU Text6 value of ProductType, then I
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.