Application Build

HiDoes anyone know if it is possible to create a 'Read only' column in a SQL table editor?I have set the column format 'AllowUpdates = False' which almost gives the correct functionality. However, the field is still editable when you insert a new row.I currently get around this by completely ignoring the value in the field during the SQL Table Editor Save Data Event, but I wondered if it is was possible to ensure that it never appear editable to the user?Regards,Mark

Originally posted by Matt Grundey 11/6/2017 Hi, has anyone any examples of using Cubeview extender rules to change the logo displayed in a report based on the entity selected. I'm aware that this wouldn't work where entities are shown in rows or columns. I can't see any examples of passing in parameters into these rules that could identify the entity, nor can I see from the reference doc how I can get the entity that the report is using. 

Hello,Our Business Operations team provided us the plan in an offline copy of a cubeview in Excel.When the FP&A user opens the offline copy it shows #LOGON instead of the numbers.How can the FP&A user see the actual values instead of #LOGON?is there any setting that will need to be set to view the values before submitting into the application?Thanks 

Do we have a function that can be used in a member formula that will calculate the average of the last 3 periods.Example: If my current forecast month is June, I want to calculate the average for the months of May, April, March for which I have actuals for a given account. Thank you. 

Posting this because I searched for the answer before putting in a ticket with OneStream support (who were excellent, by the way).  One of our applications wasn't working in a lower environment.  The connection to the application SQL DB wasn't working.  Tried removing and adding it back using the OneStream Database Configuration tool.What the fix was:The “Invalid Connection” issue was due to the DB security settings for the service account user (that was running the OneStream server application).  Not quite sure what the issue was  -- it might have been the default schema for the user.  In any case, looking at the permissions for the user in the other application SQL databases where it was working correctly gave us the guide towards fixing the issue.

Is there a way to set the property of a dashboard button to disabled?  I have a dashboard that includes a number of button objects that execute various tasks, such as running a calculation, locking the workflow and so forth.  What I'd like to be able to do is to disable a button as part of a business rule so that the user has to follow a sequence of activities and can't, for example, keep pressing the calculate button on the dashboard. I don't see any property in the button object that supports enabled/disabled.

Hello All,   I would like to know if there is any Activity guide document for OneStream Application design represents the process to build a new cube..   Thanks in Advance

Hi All, Can anyone suggest is it possible for Admin to enforce Workflow POV and Cube view POV for users, if so please guide where to do it on OneStream  Thanks in advance.

Hi All,   Currently I have weekly data, if i enter commentary in Week2 it should be in the same week later if I enter commentary in Week3 am getting w2 data in w3, can anyone suggest how to overcome this?     Thanks in advance.

OneStream 7.4.1 (On-Prem)Looking to upgrade to 7.4.2.Has anyone developed a strategy to upgrade OneStream with minimal downtime?  Uninstalling and reinstalling the application takes time, and I would like to avoid as much downtime as possible.I am using 1 server for everything.I was thinking I could install 7.4.2 in another folder, but I believe the install would attempt to create the same IIS app pools that already exist.Any suggestions would be appreciated.

Hello OneStream Community, I hope this message finds you well. I am reaching out to tap into the collective expertise of the community regarding metadata extraction from OneStream. Your insights and experiences on this topic would be invaluable. Process and Tools: What process and tools have you found effective for extracting metadata from OneStream? Are there any specific approaches, techniques, or best practices that have yielded successful results in your organization?Alation Software Integration: Has anyone in the community utilized Alation Software for metadata extraction from OneStream? If so, we would greatly appreciate hearing about your experience with integrating Alation and extracting metadata from OneStream. How well did Alation cater to your organization's requirements and enhance your metadata extraction capabilities?Connectors, APIs, and Custom Solutions: Can you provide specific details on any available connectors, APIs, or custom solutions that enable metadat

Originally posted by Katarina Sterley We have 4 extensions to our main cube and now we have a problem with the standard intercompany matching reports. The end users do not see the transactions on the lowest level from another cube. They only see the IC transactions within their own cube. If they look at the main account they see the transactions but that is not displayed in the standard intercompany matching report within the workflow. Like this from quickview: From Workflow report: Any suggestion on how we should solve this? Kind regards Katarina

Hi Team, can we run or test the business rules or code snippets outside OneStream environment? Do we have any SDK's to setup and test locally?ThanksManju

Hi,  As an admin user I can add and delete rows from a SQL table editor. However a non-admin user does not have access to do so. They can view the data but the add/delete row button on the toolbar are greyed out. Can someone tell me how to give them access to add/delete rows? Thank you Mark

Hello,I am trying to limit the access of certain entities so they they can only see there own entites, i have it set up on the entities, cube, and the workflow profile so they have their own groups for each of their own set of data. The only issue is when they load their text files it is fine but when they run the transformation rules every line shows up as an invalid intersection and the error message is "No Security Access" for each line. I saw an article that recommended going to data access on the cube but i tested them empty and i tested them with what i thought the escalation rules should look like with no luck. So i wanted to see if anyone had any other ideas on possible solutions or where i might be wrong.Thank you

Hello experts,How can we copy just data from an application to another?We have an on-premise setup and would like to copy data from prod environment to lower environment application.I know we can do simply do entire DB copy for that application, but it'll replace everything (like app artefacts).Is there a way we can just copy underlying data of an application? I noticed some data tables (BinaryData20xx, DataRecord20xx), but not sure if simply copying them will work. Thanks,Gaurav

Hi everyone-I am trying to create a reporting solution that can display data from two close calendar periods in a single cube. Is it possible to include two time profiles in a single cube?    

Hello Everyone,I am setting up Azure SSO & getting below error when trying to login. Could someone point me to the configuration section that may be incorrect in this case?   IDX10214: Audience validation failed. Audiences: '<GUID>'. Did not match: validationParameters.ValidAudience: 'null' or validationParameters.ValidAudiences: 'api://<GUID>, <GUID>'.  Thanks,Hiren 

Hello Team,We are in planning of upgrade from lower version to higher version and looking for best and stable version with out any issues.Also could you please guide us best planning approach to implement this activity.Thank you. 

Hello - we recently updated the stored values in the Percent Consolidation property in several large entity hierarchies, so there are 3 stored items with different time periods for each child. We found today that when we pull data using a YTD view, whether in the Excel add on or a cube view within the Windows application, the consolidated numbers on the parent do not match the children when the latest stored value is applied to the child data. However, we did find when the view is changed to Periodic the consolidated parent data matches the product of the child data and the current Percent Consolidation. Is this issue related to the Consolidation View on our Actual scenario? Its currently set to Periodic. If this helps, our Consolidation Algorithm Type is Standard.

We worked with OneStream to set the Inactivity Threshold to 90 days but discovered inactive users are not automatically Disabled after 90 days - only flagged as 0 days of "Remaining Allowed Inactivity".  I'm assuming we could create a Business Rule or some other process that could query OneStream security data within the system to confirm users who meet the "Remaining Allowed Inactivity" = "0 Days" criteria.  Manual review could work as well but not preferred.Any suggestions on how this could be automated in OneStream?Thanks in advance.

Hi All,We have an issue where we are unable to delete an entity member from the hierarchy.We get this error: "Unable to delete member 'XXXX'. Error removing member. Member 'XXXX' has data.How can we clean the member 100%, so we can delete it? Thank youRomario

OS Version 7.4.1. GolfStream v44When calling BRApi.Finance.Metadata.GetMembersUsingFilter in a Cube View Extender rule I'm getting a null return. e.g.:List<MemberInfo> members = BRApi.Finance.Metadata.GetMembersUsingFilter(si, "Account", "a#16999.children", false);I'm following the method signature:Is there a better/alternate way to get the output of a memberFilter in a CV Extender Rule?

Hello, we are working on a constant currency Actuals scenario that will be using alternate FX rates and are in the process of testing a Hybrid Scenario with the 'Copy Input Data From Source Scenario' setting.  We are running the data copy with a 'Force Calculate' Data Management Step using the 'Execute Scenario Hybrid Source Data Copy' setting.  We have found that after resetting the hybrid scenario, the first run of the copy step is taking around 50 minutes to complete, but subsequent copies are only taking 7 minutes.  Is this expected with a hybrid scenario copy?

Hello, our client wants to have the option to use OneStrem in Turkish for some users. I know that using culture settings we can add descriptions for different languages to the members. What I am actually looking for to change the application language meaning the options buttons, anything on the user interface. Thanks