Discuss the structure of your application build.
Recently active
I would like to create the Report that runs to multiple Entities and my table of content would be list of Entity.I would like to make use of report designer component which is in OneStream .Can someone please help me understand how to do that
Hi All,I am trying to create a dashboard to extract the data for the given point of intersection basically I have given all the dimension parameter for the user to select and click on the button download that runs the DataManagement job and will extract the data for the selected POV .I am able to achieve the above requirement just like an enhancement I want to also get the data of the user details who has loaded data into those point of intersection.Can some one help me with the lead how can I achieve the above user details that would be really great.Thank You
I need to make some changes to the UD3 dimension hierarchy member names and was wondering if there is a way I can do a mass update. For example, the coding used for UD3 name OLD_XXX will need to change to NEW_XXX. There’s ~266 members I need to update and many more to come. Can you please advise if there is an easy way to make this change? Thanks!
Hi all,I'm building a Report Component from scratch, but I'm not able to put the Application's Logo (defined in Application Properties / Logo File) in its header.I can add an Image control, but I must fill it with a file (or URL), looks like I cannot bind the control to the Application's logo (and IMHO this would be really helpful)I also tried to look at Report's Scripts, I see a lot of events, but I cannot find documentation to use them (maybe there's something I can do through them, to grab image from Application Properties, injecting it into the component)Just wondering if there's something I could do... Any help would be really appreciated
Can I extract multiple Cube Views using parameter selection in one go using a Data Management job?
Has anyone experienced after creating a shortcut that the OneStream icon is missing from the shortcut? If so, does anyone know how to resolve this issue? I know I can create my own icon and map to it, but I would think that this should be there. Thank you
Hi Community,Is it possible to execute a Book from a business rule?Regards
Hi, I'm trying to figure out how can I make few rows as un editable. Example: highlighted rows in below screenshot. I remember this can be done through Row overrides but its not working. In column member filter, I defined two dimensions as below. What should I define in Row override to have 'Total Revenues', 'Total Expense' and 'Personal' rows un editable?
Hi, I'm trying to create a form with set of accounts in rows and column should be for adding the adjustments. Here, I do not required to pull any data from the cube. Instead I have to update the adjustments based on the scenario selected. This should be a separate form where the adjustments data should not update the existing forecast data. POV: Parameters in POV are defined to pull the accounts accordingly. Rows: Columns: Issue: I couldn't get the form with editable fields. refer screenshot below. FYI: Can Modify data for Column is set to 'True'
Hi Folks,We have 12 forecast scenarios and 12 FX rate tables for each FC scenario.When we update the FX Rates in one table, it's upsetting the status in all other Forecast scenarios, but not Actual.We don't want other scenarios status getting affected when ever FX rates updated. and there is impact status rules exists in our application.Appreciate your advise. Thanks
Hi, We're on 7.4. Is there a way to extract a posted journal from one application so that I can easily load it to another application. This would be super useful for investigating issues. At present, we can easily find imported data files, and load these into our test app. But I can't see any way to extract journals in the same way. The only options seem to be extracting a .csv file, which has the information but is not formatted in a way that can be loaded again.
Hello,i've installed the SIC and it's Online in the "smart integration connector part" as you can see: in the error log i have this error:Summary: Smart Integration Connector Gateway Server Heartbeat has timed out for 'mantu_database_connector'. Current timeout: '5'. Last Reported Error Time: '9/25/2024 7:16:56 AM' UTC.and in the "system configuration part" i have created the a custom database which in i can see that the Mantu_database_connector is offline: if anyone knows what's the error and how to solve your help will be much appreciated.Thanks
Hello, I have a defined a dynamic dashboard based on an SQL table component. The goal is to create dynamic dashboards based on this table. In the last column of this dashboard, I have a parameter which drives a selection based on 2 values: Manual, Predictive. My dynamic dashboard run as expected except for the last part, which I would like to have as a Radio Button Selection and should reflect what is defined in the table. My question is : is there a way to define what would be the selection of the radio button based on a dynamic dashboard business rule ? Regards,
I'm using attribute members, unfortunately on the entity dimension, so the associated data is stored and not dynamically calculated on Parent Entities. These attributes members do not translate to foreign currencies during the consolidation process ! I'm using a 'Custom Translation', and when I execute the method 'Api.Data.Calculate()' or 'Api.Data.CalculateForTranslation()' the attribute cells do not translate.The only way I was able to actually convert them is by using Data Buffers and forcing the conversion.Is there a reason why ADC methods do not translate attributes ? Is there a hidden property to activate in order to take these members into account ? Should I use 'Api.Data.Translate()' instead of ADC ?Thanks
Dear all, Could you please advise what type of scenario is better to use for FastClose (first version of actual financial statement numbers, which we want to keep separately)?
Hi All, I am trying to create the dashboard where I pass all dimension from combo box to button taht triggers the DM sequence that has the Export Data step.I get the following error mentioned below. FYI please see the screenshot of the export data step mentioned below. Can someone please help where I am going wrong please help me with the approach. Thank you
Hello everyone,We are currently building a solution. Where we try to only pull the PlainText from a RichText component. Currently we got in our research two solutions proposed: Regex solution, which is prone to errors as we need to cather for various cases and exceptionsRichTextBox() functionality, that seems to do what we want as standard (see below) that but that throws an errorSeems this function is not used/available anymore in v8. Does anybody knows if it's possible to use this still in v8 via some additional set up in the app ? Or if we would have a corresponding similar rule in v8 environement ? Alternatively, would you have any suggestions as to how easily manipulate and extract plain text out of rich text object's code ?Thank you in advance for your help!
If a user is part of a security group with the below "Data Cell Access Security" filters, does that mean they would only have access to "Ent_3200"? For some reason this user is still able to see all base entities however they are still restricted from TOP? Why would the "E#TOP" filter be correctly restricted, but E#top.base not be restricted?
Hi all, I have set up Cube Data Manager. I am getting this error when I click on “Metadata”: Any idea on how to solve this? Thank youDaniela
We have a workflow structure such that each entity has it's own workflow, with a number of steps for Import, Forms and Journals. We had an issue recently where one entity (e.g. E123) accidentally posted a journal to the wrong entity (e.g. E321). I can't see any way in the workflow settings to prevent this. I know in the Import workflow steps there is the option 'Can Load Unrelated Entities', but I can't see anything similar on the Adjustment workflow step.
Hi,So I am using one Parameter in Cube View Formatting where I am facing some issue.So there are 11 Forecast Scenario in my application.Fy25Fcst1, Fy25Fcst2 through Fy25Fcst11.My formatting rule is set in this way- If ([|!Scenario_WaterFall_MemberList!|] Contains Fcst2) Then ***Condition***End IfThis is working perfectly for scenario 2 through 11 but even if I select 10, this shows the result of 1 as well.To negate this I tried to replace the condition with If ([|!Scenario_WaterFall_MemberList!|] EndsWith Fcst2) Then But this is not working. Can anyone let me know what can be done to resolve this issue. Thanks.JackLacavaKrishna
I've got a Tree View component which is populated via code in an Assembly.It currently displays all the members for a selected dimension but will can only show those members that a user has access to.The tool that is a part of is indented for cross group use so it would be useful for users to see all the members available, not just the ones that they have access to. It's purely a visual aid, not for data viewing.Can anyone advise if this is possible and what I'd have to do to enable it?Thank you in advance :-)Craig
Hello, Other than the 200 character limit, are there any other restrictions imposed on the Default Description for a dimension member? Thank you for your time.
Hello to everyone. Does anyone know how to build in Excel Add-ins for Task Manager? Our OneStream version is 8.2.2.16127? Guidance for this version provides the step-by-step instructions how to set up Add-ins for Word and PowerPoint, but not for Excel Add-ins. Our Task Manager version is PV800 SV100. If to be very specific, we are looking for the opportunity to install Excel Add-Ins to link the preparation status from excel file to particular task in Task Manager. For example, if we have the excel file somewhere outside OneStream (on Sharepoint), and when the work done inside this file, we can push built-in "Complete" button in this file. The completion status from this file automatically forces the change in the preparation status in Task Manager for this task, which is linked to this file through the action type functionality in Task Manager. Does it sound real? Could it be potentially implemented from technical point of view? Thank you in advance fo
Hi,Is there a way to see what PoV was used when a Data Management step was executed?I am not able to find these details under Task Activity.Please suggest if there is a way.Tx.
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.