Application Build

Hi, I have set all security settings on an entity to "Nobody" and yet when I see a dashboard using a non-admin user I still see data. The same when using a spreadsheet. This does not make sense to me. What am I missing? 

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)?  

I've heard about org by period since my first exposure to OneStream but I see nothing in the docs and no clear discussion about how it works or what the limitations/requirements are. Where does this information live?

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?     

Hello All,Anyone know if it is possible to pass a parameter value into the PLP Register?  I have a method query returning a value based on scenario & year and need that to be the column header in the register.  This is more of a POC than a hard requirement at this point.Any creative suggestions are welcome. 

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 

Hi All, Working with a dialog box with 3 parameters that are being used in a business rule later on. I want the parameters on dashboard load to always show the first value in my delimited list. Right now it always saved my previous selection. I have tried to set "Default Value" in the parameter itself, that dosen't work, guess it is only working on first load? I have tried to run a Dashboard extender BR like below to set param values on load of dashboard, but it dosen't overwrite my previous selection.: Only thing that have worked this far is to set a bound parameter with a set value on my button that opens my dialog box. However it seems to only let me add one bound parameter, I have 3.    Anyone having any advice how I can set one value from my delimited list to always appear when loading my dialog box. 

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 All, I have a Cube View that I want to use as data source for a BI VIewer object. When I execute this CV, I can see data: When I use this (basic) CV as MD in data adapter, it is empty. I checked the set up steps in the doc and I can't see what I could have missed.   Would you have any ideas why the result table doesn't return values that I can see in my Cube View ? Thanks for your help Matthieu  

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.

Was able to "Process Cube" for October and November... in attempting to close a form for December (1Q) - now receiving this error message. The Entity Assignments and Calculation Definitions on the Workflow Profile are the same as they've ever been. Can somebody share other possibilities based on what this code is telling me? Cannot execute the Process Cube (Calculation) workflow task because the current workflow profile [Investment_Sub] has not been assigned a calculation definition.User Interface Stack Trace:   at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)   at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs)   at System.Se

Is it normal for certain security settings to be "reset" when a copy of production is made to dev? Every time we make a copy of production into the development environment certain security fields within Security Roles, Entity dimension, Scenario dimension, Workflow Profiles and Data Management Groups are set to "(Not Found)" instead of the correct security group.  Is this normal? If so, what's the easiest way to update this? Thanks!

Hi all,I'm quite new in OS and, as a Dev, I'm writing some code in Assemblies/Business Rules.I'm experiencing an issue with Intellisense.While I'm working from inside a class, I can see all the hints supplied by intellisense for all the Standard/OS Classes/Methods and for the Methods inside my current class.Unfortunately I cannot see hints for my other custom classes/methods that I wrote under the same assembly/namespace (they are correctly referenced, the assembly is compiled)I tried adding triple-slash comments, but - again - no luck.Just wondering if there's something I should do to make intellisense works or if I stumbled in a platform's limit.Thanks in Advance for Your precious helpFabioG 

Hi Team, Could someone assist me with transitioning WinSCP operations to SSH.Net? Also, is this a good move to make? Thanks, Anitha  

Hi, I have a SQL table with a decimal column that allows nulls, and I want to differentiate between an actual 0 and a null value.I seem unable to configure the SQL Table Editor in a way that enables me to save a null value. When I press Insert new row, it defaults to an amount of 0.0, instead of null. I am aware that I can do a dashboard extender and override the save operation but in this case the column value could be either 0 or null and I wouldn't know how to differentiate between the two. Any ideas? 

Hi everyone, I have to do some systems diagnostics but I cannot run the dashboard because there is an error in the business rule "OSD_SolutionHelper". This business rule does not compile due to an error in line 4882Dim computer As New Microsoft.VisualBasic.Devices.Computer()Error: Type 'Microsoft.VisualBasic.Devices.Computer' is not defined. Anyone else encountering this issue? We are on version 8.4.0.16413. RegardsMartin  

I am trying to build a cubeview to enter yearly rates in cubeview for forecast scenario. Is there any way I can do that? Idea is to enter rates during budget and use to for all forecast months instead of loading by periods.  

In the data record tables in the database, there are status code columns. For example. Here are what those status codes mean: Status (Stored Bits) Existence Type Storage Type 16 NoData StoredButNoActivity 17 IsRealData StoredButNoActivity 18 IsDerivedData StoredButNoActivity 32 NoData Input 33 IsRealData Input 34 IsDerivedData Input 37 IsDerivedData StoredButNoActivity 48 NoData Journals 49 IsRealData Journals 50 IsDerivedData Journals 64 NoData Calculation 65 IsRealData Calculation 66 IsDerivedData Calculation 80 NoData Translation 81 IsRealData Translation 82 IsDerivedData Translation 96 NoData Consolidation 97 IsRealData Consolidation 98 IsDerivedData Consolidation 113 IsRealData DataCellDetail 144 NoData DurableCalculation 145 IsRealData DurableCalculation 146 IsDerivedData DurableCalcula