Application Build

I’ve noticed in working with the newer versions (that have Workspaces), that the SetLiteralParameterValue seems to only work on literal parameters in the default workspace.  However, I’m unsure if this is a bug or if this is by design.   My understanding from I saw at the Wave Conference was that Workspaces were intended to be used for better grouping of solutions, versioning, and development.  Currently, they support the creation of identically named parameters in multiple workspaces.  If you’re attempting to update a literal param in a specific workspace… is that even possible?  If not, are all active solutions intended to be in the Default workspace only?  Could someone please advise on the intended usage of Workspaces?

I am trying to use a dashboard button to Select All and Unselect All values in a Multiselect Combo-box which I am passing to a Spreadsheet (TableView) business rule. I have tried to run a Data Extender rule from a button that clears the data using the code below:  Dim selectionChangedTaskResult As New XFSelectionChangedTaskResult()selectionChangedTaskResult.ModifiedCustomSubstVars.Add("lv_BusinessChannel", string.Empty)selectionChangedTaskResult.ChangeCustomSubstVarsInDashboard = True ' Set the Return valueselectionChangedTaskResult.IsOK = TrueReturn selectionChangedTaskResult

We are in cloud OneStream environment and our retention policy for Non Production is 7 days and Production 365 days ( I think ). Restore from backup does whole environment restore and not application by application. We have multiple application including PLP and I was wondering if anybody has figure out way to restore application.Any help or procedure or steps are apricated.Saurin Patel*migrated from champions

Has anyone worked yet with workspaces (loading/ extracting) using a .xfproj file?  I am trying to moved a dashboard maintenance unit (DMU) out of the default workspace into a new one.  However, when I export my .xfproj file (pre-7.3), remove the DMU from default, and load the .xfproj file back in I do not see it loading to the new workspace I created.  Is there something in the .xfproj file that needs added to accumadate workpsaces in 7.3?

We would like to combine two of our cubes into one.  Some of the UD dimensions will change in the new combined cube.  Is it best to start with a new application?  Any suggestions?

When using a Parameter to specify a member in a CubeView, how do I specify which Workspace the Parameter is in?  

hello all, please suggest if there is a way that we can stop users from running Force Consolidate for a given period? 

Hi Community, We have a few scheduled calcs and consolidations running on an hourly basis, and sometimes these start queuing up and cause other DM jobs to fail/get cancelled by the system. Is there any good way to monitor or alert the admins via email if there are more than a few DM jobs getting queued up? We already have a scheduled task which queries the TaskActivity table for any failed jobs periodically and then sends out an email to the admins to address them. But this idea doesn't work for the Queued Jobs as this DM also gets "Queued" along with the others.   Thanks, Sudarshan

How do others manage User Names in their applications? We were advised to use FirstName LastName as the user name, the Description field is not used (screen shot below). We have single sign on enabled which uses AzureSSO and the employees 5 digit number assigned by IT.   We have several name changes that we have held off on making in our application.  Our application includes a custom compensation model that also leverages the User Name and a separate security model within that module.  We can replicate the name change in the comp model and test;  however we are concerned about other implications that we have not considered. Our implementation partner highly cautioned us from renaming metadata.    I fully appreciate the complexities with Entity or Account metadata name changes;  however in this User Name metadata, the implications seem small (historical logs will have the old name pre change and new name post change, possibly an impact to their f

  If you’re using a dimension for only dynamic calculation members, it needs to be enabled on the cube where you want to use that dimension. Question Credit: Chul Smith 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

My client needs me to capture foreign characters apart from regular English as part of Account Metadata. Some of their ERP(Account/Entity) data is in chinese characters and the question was will this be brought in to onestream in their local language or do they first need to translate it to english?    

Hi,  I'm trying to look up values from a VLookUp table (previously made in the Transformation Rules) within a Complex Rule in my Data Source, MMomentoff how could I this? Thank you very much in advanced.   Best, Nieves

I am trying to create a form template using all base and Origin as form.When I am running the form through WF,i get a light green shade in the fields where I need to key in data.Any suggestion as to why I am unable to see the white cells?

Hello, Is it possible to remove user defined dimension association from cube (Application>Cubes>Cube Dimensions)? We've an unused dimension initially created but now we'd like to remove it, as all data is loaded at None member. But when we try to change that UD7 dimension setting to default (RootUD7Dim), it throws below error: "Error updating cube. Unable to modify cube 'CUBENAMEXXXX' dimensions because the cube has data."   I know that error is because we've loaded data already but just wondering if there's a way to get rid of this dimension from cube.   Thanks, Gaurav  

Hi, I have a requirement to report on transaction currency. Is there a way for me not to use any UDs to hold the transaction currency? May be  using the alternate input currency in flow? Any suggestion is appreciated . Thanks

What alterantive solution you have build for Workforce Planning. I don't want to use People Planning Market place solution. 1) Run calculations inside the cube by storing all employee information. 2) Relational Table + Cube. Can you give me a top level design where i can start with ? Thanks!

We have a cube view with Entity Hierarchy in rows displaying values in local currency at the base level and USD at parent level. columns are CY Amount, PY Amount, Variance, Variance %, Currency Change Note - Currency Change is always reflected in USD(both at base and Parent Level) Formula for currency change = (CY Avg Rate - PY Average Rate)* CY Amount (conversion to USD) Problem Statement  Currency Change is displaying correct values at the base level entity, but when rolling up its showing a 0 because the CY Amount at Parent level always shows in USD so the conversion rate by default is 1.   I am looking for a solution to have the Currency Change apply only at the base level and the parent should be a rollup of the base. see screenshot below. Looking forward to some inputs here!      

Hey All. I have a cube view for a client that contains a decently sized row count. I don't really understand why Data Explorer will only format the cube view to have 4 rows per page. Does the red paging mean anything?

Hi All, We are trying to load more than 100 rows through a table view using the method NumberOfEmptyRowsToAdd in the Business Rule: tv is our table view object.  However, when we add a value bigger than 100 in the code, no rows are available to load data in the Spreadsheet. We think is an internal limitation from Onestream to optimize performance. Is there any way to increase this limit? Maybe is only possible with some additional admin privileges in OS?    

Hi All,  In OneStream there are many audit tables containing specific sections that can be audited. I'm looking for a detailed overall data audit showing which user changed which number at what time. Preferably combining loads with (Excel) input. Does anybody know which tables to join to get the good old HFM data audit table?   Thanks in advance,  Marc

Assuming data exists at every base account shown, the data will be accurate at the 69000 – Net Income level using the following account structure in a monolithic cube. Question Credit: Chul Smith 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

Hello ! I am trying to execute the "LogonAndReturnCookie" web api. I thought everything was configured correctly, but I get the message (401 - unauthorized) : "Error processing External Provider Sign In information. Custom Scopes from the Request do not match the ones configured." In the REST API documentation, it is written that the "custom scope" should be as followed : (OneStream web api  app custom scope : allowpostman) : [screenshot removed] How do you configure this custom scope in the app / in azure AD / in postman ?   Regards,

Hello,  Our Organization is currently going through a Planning implementation of OneStream. We have provided a list of enhancement requests to OneStream that we feel would significantly improve the products reporting capabilities. Here is a list of the enhancement requests submitted. I am posting with hope that other customers would also benefit from these enhancements and reach out to OneStream directly to also request this functionality! You can also like ("Kudos") this post.   1.       Drill Down within XFGetCell Function. (This was something that came up a lot at Splash when discussing with other customers) 2.       Retain excel formatting when refreshing quick views 3.       Ability to utilize the member description to pull quick views or XF functions (Today you can only user member name) 4.       “Hardcode” the default Quick View POV when creating

CubeView that was assigned to different role is still visible when the user is set to another role.Example:CubeViewProfile1 - Access Group: Role 1CubeViewGroup1.1 - Access Group: Role 1CubeViewGroup1.2 - Access Group: EveryoneCubeViewProfile2 - Access Group: Role 2CubeViewGroup2.1 - Access Group: Everyone User with Role2 is able to view CubeViewProfile1 and all of its members while user with Role1 is able to view CubeViewProfile2 under OnePlace > Cube Views.How do I hide the CubeViews in OnePlace from users who do not have the right role? Are there other configurations I need to take into consideration? 

Hello, i have a scenario with a range defined (i.e :Month 3 to Month 12) , i wanna process cube only on these months from month 3 to month 12. however when i launch the process cube through the workflow profile, it executes all the periods (even the prior ones , i.e M1 & M2) , i tried to lock through a BR these two months but it didnt work... how can i process cube only on my scenario range plz ?  thanks,